Hi Everyone,
This is my first post on this forum so please bare with me. I've finally got my gallery 2 to work and upgraded to 2.0.2. I am in the process of adding this checkout(ver 0.1.12)feature along with the accompanying plugins (by email and by paypal). I was able to install the checkout by email module, but could not do so with the checkout and the checkout by paypal. The following is the error message that showed up after my attempts. Any help is greatly appreciated. Thanks.
-------------------- DEBUG Message Begins -------------------
Error Detail -
Error (ERROR_STORAGE_FAILURE) : Error trying to load /webproofs/modules/core/classes/GalleryStorage/../../../../modules/checkout/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryCheckoutItem.sql
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1818 (gallerystatus::error)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1546 (mysqldatabasestorage::_executesqlfile)
in modules/core/classes/GalleryStorage.class at line 387 (mysqldatabasestorage::configurestore)
in modules/core/classes/GalleryModule.class at line 145 (gallerystorage::configurestore)
in modules/core/AdminModules.inc at line 68 (checkoutmodule::installorupgrade)
in main.php at line 174 (adminmodulescontroller::handlerequest)
in main.php at line 87
in main.php at line 80
System Information
Gallery version 2.0.2
PHP version 4.3.11 cgi-fcgi
Webserver Apache/1.3.33 (Unix) FrontPage/5.0.2.2510 mod_fastcgi/2.4.2
Database mysql 4.1.14
Toolkits NetPBM, Gd
Operating system FreeBSD robs-p2-wh-test.biz 4.8-YAHOO-20030628 FreeBSD 4.8-YAHOO-20030628 #0: i386
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Debug Output
getParameter permissions.file for core plugin file_exists(//webproofs/6c73f70812/g2data/cache/module/core/0/0/0.inc) file_exists(//webproofs/6c73f70812/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator file_exists(//webproofs/6c73f70812/g2data/sessions/f82866d870d7dd0ca94e876cd8e8cc9e) getParameter session.lifetime for core plugin getParameter session.inactivityTimeout for core plugin stat(//webproofs/6c73f70812/g2data/sessions/f82866d870d7dd0ca94e876cd8e8cc9e) file_exists(//webproofs/6c73f70812/g2data/sessions/f82866d870d7dd0ca94e876cd8e8cc9e) getParameter cookie.domain for core plugin getParameter cookie.path for core plugin getParameter default.language for core plugin Loading plugin core Class not defined, trying to include it. file_exists(/webproofs/modules/core/classes/helpers/../../../../modules/core/module.inc) realpath(/webproofs/modules/core/classes/../../..) Binding text domain: modules_core -> /webproofs/modules/core/locale core plugin successfully instantiated file_exists(//webproofs/6c73f70812/g2data/versions.dat) file(//webproofs/6c73f70812/g2data/versions.dat, ) [1139128683] can't guarantee 5 -- extending! file_exists(//webproofs/6c73f70812/g2data/cache/entity/0/0/6.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(//webproofs/6c73f70812/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/webproofs/modules/core/classes/../../../modules/core/AdminModules.inc) getParameter id.adminGroup for core plugin
--------------------------------------------------------------------------------
(mysql): SELECT g2_UserGroupMap.g_userId FROM g2_UserGroupMap WHERE g2_UserGroupMap.g_userId = 6 AND g2_UserGroupMap.g_groupId = '3' LIMIT 1
--------------------------------------------------------------------------------
Loading plugin checkout Class not defined, trying to include it. file_exists(/webproofs/modules/core/classes/helpers/../../../../modules/checkout/module.inc) realpath(/webproofs/modules/core/classes/../../..) Binding text domain: modules_checkout -> /webproofs/modules/checkout/locale checkout plugin successfully instantiated GalleryModule::installOrUpgrade checkout module getParameter _version for checkout plugin file_exists(//webproofs/6c73f70812/g2data/cache/module/checkout/0/0/0.inc) Configure store for checkout module file_exists(/webproofs/modules/core/classes/GalleryStorage/../../../../modules/checkout/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql) opendir(/webproofs/modules/core/classes/GalleryStorage/../../../../modules/checkout/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) readdir(Resource id #58) closedir(Resource id #58)
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema
--------------------------------------------------------------------------------
mysql error: [1044: Access denied for user 'yscr_bbyEoE'@'localhost' to database 'gallery2'] in EXECUTE("-- This file was automatically generated from an XSL template, which is -- why it looks so ugly. Editing it by hand would be a bad idea. -- CREATE TABLE g2_CheckoutItem ( g_id int(11) NOT NULL , g_item int(11) NOT NULL , g_itemName varchar( 128 ) , g_product int(11) NOT NULL , g_productName varchar( 128 ) , g_qty int(11) NOT NULL , g_priceEach varchar( 32 ) , g_priceTotal varchar( 32 ) , g_notes text , PRIMARY KEY (g_id) , INDEX g2_CheckoutItem_72670 (g_item) ) TYPE=MyISAM")
--------------------------------------------------------------------------------
(mysql): -- This file was automatically generated from an XSL template, which is -- why it looks so ugly. Editing it by hand would be a bad idea. -- CREATE TABLE g2_CheckoutItem ( g_id int(11) NOT NULL , g_item int(11) NOT NULL , g_itemName varchar( 128 ) , g_product int(11) NOT NULL , g_productName varchar( 128 ) , g_qty int(11) NOT NULL , g_priceEach varchar( 32 ) , g_priceTotal varchar( 32 ) , g_notes text , PRIMARY KEY (g_id) , INDEX g2_CheckoutItem_72670 (g_item) ) TYPE=MyISAM
--------------------------------------------------------------------------------
1044: Access denied for user 'yscr_bbyEoE'@'localhost' to database 'gallery2'
adodb_mysql._execute(-- This file was
automatically generated from an XSL template, which is
-- why it looks so ugly. Editing it by hand would b...,
false) % line 855, file: adodb.inc.php
adodb_mysql.execute(-- This file was automatically generated
from an XSL template, which is
-- why it looks so ugly. Editing it by hand would b...) % line 1814, file: DatabaseStorage.class
mysqldatabasestorage._executesqlfile(/webproofs/modules/core/classes/GalleryStorage/../../../../modules/checkout/classes/GalleryStorage/DatabaseStorage/schema/platfo...) % line 1546, file: DatabaseStorage.class
mysqldatabasestorage.configurestore(checkout) % line 387, file: GalleryStorage.class
gallerystorage.configurestore(checkout) % line 145, file: GalleryModule.class
realpath(/webproofs/modules/core/classes/../../../) Error: Failed to configure the persistent store, this is the error stack trace: Error (ERROR_STORAGE_FAILURE) : Error trying to load /webproofs/modules/core/classes/GalleryStorage/../../../../modules/checkout/classes/GalleryStorage/DatabaseStorage/schema/platform/mysql/GalleryCheckoutItem.sqlin modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1818 (gallerystatus::error) in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1546 (mysqldatabasestorage::_executesqlfile) in modules/core/classes/GalleryStorage.class at line 387 (mysqldatabasestorage::configurestore) in modules/core/classes/GalleryModule.class at line 145 (gallerystorage::configurestore) in modules/core/AdminModules.inc at line 68 (checkoutmodule::installorupgrade) in main.php at line 174 (adminmodulescontroller::handlerequest) in main.php at line 87 in main.php at line 80 getParameter default.theme for core plugin Loading plugin matrix Class not defined, trying to include it. file_exists(/webproofs/modules/core/classes/helpers/../../../../themes/matrix/theme.inc) matrix plugin successfully instantiated Check the version of the matrix plugin file_exists(//webproofs/6c73f70812/g2data/cache/theme/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the matrix plugin is ok Loading plugin core core plugin successfully instantiated Check the version of the core plugin The version of the core plugin is ok file_exists(/webproofs/modules/core/classes/../../../modules/core/ErrorPage.inc) getParameter id.adminGroup for core plugin realpath(/webproofs/modules/core/classes/../../../)
--------------------------------------------------------------------------------
(mysql): SELECT g2_TkOperatnMimeTypeMap.g_mimeType, g2_TkOperatnMimeTypeMap.g_toolkitId FROM g2_TkOperatnMimeTypeMap WHERE g2_TkOperatnMimeTypeMap.g_operationName = 'thumbnail' ORDER BY g2_TkOperatnMimeTypeMap.g_mimeType ASC, g2_TkOperatnMimeTypeMap.g_priority ASC
--------------------------------------------------------------------------------
file_exists(/webproofs/modules/core/classes/../../../lib/javascript/local/BlockToggle.js) file_exists(//webproofs/6c73f70812/g2data/smarty/templates_c/%%526996645) is_dir(//webproofs/6c73f70812/g2data/smarty/templates_c/%%526996645) file_exists(//webproofs/6c73f70812/g2data/smarty/templates_c/%%526996645) is_writeable(//webproofs/6c73f70812/g2data/smarty/templates_c/%%526996645) file_exists(//webproofs/6c73f70812/g2data/smarty/templates_c/%%526996645/v_8) realpath(/webproofs/modules/core/classes/../../..) Binding text domain: themes_matrix -> /webproofs/themes/matrix/locale file_exists(/webproofs/modules/core/classes/../../../themes/matrix/local/theme.css)
Posted: Sun, 2006-02-05 08:41
Posts: 431
I think the key line in here is probably the following:
This implies to me that the user doesn't have the right to create new tables in the gallery2 databases. Both the Checkout and CheckoutPaypal module need to create new databse tables, whereas CheckoutEmail doesn't, so that fits with your symptoms.
Please can you check what priviliges the user 'yscb_bbyEoE' has? The following query will do that:
I have seen a couple of other people reporting this symptom, but they also had more problems in Gallery itself - like not being able to add or delete photos because of database problems. Is everything else working as expected for you?
Posts: 2
Thanks for the response turnbulm. I am more familiar with MS SQL than MySql, nevertheless, I was able to look into the user table to find that 'yscb_bbyEoE' does not have any priviliges. I activated the user privileges and everything worked fine. Thanks for your help.
Posts: 431
No problem - you made it easy by posting all the information up front! By the way, welcome to G2.