jennki Posted December 19, 2005 Posted December 19, 2005 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.
buzuc Posted December 19, 2005 Posted December 19, 2005 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 !
jennki Posted December 19, 2005 Author Posted December 19, 2005 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.
buzuc Posted December 19, 2005 Posted December 19, 2005 "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 !
jennki Posted December 19, 2005 Author Posted December 19, 2005 "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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.