I'm trying to install eCommerce to a relatively fresh install of Drupal 5.2. I get this error message on some Admin screens:

Fatal error: Call to undefined function: array_intersect_key() in /home/mousenav/public_html/modules/ecommerce/ec_receipt/ec_receipt.module on line 926

This is the only line on the page when viewing site.com/admin and a few other pages.

I also see these error messages in the log files. Not sure if it's related:

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 'AUTO_INCREMENT PRIMARY KEY, region_name VARCHAR(255) NOT NULL, region' at line 2 query: CREATE TABLE ec_region ( regid AUTO_INCREMENT PRIMARY KEY, region_name VARCHAR(255) NOT NULL, region_realm VARCHAR(32) NOT NULL ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/site/public_html/includes/database.mysql.inc on line 172.

Table 'site_main.ec_receipt_types' doesn't exist query: SELECT * FROM ec_receipt_types in /home/site/public_html/includes/database.mysql.inc on line 172.

I've tried uninstalling eCommerce, deleting the ecommerce tables from the database and starting over with another version. I've tried alpha4 and alpha5, but I think I'm experiencing the same problem with all of them.

1. Has anyone else experienced this issue?
2. Have I just done something wrong with the installation? If so, what the best way to start over?
3. Which version of eCommerce is the most stable for Drupal 5.2? The exact release number would be helpful.

Thanks!
Anne

Comments

Anonymous’s picture

Anonymous (not verified) commented

Oh, dear... I think I've figured it out. I'm thinking it's the PHP5.2 issue... thought I had it taken care of. Going to work on it now.

Anonymous’s picture

Anonymous (not verified) commented

Done.

Note to self: Read the notes more closely before posting.

gordon’s picture

gordon commented
Status: Active » Closed (works as designed)

php 5.2

LaoziSailor’s picture

LaoziSailor commented

I had this happen on Drupal-5.5 and after (at the end of enabling all modules) e-Commerce 5.x-4.0-alpha6 (2007-Nov-01). I haven't performed any customizing or other activities yet.

STORE ACTIVATION
* e-Commerce: Store tables have been created.
* e-Commerce: Mail tables have been created.
* Product feature Anonymous purchases has been enabled for Non-Shippable Product
* e-Commerce: Product tables have been created.
* e-Commerce: Cart tables have been created.
* e-Commerce: receipt tables have been created.
* Mail added: Default customer invoice
* Mail added: Default processing error
* Mail added: Default order cancellation notice
* Mail added: Default query to customer
* e-Commerce: All core modules have been installed! You still need install at least one payment gateway in order to use the e-Commerce. Good sales!
* The configuration options have been saved.

REST OF MODULES ACTIVATION

* e-Commerce: Authorize.net tables have been created.
* e-Commerce: Paypal tables have been created.
* e-Commerce: Auction tables have been created.
* e-Commerce: Availability tables have been created.
* e-Commerce: User Account tables have been created.
* Mail added: Default email confirmation
* Mail added: Default welcome mail
* e-Commerce: File tables have been created.
* Product feature Anonymous purchases has been enabled for Tangible Subproduct
* Product feature Anonymous purchases has been enabled for Attribute
* Created new vocabulary Subproducts: Product Variation.
* Created new vocabulary Subproducts: Attribute Tags.
* Created new vocabulary Subproducts: Attribute Forbidden Tags.
* e-Commerce: Coupon tables have been created.
* Mail added: Default coupon mail
* e-Commerce: eC Charge tables have been created.
* e-Commerce: Recurring tables have been created.
* Mail added: Default renewal reminder
* Mail added: Default expiration notice
* e-Commerce: Roles tables have been created.
* e-Commerce: Role Discount tables have been created.
* e-Commerce: Shipping tables have been created.
* Product feature Anonymous purchases has been enabled for Shippable Product
* Mail added: Default shipping notification
* The configuration options have been saved.

user warning: 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 'AUTO_INCREMENT PRIMARY KEY, region_name VARCHAR(255) NOT query: CREATE TABLE ec_region ( regid AUTO_INCREMENT PRIMARY KEY, region_name VARCHAR(255) NOT NULL, region_realm VARCHAR(32) NOT NULL ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */ in /services2/webpages/c/c/site/public/Drupal/includes/database.mysql.inc on line 172.

I've just noticed:
ec_region.patch 1.81 KB

--- ec_region.module	4 Dec 2007 08:02:53 -0000	1.3
+++ ec_region.module	4 Dec 2007 11:17:41 -0000
@@ -159,7 +159,7 @@
...
etc.

Should I apply this or is there a new update for the alpha6 component?

Thanks

smikey’s picture

smikey commented

Hi -

I'm unclear as to what casued the following error:

Table 'site_main.ec_receipt_types' doesn't exist query: SELECT * FROM ec_receipt_types in /home/site/public_html/includes/database.mysql.inc on line 172.

Was this related to a PHP issue? I'm getting a similar error message. Thanks..