[SOLVED] Website and Admin Panel slow after upgrading

[inyerface]

I duplicated a client website EXACTLY then ran an upgrade from 1.2.3 to 1.6.6.  Eveything worked well until I added the Products/Orders suite now the website and admin panel seems to load endlessly... it's like it gets frozen and doesn't load the page fully... cursor keep circling.

My hosting support tells me it's script related.  Server load is really high when this website runs now which is unusual...

Here is the info on the new install:

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

Cms Version: 1.6.6

Installed Modules:

   * CMSMailer: 1.73.14
   * MenuManager: 1.6.2
   * ModuleManager: 1.3.1
   * News: 2.10.3
   * nuSOAP: 1.0.1
   * Search: 1.6.1
   * ThemeManager: 1.1.1
   * SitePusher: 0.1
   * TinyMCEAdv: 2.2.2
   * FileManager: 1.0.1
   * Printing: 1.0.4
   * CGExtensions: 1.17.5
   * TinyMCE: 2.5.5
   * FrontEndUsers: 1.6.10
   * CGSimpleSmarty: 1.4.3
   * Products: 2.4.3
   * CGPaymentGatewayBase: 1.0.3
   * Orders: 1.6.4
   * Cart: 1.4.2
   * CustomContent: 1.5.3
   * CGBlog: 1.3.1


Config Information:

   * php_memory_limit:
   * process_whole_template: false
   * max_upload_size: 10000000
   * default_upload_permission: 664
   * assume_mod_rewrite: false
   * page_extension:
   * internal_pretty_urls: false
   * use_hierarchy: false


Php Information:

   * phpversion: 5.2.6
   * md5_function: On (True)
   * gd_version: 2
   * tempnam_function: On (True)
   * magic_quotes_runtime: Off (False)
   * memory_limit: 100M
   * max_execution_time: 120
   * safe_mode: Off (False)
   * session_save_path: /tmp (1777)
   * session.use_cookies: On (True)


Server Information:

   * Server Api: cgi-fcgi
   * Server Db Type: MySQL (mysql)
   * Server Db Version: 5.0.81


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

[Somebody_1]

I'm running 1.6.6 Products and orders on a few different machines and all are fine.

If you can get to it, it might be worth doing a full checksum test.

Also you could try a fresh install of 1.6.6 in a sub dir and see if you have the same problems.

[inyerface]

Thanks.  I got "925 Files failed md5sum check:"

What is Checksum anyway and how can I fix these files?

Thanks in advance!

[Somebody_1]

http://en.wikipedia.org/wiki/Checksum

I'm making the assumption that you ran the right checksum.

My suggestion.

Backup all files and database.

Then upload over the top version 1.6.6 of CMSMS Overwriting all files (make sure your FTP is set to Binary mode, and that you have downloaded v 1.6.6 from CMSMS.org)

Run the checksum again.

[inyerface]

Everything checks out now but still gets stuck.

It appears to only be doing it when accessing the followiing 2 admin pages:

moduleinterface.php
siteprefs.php

So the following pages don't load (or keeps loading like it's looping all the time)

Extensions > Module Manager
Site Admin > Global Settings
Extension > Cart
Content > Product Manager
Content > Order Manager
Content > Calguys Blog Module
Extensions > Newsletter Made Simple
Extensions > CMSMailer

There are 3 pages in Extensions that access to moduleinterface.php but that load fine.

Extensions > Printing
Extnesions > Search
Extensions > TinyMCEW WYSIWYG

Out of 60 or so site hosted with CMSMS this is the only one doing this!!

[Somebody_1]

Try enabling debug in config.php and checking the server logs.

[inyerface]

Thanks ahead of time for all the help... this is the Debug info when I click on Order Manager:

Debug: (6.3E-5) - (579776)

loading smarty

Debug: (0.005309) - (855336)

loading adodb

Debug: (0.00698) - (942024)

loading page functions

Debug: (0.010314) - (1117996)

loading content functions

Debug: (0.013561) - (1317032)

loading pageinfo functions

Debug: (0.014253) - (1350540)

loading translation functions

Debug: (0.014728) - (1368864)

loading events functions

Debug: (0.016187) - (1452524)

loading php4 entity decode functions

Debug: (0.01934) - (1656344)

done loading files

Debug: (0.034419) - (2344032)


