Hello All,
I am installing the checkout module on a patched Gallery 2.1.2 (I have to use this one since I am hosted on a php safe-mode host). The checkout module I am trying to install is the 0.0.18, since I could not find earlier versions. I have a problem similar to what is posted here;
http://gallery.menalto.com/node/44001
However, my error is probably syntax-related and not privilege-related.
Is this just incompatibility of this checkout with this gallery version?
Is this solvable?
Any help is very much appreciated!
Site: http://www.exuria.be
phpinfo.php present
Debug output posted below up to where I reckon is relevant.
Full debug output: exuria.be/error.txt
Thanks
Error Detail
Error (ERROR_STORAGE_FAILURE) : Error trying to run query: CREATE TABLE g2_CheckoutItem( g_id int(11) NOT NULL, g_item int(11) NOT NULL, g_transaction 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), INDEX g2_CheckoutItem_8593(g_transaction) ) MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1528 (GalleryCoreApi::error)
* in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1280 (GalleryStorageExtras::_executeSql)
* in modules/core/classes/GalleryStorage.class at line 625 (GalleryStorageExtras::configureStore)
* in modules/core/classes/GalleryModule.class at line 144 (GalleryStorage::configureStore)
* in modules/core/AdminModules.inc at line 64 (GalleryModule::installOrUpgrade)
* in main.php at line 199 (AdminModulesController::handleRequest)
* in main.php at line 87
* in main.php at line 80
Gallery version = 2.1.2 core 1.1.0.2
PHP version = 5.2.8 cgi-fcgi
Webserver = Apache
Database = mysql 5.0.32-Debian_7etch8-log, lock.system=flock
Toolkits = Gd
Acceleration = none, none
Operating system = Linux srv123 2.6.18-6-vserver-amd64 #1 SMP Fri Dec 12 06:15:44 UTC 2008 x86_64
Default theme = matrix
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5
Debug Output
file_exists(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../config.php) file_exists(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../plugins/index.modules) file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc) Unimplemented: GalleryUrlGenerator getParameter session.lifetime for core plugin file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/core/0/0/0.inc) getParameter session.inactivityTimeout for core plugin
--------------------------------------------------------------------------------
(mysql): SET NAMES "utf8"
--------------------------------------------------------------------------------
(mysql): SELECT g2_SessionMap.g_id, g2_SessionMap.g_userId, g2_SessionMap.g_remoteIdentifier,g2_SessionMap.g_creationTimestamp, g2_SessionMap.g_modificationTimestamp, g2_SessionMap.g_data FROM g2_SessionMap WHERE g2_SessionMap.g_id = '0ba5a1eb03e5562c1e70ccc48f4e0130'
--------------------------------------------------------------------------------
controller core.AdminModules, view Loading plugin core Class not defined, trying to include it. file_exists(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../modules/core/module.inc) core plugin successfully instantiated file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/versions.dat) file(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/versions.dat, ) [1230677722] can't guarantee 5 -- extending! file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/entity/0/0/6.inc) Loading plugin core core plugin successfully instantiated Check the version of the core plugin file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) The version of the core plugin is ok file_exists(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../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(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../modules/checkout/module.inc) checkout plugin successfully instantiated GalleryModule::installOrUpgrade checkout module getParameter _version for checkout plugin file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/checkout/0/0/0.inc) Configure store for checkout module file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/_all/0/0/GalleryStorage_describeMap.inc) is_dir(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/_all/0/0/GalleryStorage_describeMap.inc) unlink(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/_all/0/0/GalleryStorage_describeMap.inc) file_exists(/customers/exuria.be/exuria.be/httpd.www/g2data_facd756dff/cache/module/_all/0/0/GalleryStorage_describeEntity.inc) file_exists(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../modules/checkout/classes/GalleryStorage/schema.tpl) file(/customers/exuria.be/exuria.be/httpd.www/modules/core/classes/helpers/../../../../modules/checkout/classes/GalleryStorage/schema.tpl, )
--------------------------------------------------------------------------------
(mysql): SHOW TABLES
--------------------------------------------------------------------------------
(mysql): SELECT g_name, g_major, g_minor FROM g2_Schema
--------------------------------------------------------------------------------
mysql error: [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 'MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */' at line 15] in EXECUTE("CREATE TABLE g2_CheckoutItem( g_id int(11) NOT NULL, g_item int(11) NOT NULL, g_transaction 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), INDEX g2_CheckoutItem_8593(g_transaction) ) MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */")
--------------------------------------------------------------------------------
(mysql): CREATE TABLE g2_CheckoutItem( g_id int(11) NOT NULL, g_item int(11) NOT NULL, g_transaction 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), INDEX g2_CheckoutItem_8593(g_transaction) ) MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */
--------------------------------------------------------------------------------
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 'MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */' at line 15
ADOConnection...
Posted: Tue, 2008-12-30 23:21
Posts: 3364
Good Lord, ancient history. Why?
Posts: 3
I know, but I thought I had no choice.
It is the only one I could find to install on a 2.1.2 Gallery?
Thanks!
Posts: 3364
I'm sorry - I don't think I can help you - I have no idea about old versions of Gallery.
Posts: 26
What happens if you remove the force to UTF-8 character set? ((mysql): SET NAMES "utf8")
Posts: 3364
Again, no idea. But in general Gallery requires UTF-8 throughout, it's not a checkout thing.
Posts: 3
Thank you all for the help!
As the error report suggested, I 'checked the mysql commands for syntax errors'. I am absolutely worthless regarding that subject but tried to remove the "DB_TABLE_TYPE" (which is probably returning MyISAM in the error report) in the following command:
It appears a few times in the schema.tpl in \checkout\classes\GalleryStorage
Apparently that did the trick and enabled me to install the checkout module successfully.
Why was it there, and have I not been very stupid about something when removing it?
Anyways, I notice that this version does not support per-item pricing yet, which I really need.
Is there any way to install a newer verion on my gallery verion (I am forced to use this one, host does not support php safe mode off), and if yes, where can I find it? (I don't have the 'Get more plugins tab' in this gallery installation)
Many thanks!
Posts: 3364
Latest version is always at this link:
http://gallery-contrib.svn.sourceforge.net/viewvc/gallery-contrib/trunk/gallery2/modules/checkout.tar.gz?view=tar
(By far the best bet is to find a host that doesn't have stupid safe-mode restrictions; it's totally useless, deprecated, and removed from php6 - and hosts that insist on it clearly don't have a clue about secure server management or are lazy beyond belief. $6 a month will buy you any number of hosting setups that actually have got clue.)