First off, GREAT module!

Ok, I have the module installed, and it works great, except that on "some" page loads, and most reloads, where there are items in the cart, Drupal kicks back an error like this...

* warning: Invalid argument supplied for foreach() in /home/.grim/trevhost/ws.unklenono.com/modules/node/node.module on line 561.
* warning: implode() [function.implode]: Invalid arguments passed in /home/.grim/trevhost/ws.unklenono.com/modules/node/node.module on line 565.
* user warning: 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 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM drupal_node n INNER JOIN drupal_users u ON u.uid = n.uid INNER JOIN drupal_node_revisions r ON r.vid = n.vid WHERE in /home/.grim/trevhost/ws.unklenono.com/includes/database.mysqli.inc on line 156.

and here are the corresponding entries in the Drupal Log

-------------------------------------------
Type php
Date Friday, December 5, 2008 - 06:32
User admin
Location http://ws.unklenono.com/cart/ajax/update?qty=1&form_token=3b04674f0faa43...
Referrer http://ws.unklenono.com/catalog/2/spoons
Message 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 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM drupal_node n INNER JOIN drupal_users u ON u.uid = n.uid INNER JOIN drupal_node_revisions r ON r.vid = n.vid WHERE in /home/.grim/trevhost/ws.unklenono.com/includes/database.mysqli.inc on line 156.
Severity error
Hostname 99.194.26.150
-------------------------------------------
Type php
Date Friday, December 5, 2008 - 06:32
User admin
Location http://ws.unklenono.com/cart/ajax/update?qty=1&form_token=3b04674f0faa43...
Referrer http://ws.unklenono.com/catalog/2/spoons
Message implode() [function.implode]: Invalid arguments passed in /home/.grim/trevhost/ws.unklenono.com/modules/node/node.module on line 565.
Severity error
Hostname 99.194.26.150
-------------------------------------------
Type php
Date Friday, December 5, 2008 - 06:32
User admin
Location http://ws.unklenono.com/cart/ajax/update?qty=1&form_token=3b04674f0faa43...
Referrer http://ws.unklenono.com/catalog/2/spoons
Message Invalid argument supplied for foreach() in /home/.grim/trevhost/ws.unklenono.com/modules/node/node.module on line 561.
Severity error
Hostname 99.194.26.150
-------------------------------------------

Comments

trevorleenc’s picture

the above error was generated using the following scenario...

Loaded the catalog page for "spoons" (catalog is arranged as a grid, with an add to cart field, and there is also a quantity field)
Added a product to the cart
Hit reload on the catalog page
Errors appeared.

Note: this same set of errors gets generated if I perform the above steps, and visit another page on the site, such as view cart, checkout, or open a product node page etc.

Extra Info:
Drupal: 5.12
Ucart: 1.6
Theme: Garland (error also occurs using other themes)

Finally, I tried some of the settings for the block...none of these in various odd combinations worked..

I also cannot select "Clear cart cache on every ajax call. With this option enabled, cart content is rebuilded every request.", when I select this option, and save the block, the option does not get saved...not sure if this is related or not.

thanks again!

p.s. also this site is "private" but if needed, I can provide access, as the site is still under development.

Erik Seifert’s picture

Component: Miscellaneous » Code
Assigned: Unassigned » Erik Seifert
Priority: Normal » Critical

assigned

asak’s picture

I'm getting this same errors.

tried various settings - none solve these errors.

subscribing.

Erik Seifert’s picture

@trevorleenc : Can you make me an login for testing ?

One thing also. Was this product a product kit or a normal product ?

Thanx ;- )

Erik Seifert’s picture

Status: Active » Fixed

See new version

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.