product_type_layout' doesn't exist

[dreamstudio]

We have had to move from another host to our own hosting, I have followed the instructions but when I try to view the site on the new hosting or even run the fix_cache_key.php file this is the error message

1146 Table 'web87-trackadmin.product_type_layout' doesn't exist


I did a search for product_type_layout in the sql file and nothing was found, if I search for product_type it will find aload of them



What needs to be done to get the site reworking

[kobra]

You should be checking with your host on this as they should be assisting you in this move??

[dreamstudio]

You should be checking with your host on this as they should be assisting you in this move??

Well we are moving from another host as they got hacked and are less than useless. I got a SQL file which I had to clean up due to the extra data. I then tried to import and get this error which I dont know how best to fix.

My fear is if I cant fix it then it will need to be restarted from scratch and I am not happy about this as it was the previous hosts fault

[kobra]

I may talking to my hand here - but if you operate a some what busy shop you should be taking daily DB backups - as a hack very seldom can or does access the actual DB your backs should be good at some point and then you only need to look at the customer and order tables from the most current to attempt to capture the most recent business.

[DrByte]

"product_type_layout" is a pretty important table, introduced in v1.2.0

It's odd that it would be missing from your backup.
However, if you simply need the master structure, you can obtain it from the mysql_zencart.sql file in the zc_install/sql folder.
There are a number of INSERT INTO statements elsewhere in that file for the same table, which will be needed to populate all the default settings for product type defaults/settings/behaviours.
You can reconfigure those settings via Admin->Catalog->Product Types once the defaults are loaded.

However, if that table is missing from your backup, I suspect you likely have other problems too.

Did you delete too much when you were housecleaning the backup file?

[dreamstudio]

We had major problems with the last host and I havent met a more unfriendly unhelpful bunch. I got the original DB file and was able to remove all the rubbish and got the information needed to get the site working with some fiddling

As to daily backups, well the client was offered this service and said they would do it themselves. And we couldnt have access to php admin either so all around its been a nightmare

I have now sorted it and hoping the client either accepts us backing it up or does do this themselves