Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

What does this error message mean?


Guest

Recommended Posts

Posted

Does anyone know what this error means? I don't know if it's referring to a catalog .php file error or admin side error, or something else like SQL.It's appearing on the product information page, and I'm getting the same kind of thing in admin too If I can get some idea where to look I might be able to fix it.

 

1054 - Unknown column 'approved' in 'where clause'

 

select count(*) as count from reviews where approved = 1 and products_id = '25'

 

[TEP STOP]

Posted

Sounds like you tried to install something like this but didn't get the sql added to the DB.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Posted

Sounds like you tried to install something like this but didn't get the sql added to the DB.

 

Thanks so much germ! :) That was the problem - I added the required sql to the database and it all is working properly now. Thanks very much for your quick response.

Archived

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

×
×
  • Create New...