Attribute Error

26 Nov 2007, 02:06

#1

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Attribute Error

When adding an attribute I get an error that says "1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes values (0, '33', '1', '1', '5', '+', '1', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '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."

can anybody help?

26 Nov 2007, 02:17

#2

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Attribute Error

Check this FAQ and others - most likely a corrupt file that is only used for attributes - https://www.zen-cart.com/tutorials/index.php?article=87

Dheck your Signature - Where are they now??

26 Nov 2007, 02:29

#3

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

kobra:
Check this FAQ and others - most likely a corrupt file that is only used for attributes - https://www.zen-cart.com/tutorials/index.php?article=87

Dheck your Signature - Where are they now??

Sorry but I do not know much about ZenCart files/configurations. The link did not help me (could not understand how to fix my problem from it) and do not understand what you mean by Dheck your Signature - Where are they now??

26 Nov 2007, 02:34

#4

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Attribute Error

do not understand what you mean by Dheck your Signature - Where are they now??

Meant

Check your signature "Want a cheap webservice to host your Zen-Cart? "- Where are they now?

26 Nov 2007, 02:41

#5

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

kobra:
Meant

Check your signature "Want a cheap webservice to host your Zen-Cart? "- Where are they now?

what do you mean by Where are they now?

26 Nov 2007, 02:53

#6

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Attribute Error

You get what you pay for!!
They are as you state "cheap hosting for Zen Cart" But apparently do not support your efforts over or above just being a host. As you are experiencing issues and are admitedly less than up to speed with Zen Cart (or other php applications) - They are not there for you to assist.

Use your FTP Client and check the files for any ZERO byte length files....

26 Nov 2007, 02:56

#7

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

Thanks but my webhost is very willing to help me when I need it. I just figured I would ask via this forum to see if anybody has had this problem before and figured that the creators of the system would be able to help me more than my webhost techs.

26 Nov 2007, 03:06

#8

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

the only zero byte file I could find is sitemapezpages.xml under the root directory.

26 Nov 2007, 03:16

#9

kobra

Black Belt

Join Date:: Aug 2005
Posts:: 31,500
Plugin Contributions:: 4

Re: Attribute Error

What Zen Cart Version?
Installed from a download or through Fantastico?
What Mods are applied?
Any other pertinent factors you can determine might be useful...

26 Nov 2007, 03:22

#10

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

Version 1.3.7, installed from a download, installed mods: TY Package tracker, PDF order center, Customer Birthdays, Export Email addresses, mailing lables and Email Archive Manager as well as DHL and FedEx shipping mods.

26 Nov 2007, 03:37

#11

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

.......

26 Nov 2007, 03:45

#12

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Attribute Error

This is a Free forum and no one is paid to help you ...

If you do not get a response in 24 hours, add-on to your post, otherwise do wait patiently for help ... thanks! :smile:

26 Nov 2007, 03:54

#13

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

sorry for the confusion. the ...... was not to rush but I had made a post that I did not mean to post so I edited it and replaced it with ..... I did not think about the way it would come across to people untill you said something.

26 Nov 2007, 04:01

#14

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Attribute Error

Yeps ... sometimes just something like:

........

dumb idea ...

scratch that ...

etc. etc. etc.

Otherwise it looks like you are bumping the post impatiently and for that, well ... we'd have to kill you ... :eek:

26 Nov 2007, 04:35

#15

website_rob

Inactive

Join Date:: Oct 2006
Posts:: 4,572
Plugin Contributions:: 0

Re: Attribute Error

jakumpe:
Sorry but I do not know much about ZenCart files/configurations.

jakumpe:
installed mods: TY Package tracker, PDF order center, Customer Birthdays, Export Email addresses, mailing lables and Email Archive Manager as well as DHL and FedEx shipping mods.

For somebody who doesn't know much about Zen Cart, you're doing pretty darn good! :yes:

As you didn't mention when the problem started, fastest solution might be to start uninstalling your Mods, one at time, then check for the error msg. Once you no longer see it you'll know which Mod is causing the problem.

Linda, that was a bit of a cheeky post.
Will have to remember to not get on your 'bad' side. :laugh:

26 Nov 2007, 04:42

#16

jakumpe

New Zenner

Join Date:: Jun 2007
Posts:: 71
Plugin Contributions:: 0

Re: Attribute Error

As far as when the problem occured, I am just now exploring the attributes so there is no way to know when it occured. As far as the mods I installed I know a little about simple programing and can do just about anything when I have instructions. I will uninstall the mods one by one but I was hoping it would be simpler as this will take for ever (wish it was a simple as clicking uninstall).

26 Nov 2007, 04:46

#17

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Attribute Error

Website Rob:

Linda, that was a bit of a cheeky post.
Will have to remember to not get on your 'bad' side. :laugh:

Even jolly ol' elves have those kinda days where just one more bumped post and gonna get all tuff ... in a nice sorta way ... :flex: