Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Error...


hityr5yr

Recommended Posts

Hi,

 

Following your instructions to run moneybookers.sql for updated DB I've got following error while importing the file into my OSC database:

 

Error

 

SQL query:

 

INSERT INTO orders_status

VALUES ( 88888, 1, 'Moneybookers before process' ) ;

 

MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

 

Please advise how to complete the installation.

 

Thank you.

 

Peter

Link to comment
Share on other sites

  • 1 month later...
  • 2 months later...
TTT.

 

Still looking for info if anybody has any.

 

Thanks!

 

I installed a fresh OSCommerce and tried (again) to dump moneybookers.sql into the fresh database.

Unfortunately the same message

 

SQL query:

 

INSERT INTO orders_status

VALUES ( 88888, 1, 'Moneybookers before process' )

 

MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

 

 

Probably I need to change the number of columns on orders_status in my database, or add a line about that into the moneybookers.sql, but I dont know how ....

 

Please advise

Thanks for your time

J de Groot

Link to comment
Share on other sites

I have 2 extra columns

 

INSERT INTO orders_status VALUES ( 88888, 1, 'Moneybookers before process', 1, 0)

 

Might work or Browse the table and add the status manually. or go to your shop's Admin panel >> Localisation >> Order Status.

 

Your choice...

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

  • 8 months later...

The only reason for that to happen is if you have a non-standard osCommerce orders_status MS2.2 RC2a table in your osC MySQL database with either more or less than 5 columns that the standard osCommerce orders_status table has.

These are the 5 columns in the latest osCommerce:

orders_status_id language_id orders_status_name public_flag downloads_flag

You probably have an old version of osC installed, so I highly recommend that you upgrade to the latest MS2.2 RC2a.

If you don't want to upgrade the entire shop, I suggest you run the following SQL commands at least (they will add 2 extra columns to the table):

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

 

And then try installing MB sql again.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...