RE: SECv2.2 with Credit Class and GVv5.05 for MS2

Ajeh <[email protected]> 11 Sep 2003 02:50:40 -0000
Newsgroups gmane.comp.web.oscommerce.contributions
Message-ID <0ecefe69ca1f3d9bf7359f996692bd9b@osCommerce-Forums>
This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=227692#227692
----------------------------------------------------------------

[quote="ollie53"]Joseph,
How did you get rid of your first error? The one that said:

Warning: Invalid argument supplied for foreach() in /var/www/html/catalog/includes/modules/main_categories.php on line 50

I'm getting the same error! Thanks![/quote]

It looks like you also missed one of the sql files that needs to be run or you have additional fields in your products_attributes table.

The structure should be:
[code]  products_attributes_id int(11) NOT NULL auto_increment,
  products_id int(11) NOT NULL default '0',
  options_id int(11) NOT NULL default '0',
  options_values_id int(11) NOT NULL default '0',
  options_values_price decimal(15,4) NOT NULL default '0.0000',
  price_prefix char(1) NOT NULL default '',
  products_options_sort_order int(11) NOT NULL default '0',
  product_attribute_is_free tinyint(1) NOT NULL default '0',
  products_attributes_weight decimal(8,4) NOT NULL default '0.0000',
  products_attributes_weight_prefix char(1) NOT NULL default '',
  attributes_price_onetime decimal(15,4) NOT NULL default '0.0000',
  attributes_display_only tinyint(1) NOT NULL default '0',
  attributes_default tinyint(1) NOT NULL default '0',
  attributes_qty_prices_onetime text,
  attributes_discounted tinyint(1) NOT NULL default '1',
  attributes_price_factor decimal(8,2) NOT NULL default '0.00',
  attributes_price_factor_offset decimal(8,2) NOT NULL default '0.00',
[/code]