jrcomment wont verify after update

soaringeagle
@soaringeagle
9 years ago
3,304 posts
the threaded update made the jrcomment redirect to a whitescreen page during verify
additionaly my
{if strlen($_post.option) === 0}
<br><div class="commentback"><a href="{$jamroom_url}/{$item.profile_url}#cform">Comment Back</a></div>
{/if}
made profiles no longer load rigtht with an error in safari saying
"ReferenceError: Can't find variable: $"

after removing my core resetting templates
the profiles load but ...integrity checkstill stops at jrcommewnt and wont progress past there


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

updated by @soaringeagle: 02/27/15 06:28:49AM
brian
@brian
9 years ago
10,148 posts
It may take a little bit to run as it has to create new keys, but it should not get a white screen - it took ~45 seconds to run here on Jamroom.net. Try an integrity check and let it run again.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
its been running at least 20 minutes


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
soaringeagle:
its been running at least 20 minutes

How many comments do you have in your system? And are there errors in your data/logs/php_error_log?

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
the white screen was during the update now after the update its taking ages to run the integrity check...just to be clear


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
soaringeagle:
the white screen was during the update now after the update its taking ages to run the integrity check...just to be clear

How many comments do you have? (rows in your jr_jrcomment_item table).


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
260 thousand about
but it went past the repair tables the optimize tables its the verify module thats stuck


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
soaringeagle:
260 thousand about
but it went past the repair tables the optimize tables its the verify module thats stuck

Yes - that's because it has to add in 260,000+ new keys - that's going to take quite a while. Let it run if it will run. Do you end up getting an error if you just let the integrity check run?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
not yet ill let it run and see
so i guess my "comment back' tip no longer will work?


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
soaringeagle:
not yet ill let it run and see
so i guess my "comment back' tip no longer will work?

I don't see what it wouldn't work - the comment item_list.tpl file was updated to have a "reply" link in it, so you would just want to add your customizations to it.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
when i had it there it gavean error but maybe that was the integrityu check not me tremovingthe code that solved that profile pages wernt loading and paul was getting an error in safari
unrecognized variable $ or something

i did remove the code while the integrity check was running thinking that might have been causing the integrity failure

on that subject
what code can i addto it to check if the users online and only show on the active users profile not every profile


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
9 years ago
3,304 posts
been running bout an hour now

corection...2


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

updated by @soaringeagle: 01/22/15 05:12:16PM
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Maybe time for the Heimlich maneuver.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
soaringeagle:
been running bout an hour now

corection...2

It took about 30 seconds here to do ~10,000 comments here on Jamroom.net, so even with 260,000 it should not be taking hours. I would bet it's no longer running - check your php error log.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
ive tried it 3 times now i just cleared php log to run it again and see what we get


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
fwiw i JUST APPLIED ALL THE MODULE UPDATES (oops caps) and seemed to have a little trouble with the Comment update stalling. I finally interupted it after several minutes, and it said the update had been succesful to the new version. But to be safe I ReLoaded that comments module again, successfully.
Then I started integrity check 15 minutes ago and it's still running...took a screenshot of what it's 'repairing'- the little wheel just keeps spinning...(it never showed as repairing anything before long enough for me to see it reparing). Here's what I'm seeing now for past 15 minutes:
integrity_check.jpg
integrity_check.jpg  •  87KB




--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/22/15 07:47:32PM
soaringeagle
@soaringeagle
9 years ago
3,304 posts
yea im tempted to delete and reinstall the module


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
9 years ago
3,304 posts
[22-Jan-2015 22:28:56 America/New_York] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 1803886 bytes) in /home/greentechnologyf/public_html/modules/jrCore-release-5.2.22/lib/datastore.php on line 1206 [x 1]



--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
9 years ago
3,304 posts
looks like its jrcore not commentsitrs bombing out on

if theres an error in the core would that explain my missing menu item

