Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
Jamroom Help:
Can't login after a MYSQL crash...
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 09:30 
I think my log file got way too big, and I'm getting a blank screen for login.php. How should I proceed? I'm running the latest version of Jamroom 4...

Back to top
Dazed



Joined: 22 Mar 2006
Posts: 4147

Posted: 09/15/13 09:51 
Did you delete or rename the log file? If it get's to 2GB it usually shuts the site down.

Back to top
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 10:02 
In the folder logs, there are several files... Which log file are you talking about?

In MySQL, there were some log tables that seem to be corrupt...

Kindly be a little more specific.

Best wishes.

Back to top
Dazed



Joined: 22 Mar 2006
Posts: 4147

Posted: 09/15/13 10:07 
run an integrity check and that should fix the database. As for the logs, log in via ftp and look at the file size. If you are close or at 2GB. just rename it *.old and a new log file will be created.

Back to top
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 10:22 
Dazed,

I can't login as an admin because I get a blank screen... so, I can't do an integrity check.

Also, MySQL has a few tables with "log" in them, that may be corrupt.

Please tell me the location of the log file you are talking about... for example: /logs/log file's name.

There are several files in the logs directory. Please be a little more specific.

Back to top
Dazed



Joined: 22 Mar 2006
Posts: 4147

Posted: 09/15/13 10:56 
Kind of hard to be specific because you are on JR4 and I am on JR5 so I am going by memory.

It should just be the logs directory. The name does not matter. Look at file size. You can rename them all and it will not effect JR. New logs will be created automatically. Just do that first and see if you can see your site.

Back to top
Dazed



Joined: 22 Mar 2006
Posts: 4147

Posted: 09/15/13 10:59 
ok I just found a post with your site on it. Your logs should be fine. Typically if you can't get to the site at all, your log file is full.

Look in your error log file via ftp and check the errors. Did you make any changes? A white screen is usually a php error.

http://www.jamroom.net/phpBB2/viewtopic.php?t=12947

you know there are some odd things appearing here on your site on the login page:


[Fiddler] DNS Lookup for "ndrskmqyiy" failed. The requested name is valid, but no data of the requested type was found


[Fiddler] DNS Lookup for "ezpbgkbdmi" failed. The requested name is valid, but no data of the requested type was found

[Fiddler] DNS Lookup for "qgsgiqrmen" failed. The requested name is valid, but no data of the requested type was found

Back to top
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 12:00 
The php error log is gigantic:

Here's just some of it...
Code
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method CSSPseudoLinkTarget::is_local_link() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/strategy.link.rendering.normal.php on line 16
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method CSSPseudoLinkTarget::is_external_link() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/strategy.link.rendering.normal.php on line 10
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method CSSPseudoLinkTarget::is_local_link() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/strategy.link.rendering.normal.php on line 16
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method CSSPseudoLinkTarget::is_external_link() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/strategy.link.rendering.normal.php on line 10
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method CSSPseudoLinkTarget::is_local_link() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/strategy.link.rendering.normal.php on line 16
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method ContentType::pdf() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/output._generic.pdf.class.php on line 12
[15-Sep-2013 14:50:47 UTC] PHP Strict Standards:  Non-static method Image::clear_cache() should not be called statically, assuming $this from incompatible context in /home/musician/public_html/include/html2pdf/pipeline.class.php on line 369
[15-Sep-2013 16:33:11 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/forum.php on line 142
[15-Sep-2013 16:49:14 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9768
[15-Sep-2013 16:49:14 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9771
[15-Sep-2013 16:49:39 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9768
[15-Sep-2013 16:49:39 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9771
[15-Sep-2013 16:49:53 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9768
[15-Sep-2013 16:49:53 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9771
[15-Sep-2013 16:51:15 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9768
[15-Sep-2013 16:51:15 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/include/jamroom-misc.inc.php on line 9771


Back to top
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 12:28 
The errors just started a few days ago. I didn't make any changes. The log file is over 136Megs...

Back to top
Dazed



Joined: 22 Mar 2006
Posts: 4147

Posted: 09/15/13 14:25 
rename the error log. I would just add a .old to the end of it. Then go to the login page. Then after you get the white page, pull the new error log and post it. This way you will only show the errors for the page.

Back to top
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 15:33 
Funny, now when I try to access charts and merchandise I get the white screen too. Maybe I didn't notice before. Anyhow, here's what I got after renaming the file...


Code
[15-Sep-2013 21:16:42 UTC] PHP Strict Standards:  Only variables should be passed by reference in /home/musician/public_html/forum.php on line 142


Back to top
Dazed



Joined: 22 Mar 2006
Posts: 4147

Posted: 09/15/13 16:24 
I am seeing 502 errors on your site using Fiddler. You also mention you had an sql crash and I am not sure what was involved on that. You can repair tables directly from the database but I am not sure if that will help here. Have you looked at your .htaccess file and make sure there is nothing odd in there?

Brian will probably solve this in a few minutes. If it were my site, I would probably reload the core php files for grins and see if that does anything. I am assuming you looked at the login form and made sure that was not changed as well as the charts. Since only a few areas are effected, it seems a bit strange since you have not made changes.

Back to top
JammerPro



Joined: 12 Apr 2007
Posts: 304

Posted: 09/15/13 16:29 
Dazed, thanks for trying to help... Hope my Jamroom is not destroyed.

Anyhow... BRIAN HELP PLEASE!!!

Back to top
djmerlyn
Jamroom Ustad


Joined: 18 Dec 2003
Posts: 13497
Location: Behind You

Posted: 09/16/13 09:51 
You would want to do a database check using phpmyadmin or similar and look for tables marked as crashed, if none are reported as crashed then the next step might be to see why is php running in strict mode.


_________________
Pro JR Hosting, now 50% off!
-100% Guaranteed

"more server and network power than any host, dedicated to your jamroom site"
Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 09/16/13 10:57 
Yeah DJ is correct - using phpMyAdmin you can run "REPAIR TABLE" on all of your Jamroom tables - that should fix it up for you.

Hope this helps!

- Brian


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
Jamroom Help

12Next >
 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.