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.
|
Add to Favourites Print this Article
Also Read