1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

upgrade to 8.6 - PleskMainDBException - error in your SQL syntax

Discussion in 'Plesk for Windows - 8.x and Older' started by Gernavor, Aug 14, 2008.

  1. Gernavor

    Gernavor Guest

    0
     
    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
     
  2. skvoboo

    skvoboo Basic Pleskian Staff Member

    23
    53%
    Joined:
    Jul 22, 2008
    Messages:
    37
    Likes Received:
    0
    Please execute:

    ---
    cd %plesk_bin%

    dbclient.exe --direct-sql --sql="select * from misc where param='admin_itmpl_id' or param='def_itmpl_id'"
    ---
     
  3. Gernavor

    Gernavor Guest

    0
     
    I executed that from command line and it only showed this:
    param val


    Came back with the same error...
     
  4. skvoboo

    skvoboo Basic Pleskian Staff Member

    23
    53%
    Joined:
    Jul 22, 2008
    Messages:
    37
    Likes Received:
    0
    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')"
    ---
     
  5. Gernavor

    Gernavor Guest

    0
     
    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
     
  6. skvoboo

    skvoboo Basic Pleskian Staff Member

    23
    53%
    Joined:
    Jul 22, 2008
    Messages:
    37
    Likes Received:
    0
    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;
    ---
     
  7. Gernavor

    Gernavor Guest

    0
     
    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.
     
  8. skvoboo

    skvoboo Basic Pleskian Staff Member

    23
    53%
    Joined:
    Jul 22, 2008
    Messages:
    37
    Likes Received:
    0
    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;
    ---
     
  9. Gernavor

    Gernavor Guest

    0
     
    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.
     
  10. Gernavor

    Gernavor Guest

    0
     
    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???
     
  11. skvoboo

    skvoboo Basic Pleskian Staff Member

    23
    53%
    Joined:
    Jul 22, 2008
    Messages:
    37
    Likes Received:
    0
    Please execute SQL query

    ALTER TABLE `ip_addresses` ADD COLUMN `ftps` enum('false','true') NOT NULL default 'false';
     
  12. Gernavor

    Gernavor Guest

    0
     
    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
     
  13. skvoboo

    skvoboo Basic Pleskian Staff Member

    23
    53%
    Joined:
    Jul 22, 2008
    Messages:
    37
    Likes Received:
    0
    Could you please post support ticket and send me its number?
     
  14. Gernavor

    Gernavor Guest

    0
     
    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.
     
  15. Gernavor

    Gernavor Guest

    0
     
    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?
     
  16. Gernavor

    Gernavor Guest

    0
     
    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.
     
  17. sergius

    sergius Golden Pleskian

    28
    57%
    Joined:
    Nov 6, 2005
    Messages:
    1,898
    Likes Received:
    0
    Please install Plesk 8.6.0.3
     
  18. colinjack

    colinjack Guest

    0
     
    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
     
Loading...