justnelenasmom Posted April 25, 2004 Posted April 25, 2004 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
DnJ Posted April 25, 2004 Posted April 25, 2004 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"
justnelenasmom Posted April 25, 2004 Author Posted April 25, 2004 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??
DnJ Posted April 25, 2004 Posted April 25, 2004 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"
justnelenasmom Posted April 25, 2004 Author Posted April 25, 2004 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 :(
taz1 Posted May 4, 2004 Posted May 4, 2004 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]
TWDesignStudios Posted May 5, 2004 Posted May 5, 2004 I have the same error taz! maybe someone can help us both!
Guest Posted June 2, 2004 Posted June 2, 2004 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.
Guest Posted June 2, 2004 Posted June 2, 2004 what have you modified? what are the contributions you have installed? perhaps they were not installed all the way . . .
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.