Installed Gallery3 tonight on my server and everything was installed successfully. Clicked on Start using Gallery and I got the following error:
Dang... Something went wrong!
We tried really hard, but it's broken.
Talk to your Gallery administrator for help fixing this!
Checked my log file in gallery3/var/logs and this is what it shows:
2013-02-28 05:27:31 +00:00 --- error: Database_Exception [ 44 ]: #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key IN ('var_cache')' at line 3 [ SELECT *
FROM `caches`
WHERE key IN ('var_cache') ]
/var/.www/secure/gallery3/system/libraries/Database_Mysqli_Result.php [ 27 ]
#0 /var/.www/secure/gallery3/system/libraries/Database_Mysqli.php(79): Database_Mysqli_Result_Core->__construct(false, 'SELECT *?FROM `...', Object(mysqli), true)
#1 /var/.www/secure/gallery3/system/libraries/Database.php(272): Database_Mysqli_Core->query_execute('SELECT *?FROM `...')
#2 /var/.www/secure/gallery3/modules/gallery/libraries/MY_Database.php(48): Database_Core->query('SELECT *?FROM `...')
#3 /var/.www/secure/gallery3/system/libraries/Database_Builder.php(973): Database->query('SELECT *?FROM `...')
#4 /var/.www/secure/gallery3/modules/gallery/libraries/drivers/Cache/Database.php(105): Database_Builder_Core->execute()
#5 /var/.www/secure/gallery3/system/libraries/Cache.php(141): Cache_Database_Driver->get(Array, 1)
#6 /var/.www/secure/gallery3/modules/gallery/helpers/module.php(437): Cache_Core->get('var_cache')
#7 /var/.www/secure/gallery3/modules/gallery/config/locale.php(36): module_Core::get_var('gallery', 'timezone', 'UTC')
#8 /var/.www/secure/gallery3/system/libraries/drivers/Config/Array.php(70): require('/var/.www/secur...')
#9 /var/.www/secure/gallery3/system/libraries/drivers/Config.php(111): Config_Array_Driver->load('locale', 0)
#10 /var/.www/secure/gallery3/system/core/Kohana_Config.php(121): Config_Driver->get('locale.language', 0, 0)
#11 /var/.www/secure/gallery3/system/core/Kohana.php(385): Kohana_Config_Core->get('locale.language', 0, 0)
#12 /var/.www/secure/gallery3/system/core/Kohana.php(150): Kohana_Core::config('locale.language')
#13 /var/.www/secure/gallery3/application/Bootstrap.php(49): Kohana_Core::setup()
#14 /var/.www/secure/gallery3/index.php(116): require('/var/.www/secur...')
#15 {main}
Any suggestions on what to do?
Thanks,
Ryan
Posted: Thu, 2013-02-28 05:54
