• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

upgrade to 8.6 - PleskMainDBException - error in your SQL syntax

G

Gernavor

Guest
I got the error below after upgrading to 8.6; i've never toyed with DB provider in reconfig and hopefully I wont have to. Its been using MySql before with no problems so I don't see what its fussing about now...





ERROR: PleskMainDBException
DB query 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

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
DB query 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

0: plib\common_func.php3:243
db_query(string 'SELECT control, state FROM itmpl_data WHERE page='/login_up.php3' AND itmpl_id=')
1: plib\visibility.php:244
getVisibilityCustomizations(string '/login_up.php3')
2: plib\visibility.php:489
getVisibility(string 'login', boolean true, NULL null)
3: plib\visibility.php:498
isControlVisible(string 'login', boolean true)
4: plib\elements.php3:566
fetch_hideable_button(array)
5: plib\elements.php3:449
comm_button(string 'login', string '', string 'return login_oC(document.forms[0], document.forms[1])', boolean true, integer '3')
6: plib\LoginForm.php:93
LoginForm->assign()
7: htdocs\login_up.php3:155
 
Please execute:

---
cd %plesk_bin%

dbclient.exe --direct-sql --sql="select * from misc where param='admin_itmpl_id' or param='def_itmpl_id'"
---
 
I executed that from command line and it only showed this:
param val


Came back with the same error...
 
Please execute:

---
cd %plesk_bin%

dbclient.exe --direct-sql --sql="insert into misc values ('def_itmpl_id', '1')"

dbclient.exe --direct-sql --sql="insert into misc values ('admin_itmpl_id', '1')"
---
 
DB query failed: Table 'psa.itmpl_data' doesn't exist

Done. CLI command now shows:
param val
admin_itmpl_id 1
def_itmpl_id 1




got new error when trying to access the panel:

ERROR: PleskMainDBException
DB query failed: Table 'psa.itmpl_data' doesn't exist

Additionally, an exception has occurred while trying to report this error: PleskMainDBException
DB query failed: Table 'psa.itmpl_data' doesn't exist
 
Please execute these SQL queries

---
CREATE TABLE `itmpl` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` char(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `itmpl` VALUES (1,'Interface customization template');

CREATE TABLE `itmpl_data` (
`itmpl_id` int(10) unsigned NOT NULL default '0',
`page` varchar(127) NOT NULL default '',
`control` varchar(127) NOT NULL default '',
`state` enum('hide','adminOnly','show') NOT NULL default 'hide',
`control_type` enum('button','formControl') NOT NULL default 'button',
PRIMARY KEY (`itmpl_id`,`page`,`control`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
 
Ok got to login page; but got new error:
-----
DB query failed: Table 'psa.admin_aliases' doesn't exist
-----


Why does this sounds like my whole DB got screwed, is there any hope to fix all this?

I've checked the SQL dump files in the backup folder and see domain_aliases table structure in psa but nothing for admin_aliases.
 
Please execute SQL query

---
CREATE TABLE `admin_aliases` (
`id` int(10) unsigned NOT NULL auto_increment,
`login` varchar(20) NOT NULL default '',
`passwd` varchar(20) NOT NULL default '',
`arealname` varchar(255) NOT NULL default '',
`aemail` varchar(255) NOT NULL default '',
`comments` varchar(255) NOT NULL default '',
`status` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
 
Ok, did that and it came up with 2 more errors: DashboardPreset and DashboardPresetConfig do not exist. I used the following to resolve them.


---
CREATE TABLE `DashboardPreset` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) character SET utf8 DEFAULT '',
`uri` varchar(255) character SET ascii NOT NULL DEFAULT '',
`type` enum('admin','client','domain','private','custom') NOT NULL DEFAULT 'private',
PRIMARY KEY (`id`),
KEY `name_type` (`name`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
---

---
CREATE TABLE `DashboardPresetConfig` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`preset_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`ord` int(10) UNSIGNED NOT NULL DEFAULT '0',
`uri` varchar(255) character SET ascii NOT NULL DEFAULT '',
`parent_id` int(10) UNSIGNED DEFAULT NULL,
`type` enum('none','button','custom-buttons','column','footer','indicator','left','right','section','shortcut','tab','tabs','quick-search','quick-search-option') NOT NULL DEFAULT 'none',
`title` varchar(255) character SET utf8 DEFAULT NULL,
`description` varchar(255) character SET utf8 DEFAULT NULL,
`enabled` enum('false','true') NOT NULL DEFAULT 'true',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
---


