PowWeb Forums - The Perfect Community for the Perfect Host  

Register now to interact with over 11,000 members! Registered users have Posting Privileges, free access to Private Messaging, Email Notifications and more.

Go Back   PowWeb Community Forums > Web Site Design > Content Management Systems > E-commerce and Shopping Carts
User Name
Password
Register FAQ Members List Search Today's Posts Mark Forums Read

Closed Thread
 
Thread Tools Search this Thread
Old 1-13-05, 01:28 AM   #1
bularae
Registered
 
Join Date: Nov 2004
Location: Hawaii
Posts: 21
Reputation: 1
Zen-Cart & Authorize.net Error 1064

I am throwing up my hands at both Zen-Cart and OS-Commerce's forums. Thought someone here might be able to help.

I have turned on teh AIM module and when I try a transaction I get an error, for which I went and found the message being generated in the db:

#1064 - 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 'response_code`SELECT * FROM `ps_authorizenet` WHERE 1 LIMIT 0,

Anybody have any help as to what this means and what to do about it?

Thanks
bularae is offline  
Old 1-13-05, 12:31 PM   #2
stevel
XPW
 
stevel's Avatar
 
Join Date: Jun 2002
Location: New Hampshire, USA
Posts: 9,464
Reputation: 265
See this thread - I expect that ZenCart has the same bug. You will have to look around to see where to make the change in ZenCart, as yours seems to be in a different area. The "LIMIT 0" is the problem, and you'll have to figure out where that comes from and add code to make sure it is no lower than 1.
__________________
Steve
stevel is offline  
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 12:22 PM.


Contents ©PowWeb, Inc. ~ vBulletin, Copyright © 2000-2007 Jelsoft Enterprises Limited.