coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: ishi92 on August 23, 2010, 06:17:37 PM

Title: Unknown Column error :(
Post by: ishi92 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

Title: Re: Unknown Column error :(
Post by: ishi92 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
Title: Re: Unknown Column error :(
Post by: ishi92 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

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
Title: Re: Unknown Column error :(
Post by: ishi92 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.