Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Table errors, 2 catalogs, 1 database


Guest

Recommended Posts

Hi all,

 

My hosting allows only one database and I have 2 catalogs and 2 phpBB on the one database.

 

I used a great contribution that lets you change the prefix to the table in the setup of the catalog so that each one has its own database. For example: configuration_group in my database is set for E_configuration_group for catalog 1, and S_configuration_group for catalog 2.

 

The problem I have run into is that when I added this outstanding Paypal contribution everything went fine in the install process. When I try testing though I get an error showing that it isn't finding the table with the right prefix, rather it is looking for just "un" prefixed PayPal tables.

 

This is one of the errors I get:

 

1146 - Table 'db99562261.orders_session_info' doesn't exist

 

The orders_session_info in fact does exist, but as the name S_orders_session_info (along with other tables)

 

Does anyone know where I might find a previous post on this topic? I have searched and I can't seem to find one. Or if anyone knows how I can change the query to look for only tables with the E_ or S_ prefix I would be most appreciative.

 

Thanks,

 

Larry

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...