but then againit was comments that wouldnt verify when i was installing it


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Something is very not right. It all started happening after I did the latest updates this afternoon, sbalking on the Comments update and then stalling at the integrity check permanently.
After 2 hours the integrity check was just stuck showing same as screenshot. Then my Firefox crashed and when i got back i was logged out of my site. Logged in and cleared cache ok, then started integ check again , and same thing- stuck showing the same screenshot stuff.
Was able to look on my server and kept refreshing the screen, and it showed my site was wildly fluctuating between 0% CPU and 85% cpu every 30 seconds or so. With just me logged in and only having the integ check running.
My PHP error log doesn't show any errors dated after Jan 16 or so- should I clear it?
System check was all green lights.

That's all for now- unfortunately I HAVE to go to bed, so rather than leave my CPU runingg wild all night I'm signing out of my site and going to bed.
-I notice it shows that the CPU goes down right away to 0% when I log out. and if I start logging in the CPU rate on my server goes crazy to 80% right away again.
G'nite!

Oh- if any of you JR Team has my log in info and wants to go in and check things out- you have my permission in case you want to.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/22/15 08:53:01PM
michael
@michael
9 years ago
7,714 posts
That error reads "The server ran out of memory, so could not complete what it was trying to do".

We'll look into it.
soaringeagle
@soaringeagle
9 years ago
3,304 posts
i left it run all night it never verified


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
9 years ago
3,304 posts
michael:
That error reads "The server ran out of memory, so could not complete what it was trying to do".

We'll look into it.

yea i realize that but shouldnt happen as i have a very high memory limit


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
I've just pushed out version 1.5.1 of the User Comments module that will now do the needed updates in "batches". Upgrade to that, and in another tab bring up your site activity log - it will record an INF log message to the activity log for every 1,000 comments it updates - that way you can refresh your activity log and get an idea of how fast it is running on your server.

Let me know if that works.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
I am still having major problems ever since yesterday's updates.

I can get into my site. and I can get into my server.
I can run a jr cache clear ok. Saw no recent errors in the system check or error log.
All modules say up to date. I deleted all the Data/cache files from my server end.

BUT:
1)--on my JR site I now cannot get to ANY user's profile page, including my own. (!) Browser just hangs (safari and FF, computer restarted) Cannot access profile pages at all.

2)--See above screenshot for what I get when I try to run integrity check- it starts ok and moves along til it gets to any jrComments item- and then it just hangs. For hours, cannot finish. I tried checking and unchecking various boxes for the integrity check, even just checking one box...but no matter, it always hangs when it gets to a jrComment item of any kind.

3)--when I'm on my site (nobody else there or doing anything) if I refresh the browser every 20 seconds in my server cPanel, the CPU usage keeps fluctuating wildly between 0%, 60%, and 80% (in the red). (i only have 33GB on my server right now, well within limits) Oy...gonna get visited now by Arvixe CPU thugs at my back kitchen door...

Something has gone real wrong since I applied module/ningja updates yesterday and the update hung while in the middle of updating the Comments module. Before that everything was working just fine.

