Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Problems after deleting CPG SQL account  (Read 3054 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.022 seconds with 19 queries.