Topic: Cutenews MySQL

Is there a hack to news have been added to the mysql database?

I have over 500 news news.txt file and it is difficult to manually edit anything. Long opens and saves.

2 (edited by 2013-06-01 18:32:01)

Re: Cutenews MySQL

Does it work?

http://www.ineedtutorials.com/code/php/cut...ql-php-tutorial

I have over 500 records (news) in the file news.txt. Please help me https://cutephp.com/forum/style_emoticons/default/mellow.gif .

Re: Cutenews MySQL

I works correctly    https://cutephp.com/forum/style_emoticons/default/smile.gif ,  the problem I have is how to show the news and read them the MYSQL database, and also as to the INCLUDE ...

The problem is how to read from the database to display the news.  https://cutephp.com/forum/style_emoticons/default/huh.gif

4 (edited by 2013-06-05 08:23:27)

Re: Cutenews MySQL

It's important not to confuse what the tutorial does, which Piotr kindly posted. It extracts the news from the CuteNews file into a MySQL database, but CuteNews [currently] doesn't understand SQL, so once you have your database, its management is beyond the scope of CuteNews and up to you.

There's an unofficial fork of CuteNews called CuteNews.ru (at cutenewsru.com) that offers MySQL support, but I've never tried it and I think it hasn't been developed actively for a while now.

As things are right now, these are the following options:
- Stick with flat-file for CuteNews, archive regularly (manually or using a monthly auto-archive; this can be set in Options > System Configurations > General)
- If flat-file isn't doable/desirable, a <acronym title='Content management system'>CMS</acronym> with MySQL support has to be found.

@Support_Team Seeing as this is not the first topic within the last 30 days about files becoming too big, an automatic archiving function dependent on file size might be interesting (i.e. automatically make an archive if news.txt exceeds 1 MB, for instance).

Re: Cutenews MySQL

There should be a way to work with MYSQL CN but I think it is rather easy to migrate the system and less if you are online, as they would have to change several settings files and could generate multiple errors, as said (LKJ) filed from time to time .

Another small problem I had is that when filing the latest_comments stops working because, when filed, the news with his comments folder change, not if there is a hack for this, I ask out of curiosity, greetings to all!  https://cutephp.com/forum/style_emoticons/default/cool.gif

Re: Cutenews MySQL

MySQL support in the current 1.5.4 version is rooted too difficult and there will be a lot of mistakes. You can do temporary hacks for reading and recording in MySQL but it won't be stable. Anyway there are plans for it but the main database is flat-db.

Best regards,
CN Support team