Products table doesn't exist?

[jpweber]

But I don't know what to do. Did I somehow delete my products table?

 

1146 - Table 'mydatabase.products' doesn't exist

 

My entire OSC is messed up. Can someone tell me what to do? I have plenty of SQL backup files where I backed up my database.

 

Thanks for any direction anyone can point me in,

 

J

[jhsands]

BACKUP your CURRENT database [lets call it DB1]... restore the old database [DB2] ... export the .products field from DB2... restore DB1 and import the .products field.

 

Use PHPmyAdmin

[jpweber]

BACKUP your CURRENT database [lets call it DB1]... restore the old database [DB2] ... export the .products field from DB2... restore DB1 and import the .products field.

 

Use PHPmyAdmin

 

I only have the 1 database. This doesn't have my products field in it. I have backed it up in SQL files every other day, so I have tons of backed up SQL files. I just don't know what to do with them. You can see my site .... http://www.thevisiondepot.com ... it's a mess. But why back up my current database when that's the one missing the products field? I'm confused, but I can follow instructions if someone would let me know what to do.

 

J

[jpweber]

I did it, but some of my products are missing. Am I SOL, or is there a way I can retrieve them? I believe I added them before my last backup. Thanks!

 

Jason

[jhsands]

You wanted to backup the current database for the customers/orders you gained. If you just replaced the DB with the last backup... and didn't backup the current ... yeah, SOL. My host does a daily backup everyday... so check with your host quickly to see if they have one.

[jpweber]

You wanted to backup the current database for the customers/orders you gained. If you just replaced the DB with the last backup... and didn't backup the current ... yeah, SOL. My host does a daily backup everyday... so check with your host quickly to see if they have one.

 

 

I just found out the probably cause of my problems. Things are much better, but sometimes I can't add products properly, and sometimes I can't even log into my ADMIN properly. I had added a module, MVS, and installed the fxfreight.sql file. It looks like this:

 

ALTER TABLE `products`

ADD `products_fxf_class` VARCHAR( 3 ) DEFAULT '050' NOT NULL ,

ADD `products_fxf_desc` VARCHAR( 100 ) ,

ADD `products_fxf_nmfc` VARCHAR( 100 ) ,

ADD `products_fxf_haz` TINYINT DEFAULT '0' NOT NULL ,

ADD `products_fxf_freezable` TINYINT DEFAULT '0' NOT NULL ;

 

I have no idea if this is what caused all the problems, but if so, I don't know how to undo it, as my knowledge of SQL is limited at best. Do you have any suggestions, assuming I'm on the right path? Thanks!

 

J

[jpweber]

But I look in my table, products, and none of those things (products_fxf_class, products_fxf_dexc, etc) are there anymore, so maybe my host undid this when they restored the database? But it's still not working properly yet.

 

J

[jpweber]

I'm getting this error when I try to log into my ADMIN tool now:

 

Warning: mysql_query(): Unable to save result set in /home/mysite/public_html/catalog/admin/includes/functions/database.php on line 45

1030 - Got error 127 from table handler

 

select count(*) as count from products where products_status = '1'

 

[TEP STOP]

[jhsands]

Did you uninstall the rest of the contribution from the files you altered?

 

ALTER TABLE `products`
delete `products_fxf_class` VARCHAR( 3 ) DEFAULT '050' NOT NULL ,
delete `products_fxf_desc` VARCHAR( 100 ) ,
delete `products_fxf_nmfc` VARCHAR( 100 ) ,
delete `products_fxf_haz` TINYINT DEFAULT '0' NOT NULL ,
delete `products_fxf_freezable` TINYINT DEFAULT '0' NOT NULL;

[jpweber]

Should I do this even though I don't see those items in the products table anymore? I don't want to hurt anything any worse ...

 

J

[PD_Steve]

If your host had a backup of your site, check to see if they also run weekly and monthly backups. Its pretty much a standard function in WHM and it sounds like they might be running this. Ask them to send you the files for the weekly and monthly and roll back to before you installed this update.

 

On the servers I have I always store daily, weekly and monthly backups on a secondary hard-drive config just incase this kind of incident happens to any of my clients. I have a feeling your host may do the same.

 

Oh, dont get your host to rollback, just ask them to send you the compressed backup. They should store via account so yours will be a seperate backup to any other accounts they run. Its better to be able to examine your own files so you can see which is the correct one to use (the average OsCommerce site is not that large so it should be possible to mail to you or plonk on your account somewhere so you can download)

[jpweber]

I went to phpmyadmin and clicked "repair" next to my database, and for now, that seems to have resolved all issues. Thanks a bunch for your responses and help, and for any further suggestions you can offer.

 

J