The vB Geek

Go Back   The vB Geek > vB Geek Products > GeekMart

GeekMart GMart is an integrated shopping cart system for vBulletin.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12-26-2006, 09:42 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

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?
Reply With Quote
  #3  
Old 12-26-2006, 02:46 PM
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

It's popping up whenever I click on "pay for goods" - I should be forwarded to PayPal, but alas, I am not .
Reply With Quote
  #4  
Old 12-28-2006, 09:07 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Are you using any modules?
Reply With Quote
  #5  
Old 12-29-2006, 04:11 PM
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

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

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi page articles "meta description" problem bgpa Geek Article and Review System 3 12-02-2008 03:12 AM
There is not "member rating" in "newreply.php" gollo Geek Article and Review System 9 11-11-2008 04:57 AM
Database error - missing field "softdelete" pixie Geek Article and Review System 5 03-27-2007 07:00 AM
fehler "kein benuzername.." error "username" hohleweg Geek Article and Review System 7 03-22-2007 10:28 PM
"GARS Rating" Just Like "Hot-or-Not" Voting Pehchaan Geek Article and Review System 4 12-10-2006 06:51 PM


All times are GMT. The time now is 10:26 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.