blucollarguy Posted July 17, 2004 Share Posted July 17, 2004 I have never seen this error before and have no idea what is causing it. :blink: I am working on a mod and have worked the code through to this error: 1064 - You have an error in your SQL syntax near 'Resource id #44' at line 1 Resource id #44 TEP STOP Can anyone enlighten me? Thanks, Craig. Happy Coding! Craig Garrison Sr Anything worth having, is worth working for. Multi Vendor Shipping V1.1 Demo Catalog 3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout. Multi Vendor Shipping V1.1 Demo Admin login: [email protected] pass: mvs_demo MVS Thread: Multi-Vendor Shipping My contribs: Download Multi Vendor Shipping V1.1 Vendor Email Vendor Info in easypopulate EZ Price Updater And more to come! Link to comment Share on other sites More sharing options...
The_ancient Posted July 17, 2004 Share Posted July 17, 2004 that mean you query is wrong and mySQL is rejecting it post the code... Link to comment Share on other sites More sharing options...
blucollarguy Posted July 17, 2004 Author Share Posted July 17, 2004 I am trying to add code to catalog/includes/classes/shoping_cart.php in order to create a new products list that will sort by vendor_id rather than just product_id. The query is: //changes mlti_vendor //get vendors_zipcode list $zipcode = tep_db_query(tep_db_query("select cb.products_id, v.vendors_id, v.vendors_name, v.vendors_zipcode from " . TABLE_CUSTOMERS_BASKET . " cb, " . TABLE_PRODUCTS . " p, " . TABLE_VENDORS . " v where customers_id = '" . (int)$customer_id . "' and cb.products_id=p.products_id and v.vendors_id=p.vendors_id ORDER by vendors_id")); while ($mlti_zipcode = tep_db_fetch_array($zipcode)) { $vendors_id=$mlti_zipcode['vendors_id']; } I have used this basic code structure many times and have never seen this error before. Any ideas? Happy Coding! Craig Garrison Sr Anything worth having, is worth working for. Multi Vendor Shipping V1.1 Demo Catalog 3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout. Multi Vendor Shipping V1.1 Demo Admin login: [email protected] pass: mvs_demo MVS Thread: Multi-Vendor Shipping My contribs: Download Multi Vendor Shipping V1.1 Vendor Email Vendor Info in easypopulate EZ Price Updater And more to come! Link to comment Share on other sites More sharing options...
blucollarguy Posted July 17, 2004 Author Share Posted July 17, 2004 I just saw my error, "(tep_db_query" doesn't belong. DUH! do you see any other issues in my code? The odd thing is everything runs with not errors now except when I try to "select" another field from the vendors table, I get "unknown field in field list". I don't understand why the list is ok as is but I can't get more info. It is wierd. Any ideas? Happy Coding! Craig Garrison Sr Anything worth having, is worth working for. Multi Vendor Shipping V1.1 Demo Catalog 3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout. Multi Vendor Shipping V1.1 Demo Admin login: [email protected] pass: mvs_demo MVS Thread: Multi-Vendor Shipping My contribs: Download Multi Vendor Shipping V1.1 Vendor Email Vendor Info in easypopulate EZ Price Updater And more to come! Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted July 17, 2004 Share Posted July 17, 2004 maybe a typo, field with or without "s" ? KEEP CALM AND CARRY ON I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support). So if you are still here ? What are you waiting for ?! Find the most frequent unique errors to fix: grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.