Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Login error - say table doesn't exist


disciple1

Recommended Posts

Hi,

 

I have been adding products to my database. Everything has been running fine until now.

 

I just tried to login with a fake customer I created and received this error where my shopping cart box should have been.

 

1146 - Table 'disciple_test.TABLE_PRICES' doesn't exist

 

select quantity, unitprice from TABLE_PRICES where products_id = 134 and quantity <= 1 order by quantity desc

 

[TEP STOP]

 

 

Seems like a weird error since I haven't done anything to the database except enter products. I know absolutely nothing about mySQL. Does anyone have any ideas?

 

Thanks,

 

Rick

All that is not eternal is eternally useless.

Link to comment
Share on other sites

I don't know what caused the error but I went into my sql file and found 3 products in the shopping cart. I deleted the one in question (products_id=134) and then it gave me the same error for the next one. So I deleted all of them and the problem is solved.

 

I don't remember saving anything in my cart though so I am not sure why or how they got there. I have always removed everything from my cart when testing things.

 

Anyway problem solved.

All that is not eternal is eternally useless.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...