Problems after deleting CPG SQL account Problems after deleting CPG SQL account
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Problems after deleting CPG SQL account

Started by fmk, April 14, 2012, 01:20:57 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

fmk

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&timestamp=1334358107
FMK

Love doesn't stop by my door, I am always infatuated with new things.

Joe Carver

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?

Αndré

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.

fmk

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.
FMK

Love doesn't stop by my door, I am always infatuated with new things.

Αndré

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