Zen-Cart & Authorize.net Error 1064

[bularae]

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

[stevel]

See this thread (http://forum.powweb.com/showthread.php?t=45352) - 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.