All kinds of errors abound upgrading CGEcommerce UGH!!!!

[pixelita]

First the Products module bellyached it needed upgrading, so I did or attempted to, rather. When I clicked on the upgrade link in the module manager, it complained it was missing a database table.

I then took everything back down to a known working state; e.g., deleted all the ecommerce module folders via FTP, went back to an old testbed, downloaded the XML files for CGEcommerce, Cart, Orders, PayPal Gateway, and Products, installed those on the new testbed.

Then everything upgraded okay except the Products module which is now giving this error in the Products area of the dashboard:

Code: Select all

Warning: Invalid argument supplied for foreach() in /home/mytestbe/public_html/honfish/modules/Products/Products.module.php on line 429

I don't know enough about PHP really to know what it is complaining about or how to fix it.

The whole upgrade process was spawned to begin with because the Products module was giving me TWO of every product, and if I went into the database, there was only ONE of them there; but if I went back to the dashboard and deleted one, they'd both be gone.

Ideas anyone?

Here is the CMSMS info:
----------------------------------------------

Cms Version: 1.10.2

Installed Modules:

* CMSMailer: 2.0.2
* FileManager: 1.2.0
* MenuManager: 1.7.7
* ModuleManager: 1.5.3
* News: 2.12.3
* nuSOAP: 1.0.2
* Printing: 1.1.2
* Search: 1.7
* ThemeManager: 1.1.4
* TinyMCE: 2.8.4
* Gallery: 1.4.1
* Captcha: 0.4.5
* Cataloger: 0.10
* CGExtensions: 1.28.1
* CMSForms: 0.0.20
* FormBuilder: 0.7.2
* ShopMadeSimple: 0.3.2
* Uploads: 1.14.2
* Play: 1.0.3
* FrontEndUsers: 1.17.1
* JQueryTools: 1.0.10
* CGEcommerceBase: 1.3.9
* CGSimpleSmarty: 1.5
* CGPaymentGatewayBase: 1.0.11
* AJAXStarRatingBar: 0.9.2
* Products: 2.17
* Cart: 1.8.2
* PaypalGateway: 2.3.5
* Orders: 1.13
* OrdersToIIF: 1.1
* OwnersManual: 1.0.2
* AdvancedContent: 0.9.2
* RateThis: 1.0
* ContentAliases: 0.6.11
* CGMyOrders: 1.0
* ShareItPop: 0.1.1
* CMSPrinting: 1.0
* MicroTiny: 1.1.1


Config Information:

* php_memory_limit:
* process_whole_template: false
* output_compression: false
* max_upload_size: 50000000
* default_upload_permission: 664
* url_rewriting: mod_rewrite
* page_extension:
* query_var: page
* image_manipulation_prog: GD
* auto_alias_content: true
* locale:
* default_encoding: utf-8
* admin_encoding: utf-8
* set_names: true


Php Information:

* phpversion: 5.2.9
* md5_function: On (True)
* gd_version: 2
* tempnam_function: On (True)
* magic_quotes_runtime: Off (False)
* E_STRICT: 0
* memory_limit: 64M
* max_execution_time: 30
* output_buffering: On
* safe_mode: Off (False)
* file_uploads: On (True)
* post_max_size: 8M
* upload_max_filesize: 50M
* session_save_path: /tmp (1777)
* session_use_cookies: On (True)
* xml_function: On (True)


Server Information:

* Server Api: cgi
* Server Db Type: MySQL (mysql)
* Server Db Version: 5.0.95


----------------------------------------------

[pixelita]

Okay, this is weird. In the above CMSMS info, it says SHOP MADE SIMPLE is installed, and it is not. Here is a screen dump of my installed modules page and SMS is nowhere on there.

[myshko]

Hi Pixelita,

I originally suggested updating to Orders 1.13.1, but there are a few critical issues and I wouldn't advise updating just yet.

http://dev.cmsmadesimple.org/bug/view/7859
http://dev.cmsmadesimple.org/bug/view/7772

If it was me, I'd compare that file (Products.module.php) with the previous version, at that line and see if there is a typo or some redundant code.

I am using the same ecommerce module versions, and I can't recreate the issue at this time, although I am using cmsms 1.10.3 "Hyacinthe".

Perhaps ugrading CMSMS core will resolve the issue?

Regards,

Mikey

[Dr.CSS]

It seems that at some point the site might have had SMS installed and after uninstall it didn't clean all it's tables in DB, I would look in DB for any instance of it...

[pixelita]

Thanks! I will look into that. This poor site has been to hell and back and I think it would benefit from fresh files and a clean database.