aodfan Posted October 10, 2006 Share Posted October 10, 2006 Hello, I just installed MVS on the admin side, and went to see how it turned out, but when I refreshed I received this error: 1146 - Table 'aodfan_aodfan.TABLE_VENDOR_CONFIGURATION' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from TABLE_VENDOR_CONFIGURATION [TEP STOP] This is the code in application_top.php, that I believe it is refering to: //MVS Start // set the vendor shipping constants $vendor_configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_VENDOR_CONFIGURATION); while ($vendor_configuration = tep_db_fetch_array($vendor_configuration_query)) { define($vendor_configuration['cfgKey'], $vendor_configuration['cfgValue']); } //MVS End Can anyone tell me why it is saying this even though I have ran the sql in phpmyadmin and have verified that that table exists? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
aodfan Posted October 12, 2006 Author Share Posted October 12, 2006 For some reason it is including my username in the table name? I guess I do not know what is happening.... Quote Link to comment Share on other sites More sharing options...
safoo Posted October 12, 2006 Share Posted October 12, 2006 Double check your database.php additions. There should be a define for "TABLE_VENDOR_CONFIGURATION". If you look in the file, you will know what I mean. Any time you have an error similar to this one, OSC is missing the definition for that place holder. In this case: TABLE_VENDOR_CONFIGURATION Also, this should have been posted in the MVS thread. Quote Link to comment Share on other sites More sharing options...
divyendu Posted September 15, 2007 Share Posted September 15, 2007 I got the same error but that was removed when I inserted this line in database_tables.php //MVS Start define('TABLE_HEADING_PRODUCTS_VENDOR', 'Vendor');//inserted by MVS define('TABLE_HEADING_QUANTITY', 'Qty');//inserted by MVS define('TABLE_HEADING_VENDORS_SHIP', 'Shipper');//inserted by MVS define('TABLE_HEADING_SHIPPING_METHOD', 'Method');//inserted by MVS define('TABLE_HEADING_SHIPPING_COST', 'Ship Cost');//inserted by MVS define('TABLE_VENDOR_CONFIGURATION','Configuration');// inserted by Divyendu define('TABLE_VENDORS','Vendors');// inserted by Divyendu define('VENDOR_ORDER_SENT', 'Order Sent to ');//inserted by MVS //MVS End Now the admin window was opened successfully. But when I clicked the Vendor Management Link it gives error. 1146 - Table 'test.table_orders_shipping' doesn't exist select count(*) as total from TABLE_ORDERS_SHIPPING where vendors_id='1' [TEP STOP] Please suggest some remedy. Thanks Divyendu www.toy4education.com 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.