osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

1064 - You have an error in your SQL syntax.

This is a discussion on 1064 - You have an error in your SQL syntax. within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; Could someone look at this and see if this can be fixed? 1064 - You have an error in your ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Modification Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack (7) Thread Tools
  7 links from elsewhere to this Post. Click to view. #1  
Old 10-20-2004, 11:45 AM
Lurker
 
Join Date: Oct 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jamie74
Default 1064 - You have an error in your SQL syntax.

Could someone look at this and see if this can be fixed?


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 '{2}24{3}50{4}48{5}51 ORDER BY products_extra_fields

SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM products_extra_fields pef LEFT JOIN products_to_products_extra_fields ptf ON ptf.products_extra_fields_id=pef.products_extra_fi elds_id WHERE ptf.products_id=894{2}24{3}50{4}48{5}51 ORDER BY products_extra_fields_order

[TEP STOP]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

LinkBacks (?)
LinkBack to this Thread: http://www.oscmax.com/forums/oscommerce-2-2-modification-help/3432-1064-you-have-error-your-sql-syntax.html

Posted By For Type Date
error 1064 - /checkout_confirmation.php - osCommerce Community Support Forums This thread Refback 03-10-2008 04:54 AM
error 1064 - /checkout_confirmation.php - osCommerce Community Support Forums This thread Refback 01-09-2008 06:11 AM
osCommerce Community Support Forums > error 1064 - /checkout_confirmation.php This thread Refback 12-29-2007 01:42 AM
oscommerce 1064 You have an error in your SQL | osCommerce Help and CRE Loaded Support This thread Refback 06-26-2007 08:03 AM
oscommerce Error in SQL syntax | osCommerce Help and CRE Loaded Support This thread Refback 06-09-2007 03:55 PM
osCommerce Community Support Forums > error 1064 - /checkout_confirmation.php This thread Refback 02-04-2007 03:27 AM
error 1064 - /checkout_confirmation.php - osCommerce Community Support Forums This thread Refback 01-19-2007 11:07 PM

Similar Threads

Thread Thread Starter Forum Replies Last Post
1064 - error in your SQL syntax admin customer search webwolfe osCMax v1.7 Discussion 0 11-10-2006 06:13 AM
osCMax-2.0RC2-update051112 1064 Error. gamerigs osCMax v2 Customization/Mods 3 12-05-2005 06:44 AM
1064 error when creating new account CTapia osCommerce 2.2 Installation Help 2 10-01-2004 02:20 AM
1064 - You have an error in your SQL syntax. j0ly osCommerce 2.2 Installation Help 1 08-24-2004 03:13 PM
1064 - You have an error in your SQL syntax Anonymous osCMax v1.7 Installation 3 05-10-2004 10:48 AM


All times are GMT -8. The time now is 05:23 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax