Jump to content
Sign in to follow this  
aodfan

Multi-Vendor Shipping sql error

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×