Count doesn't match value

[characterdriven]

Thanks again for your help. That seems to be it as all attributes are playing nicely now. Much appreciated.

/admin/includes/functions/general.php
line 1929:

          // New attribute - insert it
// @TODO: MySQL5
          $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values (0, '" . $products_id_to . "',

replace with:

          // New attribute - insert it
          $db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '" . $products_id_to . "',

[vivaraquel]

I've done the previous steps as I was getting that error messagw.

When I go to admin>cat>products with attributes stock I now get this error message:
1146 Table 'easybead_zc1.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="241"]

aaaah you gotta have a laugh!!

[vivaraquel]

Not laughing now. I can't add products to cart, even products with no attributes cuz I get the quoted error.

I really need help fast for this, my cart is out of order. And I have no idea what it means. Even though I have tried to add a product order than product id#241, the message keeps coming up.

Thanks.

[DrByte]

I've done the previous steps as I was getting that error messagw.

When I go to admin>cat>products with attributes stock I now get this error message:
1146 Table 'easybead_zc1.zen_products_with_attributes_stock' doesn't exist
in:
[select * from zen_products_with_attributes_stock where products_id="241"]

You partially installed a contribution. Apparently for attribute stock. But you didn't do the database part. Presumably there are instructions for that in the readme files for the contribution.

I suggest you go to the contribution's readme / installation instructions and double-check everything. Failing that, report your problem in the support thread for that contribution.

[vivaraquel]

Thanks for that DrByte. That must have been the part I didn't understand on how to do.

Do I upload the stock_attribute.sql file via ftp or through the tools>install SQL patches?

Thank you for your prompt reply.

[kuroi]

Do I upload the stock_attribute.sql file via ftp or through the tools>install SQL patches?

tools>install SQL patches

[gfogleman]

I have a similar issue, but with regard to the Authorize.Net Sim module. My error is:

1136 Column count doesn't match value count at row 1
in:
[insert into zen_orders_status_history (comments, po_number, orders_id, orders_status_id, date_added) values ('Credit Card payment. AUTH: 507639. TransID: 1908858370.' , '82','', now() )]

My code in catalog/includes/modules/payment/authorizenet_aim.php is:

function after_process() {
global $insert_id, $db;
$db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (comments, po_number, orders_id, orders_status_id, date_added) values ('Credit Card payment. AUTH: " . $this->auth_code . ". TransID: " . $this->transaction_id . ".' , '". (int)$insert_id . "','" . $this->order_status . "', now() )");
return false;
}

I am not spotting the issue but am surely overlooking the obvious. Any ideas?

Thanks!

Gary

[DrByte]

I have a similar issue, but with regard to the Authorize.Net Sim module.

My code in catalog/includes/modules/payment/authorizenet_aim.php is:

So, which one are you using? SIM or AIM?
What version of Zen Cart?

[gfogleman]

OOPS! I meant my Authorize.Net AIM module.

Version 1.3.7.1

[DrByte]

There's an updated AIM module for 1.3.7.x, which includes some improvements and some of the newer features of the 1.3.8 version. The beta version for 1.3.7.x is here: http://www.zen-cart.com/forum/showth...023#post441023

For the full improvements for 1.3.8, you'll need to upgrade to 1.3.8