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: Unknown Column error :(  (Read 4012 times)

0 Members and 1 Guest are viewing this topic.

ishi92

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Unknown Column error :(
« on: August 23, 2010, 06:17:37 pm »

I just tried updating my Coppermine Gallery from version 1.4.19 to 1.5.6, but I got the error :
Upgrade failed! Errors are:

 Upgrade failed (Can't coerce GLOB to string in or at /opt/lib/perl5/bl/BL/InstallCentral/Coppermine.pm line 160.

Stack:
  [/opt/lib/perl5/bl/BL/InstallCentral/Coppermine.pm:160]
  [/opt/lib/perl5/bl/BL/InstallCentral/Coppermine.pm:124]
  [/opt/lib/perl5/bl/BL/InstallCentral/Installer.pm:655]
  [/opt/lib/perl5/bl/BL/InstallCentral/Installer.pm:620]
  [/home/bizland/member/InstallCentral/Applications/autohandler:1483]
  [/opt/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm:908]
  [/home/bizland/member/InstallCentral/Applications/autohandler:2112]
  [/home/bizland/member/InstallCentral/Applications/autohandler:1463]
  [/opt/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm:908]
  [/home/bizland/member/InstallCentral/Applications/autohandler:2105]
  [/home/bizland/member/InstallCentral/Applications/autohandler:28]
  [/opt/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm:908]
  [/home/bizland/member/InstallCentral/Applications/autohandler:2171]
  [/home/bizland/member/autohandler:65]
  [/home/bizland/autohandler:9]
)!


So I enable the debug mode from phpMyAdmin and I reloaded my gallery. I now get the error :

While executing query 'SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS  priv_upl_need_approval FROM cpg148_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 321

mySQL error: Unknown column 'access_level' in 'field list'

I have no idea what to do now. I can't afford to lose my gallery. :( Please help!
My gallery : www.tokiohotelindia.com/gallery

Logged

ishi92

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Unknown Column error :(
« Reply #1 on: August 23, 2010, 07:39:11 pm »

ok Now I'm getting 'Critical Error - There was an error while processing a database query'
please help!
I followed some instructions from here before I got the critical error message  :http://forum.coppermine-gallery.net/index.php/topic,65521.0/wap2.html
Logged

ishi92

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Unknown Column error :(
« Reply #2 on: August 26, 2010, 12:53:00 am »

Um...anyone?

This is what I'm getting
Critical error

There was an error while processing a database query.

While executing query 'SELECT lang_id FROM cpg148_languages WHERE enabled='YES'' in include/init.inc.php on line 326 mySQL error: Table 'ishi92_IC_20100723_175245.cpg148_languages' doesn't exist

Code: [Select]
While executing query 'SELECT lang_id FROM cpg148_languages WHERE enabled='YES'' in include/init.inc.php on line 326

mySQL error: Table 'xxxxx_IC_20100723_175245.cpg148_languages' doesn't exist
Logged

ishi92

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Unknown Column error :(
« Reply #3 on: August 26, 2010, 01:09:58 am »

wait it's alright.
I did a manual update (if that's what it is called)
I did www.tokiohotelindia.com/gallery/update.php
and then I refreshed the gallery, and it appeared! :)
Thanks anyway.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.