Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

What does this mean??


hongbiaoke

Recommended Posts

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

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

  • 3 weeks later...

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

Archived

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

×
×
  • Create New...