(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs
Error (0):

Debug: (0.04005) - (2520100)


(mysql): SELECT * FROM cms_userplugins
Error (0):

Debug: (0.063778) - (3178624)


(mysql): SELECT * FROM cms_modules WHERE active = 1 ORDER by module_name
Error (0):

Debug display of 'Load Content Operations':(0.075404) - (3921684)
Debug display of 'End Load Content Operations':(0.084601) - (4463828)
Debug: (0.085129) - (4465812)


(mysql): SELECT content_id FROM cms_content WHERE default_content = 1
Error (0):

Debug display of 'End of include':(0.160108) - (8359284)
Debug: (0.160281) - (8317240)

Session found.  Moving on...

Debug: (0.160344) - (8317476)

Session found.  Moving on...

Debug: (0.16091) - (8319076)


(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'
Error (0):

Debug: (0.168696) - (8748608)

Session found.  Moving on...

Debug: (0.168842) - (8749040)

Session found.  Moving on...

Debug: (0.172596) - (8928888)


(mysql): SELECT ug.user_id FROM cms_user_groups ug
                    WHERE ug.user_id = '1' AND ug.group_id = 1
Error (0):

Debug: (0.172915) - (8931532)


(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id INNER JOIN cms_groups gr ON gr.group_id = ug.group_id WHERE ug.user_id = '1' AND gr.active = 1
Error (0):

Debug: (0.184156) - (9145984)


(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'
Error (0):

Debug: (0.184479) - (9147888)


(mysql): SELECT group_id FROM cms_user_groups WHERE user_id = '1'
Error (0):

Debug: (0.184665) - (9148700)


(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id IN (-1)
Error (0):

Debug: (0.184886) - (9148972)


(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'
Error (0):

Debug: (0.185166) - (9150040)


(mysql): SELECT user_id,content_id FROM cms_additional_users
Error (0):

Debug: (0.193262) - (9239228)


(mysql): SELECT count(cgblog_id) FROM cms_module_cgblog n
                  WHERE status != 'published'
                    AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2009-11-16 15:37:17'))
Error (0):

Debug: (0.1943) - (9239632)


(mysql): SELECT count(news_id) FROM cms_module_news n
                  WHERE status != 'published'
                    AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2009-11-16 15:37:17'))
Error (0):

Debug: (0.195147) - (9239384)


(mysql): SELECT version from cms_version
Error (0):

Debug: (0.197358) - (9274884)


(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '1' ORDER BY title
Error (0):

Debug: (0.269377) - (9559776)

Session found.  Moving on...

Debug: (0.269508) - (9560040)

Session found.  Moving on...

Debug: (0.269552) - (9560056)

Session found.  Moving on...

Debug: (0.269595) - (9560072)

Session found.  Moving on...

Debug: (0.269637) - (9560088)

Session found.  Moving on...

Debug: (0.324753) - (9598796)


(mysql): SELECT count(a.id) AS count
            FROM cms_module_orders a
Error (0):

Debug: (0.34868) - (9601968)


(mysql): SELECT a.id,a.feu_user_id, a.invoice,
                a.billing_first_name, a.billing_last_name,
                a.status,
                a.create_date, a.modified_date,
                c.total AS total,
                d.items AS items
          FROM cms_module_orders a
          LEFT JOIN
              (SELECT order_id, SUM(quantity*(unit_price+IFNULL(discount,0))) AS total
                FROM cms_module_orders_items
                GROUP BY order_id) AS c
          ON a.id = c.order_id
          LEFT JOIN
              (SELECT order_id, SUM(quantity) AS items FROM cms_module_orders_items
                WHERE item_type = '0_product' OR item_type = '1_service'
                GROUP BY order_id) AS d
          ON a.id = d.order_id GROUP by c.order_id ORDER BY id LIMIT 0, 10000
Error (0):

Debug: (0.42537) - (10400016)


(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
        INNER JOIN cms_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC
Error (0):

Debug: (0.712863) - (10823544)


(mysql): SELECT * FROM cms_module_feusers_propdefn
Error (0):

Debug: (0.736972) - (10825468)


(mysql): SELECT * FROM cms_module_feusers_grouppropmap
          WHERE group_id = '1' ORDER BY sort_key DESC
Error (0):

Debug: (0.805577) - (10891064)


(mysql): SELECT * FROM cms_module_feusers_groups
Error (0):

Debug: (0.82436) - (10954844)

get all content...

Debug: (0.826364) - (10954896)


(mysql): SELECT * FROM cms_content ORDER BY hierarchy
Error (0):

Debug: (0.857952) - (11079696)

get all content...

Debug: (0.858837) - (11079696)


(mysql): SELECT * FROM cms_content ORDER BY hierarchy
Error (0):

Debug: (0.866111) - (11081588)

get all content...

Debug: (0.86683) - (11081588)


(mysql): SELECT * FROM cms_content ORDER BY hierarchy
Error (0):

Debug: (0.874089) - (11083448)

get all content...

Debug: (0.874811) - (11083448)


(mysql): SELECT * FROM cms_content ORDER BY hierarchy
Error (0):

Debug: (0.910142) - (11160956)


(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template FROM cms_templates WHERE default_template = 1
Error (0):

Debug: (0.935794) - (11168800)


(mysql): SELECT * from cms_module_templates WHERE module_name = 'Orders' ORDER BY template_name ASC
Error (0):

[Somebody_1]

I'm no expert on that stuff but it all looks ok to me.

What about server logs and a fresh install under a sub directory?

[inyerface]

I solved the problem by uninstalling CGBlog. as soon as it was removed everything was loading as it should and back to normal.  I have notified Calguy about it too and hopefully it's an easy fix. 

Thanks for helping my through this.

[mics]

I have the same problem. Any news on how this can be solved without uninstalling CGBlog?

[inyerface]

Hello, the actual solution was in upgrading from PHP version 5.2.6 to version 5.2.13.  Now I don't have to uninstall any of the modules I actually want to keep