Help? I'm kind of in a crippled state right now.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Brian just read your post- i will go and try to update to the new comment module now...brb.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
soaringeagle
@soaringeagle
9 years ago
3,304 posts
wont be able to till migrations complete to nbew server


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
The update to the new Comment module from 1.5.0 to 1.5.1 is hanging now...12 minutes now and counting. Page still loading, but little wheel stopped spinning. Meanwhile, my server CPU usage says 0%. :(


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
Strumelia:
The update to the new Comment module from 1.5.0 to 1.5.1 is hanging now...12 minutes now and counting. Page still loading, but little wheel stopped spinning. Meanwhile, my server CPU usage says 0%. :(

Like I outline above, what do you see in your Activity log?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
There are no PHP errors, and here is my latest log:
Note that the update process hung indefinitely and I had to halt it after 15 min...but the module now says it's 1.5.1. CPU usage currently 0% even though i'm in there and clicking around. Still cannot access any profiles.
activity_log.jpg
activity_log.jpg  •  138KB




--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/23/15 11:08:15AM
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Integ check still hangs at 'comment' items...see new screenshot attached.
integrity_check.jpg
integrity_check.jpg  •  59KB




--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/23/15 11:08:52AM
brian
@brian
9 years ago
10,148 posts
It should not be hanging on REPAIR TABLE unless the MySQL server is just insanely slow. I can see in your Activity Log that it never even made it through the first 1,000 in 2 minutes, so something is just super slow in MySQL.

has it got past the repair table yet? That's not even part of the update, so you must have checked "repair tables" in your integrity check - you don't need to do that.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Ok, I just halted the inegrity check finally. started over, with all checked except repair tables.
Now it hangs here:
integrity_check.jpg
integrity_check.jpg  •  67KB




--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/23/15 11:26:29AM
brian
@brian
9 years ago
10,148 posts
Yeah that means it is "working" on updating your existing comments. Let it run, and look in your Activity Log - for every 1,000 comments it updates it will log an entry in there. Let it run until it is done.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
OK, letting it run. Will report back here in an hour or so...?


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
Strumelia:
OK, letting it run. Will report back here in an hour or so...?

How many comments do you have in your system? And has it completed the first 1,000 yet?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

updated by @brian: 01/23/15 11:36:53AM
Clay Gordon
Clay Gordon
@claygordon
9 years ago
733 posts
@Brian -

I updated the jrComment (1.5.0, not 1.5.1) module but have not (yet) done an integrity check. My comments all appear to be working (except for the invert sort when threading is enabled I mentioned yesterday).

I have about 16,000 comments.

Is running the integrity check something I should do after every module/core update?
updated by @claygordon: 01/23/15 11:41:49AM
brian
@brian
9 years ago
10,148 posts
thechocolatelife:
@Brian -

I updated the jrComment module but have not (yet) done an integrity check. My comments all appear to be working (except for the invert sort when threading is enabled I mentioned yesterday).

I have about 16,000 comments.

Is running the integrity check something I should do after every module/core update?

No - when you update to a module the integrity is actually run for you automatically on the module being updated, so you should be good to go.

I think the root cause of the issues we're seeing in this thread are twofold:

- For @soaringeagle he just has so many comments that the update script was running out of memory (that should be fixed now)
- For @strumelia I believe it is that the MySQL performance on the Arvixe shared hosting is just really, really slow - it should complete but may take some time.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
brian:
How many comments do you have in your system? And has it completed the first 1,000 yet?
Where would I find the number of comments I have? I will then look and tell you. Just geussing, i must have fewer than 1/10th the number Soaring has.

Nope- started the new integ check without repair tables at 2:24...now it's 2:54 and no new entries in a refreshed activity log yet.
Integ check wheel still spinning...


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
Strumelia:
brian:
How many comments do you have in your system? And has it completed the first 1,000 yet?
Where would I find the number of comments I have? I will then look and tell you. Just geussing, i must have fewer than 1/10th the number Soaring has.

Nope- started the new integ check without repair tables at 2:24...now it's 2:54 and no new entries in a refreshed activity log yet.
Integ check wheel still spinning...

OK so we're going on 30 minutes and it has not done even 1,000? There's got to be some rate limiting going on as even on a very slow server it should do 1,000 at least every 30 seconds to a minute.

Send me a Private Note with your server info and I will check it out for you.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Yep, still nothing. And I can't access any profiles until this issue/mystery is unraveled.
Sending you my login info for both my jr site and my server. I'm going to log out of there right now and will do nothing til I hear back from you.
Thanks so much Brian.

Oh- sent you an email instead of a private note- hope that's ok, didn't notice til after....


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/23/15 12:23:40PM
brian
@brian
9 years ago
10,148 posts
derrickhand300:
Just updated the User Comment Module and checked the log after integrity check ran ok-
It did 15,700 comments in around 60 seconds
[Curtis] : added comment_thread_id to 15790 comments

Glad to hear that :)

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Brian's been graciously helping me, but now Arvixe has BLOCKED me from my own server due to all the 'excessive' connections or CPU or something while this has been going on today. LAME. Have to go on Arvixe support chat tomorrow. Grrr... all because of the comment threading update and my lame arvixe server.



--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/23/15 05:17:05PM
Clay Gordon
Clay Gordon
@claygordon
9 years ago
733 posts
Strumelia:
Where would I find the number of comments I have?

Go to the DataStore browser in the User Comments module:

http://www.yoursitename.com/comment/browser

Look at the ID number of the top-most comment. That's how many comments you have.

-- edited to add --

Until inline editing of user comments becomes available, this is the place where you would be editing user comments. Get the ID from the comment (by hovering over the comment's trash can) and search for it on this page.
updated by @claygordon: 01/23/15 08:09:27PM
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Clay, thanks. Good to know!

Will check it out after Arvixe decides to let me have access to my server and site again.

(d'ooooohhhhhhh....)


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
Clay Gordon
Clay Gordon
@claygordon
9 years ago
733 posts
Work into the conversation questions about the sucky mySQL performance, mention that another Jamroom user just upgraded to business class because of sucky mySQL performance and is now happy, so inquire about that ... and see if they will soften their stance on things.

It can't hurt.
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Clay, I'm going to get some work done and then get on arvixe chat support later this afternoon. Can you just quickly explain to me what mySQL is, so I don't feel so clueless? Thanks friend. :)


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
Strumelia:
Clay, I'm going to get some work done and then get on arvixe chat support later this afternoon. Can you just quickly explain to me what mySQL is, so I don't feel so clueless? Thanks friend. :)

MySQL is an open source database:

https://www.mysql.com/

Jamroom uses it as the database on your server.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
So if it's used by JR, and if I'm going to complain about my sucky mySQL to Arvixe, - is this suckiness their fault? Just want to not sound foolish.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
Strumelia:
So if it's used by JR, and if I'm going to complain about my sucky mySQL to Arvixe, - is this suckiness their fault? Just want to not sound foolish.

Yes - it appears they have process limits in place that prevent you from using the mysql server "too much".


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Clay Gordon
Clay Gordon
@claygordon
9 years ago
733 posts
@Strumelia -

I just complained that it was real slow and that "I'd heard" that they artificially limited the performance on the personal account with some sort of monitoring code. A little birdie told me that - might have been Brian - but I did not mention that to Arvixe support, just that "I'd heard."
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Yeah, no names is good.

Hey I have to work today too much and can't catch a break to wrestle with Arvixe support. Just gotta leave my site kicked off by Arvixe until tomorrow when i can get them on chat maybe... I just can't get away frommy day job deadlines today. Oh well, good that it's not live!


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
SteveX
SteveX
@ultrajam
9 years ago
2,584 posts
Strumelia:
So if it's used by JR, and if I'm going to complain about my sucky mySQL to Arvixe, - is this suckiness their fault? Just want to not sound foolish.

I doubt that it's their "fault", just their calculation as to what they can provide across all accounts on a shared hosting server without either pricing themselves out of business (price too low) or driving away their customers (price too high). Database restrictions are coming into play for you because you are migrating a large ning site to jamroom and ironing out the kinks, probably an unexpected spike in demand for one account - they share resources so all accounts get a fair deal for their money (hopefully it's a fair deal), i.e. all sites are not suffering because one site makes an unanticipated demand on processor, ram, support, bandwidth etc.

