SHEPJ Posted August 15, 2010 Posted August 15, 2010 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.
FIMBLE Posted August 16, 2010 Posted August 16, 2010 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
SHEPJ Posted August 16, 2010 Author Posted August 16, 2010 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...
SHEPJ Posted August 17, 2010 Author Posted August 17, 2010 Anyone? I assume that I need to add a table to my database?
multimixer Posted August 17, 2010 Posted August 17, 2010 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? My community profile | Template system for osCommerce - New: Responsive | Feedback channel
Guest Posted August 17, 2010 Posted August 17, 2010 Jason, The answer is above. You need to create the missing tables in the database and then import the relevant data. Chris
Recommended Posts
Archived
This topic is now archived and is closed to further replies.