Born2Kill

Well-Known Member
Jan 2, 2004
120
0
166
localhost or dev/null
When i click on link Cpanel/Whm news that page does not load full.

When table is loading about software is stop loading on Apache Installed Version.

How i can fix this ?
 

rix

Well-Known Member
May 1, 2003
68
0
156
WHM/Cpanel keep giving error msg such as this

Unable to create datastore file /home/<username>/.cpanel-datastore/apache_LISTSUBDOMAINS_0: Bad file descriptor Unable to create datastore file /home/<username>/.cpanel-datastore/apache_LISTMULTIPARKED_0: Bad file descriptor
Also on mysql page
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /usr/local/cpanel/Cpanel/Mysql.pm line 826. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 827.
any body having this ?
 

latinwit1

Member
Apr 23, 2006
7
0
151
rix said:
any body having this ?
Yes!!, in one server after update to WHM 10.8.0 cPanel 10.9.0-C9.

New accounts don't create any files in /home/<username>/.cpanel-datastore
 

latinwit1

Member
Apr 23, 2006
7
0
151
latinwit1 said:
Yes!!, in one server after update to WHM 10.8.0 cPanel 10.9.0-C9.

New accounts don't create any files in /home/<username>/.cpanel-datastore
I fix this by removing /home/<username>/.cpanel-datastore for these user (cpanel re-create this in the next login),

but problem remain for new accounts...
 

cytexone

Member
Mar 13, 2004
10
0
151
This fixed our problem as well

rm -rf .cpanel-datastore/

Is it going to be a problem for future accounts?
 

teakwood

Active Member
Jul 8, 2006
26
0
151
Sydney
Ugly problem! I had an account created before these updates that had never logged in until today, and I got the "Unable to create datastore file" messages.

Worse, the account was set to bluelagoon theme, and they didn't even get as far as the message - they got no control panel at all (except for the first few lines). Couldn't do anything until I switched it to X, saw the error messages, came here, and found the answer.

Thanks, your solution of removing .cpanel-datastore fixed it.
 

germanos

Member
Oct 11, 2005
6
0
151
Belo Horizonte / Brazil
cPanel Access Level
Root Administrator
Twitter
"apache_LISTSUBDOMAINS_0:" and "DBD::mysql::st execute failed"

I am having the same problem and I get to solve using "rm -rf .cpanel-datastore/", but whenever I create a new account the problem returns in the control panel (x) of the customer

In cPanel x
---------
Unable to create datastore file /home/loginclient/.cpanel-datastore/apache_LISTSUBDOMAINS_0: Bad file descriptor
--------
and in MySQL Account Maintenance in x
---------
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /usr/local/cpanel/Cpanel/Mysql.pm line 826, line 541. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 827, line 541.
--------

I solve the problem today but the following day the problem returns after the "/scripts/upcp".
I´m try /scripts/upcp --force and restart cpanel

:(

What do I make? Please, can anybody help me?

Regards
Germano
 

Bruce

Well-Known Member
Oct 4, 2001
147
0
316
We are having the same problem with BOTH of those issues and running the new Stable !!
This is really bad , all my servers have this problem now and no ryhm or reason , some accounts show the error and some dont and doesnt matter what cpanel theme is being used !
 
Last edited:

germanos

Member
Oct 11, 2005
6
0
151
Belo Horizonte / Brazil
cPanel Access Level
Root Administrator
Twitter
germanos said:
I am having the same problem and I get to solve using "rm -rf .cpanel-datastore/", but whenever I create a new account the problem returns in the control panel (x) of the customer

In cPanel x
---------
Unable to create datastore file /home/loginclient/.cpanel-datastore/apache_LISTSUBDOMAINS_0: Bad file descriptor
--------
and in MySQL Account Maintenance in x
---------
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /usr/local/cpanel/Cpanel/Mysql.pm line 826, line 541. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 827, line 541.
--------

I solve the problem today but the following day the problem returns after the "/scripts/upcp".
I´m try /scripts/upcp --force and restart cpanel

:(

What do I make? Please, can anybody help me?

Regards
Germano
Verifying at other forums I see that problem seems to be a BUG of the cpanel. Does anybody know as solving the problem?