Unknown Column error :( Unknown Column error :(
 

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

Unknown Column error :(

Started by ishi92, August 23, 2010, 06:17:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ishi92

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


ishi92

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

ishi92

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

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

ishi92

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.