Help

[splitbux]

I added a attribute sort order contribution and it didn't work properly so i removed it. i deleted the mysql enty it made and removed the new added lines in php files. Now when i goto any one of my products at the bottom where the attributes should be it does not display them instead it displays this error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/37/d182686405/htdocs/catalog/includes/functions/database.php on line 99" and on line 99 it says this

 

function tep_db_fetch_array($db_query) {

return mysql_fetch_array($db_query, MYSQL_ASSOC);

}

 

Please someone help me fix this problem. I know i even replaced all edited php files with my backed up ones and this error still won't go away.

[dynamoeffects]

The problem isn't with that function, it's with the query you passed to it. Post the queries that you modified here.

[splitbux]

this is what it added to mysql database "ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0';"

so i deleted the attribute_sort column in the table.

[dynamoeffects]

Did you also remove "attribute_sort" from all other queries as well?

[splitbux]

didnt it only added attribute_sort to that one table. I did a search of attribute_sort of my whole database and it didnt find it. Then again i might not understand what you mean as i dont know much about mysql or php. if you can please explain in detail a little better

[dynamoeffects]

You're getting queries and tables mixed up. Open all of the files that you modified and search and remove all instances of "attribute_sort." Hopefully that doesn't cause more problems than it solves, but it's the only simple way I can think of explaining it.

[splitbux]

i have searched through all the files and there are no "attribute_sort" lines i dont know what else to do.

[splitbux]

i replaced the edited files with fresh install files and it fixed it thanks for all your help.