Funky issue - restore has created bigger problems

[epinFLA]

I noticed today that my store was acting up - every time I click on a catagory I would get a strange error. I thought I would go back and restore to an eariler date and when I did I got this error message:

 

 

1146 - Table 'gavasys_oscommerce.sessions' doesn't exist

 

select value from sessions where sesskey = '00e4da40afaf92d4ac358538e5c4398d' and expiry > '1225579804'

 

[TEP STOP]

 

Any ideas of how I can get this back on its feet??

 

Thanks,

 

Rick

[Hotclutch]

I noticed today that my store was acting up - every time I click on a catagory I would get a strange error. I thought I would go back and restore to an eariler date and when I did I got this error message:

 

 

1146 - Table 'gavasys_oscommerce.sessions' doesn't exist

 

select value from sessions where sesskey = '00e4da40afaf92d4ac358538e5c4398d' and expiry > '1225579804'

 

[TEP STOP]

 

Any ideas of how I can get this back on its feet??

 

Thanks,

 

Rick

 

It could be that your backup.sql file is too big and timimg out when you do the restore. Try breaking up your backup.sql (obviously keep a good copy safe somewhere) into 2 or more parts and then execute them on your database in phpMyAdmin.

[Hotclutch]

I noticed today that my store was acting up - every time I click on a catagory I would get a strange error. I thought I would go back and restore to an eariler date and when I did I got this error message:

 

 

1146 - Table 'gavasys_oscommerce.sessions' doesn't exist

 

select value from sessions where sesskey = '00e4da40afaf92d4ac358538e5c4398d' and expiry > '1225579804'

 

[TEP STOP]

 

Any ideas of how I can get this back on its feet??

 

Thanks,

 

Rick

 

It could be that your backup.sql file is too big and timimg out when you do the restore. Try breaking up your backup.sql (obviously keep a good copy safe somewhere) into 2 or more parts and then execute them on your database in phpMyAdmin.

[Guest]

Is the backup recent and no addons installed after the date of the back up?

[epinFLA]

I backup up the DB about 2 months ago and have not added any addins between than and now.

[epinFLA]

It could be that your backup.sql file is too big and timimg out when you do the restore. Try breaking up your backup.sql (obviously keep a good copy safe somewhere) into 2 or more parts and then execute them on your database in phpMyAdmin.

 

The file is only 684kb - how would I split it? 684kb is small (at least I think it is small)

[Hotclutch]

The file is only 684kb - how would I split it? 684kb is small (at least I think it is small)

 

Then go to phpMyAdmin, select SQL, then copy and paste the contents of your backup.sql into the white box area and click GO (This is located on your server in Catalog\admin\backups and usually has a name with a date stamp). ANY CHANGES YOU HAVE MADE TO THE DATABASE SINCE YOU MADE THE BACKUP TWO MONTHS AGO WILL BE LOST.

[epinFLA]

Then go to phpMyAdmin, select SQL, then copy and paste the contents of your backup.sql into the white box area and click GO (This is located on your server in Catalog\admin\backups and usually has a name with a date stamp). ANY CHANGES YOU HAVE MADE TO THE DATABASE SINCE YOU MADE THE BACKUP TWO MONTHS AGO WILL BE LOST.

 

 

That worked to restore OSC, but I still have the orginal message:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21'

 

This happens when you click on any of the categories for the products - any ideas?

 

Thanks,

 

Rick

[Guest]

That worked to restore OSC, but I still have the orginal message:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21'

 

This happens when you click on any of the categories for the products - any ideas?

 

Thanks,

 

Rick

I seem to remember that it has been answered previously in the forum.

[Hotclutch]

That worked to restore OSC, but I still have the orginal message:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21'

 

This happens when you click on any of the categories for the products - any ideas?

 

Thanks,

 

Rick

 

Search the contributions for that error code. It will explain how to fix it.

[epinFLA]

Search the contributions for that error code. It will explain how to fix it.

 

I found one entry, but no reference on how to fix it - anyone have any ideas??

[Hotclutch]

I found one entry, but no reference on how to fix it - anyone have any ideas??

 

Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'