View Single Post
  #1  
Old 12-26-2006, 01:37 AM
Bluestrike2 Bluestrike2 is offline
Member
 
Join Date: Dec 2005
Posts: 32
GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default Anyone ever have this problem? db error after "pay for goods"

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":

Code:
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).
Reply With Quote