chrometweaks.org

What happened to my iPage site?ad it for many years and its gone...http://www.iPage.com/Hollywood/Hi

Click Here To View All Answers...


Got a question, hope someone can answer... What happened to my iPage site?ad it for many years and it's gone...http://www.iPage.com/Hollywood/Hi Hoping for any response. Another question I got... 1136 - Column count doesn't match value count at row 1.

Insert into products_attributes values ('', '30', '5', '13', '', '+').

[TEP STOP].

Tried to install Product Attributes Sort Order v1.7.

Not working to well and I need the function of this sort..

This post has been edited by.

Daimyo.

: 17 December 2008, 20:26..

Comments (33)

Good question... I dunno what is the answer. I'll do some investigation and get back to you if I got an anything. You should email the people at iPage as they probably could give you help..

Comment #1

There are 6 fields on a standard product_attribute table. So this looks like you have added a field using the sql and the update code is still putting in 6 fields rather than the new number..

Check you installed the php updates correctly. Probably be to do with a field called sort_order...

Comment #2

My moded sql has 9 tables.

Field Type Collation Attributes Null Default Extra.

Products_attributes_id int(11) No auto_increment.

Products_id int(11) No.

Options_id int(11) No.

Options_values_id int(11) No.

Options_values_price decimal(15,4) No.

Price_prefix char(1) utf8_general_ci No.

Options_values_weight decimal(5,3) No 0.000.

Sort_order int(11) No 50.

Attribute_sort int(10) UNSIGNED No 0..

Comment #3

And that statement is only inserting 6 fields.

Somewhere the php is not updating all the fields. Look through the updates you need to make, looks like at least one was not done correctly..

G...

Comment #4

So far, I found it must be in this set of php string...

Case 'add_product_attributes':.

$products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);.

$options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']);.

$values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']);.

$value_price = tep_db_prepare_input($HTTP_POST_VARS['value_price']);.

$price_prefix = tep_db_prepare_input($HTTP_POST_VARS['price_prefix']);.

$attributes_sort = tep_db_prepare_input($HTTP_POST_VARS['attributes_sort']);.

$value_weight = tep_db_prepare_input($HTTP_POST_VARS['value_weight']);.

Tep_db_query("insert into "TABLE_PRODUCTS_ATTRIBUTES" values ('', '"(int)$products_id"', '"(int)$options_id"', '"(int)$values_id"', '"tep_db_input($value_price)"', '"tep_db_input($price_prefix)tep_db_input($value_weight)"')");.

If (DOWNLOAD_ENABLED == 'true') {.

$products_attributes_id = tep_db_insert_id();.

$products_attributes_filename = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_filename']);.

$products_attributes_maxdays = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxdays']);.

$products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']);.

If (tep_not_null($products_attributes_filename)) {.

Tep_db_query("insert into "TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD" values ("(int)$products_attributes_id", '"tep_db_input($products_attributes_filename)"', '"tep_db_input($products_attributes_maxdays)"', '"tep_db_input($products_attributes_maxcount)"')");.

}.

}.

Tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));.

Break;.

I hope I don't sound annoying, I have the power to read PHP and know grammar errors in it but I can"t write any of it..

So, the grammar looks right but I have no clue at what I'm missing. I don't work in the back end much, I have a foreground I like to work in called Openlaszlo..

Comment #5

Ty, found it..

I was missing Sort_order in the Mysql not part of the attribute_order.

Its anyone comes to this again heres the most like solver.

Tep_db_query("insert into "TABLE_PRODUCTS_ATTRIBUTES" values (null,'"(int)$products_id"', '"(int)$options_id"', '"(int)$values_id"', '"(float)tep_db_input($value_price)"', '"tep_db_input($price_prefix)"', '"tep_db_input($value_weight)"', '', '"tep_db_input($attributes_sort)"')");.

8 , that the table sets..

Comment #6

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

Insert into products_attributes values ('', '30', '5', '13', '', '+').

[TEP STOP].

Tried to install Product Attributes Sort Order v1.7.

Not working to well and I need the function of this sort..

This post has been edited by.

Daimyo.

: 17 December 2008, 20:26..

Comment #7

Was there an instruction to run some sql that you did not follow?.

If so, go back and folow the instruction..

G..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.