Forums / Upgrading from 1.2 to 1.3.x / insert into zen_products_attributes values -- error

insert into zen_products_attributes values -- error

Locked

Started by marcie on 1 Feb 2007, 9:43 PM · Views: 3,400

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
1 Feb 2007, 9:43 PM
#1
marcie avatar

marcie

New Zenner

Join Date:
Jan 2005
Posts:
25
Plugin Contributions:
0

insert into zen_products_attributes values -- error

I upgraded from an older (not exactly sure what version) of Zen Cart to the newest and installed the wholesale pricing mod and now I get this error:

1136 Column count doesn't match value count at row 1 in:
[insert into zen_products_attributes values (0, '280', '1', '2', '12.0000', '+', '1', '0', '0', '+', '0', '0', '1', '', '0', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '0', '0')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

When trying to copy a product. If I uncheck "copy attributes" then it goes through fine.

Can anyone tell me what may be the problem?

Thanks

27 Mar 2008, 3:30 AM
#2
haleann avatar

haleann

New Zenner

Join Date:
Dec 2007
Posts:
3
Plugin Contributions:
0

Re: insert into zen_products_attributes values -- error

if you get this error, it means u must have updated your zc, but the attributes file did not,

this is a simple fix

log into your php my admin, if you cannot do this, tell your webhost to do it,

you have the wrong files labeled,

the file labeled zen_products_attributes is the old file.

there should be another file called, products_attributes

click on operations

and rename. basically swap the prefixes,

i hope i explained this ok,
jean:blink::smartalec: