firstbizsoft Posted February 5, 2016 Share Posted February 5, 2016 Hi all, Give me this error There was a problem importing the database. The following error had occured: Column count doesn't match value count at row 1 Please verify the connection parameters and try again. when I try install the oscommerce 2.3.4BS by Garry on my hostinger.es account. Pls help me. Regards Link to comment Share on other sites More sharing options...
MrPhil Posted February 5, 2016 Share Posted February 5, 2016 Are you trying to import an older store's data into the current osC? It sounds like a column was added to the database definition some time between the two. Normally you would upgrade an old database step by step to bring it into compatibility with the new store's database layout. If you can tell us what the old store was running at, someone can give you the steps. It is quite possible to manually edit the .sql or .csv file to add or change fields so it can be imported. Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 5, 2016 Author Share Posted February 5, 2016 I created a new database then I import the oscommerce.sql from install folder. Don't give me any error. When I point in my browser http:// mysite.com/install, in the step 1 I introduce the database name, pass etc, and when I click to go to the second step give me this error. Link to comment Share on other sites More sharing options...
MrPhil Posted February 5, 2016 Share Posted February 5, 2016 So this is a fresh install with the sample store merchandise? Are you sure you're using the oscommerce.sql that came with 2.3.4BS and not one from 2.3.4 (or an earlier version)? They're different. Doesn't the install do all this for you -- why did you manually import the oscommerce.sql file? Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 8, 2016 Author Share Posted February 8, 2016 Hi Phil, Sorry for not response at your last post, but I have problems with my internet provider. I intented again today. Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 8, 2016 Author Share Posted February 8, 2016 I deleted the database. Created new one. And I'am sure using the the oscommerce.sql that came with 2.3.4BS and not one from 2.3.4 (or an earlier version). And still give me the same error. What I did wrong? The hosting name is hostinger.es Link to comment Share on other sites More sharing options...
MrPhil Posted February 8, 2016 Share Posted February 8, 2016 Why are you importing the database and then running the installer? The installer should be handling the DB import. Try emptying out all the tables in the database and try the install again. I think you will still need to manually create an empty database. Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 8, 2016 Author Share Posted February 8, 2016 Thank you , for your patience. Finally, I deleted all data from my host account. Download the last version of bs234 edge from github, upload it, create a new database, and install without problems Tks, Phill Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.