SQL errors for 2.5.8 and 3.0.2 sites - Joomla! Forum - community, help and support
help please,
i surrender wisdom , generosity of community! can't figure out what/where/why/how fix seemingly related crashes i'm having of 2.5.8 sites , 3.0.2 - both today! 2.5.8 sites have been , unpredictably experiencing errors content/inset section of template (any) filled looks me sort of mysql unhappiness ("can't create/write file '/tmp/#sql_347c4_2.myi' (errcode: 28) sql=select ..."). "500 - sql-select" message on 3.0.2 sites further suggests kind of mysql confusion ... screenshots of errors attached (a composite, of 5 (5) errors minimize attachments post) + fpa.txt reports (the post generator doesn't work on either site: returns '500 ise').
observations (besides site crash pages' messages):
1. i'm unable login any/either version admin panel: returns "500 internal server error".
2. when try cpanel > phpmyadmin, page "error - cannot start session without errors, ..." delivered.
3. happens regardless of browser & os: chrome, firefox, ie8, opera, safari, android, dolphin. flushing caches/cookies/history/reopen - doesn't help.
4. 2.5.8 sites (e.g., sandbox/vp_j), home page has "sql dump" (if that's is) or invalid arguments; other pages (via menu links) display expected.
5. 3.0.2. sites (e.g., sandbox/sg_j), if added /index.php site url, page opens expected refresh of page; usually, 500 error returns: can't show me home page @ can't if menu-linked pages displaying okay.
6. ran fpa sandbox/sg_j (v3.0.2), couldn't generate post content: same error no. 1 above. see attached 130112_fpa_sg_j.txt file here results. no php error log results captured script.
7. fpa sandbox/vp_j failed generate post content w/500 internal server error, see attached file 130112_fpa_vp_j.txt results. php error log captured: "[12-jan-2013 23:38:00 utc] php warning: mysql_num_rows() expects parameter 1 resource, boolean given in /home/villtorg/public_html/sandbox/vp_j/libraries/joomla/database/database/mysql.php on line 293". changed permissions on 2 media/civicrm folders 0755, rechecked site, still returns "can't create/write file '/tmp/#sql_347c4_2.myi' (errcode: 28) sql=select ..." or without using index.php.
done did several hours of searching kb's/forums/blogs/resource sites, there seems many reasons , 'solutions' there afficianados.
i've tapped 1 of (2.5) template maker's developers, since error first happened 1 of their's, didn't know ... had me run virus , malware checks on (local , server, clean).
likewise, filed couple tickets host, didn't have answer; @ least, not enough know if there's (e.g., php.ini setting, control) might not jibe joomla! version "issue" (or 3.0.2 matter, mentioned above); possibility supported observation provide joomla! 1.5.x via fantistico deluxe (which 1 or 2 such sites have aren't having of these errors).
much obliged whomever has keen insight on situation!
thanks in advance,
bob
i surrender wisdom , generosity of community! can't figure out what/where/why/how fix seemingly related crashes i'm having of 2.5.8 sites , 3.0.2 - both today! 2.5.8 sites have been , unpredictably experiencing errors content/inset section of template (any) filled looks me sort of mysql unhappiness ("can't create/write file '/tmp/#sql_347c4_2.myi' (errcode: 28) sql=select ..."). "500 - sql-select" message on 3.0.2 sites further suggests kind of mysql confusion ... screenshots of errors attached (a composite, of 5 (5) errors minimize attachments post) + fpa.txt reports (the post generator doesn't work on either site: returns '500 ise').
observations (besides site crash pages' messages):
1. i'm unable login any/either version admin panel: returns "500 internal server error".
2. when try cpanel > phpmyadmin, page "error - cannot start session without errors, ..." delivered.
3. happens regardless of browser & os: chrome, firefox, ie8, opera, safari, android, dolphin. flushing caches/cookies/history/reopen - doesn't help.
4. 2.5.8 sites (e.g., sandbox/vp_j), home page has "sql dump" (if that's is) or invalid arguments; other pages (via menu links) display expected.
5. 3.0.2. sites (e.g., sandbox/sg_j), if added /index.php site url, page opens expected refresh of page; usually, 500 error returns: can't show me home page @ can't if menu-linked pages displaying okay.
6. ran fpa sandbox/sg_j (v3.0.2), couldn't generate post content: same error no. 1 above. see attached 130112_fpa_sg_j.txt file here results. no php error log results captured script.
7. fpa sandbox/vp_j failed generate post content w/500 internal server error, see attached file 130112_fpa_vp_j.txt results. php error log captured: "[12-jan-2013 23:38:00 utc] php warning: mysql_num_rows() expects parameter 1 resource, boolean given in /home/villtorg/public_html/sandbox/vp_j/libraries/joomla/database/database/mysql.php on line 293". changed permissions on 2 media/civicrm folders 0755, rechecked site, still returns "can't create/write file '/tmp/#sql_347c4_2.myi' (errcode: 28) sql=select ..." or without using index.php.
done did several hours of searching kb's/forums/blogs/resource sites, there seems many reasons , 'solutions' there afficianados.
i've tapped 1 of (2.5) template maker's developers, since error first happened 1 of their's, didn't know ... had me run virus , malware checks on (local , server, clean).
likewise, filed couple tickets host, didn't have answer; @ least, not enough know if there's (e.g., php.ini setting, control) might not jibe joomla! version "issue" (or 3.0.2 matter, mentioned above); possibility supported observation provide joomla! 1.5.x via fantistico deluxe (which 1 or 2 such sites have aren't having of these errors).
much obliged whomever has keen insight on situation!
thanks in advance,
bob
Comments
Post a Comment