Updating products - database problems

[confused_aswell]

Hi

I have tried to update one of my items today and found that I am getting this error when i try to update from the admin > catalog > catagories/products.

1146 Table 'myusername_zc1.zen_seo_cache' doesn't exist
in:
[DELETE FROM zen_seo_cache WHERE cache_name LIKE '%seo_urls%']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields

My shop has been working fine, but I restored the database to a working backup I made a few weeks ago after I made some changes. I may have caused a few more problems in doing this, any suggestions?

The shop is working fine but just can't update anything.

Thanks,

Phil

[fairestcape]

You backed up your database a couple of weeks ago.
Did you add the SEO module AFTER that backup? And did it require a SQL patch for the dbase?

If so, you still have the SEO module code files (php files) that are giving instructions for a Dbase operation, and the (restored from backup made 2 weeks ago) dbase is not configured to accept them.

[confused_aswell]

Hi

I tried to install googlefroogle after the backup, but couldn't get it working so I decided to remove all of the files relating to that mod on my server and I tidied up the database tables that didn't have zen in them, I then came unstuck because then the supertracker mod didn't work. This is when I restored to the back up from a few weeks ago. I have really messed up haven't I?

Hope this helps,

Phil

[fairestcape]

When you say you "tidied up the database tables that didn't have zen in them", do you mean that your database uses PREFIXES?

It would appear that you have something installed (php files) that are trying to interact with the database.

You may have to remove supertracker mod (php files). As I don't use this mod, I don't know if it over-wites any core files, but if it does, you may need to restore the originals.

Basically, you need to get your php side compatible with the mysql side.

If there is php that's trying to interact with dbase tables that don't exist anymore, you'll get the error messages.

[confused_aswell]

Hi

I guess that I will have to restore the files to what it was originally, what is the best way to restore the database and files without deleting the whole thing off?

Thanks,

Phil

Yes, my database uses prefixes. eg zen_customers

[fairestcape]

As the restored database is functionally intact, it would be unwise to start manually playing around with the tables.

Basically, when you try to update, your ZC is looking for a table called:-
zen_seo_cache.

This table was probably created when you ran a SQL patch for that module.

If you open the module's folders and files (on your local drive) you will see both the folder names and file paths associated with the module.

You should REMOVE these files from your SERVER - making sure of course - that if you remove a core file that the module over-writes, you will then need to upload the ORIGINAL of that file.

It's a bit tedious, but that's all I can suggest.

Don't tamper with your database (unless you make a copy of it and play around with the copy).

[confused_aswell]

Hi

I will try and have a look later tonight. I feel foolish for what I did, I am going to have be a lot more strict on what I do.

Thanks,

Phil