I had deleted the CPG MySQL account accidentally, so I created another one (name changed) and updated info in config.inc.php, but I can not update user accounts any longer. I can open the users page (usermgr.php), however when I select any action like Activate, deactivate, delete, etc the page refreshes and redirects me to my gallery's home page. But I have observed that the address shows action URL.
http://igallery.khanz.net/delete.php?id=u28&album_listbox=reg_d&u28=&action=deactivate&what=user&new_password=&group=&delete_files=no&delete_comments=no&form_token=f1d1624cb4fadc3b07246269a47607ff×tamp=1334358107
Quote from: fmk on April 14, 2012, 01:20:57 AM
I had deleted the CPG MySQL account accidentally, so I created another one (name changed) and updated info in config.inc.php,
Did you create the table from a backup copy?
Did you run update.php afterwards?
When I visit your gallery, I just get
QuoteWhile executing query 'SELECT name, value FROM cpg15x_config' in include/init.inc.php on line 179
mySQL error: Table 'khanznet_glr.cpg15x_config' doesn't exist
It seems that your database is missing/empty.
Thanks for reply Joe. That error has been fixed. :)
I did not delete the Database, so I believe is it intact. I had only deleted the SQL database user from my cPanel X. I wish I remembered the username or I had copied it from config.inc.php before creating a new user and updating the file. I can play with the user accounts directly from SQL through phpMyAdmin, but not from the cpg.
Did you create the table from a backup copy? No.
Did you run update.php afterwards? Yes. In fact, after trying several things I updated my cpg to the latest version. The update was successful, but issue persists.
Check if the file delete.php exists on your server. It seems there's some kind of rewrite rule, as your gallery home page is always displayed for files/folders/paths that obviously don't exist, e.g. http://igallery.khanz.net/nonsense/foo.bar