Ideally arvixe would be able to temporarily put your site on a less restricted quota whilst you are taxing resources, and then move you onto a long term shared hosting quota once you working normally. (I'd expect to pay more for that)

As a long-term way around those restrictions you could get a $5 account with digitalocean, install virtualmin, play around with it for a year or two, then move your sites to that when you are confident (virtualmin seems to do a pretty easy migration of accounts from cpanel).


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

updated by @ultrajam: 01/24/15 01:22:37PM
brian
@brian
9 years ago
10,148 posts
Strumelia:
So if it's used by JR, and if I'm going to complain about my sucky mySQL to Arvixe, - is this suckiness their fault? Just want to not sound foolish.

We don't use Arvixe for any of our servers - we self host all of our servers on Linode.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
Thanks UJ, more tidbits to know. :)


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
brian:
We don't use Arvixe for any of our servers - we self host all of our servers on Linode.

No, I meant in response to your saying: "Jamroom uses it as the database on your server."
I know JR is not residing on Arvixe... yikes, just imagine! =8-*


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
brian
@brian
9 years ago
10,148 posts
Strumelia:
brian:
We don't use Arvixe for any of our servers - we self host all of our servers on Linode.

No, I meant in response to your saying: "Jamroom uses it as the database on your server."
I know JR is not residing on Arvixe... yikes, just imagine! =8-*

