Advanced search  

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

Pages: [1]   Go Down

Author Topic: Problems after deleting CPG SQL account  (Read 3056 times)

0 Members and 1 Guest are viewing this topic.

fmk

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 28
    • FMKz Test Bed
Problems after deleting CPG SQL account
« 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, 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
Logged
FMK

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

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Problems after deleting CPG SQL account
« Reply #1 on: April 15, 2012, 12:27:42 pm »

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é

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Problems after deleting CPG SQL account
« Reply #2 on: April 15, 2012, 03:13:49 pm »

When I visit your gallery, I just get
Quote
While 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.
Logged

fmk

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 28
    • FMKz Test Bed
Re: Problems after deleting CPG SQL account
« Reply #3 on: April 15, 2012, 11:52:34 pm »

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

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

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Problems after deleting CPG SQL account
« Reply #4 on: April 16, 2012, 05:11:33 pm »

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
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.