hongbiaoke Posted July 9, 2004 Share Posted July 9, 2004 I'm trying to install a contri, but I do not know what does this mean: -------------| RUN THE SQL | ------------- ALTER TABLE `orders` ADD `ipaddy` VARCHAR(15) NOT NULL; The contri I'm trying to install is IP Recorder by Acheron (http://www.oscommerce.com/community/contributions,2138/) I'm not sure how to do that. Do I go into SQL and add table or what? I'm a noob to SQL as well as PHP, so go easy on me. Thank in advance! Link to comment Share on other sites More sharing options...
241 Posted July 9, 2004 Share Posted July 9, 2004 Id you have phpMyAdmin then you would startup phpMyadmin and in the left hand frame select the database, then in the right hand frame select the sql tab and in the sql query window paste the code ALTER TABLE `orders` ADD `ipaddy` VARCHAR(15) NOT NULL; then click go, that should now have added the ipaddy to the orders table. No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Guest Posted July 27, 2004 Share Posted July 27, 2004 I have installed this correctly on a fresh version of osCommerce. However i see no sign of it in the order purchase process and when i attemp to view a order placed i get this error: 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 'where orders_id = '2'' at line 1 select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, ipaddy, last_modified fromorders where orders_id = '2' [TEP STOP] Plz help! :) Link to comment Share on other sites More sharing options...
Guest Posted July 27, 2004 Share Posted July 27, 2004 You made a small typo: fromorders should be from orders Link to comment Share on other sites More sharing options...
Guest Posted July 27, 2004 Share Posted July 27, 2004 Where and how do i fix this? Link to comment Share on other sites More sharing options...
♥yesudo Posted July 27, 2004 Share Posted July 27, 2004 do a search for fromorders on the underlying php page where the error occurs. Your online success is Paramount. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.