Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Multi-Vendor Shipping sql error


aodfan

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.

Link to comment
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.

Link to comment
Share on other sites

  • 11 months later...

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...