Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Anyone know what this SQL error is from


blucollarguy

Recommended Posts

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

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

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

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

Archived

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

×
×
  • Create New...