dookie Posted February 12, 2008 Posted February 12, 2008 Hi all, I have the below error on checkout_process.php. My database has the below table, but I'm unsure how to correct the PHP if that's where the issue is. I used the installer.php utility (which is a work of art by the way) to update my database. 1146 - Table 'Shop.TABLE_CUSTOMERS_POINTS_PENDING' doesn't exist insert into TABLE_CUSTOMERS_POINTS_PENDING (unique_id, customer_id, orders_id, points_pending, date_added, points_comment, points_type, points_status) values ('', '3', '20', '246', now(), 'TEXT_DEFAULT_COMMENT', 'SP', '1') [TEP STOP] Thanks for any and all suggestions/help ! Quote
Jan Zonjee Posted February 12, 2008 Posted February 12, 2008 1146 - Table 'Shop.TABLE_CUSTOMERS_POINTS_PENDING' doesn't exist insert into TABLE_CUSTOMERS_POINTS_PENDING (unique_id, customer_id, orders_id, points_pending, date_added, points_comment, points_type, points_status) values ('', '3', '20', '246', now(), 'TEXT_DEFAULT_COMMENT', 'SP', '1') You need to add the define for that table, probably both on the catalog and admin side (typically includes/database_tables.php)? Probably also the define for TEXT_DEFAULT_COMMENT? Quote
dookie Posted February 12, 2008 Author Posted February 12, 2008 You need to add the define for that table, probably both on the catalog and admin side (typically includes/database_tables.php)? Probably also the define for TEXT_DEFAULT_COMMENT? Thank you thank you ! That was it. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.