Ahh yes - Jamroom uses MySQL on YOUR server - correct :)


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
9 years ago
10,148 posts
derrickhand300:
Hey Brian- in moving the DB- what to do when I get this?

“mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'curtis61_jamroom5'': Cannot load from mysql.proc. The table is probably corrupted (1548)”

I've not seen that one before. You could try:

USE TABLE mysql;

then:
REPAIR TABLE proc;

You will need to run those commands as the root MySQL user.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Lora McMeans
Lora McMeans
@lora-mcmeans
9 years ago
41 posts
sounds like Arvixe is not that great to deal with... is there a better option?
brian
@brian
9 years ago
10,148 posts
That should actually work - post move check out this guide:

https://www.jamroom.net/the-jamroom-network/documentation/howto/1077/howto-change-the-jamroom-directory-or-domain

as it will also show you the post move steps to take.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
9 years ago
10,148 posts
derrickhand300:
Thank you Brian AGAIN- I will let you know how it turns out

No problem!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Clay Gordon
Clay Gordon
@claygordon
9 years ago
733 posts
@derrickhand300 -

I have a "free" three-month window on Arvixe because of an account credit and a free month. I am intensely interested to know how much you are paying monthly to get 3x performance over your previous server. Also, I am completely NOT into actively managing my server, so it'd help me to know how much of the heavy lifting Linode did - and I need to study up on the virtualadmin tools.
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
thechocolatelife:
Strumelia:
Where would I find the number of comments I have?
Go to the DataStore browser in the User Comments module:
http://www.yoursitename.com/comment/browser
Look at the ID number of the top-most comment. That's how many comments you have.

Ugh, I can't even get to that page- my browser just hangs there spinning wheels, trying to load it. I give up after ten minutes.
Integrity checks take nine minutes now and run my CPU to 80%, so I'm avoiding them so Arvixe won't cut me off again. When the integrity check finally finishes, I click on the "OK" button and get "Problem communicating with server" message. But then in a minute that screen goes away and my activity log indicates the integ check completed ok.

Ever since I made that last batch of module updates, anything having to do with 'Comments" in particular have been messing me up, even though Brian edited out the 'comment threading' code that first caused my server to choke on a ham sandwich.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
Strumelia
Strumelia
@strumelia
9 years ago
3,603 posts
update- ok I tried loading my site.com/comment/browser page for a few minutes...it wouldn't load, and now...

"Unable to connect
Firefox can't establish a connection to the server at (mysite).com.
The site could be temporarily unavailable or too busy. Try again in a few moments.
If you are unable to load any pages, check your computer's network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web."

So looks like I'll never know how many profile comments my site has, but I doubt it's anything too outrageous.

Now after five minutes of not being able to connect, I'm on again, but just trying to go to my own profile page, or to my Events page, etc...sends my server cPanel CPU shooting up to 80% again.
At this rate arvixe is going to cut me off again. wtf. Insane.
And they just charged me my $10 for another month of this.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

Tags