Thanks for this module. I install it today and all work fine (i'm check issues and fix two of problems by hand).
But i notice many records like this in my site's log:

Unknown column 'sc.session_id' in 'on clause' query: SELECT sc.sid FROM simple_cart sc LEFT JOIN sessions s ON (sc.session_id = s.sid) WHERE s.sid IS NULL в файле /home/cat/modules6/simple_cart/simple_cart.module в строке 153.

Looks like just typo in query text.

CommentFileSizeAuthor
#6 simple_cart.module.patch659 bytesami7878

Comments

zet’s picture

zet commented

same on manual cron run:

user warning: Unknown column 'sc.session_id' in 'on clause' query: SELECT sc.sid FROM simple_cart sc LEFT JOIN sessions s ON (sc.session_id = s.sid) WHERE s.sid IS NULL in /xxxx/drupal6/sites/all/modules/simple_cart/simple_cart.module on line 154.

johnaut’s picture

johnaut commented

I have changed line 152 in /xxxx/drupal6/sites/all/modules/simple_cart/simple_cart.module to

$sql = "SELECT sc.sid FROM {%s} sc LEFT JOIN {sessions} s ON (sc.sid = s.sid) WHERE s.sid IS NULL";

and now it works for me (the name of the field containing the id of the session in table sessions is sid and not session_id ==> sc.sid instead of sc.session_id).

zet’s picture

zet commented

Yeah, I've changed that too after cheking the namings in the database and is working, but I didn't have time to report back until now. Waiting for the author to commit this.

visualfox’s picture

visualfox commented

subscribing - did the same as #2 and #3 - just reporting back

vladsavitsky’s picture

vladsavitsky commented
Assigned: Unassigned » vladsavitsky
Status: Active » Fixed

Fixed in HEAD.

ami7878’s picture

ami7878 commented
StatusFileSize
new simple_cart.module.patch659 bytes

Had the same issue and thanks to johnaut problem solved.

I've added a patch with johnaut's fix.

Status: Fixed » Closed (fixed)

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