Are you getting SQLSTATE HY000 General error 1 no such table error?

Usually, this error occurs when trying to change the mail account webmail from Roundcube to Horde.

And the major reason will be missing tables in the database.

At Bobcares, we often get requests to fix email errors as a part of our Server Management Services.

Today, let’s have a look into the error and see how our Support Engineers fix it.

What is SQLSTATE[HY000]: General error: 1 no such table error?

Normally, this error is due to a number of the tables used by Horde that are missing from the user’s Horde SQLite database.

In general, control panel based servers there will more multiple webmail clients available. And, users have the privilege to choose one among them.

Recently one of our cPanel customers contacted us with this error. He tried to change the default webmail preference of a mail account under the user from Roundcube to Horde.

He got the below error:

How we fixed SQLSTATE HY000 General error 1 no such table error?

Now let’s see how our Support Engineers fixed this error effectively for our customer.

As we have already said, this error occurs due to a number of the tables used by Horde that are missing from the user’s Horde SQLite database.

Therefore, we tried to create the missing horde files for the particular user.  So our Support Engineers check the customer’s Cpanel error log.

And the log like this below.

[2019-06-22][webmaild] The subprocess (php) exited with an error: The subprocess reported error number 1 when it ended. at /usr/local/cpanel/Cpanel/Server/Handlers/SubProcess.pm line 251.
Cpanel::Server::Handlers::SubProcess::_report_subprocess_errors(Cpanel::Server::Handlers::SubProcess=HASH(0x221ae98)) called at /usr/local/cpanel/Cpanel/Server/Handlers/SubProcess.pm line 109
Cpanel::Server::Handlers::SubProcess::handler(Cpanel::Server::Handlers::SubProcess=HASH(0x221ae98), "subprocess_name", "php", "subprocess_pid_to_reap", 10417, "subprocess_read_handle", IO::Handle=GLOB(0x221ac88), "subprocess_write_handle", ...) called at cpsrvd.pl line 6658
cpanel::cpsrvd::cgiHandler("app", "php", "document", "./horde/login.php") called at cpsrvd.pl line 6456
cpanel::cpsrvd::phpHandler("document", "./horde/login.php") called at cpsrvd.pl line 5568
cpanel::cpsrvd::dodoc_webmaild() called at cpsrvd.pl line 1678
cpanel::cpsrvd::dodoc(HASH(0x1337ea0)) called at cpsrvd.pl line 1452
cpanel::cpsrvd::handle_one_connection(8) called at cpsrvd.pl line 893

Therefore to resolve this error we renamed the horde.sqlite file from .cphorde directory.

Then, we used this below command to rename the file of the particular user.

mv /home/username/.cphorde/horde.sqlite /home/username/.cphorde/horde.sqlite-bk

After this, we ran the below command to recreate the needed tables.

/usr/local/cpanel/bin/update_horde_config --user=username

Thus, it fixed the error for the customers.

[Need more assistance to solve the error SQLSTATE[HY000]: General error: 1 no such table error? We’ll help you]

Conclusion

In short, the error occurs when trying to change the mail account from Roundcube to Horde. Also, the error is due to a number of the tables used by Horde that are missing from the user’s Horde SQLite database. In today’s write-up, we saw how our Support Engineers fix this error for our customers.