Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Authorize.net AIM installation problem


Recommended Posts

I downloaded from the oscommerce site the "Install Guide" for implementing the Authorize.net Advanced Integration Method (AIM). On the first page of those instructions, it says - "Run this SQL query on your store's database:


ALTER TABLE 'orders' ADD 'transaction_details' TEXT NULL AFTER 'cc_expires';


When I try to do this, I get an error: "You have an error in your SQL syntax."


I've tried substituting the name of my SQL file for 'orders' and still get the error.


My hosting company has provided MySQL ver. 5.0.51a and PHP ver. 5.2.6


Any clues or suggestions for how to get this SQL query to work?


Incidentally, the tool I am using to input the query on my website is the mysql_send.php program from the book, "PHP & MySQL for Dummies" by Janate Valade published by Wiley, which uses mysqli type statements.


- Roger

Link to comment
Share on other sites

Apparently the problem with this syntax...


ALTER TABLE 'orders' AADD 'transaction_details' TEXT NULL AFTER 'cc_expires';


is that it should be...


ALTER TABLE orders AADD transaction_details TEXT NULL AFTER cc_expires;


...WITHOUT the single quotes shown in the example from the Install Guide.


When I removed these single quotes, then the SQL query worked.


- Roger

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...