Multi-Vendor Shipping sql error

[aodfan]

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.

[aodfan]

For some reason it is including my username in the table name? I guess I do not know what is happening....

[safoo]

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.

[divyendu]

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