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.
Dear CuteNews Users! Please feel free to contact us via our new Feedback Form and please send information about bugs to our bug tracker.
You are not logged in. Please login or register.
CutePHP Forums → Problem Solving / Help & Support → 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.
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 .
I works correctly , 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.
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).
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!
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.
CutePHP Forums → Problem Solving / Help & Support → Cutenews MySQL
Powered by PunBB, supported by Informer Technologies, Inc.
The pun_antispam official extension is installed. Copyright © 2003–2009 PunBB.