I am going to go through and see if everything works but I have a concern that my browser title and login page are still saying plesk 7.5 regardless of the fact that I went through a series of upgrades to get to 8.6.
 
Ok found some more errors:

Tried to add a new domain and got this error when I selected the client name:
DB query failed: Unknown column 'ftps' in 'field list'

This error appears when I try to do anything in Server Management:
No process is on the other end of the pipe. (Error code 233) at Unable to write to pipe


How do I restore the values from the MYSQL dump files???
 
Please execute SQL query

ALTER TABLE `ip_addresses` ADD COLUMN `ftps` enum('false','true') NOT NULL default 'false';
 
Had to alter and add more values to the ip_addresses and hosting tables.

Protected URLs can be access by the control panel but I'm still stuck with these errors right across plesk:

No process is on the other end of the pipe. (Error code 233) at Unable to write to pipe

More data is available. (Error code 234) at Unable to read from pipe
 
Is there a list of things I should check to find out why its giving me these errors? Everything I search the net for only provides MSSQL solutions under remote access, but nothing for MYSQL.


My plesk license is through my unhelpful host Godaddy, so I cannot open a ticket.

I'm not being supported by Godaddy on this matter (their solution is to reprovision the server) and cannot request support via support ticket, which is why I was sent to this forum and trying to apply fixes by myself.

Thanks for all your help so far Moderator skvoboo.
 
No process is on the other end of the pipe. (Error code 233) at Unable to write to pipe

More data is available. (Error code 234) at Unable to read from pipe


Under 'Plesk Components Management' all the following have a "component is stopped" status:
Plesk for Windows 8.6.0
DrWeb 4.44.0.10170
BIND DNS Server 9.4.2-P2
MailEnable Standard 1.981

'Plesk Components Management' says "No process is on the other end of the pipe. (Error code 233) at Unable to write to pipe" when I hit REFRESH.

Plesk services monitor shows everything is running though; what could the problem be? permissions?
 
Patched to version 8.6.0.1 hoping it would fix things but now it has only changed the wording of the error message:

Previous request has not completed! instead of the old pipe message.
 
Have you managed to repair this?

I had the same errors following the upgrade and have gone through this thread repairing things but still have errors.

e.g. "Database Servers" returns:

DB query failed: Table 'psa.databaseservers' doesn't exist
---------------------- Debug Info -------------------------------
0: plib\common_func.php3:243
db_query(string 'select `id`, `host`, `port`, `type`, `last_error`, `server_version` from DatabaseServers')
1: plib\DatabaseServerManager.php:158
DatabaseServerManager->fetchServers()
2: plib\DatabaseServerList.php:54
DatabaseServerList->fetchDatabaseServerList()
3: plib\class.cList.php3:96
cList->fetchList()
4: plib\class.cList.php3:115
cList->init()
5: plib\DatabaseServersForm.php:25
DatabaseServersForm->assign(string '')
6: C:\Program Files\SWsoft\Plesk\admin\htdocs\server\db_servers.php:100

"Mass Emails" returns:

DB query failed: Table 'psa.massmail_templates' doesn't exist
---------------------- Debug Info -------------------------------
0: plib\common_func.php3:243
db_query(string 'select `id`, `name`, `createdBy`, `sendToClients`, `sendToDomainUsers`, `sendToAdmins`, `cr_date` from massmail_templates')
1: plib\class.MassMailTemplatesList.php:36
MassMailTemplatesList->fetchMassMailTemplatesList()
2: plib\class.cList.php3:96
cList->fetchList()
3: plib\class.cList.php3:115
cList->init()
4: plib\ui\mass-email.php:60
plesk__mass_email->accessItem(string 'GET', NULL null)
5: plib\UIPointer.php:529
UIPointer->access(string 'GET')
6: C:\Program Files\SWsoft\Plesk\admin\htdocs\plesk.php:13


and so on ... my DB is totally screwed ... I am NOT a database guru and would really appreciate some help putting this back together!!

I am running 8.6.0.5

Colin
 
Back
Top