E-Commerce store
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT COUNT(txnid) FROM ec_transaction WHERE (payment_status = '1' OR payment_status = '7') AND (workflow = '1' OR workflow = '2' OR workflow = '3' OR workflow = '4') in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT COUNT(txnid) FROM ec_transaction WHERE payment_status = '2' AND (workflow = '1' OR workflow = '2' OR workflow = '3' OR workflow = '4') in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT COUNT(txnid) FROM ec_transaction WHERE payment_status = '2' and workflow = '6' in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT COUNT(txnid) FROM ec_transaction where created >= '1170306000' AND payment_status = '2' AND workflow = '6' in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT SUM(gross) FROM ec_transaction where created >= '1170306000' AND payment_status = '2' AND workflow = '6' in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT COUNT(DISTINCT uid) FROM ec_transaction in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
* user warning: Table 'ucanb_biz_-_drupal.ec_transaction' doesn't exist query: SELECT SUM(gross) FROM ec_transaction where created >= '1167627600' AND payment_status = '2' AND workflow = '6' in /var/www/html/drupal-5.1/includes/database.mysql.inc on line 172.
does anyone know how to configure so that it works?
Thanks,
ucanb
Comments
Same here
I have exactly the same kind of error.
Anyone know why ?
modules being installed in the wrong order?
I'm getting the same error too. I think maybe the directions (http://drupal.org/node/118988) left out a module that has to be installed; the one that creates the ec_transaciton table in the DB.
I'll poke around and see if I can't figure out which module that is.
Jen
*~ current project: www.customerthink.com ~*
SQL Syntax for adding missing table... Drupal 4.7.x
Ok people, the culprit here is the store module. for whatever reason store.install is failing to create the ec_transaction table. To get around this problem you can create the missing table manually using the following syntax:
CREATE TABLE ec_transaction(
txnid int( 10 ) unsigned NOT NULL default '0',
uid int( 10 ) unsigned NOT NULL default '0',
TYPE varchar( 16 ) NOT NULL default '',
mail varchar( 64 ) NOT NULL default '',
shipping_cost decimal( 10, 2 ) NOT NULL default '0.00',
payment_method varchar( 32 ) NOT NULL default '',
payment_status varchar( 32 ) NOT NULL default '1',
payment_date int( 11 ) NOT NULL default '0',
workflow int( 10 ) unsigned NOT NULL default '1',
gross decimal( 10, 2 ) NOT NULL default '0.00',
created int( 11 ) NOT NULL default '0',
CHANGED int( 11 ) NOT NULL default '0',
duedate int( 11 ) NOT NULL default '0',
token varchar( 42 ) NOT NULL default '',
PRIMARY KEY ( txnid ) ,
INDEX uid( uid )
) TYPE = MYISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
This worked for me, I hope it helps you too!
Jen
*~ current project: www.customerthink.com ~*
Thank you
Thank you very much.
Indeed, when I created manually all the databases that store.install should have, it let me go to the next page.
Thanks.
Matthieu.