M.C. Posted April 15, 2010 Share Posted April 15, 2010 Hi. We hosted our osCommerce web site with Go Daddy and moved the web site to one of our hosts here in South Africa. I activated osCommerce on our url and then uploaded the files with my ftp. I updated the includes/configure.php and admin/includes/configure.php . On our web site now the error appears: 1054 - Unknown column 'image1' in 'field list' . select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value, image1, image2 from currencies Please if anyone can help, please Thanks Link to comment Share on other sites More sharing options...
web-project Posted April 15, 2010 Share Posted April 15, 2010 1054 - Unknown column 'image1' in 'field list' . the image1, image2 field is missing from the table. select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value, image1, image2 from currencies looking on the above sql, someone incorrectly install module, as I do not believe that names for product images should be stored in currency table! Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you. Link to comment Share on other sites More sharing options...
M.C. Posted April 15, 2010 Author Share Posted April 15, 2010 Thanks for the help Link to comment Share on other sites More sharing options...
MrPhil Posted April 15, 2010 Share Posted April 15, 2010 You'll have to ask whoever modified the code to add , image1, image2 to the field list in [admin/]includes/classes/currencies.php. Was this an add-on or a custom code edit? When the store was moved, evidently someone forgot to update the customized database fields, and is probably using a standard osC database layout. Are these images of a piece of currency, or a national flag? Link to comment Share on other sites More sharing options...
web-project Posted April 16, 2010 Share Posted April 16, 2010 Are these images of a piece of currency, or a national flag? what? 2 images per currency, something new? Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.