Restored Database, but some products missing

[jpweber]

I restored my database, got my 'products' table back, but some of the products are missing, and these are pages I worked a lot on. Anyone have a clue as to what (if anything) I can do about this to get the products back?

 

I last backed up my database on August 11th, and I made the products on the 9th or 10th. Any reason they're not showing? What can I tell my host, or what can I do myself?

 

Thank you for any suggestions!

 

J

[jhsands]

Do you install a contrib after that which used an attribute mod that modified the database?

[jpweber]

Yes, I did, great thinking. MVS ... and here was hte fxfreight.sql that came with it:

 

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 ;

 

It's still not working 100% perfectly; I'm having trouble installing new products properly. Is there a code that can undo this, and do you think this was the cause?

 

J

[jpweber]

But I looked in my phpadmin, products table, and I don't see any of these things like products_fxf_class or products_fxf_desc there, so maybe my host took care of this when they restored the database. Things still aren't working properly, though. When I log into my admin right now, I get this error:

 

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]

see the other thread we have running...

[jpweber]

My host took the backup of my catalog folder and replaced with backup catalog and above admin URL seems to be working fine. Please check and let me know if you still have problem.

 

So whatever he did, it works now. Thanks for all of your input and help. Issues appear to be resolved! Thanks again,

 

J