PDA

View Full Version : Anyone ever have this problem? db error after "pay for goods"


Bluestrike2
12-26-2006, 02:37 AM
First off,

I realize this is unsupported so I'm just going to see if any other users (vB 3.6.3) have had this dB error after you click "pay for goods":


Database error in vBulletin 3.6.3:

Invalid SQL:
INSERT INTO gmart_orders (
userid,
createdate,
lastmodified,
post_method,
post_value,
value,
status,
hash,
currencyid,
payment_method,
data) VALUES (
3,
1167099033,
1167099033,
0,
,
3500,
1,
'bf81d2c32a1d9ddf04aee2185d01b4ab',
1,
1,
'');

MySQL Error : 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 '
3500,
1,
'bf81d2c32a1d9ddf04aee2185d01b4' at line 17
Error Number : 1064
Date : Monday, December 25th 2006 @ 09:10:34 PM
Script : http://www.gaming-lessons.com/mart.php
Referrer : http://www.gaming-lessons.com/mart.php
IP Address : 71.206.217.133
Username : Testing
Classname : vb_database


It was weird; it was working right before this (perfectly I might add). Any experience with this?

The only thing different between this and when I originally had it working a few minutes beforehand was that I turned on PayPal's IPN (which obviously couldn't have changed anything).

The Geek
12-26-2006, 10:42 AM
Not oto sure - but the value is empty (i.e. the grand total). Are you getting these as emails or when you browse a page?

Bluestrike2
12-26-2006, 03:46 PM
It's popping up whenever I click on "pay for goods" - I should be forwarded to PayPal, but alas, I am not :(.

The Geek
12-28-2006, 10:07 AM
Are you using any modules?

Bluestrike2
12-29-2006, 05:11 PM
Yes.

The membership module. Anyhow, I didn't have anything setup really so I just reinstalled the entire thing + forums and we're golden now.