sparkx 0 Report post Posted July 14, 2008 Â I am aware that there is already a topic about PHPMyAdmin but I am receiving a different error (and that topic is closed). It seems as if PHPMyAdmin has an error in it's code. I received the following error. Warning: session_write_close() [function.session-write-close]: SQLite: session write query failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42Warning: session_write_close() [function.session-write-close]: Failed to write session data (sqlite). Please verify that the current setting of session.save_path is correct (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:42) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 99 Now I am unsure what the first two warnings are about but the third one doesn't like the fact that HTML was already printed out. Is this caused by something in my control panel or is it the server itself? I have just recently removed all user's (except one) from all the databases and enabled remote MySQL access. I wouldn't think that would cause a problem unless I removed PHPMyAdmin's user, but I don't think you can do that can you?Any Suggestions?Sparkx Share this post Link to post Share on other sites
Quatrux 4 Report post Posted July 14, 2008 I can confirm that I have the same error when I'm trying to access phpMyAdmin through CPanel..the third error I guess is due to the previous two errors, they outputted something and headers couldn't be sent, it's a cookie or just a simple header..strange error that Database is full, I wonder which database is full, maybe the server's?I just tried to browse my CMS and the Panel, when I tried to do something with MySQL, something more than SELECT, I got an error from my CMS:"Error: Are you *u*king hacking theSite CMS Panel.."As I don't really remember where I wrote this error message, but as I remember it never should have been able to be shown, so I guess when I did UPDATE or INSERT it didn't work and else if didn't work as it should and it showed the else error message So I guess who's on that server can't really add anything more, it's out of Space? or somebody hacked something and put all the DB Free Space with trash information..???So I guess we aren't able to store or change anything in our MySQL databases.. Share this post Link to post Share on other sites
yordan 10 Report post Posted July 16, 2008 And the problem seems located in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php the "session write query failed" seems to mean a permissions problem rather than a real "database is full" problem.I would say that somebody should perform a chmod somewhere in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php Yordan Share this post Link to post Share on other sites
Quatrux 4 Report post Posted July 17, 2008 You think it's only a PHPMyAdmin problem? Why doesn't MySQL work as it should with PHP too when yo try to do something more, like insert a row.. Share this post Link to post Share on other sites
yordan 10 Report post Posted July 17, 2008 You think it's only a PHPMyAdmin problem? Why doesn't MySQL work as it should with PHP too when yo try to do something more, like insert a row..Seems that MySQL works with my site, I can add records in my GuestBook, add and delete posts in my PhpBB forums. That's why I think that my MySQL databases are OK, and only phpMyAdmin has problems. Share this post Link to post Share on other sites
yordan 10 Report post Posted July 17, 2008 You think it's only a PHPMyAdmin problem? Why doesn't MySQL work as it should with PHP too when yo try to do something more, like insert a row..Just for diagnosis purposes, i did a simple test. I downloaded phpadmin from sourceforge (https://www.phpmyadmin.net/downloads/ ) and uploaded into my Xisto account www folder, and configured the server as "localhost". It works perfectly.This means that the problem is inside the cpanel, the sytem calls to cpanel phpmyadmin are not correctly performed.Clearly, the problem is in cpanel, and not in MySQL. Share this post Link to post Share on other sites
turbopowerdmaxsteel 0 Report post Posted July 17, 2008 Its not just a PHPMyAdmin problem. The error seems to be related to session data which has to be saved somewhere in the /tmp directory. My statistics page which is based on Tracewatch is showing errors as well. Share this post Link to post Share on other sites
xboxrulz1405241485 0 Report post Posted July 18, 2008 My whole Drupal installation is popping up with ridiculously large amount of errors. Like for the past few months, Xisto servers have been crippling my website systems.I can't fix the Drupal issue without getting into PHPMyAdmin either.xboxrulz Share this post Link to post Share on other sites
Quatrux 4 Report post Posted July 18, 2008 (edited) Seems that MySQL works with my site, I can add records in my GuestBook, add and delete posts in my PhpBB forums. That's why I think that my MySQL databases are OK, and only phpMyAdmin has problems.Hmm, well you're right, just did a test it works, but my CMS doesn't work, I can't login and do something to the Panel, so as others said, maybe it's a session problem, because it uses sessions, strange though, when I'll comeback I'll need to check a simple php script with the server by using sessions..yeah, just took a look and to get that login error it could happen due to sessions also.. So maybe something is happening with permissions or the place the sessions are saved, never saw these kind of errors. Edited July 18, 2008 by Quatrux (see edit history) Share this post Link to post Share on other sites
zorba4 0 Report post Posted July 18, 2008 Maybe somebody with a csh account shoud do a "ls -ld /tmp", just to check permissons for creating temporary files too... Share this post Link to post Share on other sites
xboxrulz1405241485 0 Report post Posted July 18, 2008 Only admins have access to any terminal services, this includes and not limited to ssh and bash.xboxrulz Share this post Link to post Share on other sites
yordan 10 Report post Posted July 18, 2008 Only admins have access to any terminal services, this includes and not limited to ssh and bash.xboxrulzSome monthes ago, as a hosted member, I had ssh access.Now only paid hosting people or admins have ssh access. Share this post Link to post Share on other sites
xboxrulz1405241485 0 Report post Posted July 19, 2008 Well, I guess the system just slipped lol.xboxrulz Share this post Link to post Share on other sites
sparkx 0 Report post Posted July 20, 2008 Well, is there any chance you can fix it? It is on and off all the time. Just now I was working and right after exporting tables for a backup I get the same error. I must have not noticed it before or something, it will work just fine on show results (minus a little warning at the bottom of the page). When I go to edit my tables though I get the same error at the bottom but also a MySQL error. ErrorSQL query: SHOW FULL FIELDS FROM `Table`;MySQL said: #1030 - Got error 28 from storage engine Any Suggestions?Thanks,Sparkx Share this post Link to post Share on other sites
xboxrulz1405241485 0 Report post Posted July 21, 2008 hmmm... never heard of this SQL error before. What is going on with the Xisto servers? They're falling apart since the datacentre swap =S.xboxrulz Share this post Link to post Share on other sites
