Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error in Product Attributes


justnelenasmom

Recommended Posts

Something has happened with my product attributes. This is the error I keep seeing. Anyone have any thoughts as to what happened??

 

HEADING_TITLE_OPT

TEXT_OPTION_IDTEXT_OPTION_NAME

 

Warning: Division by zero in /home/jewelsby/jewelsbyjewls-www/catalog/admin/products_attributes.php on line 283

>>

 

TABLE_HEADING_ID TABLE_HEADING_OPT_NAME Action

 

1064 - You have an error in your SQL syntax near 'MAX_ROW_LISTS_OPTIONS' at line 1

 

select * from products_options where language_id = '1' order by products_options_id LIMIT 0, MAX_ROW_LISTS_OPTIONS

 

[TEP STOP]

 

 

Thanks in advance!

Jewls

Link to comment
Share on other sites

By chance did you just import info into the product table in the database?

 

If so did you export structure & data?

"One Of Life's Greatest Pleasures Is Doing What Others Say You Can't"

Link to comment
Share on other sites

By chance did you just import info into the product table in the database?

 

If so did you export structure & data?

I wasn't aware that I had...not sure what I did. My web hosting guy has taken a look at things and he's at a loss too. If the information was not backed up BEFORE this error, but backed up now, if I uninstall everything then reinstall, and restore, would that error still be there??

Link to comment
Share on other sites

Hopefully someone more knowlegeable than I can help you here as well but if you don't have any old back up of your product tables then using a current back-up would probably recreate the error as well

"One Of Life's Greatest Pleasures Is Doing What Others Say You Can't"

Link to comment
Share on other sites

Hopefully someone more knowlegeable than I can help you here as well but if you don't have any old back up of your product tables then using a current back-up would probably recreate the error as well

That's what I was afraid of. I didn't see the backup option until it was too late.

 

Hard lesson to learn :(

Link to comment
Share on other sites

  • 2 weeks later...

Does anyone have a glue why i have this error in the admin order.php ?

 

1064 - You have an error in your SQL syntax near 'limit 0, 20' at line 1

 

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '2' and s.orders_status_id = '3' and ot.class = 'ot_total' order by limit 0, 20

 

[TEP STOP]

Link to comment
Share on other sites

  • 4 weeks later...
I have the same error taz! maybe someone can help us both!

I have the same error, maybe someone can help the three of us.

Link to comment
Share on other sites

what have you modified? what are the contributions you have installed? perhaps they were not installed all the way . . .

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...