NukeCoder

Joined: Apr 10, 2007 Posts: 16

Hi there, been trying to get my shop working with selling items (been free till now), added item ok, however when I 'add to cart' nothing's happening. This error appeared;

Quote:

[07-09-07 01:01:47 am] [mdb2_error: message="MDB2 Error: syntax error" code=-2 mode=callback callback=handle_pear_error prefix="" info="_doquery: [Error message: Could not execute statement] [Last executed query: SELECT * FROM shop_items WHERE item_id IN()] [Native code: 1064] [Native 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] "]

Item can be viewed at;

http://www.noizeviolation.com/modules.php?name=Digital_Shop&act=showItem&item=3

Any help is much appreciated Wink

Site Admin Joined: Oct 25, 2004 Posts: 921

put the following into an empty file and save as session.php

php:

<?php

session_start();

?>

Upload that to your shop installation(in the /lib folder) and overwrite the original
Let me know if it doesn't help.

Joined: Apr 10, 2007 Posts: 16

Nope getting same error.

Below error it also reads;

Item successfully added to cart!
Continue Shopping
There are no items in your cart!

Site Admin Joined: Oct 25, 2004 Posts: 921

Ok, I'll have to look deeper into this. I'll be sending you an email soon.
Thanks.

Joined: Apr 10, 2007 Posts: 16

OK cheers m8

Site Admin Joined: Oct 25, 2004 Posts: 921

For anyone looking for the fix, you can find it here http://nukecoder.com/ftopict-407-_Fix_Cart_not_working_in_206.html [Private, shop owners only]
Applies to version 2.0.6 only!

Joined: Jun 23, 2007 Posts: 3

Have this problem too.

When I change the session file and place the fix code in the cart file, I stopped getting the error message, but now there is just empty space inside the table that should have the item added to cart.

Tried going back to original session file, but then I get a SESSION ERROR

Up to this point, the program is very nice. Makes adding a lot of pp items much easier.

Thanks in advance...

p.s. have the program installed at tapology.org

Site Admin Joined: Oct 25, 2004 Posts: 921

Ok, hang tight, I'll get to work on fixing it asap...
If you need to open your shop up, you can always switch to the "Single Item Mode" to get it working for now.

Joined: Jun 23, 2007 Posts: 3

Thanks,

I have a few more items to add, and alerted the group to the problem already, so I have maybe 2 days grace before they start pestering me Smile

Site Admin Joined: Oct 25, 2004 Posts: 921

Updated this thread with a new fix...
http://nukecoder.com/ftopict-407-_Fix_Cart_not_working_in_206.html
Let me know how it works.

Joined: Jun 23, 2007 Posts: 3

Trying it out now,

I'll let you know ...

Thanks