coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 pnCPG (Coppermine for postNuke/Zikula) => Topic started by: exoxe on February 10, 2004, 02:53:48 AM

Title: How to fix a particular issue I had (read-only mysql table)
Post by: exoxe on February 10, 2004, 02:53:48 AM
Now this may not fix your issue, but it did for me. :-)

If you ever have a problem with your album's database, and you get errors such as table is read only or "You don't have permission to access this page" try the following command if you have access to the mysql admin files:

mysqladmin flush-tables

My problem was that when I did a repair, it compacted the database, but needed that command to run in order to reset everything. Good luck!
Title: How to fix a particular issue I had (read-only mysql table)
Post by: exoxe on February 10, 2004, 06:00:24 AM
[regarding *nix platforms]

It also helps to have the correct permissions...

"chmod correct-user databasedir/*"

example:

cd /var/db/mysql/exampledb/
chmod mysql *
mysqladmin flush-tables

Hope that helps.