Installation

[DDhodg]

Morning Ladies & Gentlemen,

 

I am new to OsCommerce, PHP, SQL and need some help. On install I can do everything but the very first step. How do I run the file? Where do I insert the line?

 

 

************

* Database *

************

 

Run the included "attribute_sort.sql" OR insert line below

using phpMyAdmin or comparable software...

 

ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0';

 

 

I am gettting the below error message in Admin/attributes.

 

Products Attributes

 

<< Page 12 of 2 >>

 

ID Product Name Option Name Option Value Sort Order Value Price Prefix Action

 

1054 - Unknown column 'attribute_sort' in 'field list'

 

select attribute_sort from products_attributes where products_attributes_id = '45'

 

 

Please can some help. Thanks

[multimixer]

Following to do:

 

1) go to your phpMyAdmin (via your host cpanel)

2) select the DB you use for osCommerce

3) click "import" on top

4) choose the .sql file from your computer

5) click "ok"

 

That's it. This will do to the DB whatever the .sql file says to do, and your error will go away

[DDhodg]

Thanks for that:-

 

Now I have the following error

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /www/sites/6b5/4c4/web/catalog/includes/functions/database.php on line 19

Unable to connect to database server!

 

On Database is the following....

 

if (USE_PCONNECT == 'true') {

$$link = mysql_pconnect($server, $username, $password);

} else {

$$link = mysql_connect ($server, $username, $password);

}

 

i would be grateful if you can help

[Acknowledeged74]

I have downloaded the latest version of the add on but there isn't a "attribute_sort.sql" in the zipped folder ?