Portal Home > Knowledgebase > Articles Database > Mysql error


Mysql error




Posted by persianwhois, 09-04-2008, 02:25 PM
Hi, We have many problem in 2 days ago in mysql. Such as phpmyadmin: 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 42 Warning: 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 42 Warning: 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 Whereis problem and how can fix?

Posted by cPanelDavidG, 09-04-2008, 03:48 PM
I notice from the path information provided, you are using cPanel/WHM. What is the full version information for your installation of cPanel/WHM?

Posted by Jonathan Kinney, 09-04-2008, 06:39 PM
The first thing that stood out to me was "session write query failed: database is full". The first thing I would check is space limitations, starting with disk space. I am not aware of an actual database space limit, or at least I have yet to hit one.

Posted by activelobby4u, 09-05-2008, 06:50 AM
edit the file /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini file as following: Find >>>> session.save_handler = sqlite session.save_path =/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb Replace to >>> session.save_handler = files session.save_path = /tmp

Posted by sinus, 09-05-2008, 07:41 AM
dear masoud, i have this problem but i rebuild apache and solve it

Posted by cPanelDavidG, 09-05-2008, 10:46 AM
I just wanted to note that the latest versions of cPanel do not use sqlite anymore for session handling.

Posted by hosting_we3cares, 09-05-2008, 10:51 AM
Please check the permissions of /tmp. It should be 1777. Also, in /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini the session.save.path should be /tmp.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
38h (R.I.P ??) (Views: 599)
mod_security issues (Views: 574)