Database error

[starburst]

I have resently moved our database to a new server and added new products to our catalog. I am now getting the following error when testing. This comes up when I click on the actual product link:

 

 

1054 - Unknown column '24_25' in 'where clause'

 

select phase_id from categories WHERE categories_id = 24_25

 

[TEP STOP]

 

 

any assistance as to what I need to do to resolve this problem would be appreciated.

[jpweber]

Not direct answers, but obviously some SQL statement is messed up somewhere. Whether it's 'cause your host upgraded, or whatever, it's anyone's guess:

 

http://www.oscommerce.com/community/bugs,3171/

 

http://www.oscommerce.com/community/bugs,3259

[starburst]

Jason,

 

Thanks for the info, I will get some assistance from an IT friend to "decode" the info in the links you sent to me.

 

This is definently not my strong point!

[jpweber]

k ... sorry I couldn't be of more help Tammy ... it's just difficult when all you have is an error statement to go by, and nothing else. If you still have problems, please post here, or e-mail me. Good luck.