Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / After QBI Install - 1136 Column count doesn't match value count at row 1

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

Locked

Views: 2,330

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
2 Apr 2008, 4:11 AM
#1
bostitch avatar

bostitch

New Zenner

Join Date:
Mar 2007
Posts:
33
Plugin Contributions:
0

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

After install of QBI 3.70 - I am getting 1136 Column count doesn't match value count at row 1 when trying to add attributes.

Can anyone explain what code and files to change to correct this?

I do know QBI added things to the database - and I have read this can affect 1 or all 3 of the following files:

/admin/attributes_controller.php
/admin/includes/functions/general.php <-- This is the one affected by Copying attributes
/admin/options_values_manager.php

But I have no idea what to do to fix the problem. I am so in need of help here...
:(

2 Apr 2008, 4:17 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: After QBI Install - 1136 Column count doesn't match value count at row 1

What version of Zen Cart?
What other addons are installed?

2 Apr 2008, 4:43 AM
#3
bostitch avatar

bostitch

New Zenner

Join Date:
Mar 2007
Posts:
33
Plugin Contributions:
0

Re: After QBI Install - 1136 Column count doesn't match value count at row 1

Thanks for the reply Dr. Byte

Zencart 1.3.7

QBI 3.7

Sereral other contributions (don't have list - some paid custom work)

  • but I don't think any of the contributions really change attribute code (much?).
    I compared my admin/attributes_controller.php to original file from 1.3.7 and the only difference is 2 lines of code

    $dir->close();
    (in 2 places which are both in the line above) sort($dir_info);

line 1341 and
line 1801

I don't know what that does. But, is this any help to identify what I need to fix?

2 Apr 2008, 5:04 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: After QBI Install - 1136 Column count doesn't match value count at row 1

One of the updates in v1.3.8 was a change to the attributes_controller script so that it lists the specific database table field names when attempting to do the record inserts, because things like QBI and other addons added extra fields to the core tables, which the core code hadn't anticipated.

You could try merging the v1.3.8 version of the file into your current version.

2 Apr 2008, 8:24 AM
#5
bostitch avatar

bostitch

New Zenner

Join Date:
Mar 2007
Posts:
33
Plugin Contributions:
0

Re: After QBI Install - 1136 Column count doesn't match value count at row 1

Yes!!! It worked.

Thank you so much.

I just replaced admin/attributes_controller.php from 1.3.8.a into my 1.3.7 and the error is gone and I am now adding attributes again.

Thank again Dr. Byte.:clap: