dookie Posted February 12, 2008 Share 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 Link to comment Share on other sites More sharing options...
Jan Zonjee Posted February 12, 2008 Share 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 Link to comment Share on other sites More sharing options...
dookie Posted February 12, 2008 Author Share 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 Link to comment Share on other sites More sharing options...
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.