Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Couple of questions


SHEPJ

Recommended Posts

Posted

Howdy OScommerce folks - hoping for some help.

 

I will try to keep this as simple as possible; I used to have a website that was fully fuctional let's hypothetically say www.abc.com, wanted to jazz it up so we completely installed a new template on www.abc/AR2/ .....now don't flame me, because I am sure there was an easier way but we deleted the original website at www.abc.com and installed the new template and software to that same (www.abc.com) domain. During the install it asked for the database info, host, name, password which we provided since we wanted to keep the same items.....

 

Now having said all that here are the problems:

 

1)Through the admin panel going to 'customers' I get the following error:

 

1146 - Table 'shepherdjason.address_book' doesn't exist

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id

 

[TEP STOP]

 

2) When trying to log in as an exiting customer in order to buy something:

 

1146 - Table 'shepherdjason.address_book' doesn't exist

 

select entry_country_id, entry_zone_id from address_book where customers_id = '2' and address_book_id = '0'

 

[TEP STOP]

 

 

I assume they are related due to the obvious content of the error.

 

3) I can go directly to the admin panel without a user name and password.....

 

I hope the pro's can chime in and tell me ( newbie) how to fix my problem.....

 

Cheers! Jason.

Posted

Hi,

The erorrs you are recieveing are just what they say, the tables do not exist.

Try and reload the database, or just import the address aspect from the database via phpmyadmin

Regards

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Posted

Hi,

The erorrs you are recieveing are just what they say, the tables do not exist.

Try and reload the database, or just import the address aspect from the database via phpmyadmin

Regards

Nic

 

 

How do you 'reload' the database? or import the address aspect via phpmyadmin?

 

Thanks for your reply...

Posted

You said that you uploaded the "new software" and "new template" and replaced the old you had.

 

Did you also used the new templates database? I guess not, so you have the new files and the old database and this can be a reason that the files are looking for a table in the database that doesn't exist.

 

Normally the table address_book exist in oscommerce, but since you used and use templates, nobody knows what could be changed there.

 

The fact that you can access your admin without user/pass is a sign that your "new" template is based on an old version of osCommerce

 

Can you say what version your old template and your new template are?

Posted

Jason,

 

The answer is above. You need to create the missing tables in the database and then import the relevant data.

 

 

Chris

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...