Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Trouble Copying product in control panel


ksaun

Recommended Posts

Hey All, :D

 

I get this error message when I try to copy products to different folders in the Admin Control Panel in OSC.

 

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

 

insert into products (products_quantity, products_model,products_image, products_bimage, products_retail_price, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('1', 'C3903A', 'C3903A.jpg', 'hp-logo.gif', '48.4100', now(), '', '4.00', '0', '3', '0')

 

[TEP STOP]

 

I have recently installed the EZ new Fields Contrib so I believe it is related to that.

 

Any Idea How to fix it? :blink:

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

if you read thru the insert and compare to the data you are inserting, you are missing something here:

 

products_retail_price, products_price,

Link to comment
Share on other sites

if you read thru the insert and compare to the data you are inserting, you are missing something here:

 

products_retail_price, products_price,

 

Missing from where? :blink:

 

I looked over the instructions and I made all the changes it said to make in steps 1 thru 8.

 

So where is the problem?

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

Missing from where? :blink:

 

I looked over the instructions and I made all the changes it said to make in steps 1 thru 8.

 

So where is the problem?

 

Anybody?? :blink:

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

you are either missing the product retail price or the product price

 

column count is 12 but input values are 11

 

products_quantity,

products_model,

products_image,

products_bimage,

products_retail_price,

products_price,

products_date_added,

products_date_available,

products_weight,

products_status,

products_tax_class_id,

manufacturers_id

 

that is 12 columns

 

values

 

'1',

'C3903A',

'C3903A.jpg',

'hp-logo.gif',

'48.4100',

now(),

'',

'4.00',

'0',

'3',

'0'

 

that is 11 values therefore

 

1136 - Column count (12) doesn't match value count (11)

 

you are either missing a value or have one column more than required

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

you are either missing the product retail price or the product price

 

column count is 12 but input values are 11

 

products_quantity,

products_model,

products_image,

products_bimage,

products_retail_price,

products_price,

products_date_added,

products_date_available,

products_weight,

products_status,

products_tax_class_id,

manufacturers_id

 

that is 12 columns

 

values

 

'1',

'C3903A',

'C3903A.jpg',

'hp-logo.gif',

'48.4100',

now(),

'',

'4.00',

'0',

'3',

'0'

 

that is 11 values therefore

 

1136 - Column count (12) doesn't match value count (11)

 

you are either missing a value or have one column more than required

 

I just looked in my database and I have all 12 of them plus these 2

 

products_last_modified

 

products_ordered

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

No, they're telling you that there are not enough values being entered to match the number of columns in your db, and the missing value is one of the prices, which ever one is not 48.41. The likely cause is in adding the extra field, the contrib may not be written to account for copying. The file that would need to be modified would be admin/categories.php. When you look at the product in admin does the extra field show up?

 

Jeremy

Link to comment
Share on other sites

No, they're telling you that there are not enough values being entered to match the number of columns in your db, and the missing value is one of the prices, which ever one is not 48.41.  The likely cause is in adding the extra field, the contrib may not be written to account for copying.  The file that would need to be modified would be admin/categories.php.  When you look at the product in admin does the extra field show up?

 

Jeremy

 

Yeh, the extra field for the Retail Price is in the Admin Control Panel for every product I have on the site. I have entered several of the Retail Prices for many products already and they all seem to be working fine. And they display correctly on the site itself.

 

The only 2 weird things that I noticed was in the main listing for each product, the one that shows the edit button as well as the copy button, all prices for the Retail Price are $0.00. Even for the ones I have already added. And when I try to copy and item it gives me the error listed above.

 

Any Ideas? :huh:

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

Anybody?? :blush:

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

The likely cause is in adding the extra field, the contrib may not be written to account for copying.  The file that would need to be modified would be admin/categories.php.

Jeremy

 

You'll need to look in the file to see where you need to add code to account for your new entry.

 

Jeremy

Link to comment
Share on other sites

You'll need to look in the file to see where you need to add code to account for your new entry.

 

Jeremy

 

Thanks Jeremy :thumbsup:

 

it was this line that I forgot to add that caused the problem

 

BEFORE:

'" . tep_db_input($product['products_price']) . "',

ADD:

'" . tep_db_input($product['products_retail_price']) . "',

My Favorite Quote from a movie.

 

Question: How do you know women sooo well?

 

Answer: I think of a man, then take away reason and accountability.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...