Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Amin-categorys.php debug!


OSC-Sevilla

Recommended Posts

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

DELETE FROM products_stock WHERE products_id =

 

[TEP STOP]

 

After i delete a category i get this message! The category deletes buts its contents do not (left in db).

 

included the category.php file

 

 

anyone seen this?

 

Need help!

categories.php

Link to comment
Share on other sites

That SQL is not in categories.php. Looking at the file, I see

	  reset($products_delete);
	  while (list($key) = each($products_delete)) {
	    tep_remove_product($key);
	  }

This suggests to me that the problem lies somewhere in the tep_remove_product operation. Table products_stock is not part of the regular osCommerce. You should probably post in the appropriate contribution thread instead (probably QT Pro). You could also try replacing the above code with

	  reset($products_delete);
	  while (list($key) = each($products_delete)) {
if ( 0 != (int) $key) {
	    tep_remove_product($key);
}
	  }

and see if that helps.

Always back up before making changes.

Link to comment
Share on other sites

Your right in that its a qtpro issue... the above code change did nothing but i will now trace the problem.

 

annoyingly minmerge is not availble for mac, which is what im stuck with over the weekend.

 

thank you

 

Bingo -

 

http://www.oscommerce.com/forums/topic/31484-contribution-qtpro-quantity-tracking-professional/page__st__1840

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...