Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

perform SQL queries


jennki

Recommended Posts

Posted

Inside the update guide under "MySQL 5.0 Compatibility", it said I need to perform the following SQL queries:

 

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

 

ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;

 

ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);

 

Could anyone tell me what is mean by perform SQL queries, and how to edit/ use SQL command in more details?

 

 

Thanks in advance.

Posted

If you have phpmyadmin on your site administration it's easy if you know :

 

open phpmyadmin, click on "SQL" and copy/paste your line "ALTER TABLE..." and click "GO".

Note : you have to do it line by line

MS2 2.2 fr + Manufacturer copy (5 manufacturers - modified to make it works) + More pics 6 + FCK Editor + zones shipping (modified without weight) + My contribution : Shopping Cart Management for Unique Products

 

I apologize in advance for my poor English I'm French !

Posted
If you have phpmyadmin on your site administration it's easy if you know :

 

open phpmyadmin, click on "SQL" and copy/paste your line "ALTER TABLE..." and click "GO".

Note : you have to do it line by line

 

Yes, I have phpmyadmin, do I have to enter any database/ file in order to add those lines? As there is no mention in which database I should add those lines into?

 

sorry I'm a newbie.

Posted

"Newbie mode enabled" :P

 

1/ Open phpmyadmin

2/ Select your database (the one for oscommerce)

there can be only one database for a "normal" install of oscommerce !

3/ Click on the little "SQL" logo on the upper-left part of phpmyadmin page, a new windows will popup

4/Paste your first line in the text field area

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

5/ Click "GO"

6/ repeat step 4 for your two lines left.

7/ You are done

MS2 2.2 fr + Manufacturer copy (5 manufacturers - modified to make it works) + More pics 6 + FCK Editor + zones shipping (modified without weight) + My contribution : Shopping Cart Management for Unique Products

 

I apologize in advance for my poor English I'm French !

Posted
"Newbie mode enabled" :P

 

1/ Open phpmyadmin

2/ Select your database (the one for oscommerce)

there can be only one database for a "normal" install of oscommerce !

3/ Click on the little "SQL" logo on the upper-left part of phpmyadmin page, a new windows will popup

4/Paste your first line in the text field area

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

5/ Click "GO"

6/ repeat step 4 for your two lines left.

7/ You are done

 

Noted with thanks.

Archived

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

×
×
  • Create New...