×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Big Problem!

Big Problem! 14 years 7 months ago #9645

  • Mike Michaud
  • Mike Michaud's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Hi,
I purchased a subscription, and installed the new Beta. Basically my site (thatguywiththeglasses.com) which is on 2 balanced web servers, has a dedicated nfs server and a dedicated DB server, came to a crawl. Load averages on all servers spiked drastically. As a result I uninstalled the beta and reinstalled the Alpha. The new problem that happened is basically none of the old comments show up (250,000+). I checked the DB and they are still there, but they aren't showing up under the articles on the site, or in the backend.

How can I fix this?

Thanks!

Big Problem! 14 years 7 months ago #9646

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey Mike what was the reason for the crawl? Any ideas????

You don't see the old comments with the alpha version because 4.1 made changes to the database.

Open your database with phpmyadmin and make the following query:
UPDATE jos_comment SET component = '' WHERE component = "com_content";
UPDATE jos_comment_setting SET set_component = '' WHERE set_component = "com_content";

After you make that database query you should see again the comments with older versions. But please let us know what exactly the problem you had was.
Thank you in advance!
Daniel

Big Problem! 14 years 7 months ago #9648

  • Mike Michaud
  • Mike Michaud's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
Thanks for the quick reply. All is working again with the older version. As for the reason of the load spike.. I have no clue.

Big Problem! 14 years 7 months ago #9649

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Could you install a copy of your site on your server and install the new version. We have to track the problem down, otherwise we can not fix it :(
  • Page:
  • 1
Time to create page: 0.108 seconds