• RELEVANCY SCORE 5.45

    DB:5.45:Error: Pleskmaindbexception f9







    hello

    after upgrading to 8.2.0, i get this error msg if configuring domains:

    Code:

    DB:5.45:Error: Pleskmaindbexception f9




    hello

    after upgrading to 8.2.0, i get this error msg if configuring domains:

    Code:

  • RELEVANCY SCORE 5.34

    DB:5.34:Pleskmaindbexception Issue 8p







    Hi.

    I cant access my Plesk panel because of the following error:

    Code:

    DB:5.34:Pleskmaindbexception Issue 8p




    I´m experiencing today exactly the same problem. Any help?
    ERROR: PleskMainDBException: No connection could be made because the target machine actively refused it.
    (db.php:435)

    The log file say these:
    141201 10:16:17 [Note] Plugin FEDERATED is disabled.
    141201 10:16:25 InnoDB: The InnoDB memory heap is disabled
    141201 10:16:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions
    141201 10:16:25 InnoDB: Compressed tables use zlib 1.2.3
    141201 10:16:26 InnoDB: Initializing buffer pool, size = 16.0M
    141201 10:16:27 InnoDB: Completed initialization of buffer pool
    141201 10:16:28 InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    141201 10:16:29 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    141201 10:17:44 InnoDB: Waiting for the background threads to start
    141201 10:17:45 InnoDB: 5.5.37 started; log sequence number 144312421
    141201 10:17:45 [Note] Server hostname (bind-address): 0.0.0.0; port: 8306
    141201 10:17:45 [Note] - 0.0.0.0 resolves to 0.0.0.0;
    141201 10:17:45 [Note] Server socket created on IP: 0.0.0.0.
    141201 10:17:54 [Note] Event Scheduler: Loaded 0 events
    141201 10:17:54 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld.exe: ready for connections.
    Version: 5.5.37 socket: port: 8306 MySQL Community Server (GPL)
    141201 10:22:31 InnoDB: Operating system error number 6 in a file operation.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
    InnoDB: File operation call: flush.
    InnoDB: Cannot continue operation.

    Best regards,
    Horacio

  • RELEVANCY SCORE 5.22

    DB:5.22:Facing Error: Pleskmaindbexception: 435 zx







    Hello Friends, im using godaddy hosting service which redirects to parllels for domains and database mgt. etc. now im facing this error while connecting to parallels; any help how to resolve the problem?

    ERROR: PleskMainDBException: No connection could be made because the target machine actively refused it.
    (db.php:435)

    Ive also checked the reference link they have given right below the error message but unable to understand how to resolve as im not on localserver?

    Also i dont know if its 12x or 11x, but i posted it in 12x.

    DB:5.22:Facing Error: Pleskmaindbexception: 435 zx




    Yes, this same article, ok will contact support team.

  • RELEVANCY SCORE 4.81

    DB:4.81:Plesk Control Panel Error: Pleskmaindbexception k9





    Hi all,

    My control Panel suddenly showing this error:

    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    0: common_func.php3:600
    db_mssql_connection()
    1: common_func.php3:629
    reconnect()
    2: common_func.php3:590
    db_connect()
    3: auth.php3:87

    After do some digging, in Event Viewer it show SQL evaluation period had expired. Already reinstall the MSSQL,
    but same error still occurs. Any idea how to fix this issue? Thanks

    DB:4.81:Plesk Control Panel Error: Pleskmaindbexception k9




    Able to found the solution by change the registry value at HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config\MySQL_DB_HOST from localhost to .\SQLEXPRESS

  • RELEVANCY SCORE 4.78

    DB:4.78:Certificate Cli Cannot Work Since Update fj





    Hi,

    Since about 23rd of March 2010, the certificate command always fails :



    # /opt/psa/bin/certificate --update Name -admin -cert-file certif.crt -key-file certif.key
    ERROR: PleskMainDBException
    MySQL query failed: Cannot delete or update a parent row: a foreign key constraint fails (`psa/IP_Addresses`, CONSTRAINT `IP_Addresses_ibfk_1` FOREIGN KEY (`ssl_certificate_id`) REFERENCES `certificates` (`id`))

    0: common_func.php3:168
    db_query(string replace certificates set `id`=2, `name`=Name, `csr`=, `pvt_key`=-----BEGIN+RSA+PRIVATE+KEY-----%0A[...]%0A-----END+RSA+PRIVATE+KEY-----%0A, `cert`=-----BEGIN+CERTIFICATE-----%0A[...]%0A-----END+CERTIFICATE-----%0A, `cert_file`=cert-hWaBYG, `ca_file`=cert-x2teLX)
    1: class.Table.php:316
    Table-replaceData(array)
    2: class.Table.php:282
    Table-update(array)
    3: class.cObject.php:352
    cObject-update()
    4: class.SSLCertificate.php:454
    SSLCertificate-update()
    5: cuCertificate.php:636
    cuCertificate-cmdUpdate(string Name, array)
    6: cuCertificate.php:191
    cuCertificate-execute()
    7: certificate.php:23

    DB:4.78:Certificate Cli Cannot Work Since Update fj




    Hi,

    Since about 23rd of March 2010, the certificate command always fails :



    # /opt/psa/bin/certificate --update Name -admin -cert-file certif.crt -key-file certif.key
    ERROR: PleskMainDBException
    MySQL query failed: Cannot delete or update a parent row: a foreign key constraint fails (`psa/IP_Addresses`, CONSTRAINT `IP_Addresses_ibfk_1` FOREIGN KEY (`ssl_certificate_id`) REFERENCES `certificates` (`id`))

    0: common_func.php3:168
    db_query(string replace certificates set `id`=2, `name`=Name, `csr`=, `pvt_key`=-----BEGIN+RSA+PRIVATE+KEY-----%0A[...]%0A-----END+RSA+PRIVATE+KEY-----%0A, `cert`=-----BEGIN+CERTIFICATE-----%0A[...]%0A-----END+CERTIFICATE-----%0A, `cert_file`=cert-hWaBYG, `ca_file`=cert-x2teLX)
    1: class.Table.php:316
    Table-replaceData(array)
    2: class.Table.php:282
    Table-update(array)
    3: class.cObject.php:352
    cObject-update()
    4: class.SSLCertificate.php:454
    SSLCertificate-update()
    5: cuCertificate.php:636
    cuCertificate-cmdUpdate(string Name, array)
    6: cuCertificate.php:191
    cuCertificate-execute()
    7: certificate.php:23

  • RELEVANCY SCORE 4.76

    DB:4.76:Problem Updating 9x





    Ive b



    een doing update via autoinstaller, cause Ive been having a problem since 8.4 trying to upgrade via control panel.

    Now, in version 9.0.1, I get this error:

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:168
    db_query(string select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=6)
    1: /usr/local/psa/admin/plib/class.Table.php:183
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:479
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/dashboard/DashboardPreset.php:29
    DashboardPreset-__construct(integer 6)
    4: /usr/local/psa/admin/plib/common_func.php3:3115
    objectMaker(string DashboardPreset, integer 6, boolean false, NULL null)
    5: /usr/local/psa/admin/plib/common_func.php3:3124
    objectMakerEx(string DashboardPreset, integer 6)
    6: /usr/local/psa/admin/plib/user/UserAdmin.php:205
    UserAdmin-getDashboardCustomPreset()
    7: /usr/local/psa/admin/plib/Favorites.php:100
    Favorites::renderFavoritesDropDown(boolean false)
    8: /usr/local/psa/admin/plib/class.Form.php:286
    Form-assign()
    9: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerInstallForm.php:124
    AutoInstallerInstallForm-assignComponent(object of type AutoInstallerRelease, object of type AutoInstallerComponent, boolean true, array)
    10: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerInstallForm.php:66
    AutoInstallerInstallForm-assign(object of type AutoInstallerRelease, array, array, array, boolean false, boolean false, string , boolean false)
    11: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:132

    DB:4.76:Problem Updating 9x




    Yeah, plesk 9.x is not compatible with mysql 5.1. Youll have to roll back to 5.0 to get it to upgrade.

  • RELEVANCY SCORE 4.76

    DB:4.76:Trying To Upgrade 8.3 To 8.4 zz





    Linux - Redhat 5

    ERROR: PleskMainDBException
    Up LevelUp Level
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources)
    1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
    AutoInstallerVendorSource::getVendorSources()
    2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
    AutoInstallerManager-install(string PLESK_8_4_0, array, boolean false, string soporte@colnetwork.com, boolean true)
    3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

    DB:4.76:Trying To Upgrade 8.3 To 8.4 zz




    Thanks for the hint, I hit a similar issue (see below) and fixed it by deleting the /root/.autoinstallerrc file.



    Downloading the file repodata/repomd.xml: ERROR: Failed to download the package http://mirror.centos.org/centos-5/5/updates/repodata/repomd.xml:
    The requested URL returned error: 404

  • RELEVANCY SCORE 4.76

    DB:4.76:Error During Update Plesk 9.2.2 3x





    Hello everybody, when trying to update my plesk panel me this error:

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: common_func.php3:168
    db_query(string select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=5)
    1: class.Table.php:183
    Table-select()
    2: class.cObject.php:479
    cObject-fetchAttrsFromTable_()
    3: DashboardPreset.php:29
    DashboardPreset-__construct(integer 5)
    4: common_func.php3:3115
    objectMaker(string DashboardPreset, integer 5, boolean false, NULL null)
    5: common_func.php3:3124
    objectMakerEx(string DashboardPreset, integer 5)
    6: UserAdmin.php:205
    UserAdmin-getDashboardCustomPreset()
    7: Favorites.php:100
    Favorites::renderFavoritesDropDown(boolean true)
    8: class.Form.php:286
    Form-assign()
    9: AutoInstallerReleasesList.php:123
    AutoInstallerReleasesListForm-assign(object of type AutoInstallerReleasesList)
    10: server.autoinstaller.php:89
    plesk__server__autoinstaller-accessItem(string GET, NULL null)
    11: UIPointer.php:596
    UIPointer-access(string GET)
    12: plesk.php:38

    Thanks for any help you can provide

    DB:4.76:Error During Update Plesk 9.2.2 3x




    I apologize for the delay of my answer but I have had plenty of work. I have tried to search some kind of way for the support but I still haven’t found any. We have a reseller system with parallels despite this it has been impossible to open a support ticket to check the problem.

    What are the steps to follow so I can fix this problem?

    Thanks!

  • RELEVANCY SCORE 4.40

    DB:4.40:Error: Pleskmaindbexception kj





    Greetings:

    Ive been scratching my head trying to figure out the cause of the error (pasted below) when I attempt to access my PLESK interface. This error occurs before I get a change to log in.

    At first I assumed this was caused by corruption in the psa database, but now Im not sure. After examing the the database with unixs MYSQLCHECK PSA I can see all the tables listed, but the one referred to in the error cl_param doesnt exist... as the error indicates.

    So, my question is: should this table exist? If so, how can I recover it? I have daily dump files I can use, but I am unsure of the commands to restore it. If the table isnt meant to exist, why does the PHP3 file explicity refer to it?

    Any help or advice would be GREATLY appreciated!

    Many thanks,
    Steve Gallant

    ----- Paste of error -----------------------------------------------------------

    ERROR: PleskMainDBException


    MySQL query failed: Table psa.cl_param doesnt exist

    --------------------------------------------------------------------------------

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string select val from cl_param where param=itmpl_id and cl_id=0)
    1: /usr/local/psa/admin/plib/common_func.php3:552
    get_tparam(string itmpl_id, string cl_param, string and cl_id=0)
    2: /usr/local/psa/admin/plib/common_func.php3:567
    get_cl_param(NULL null, string itmpl_id)
    3: /usr/local/psa/admin/plib/visibility.php:355
    getITmplID()
    4: /usr/local/psa/admin/plib/visibility.php:232
    getVisibilityCustomizations(string /login_up.php3)
    5: /usr/local/psa/admin/plib/visibility.php:467
    getVisibility(string login, boolean true, NULL null)
    6: /usr/local/psa/admin/plib/visibility.php:476
    isControlVisible(string login, boolean true)
    7: /usr/local/psa/admin/plib/elements.php3:414
    fetch_hideable_button(array)
    8: /usr/local/psa/admin/plib/elements.php3:324
    comm_button(string login, string , string return login_oC(document.forms[0], document.forms[1]), boolean true, integer 3)
    9: /usr/local/psa/admin/plib/LoginForm.php:101
    LoginForm-assign()
    10: /usr/local/psa/admin/htdocs/login_up.php3:160

    DB:4.40:Error: Pleskmaindbexception kj




    Hi,

    If command is referring to it then table must exist. Have you upgraded Plesk on your server recently?
    As for now you can try running the following command:



    mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
    select * from cl_param limit 5;

  • RELEVANCY SCORE 4.38

    DB:4.38:Error: Pleskmaindbexception m8





    Clients are getting the following error when they click on the Home link from their PLESk control panel:



    ERROR: PleskMainDBException
    DB query failed: Duplicate entry 4-98-custom for key 2

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    DB query failed: Duplicate entry 4-98-custom for key 2

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:211
    db_query(string insert into `DashboardPreset` ( `name`, `type`, `uri`) values( 4-98, custom, /plesk/client@/dashboard/))
    1: C:\Program Files\SWsoft\Plesk\admin\plib\class.Table.php:336
    Table-update(array)
    2: C:\Program Files\SWsoft\Plesk\admin\plib\class.cObject.php:333
    cObject-update()
    3: C:\Program Files\SWsoft\Plesk\admin\plib\dashboard\DashboardPreset.php:183
    DashboardPreset-update()
    4: C:\Program Files\SWsoft\Plesk\admin\plib\user\User.php:344
    User-addDashboardRecent(object of type plesk__client)
    5: C:\Program Files\SWsoft\Plesk\admin\plib\class.Form.php:502
    Form-FastPrint()
    6: C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\domains.php3:279

    DB:4.38:Error: Pleskmaindbexception m8




    Clients are getting the following error when they click on the Home link from their PLESk control panel:



    ERROR: PleskMainDBException
    DB query failed: Duplicate entry 4-98-custom for key 2

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    DB query failed: Duplicate entry 4-98-custom for key 2

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:211
    db_query(string insert into `DashboardPreset` ( `name`, `type`, `uri`) values( 4-98, custom, /plesk/client@/dashboard/))
    1: C:\Program Files\SWsoft\Plesk\admin\plib\class.Table.php:336
    Table-update(array)
    2: C:\Program Files\SWsoft\Plesk\admin\plib\class.cObject.php:333
    cObject-update()
    3: C:\Program Files\SWsoft\Plesk\admin\plib\dashboard\DashboardPreset.php:183
    DashboardPreset-update()
    4: C:\Program Files\SWsoft\Plesk\admin\plib\user\User.php:344
    User-addDashboardRecent(object of type plesk__client)
    5: C:\Program Files\SWsoft\Plesk\admin\plib\class.Form.php:502
    Form-FastPrint()
    6: C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\domains.php3:279

  • RELEVANCY SCORE 4.27

    DB:4.27:Error: Pleskmaindbexception 8f





    My sites were working fine until yesterday, now I am unable to log in to plesk, I get the following error:

    ERROR: PleskMainDBException
    MySQL query failed: Cant find file: ./psa/misc.frm (errno: 5)

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:467
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:364
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:343
    db_connect_real(string localhost, string admin, string **********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:323
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:85

    How can I resolve this??

    DB:4.27:Error: Pleskmaindbexception 8f




    My sites were working fine until yesterday, now I am unable to log in to plesk, I get the following error:

    ERROR: PleskMainDBException
    MySQL query failed: Cant find file: ./psa/misc.frm (errno: 5)

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:467
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:364
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:343
    db_connect_real(string localhost, string admin, string **********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:323
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:85

    How can I resolve this??

  • RELEVANCY SCORE 4.24

    DB:4.24:Error Upgrading From 8.4 To 8.6 j9





    Server Info:

    Plesk: 8.4
    Distro: Fedora 6
    PHP: 5.2.6
    MySQL: 5.0.27

    Error Message:

    ERROR: PleskMainDBException
    Up LevelUp Level
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:214
    db_query(string SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources)
    1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
    AutoInstallerVendorSource::getVendorSources()
    2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
    AutoInstallerManager-install(string PLESK_8_6_0, array, boolean false, string support@xxxxx.com, boolean true)
    3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

    DB:4.24:Error Upgrading From 8.4 To 8.6 j9




    Server Info:

    Plesk: 8.4
    Distro: Fedora 6
    PHP: 5.2.6
    MySQL: 5.0.27

    Error Message:

    ERROR: PleskMainDBException
    Up LevelUp Level
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:214
    db_query(string SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources)
    1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
    AutoInstallerVendorSource::getVendorSources()
    2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
    AutoInstallerManager-install(string PLESK_8_6_0, array, boolean false, string support@xxxxx.com, boolean true)
    3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

  • RELEVANCY SCORE 4.24

    DB:4.24:Problem With Control Panel Access xd





    In the last period I receive often the following error when i attempt to connect at the control panel web page

    ERROR: PleskMainDBException
    Unknown database psa

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:129
    ERROR: PleskMainDBException
    Unknown database psa

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:129

    DB:4.24:Problem With Control Panel Access xd




    yes, when restarting the machine the problem resolve

  • RELEVANCY SCORE 4.11

    DB:4.11:Plesk Cp Login: Pleskmaindbexception, No Connection p3





    ---------------------------------------------------------------
    PRODUCT, VERSION, VERSION OF MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
    Plesk 10.4.4, Windows 2008 R2 64bit
    Unsure of microupdate ref because cant login but receive microupdate notice before this:
    Parallels Panel was successfully updated.
    To view the list of changes, visit http://download1.parallels.com/Plesk/PP10/whatsnew-redirect.htm?platform=windowslocale=en-US.

    PROBLEM DESCRIPTION

    On trying to visit Plesk Control Panel Screen, receive error:
    ..........................................................
    ERROR: PleskMainDBException
    No connection could be made because the target machine actively refused it.

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:129
    ERROR: PleskMainDBException
    No connection could be made because the target machine actively refused it.

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:129

    ..............................................

    STEPS TO REPRODUCE
    visit https://elure.co:8443

    ACTUAL RESULT
    See above

    EXPECTED RESULT
    Login screen

    ANY ADDITIONAL INFORMATION
    --------------------------------------------------------------

    DB:4.11:Plesk Cp Login: Pleskmaindbexception, No Connection p3




    One of the co-incidences here is that if I had have had a response to my problem about getting plesk backup about a week ago (http://forum.parallels.com/showthread.php?t=98058highlight=save+disk+backup), I may actually be in a better position. As it turns out I have a Plesk panel that wont work, no support, and no backup due to the product not being able to supply one.

    Is there any more information that can be provided? I know it may be convenient for you to provide short answers, but it is certainly not convenient for me or my clients (whos website control panels are stuffed). Any further help would be appreciated.

  • RELEVANCY SCORE 4.08

    DB:4.08:Plesk Innodb 8x





    ERROR: PleskMainDBException
    MySQL query failed: Unknown table sd in where clause

    0: /usr/local/psa/admin/plib/common_func.php3:234
    db_query(string SELECT d.id, UNIX_TIMESTAMP(d.cr_date), d.displayName, d.status, d.htype, d.real_size, d.cl_id, sum(dt.http_in) + sum(dt.ftp_in) + sum(dt.smtp_in) + sum(dt.pop3_imap_in) + sum(dt.http_out) + sum(dt.ftp_out) + sum(dt.smtp_out) + sum(dt.pop3_imap_out) AS traffic FROM domains d LEFT JOIN DomainsTraffic dt ON (dt.date BETWEEN 2007-09-01 AND 2007-09-05) AND dt.dom_id = d.id WHERE (d.displayName like %2% OR sd.displayName LIKE %2%) AND 1 GROUP BY d.id ORDER BY traffic DESC, d.displayName LIMIT 0, 100)
    1: /usr/local/psa/admin/plib/class.DomainsList.php3:218
    DomainsList-fetchDomainsList()
    2: /usr/local/psa/admin/plib/class.cList.php3:99
    cList-fetchList()
    3: /usr/local/psa/admin/plib/class.cList.php3:119
    cList-init()
    4: /usr/local/psa/admin/htdocs/domains/domains.php3:261

    how can i attempt to solve this issue stated above?

    DB:4.08:Plesk Innodb 8x




    ERROR: PleskMainDBException
    MySQL query failed: Unknown table sd in where clause

    0: /usr/local/psa/admin/plib/common_func.php3:234
    db_query(string SELECT d.id, UNIX_TIMESTAMP(d.cr_date), d.displayName, d.status, d.htype, d.real_size, d.cl_id, sum(dt.http_in) + sum(dt.ftp_in) + sum(dt.smtp_in) + sum(dt.pop3_imap_in) + sum(dt.http_out) + sum(dt.ftp_out) + sum(dt.smtp_out) + sum(dt.pop3_imap_out) AS traffic FROM domains d LEFT JOIN DomainsTraffic dt ON (dt.date BETWEEN 2007-09-01 AND 2007-09-05) AND dt.dom_id = d.id WHERE (d.displayName like %2% OR sd.displayName LIKE %2%) AND 1 GROUP BY d.id ORDER BY traffic DESC, d.displayName LIMIT 0, 100)
    1: /usr/local/psa/admin/plib/class.DomainsList.php3:218
    DomainsList-fetchDomainsList()
    2: /usr/local/psa/admin/plib/class.cList.php3:99
    cList-fetchList()
    3: /usr/local/psa/admin/plib/class.cList.php3:119
    cList-init()
    4: /usr/local/psa/admin/htdocs/domains/domains.php3:261

    how can i attempt to solve this issue stated above?

  • RELEVANCY SCORE 4.08

    DB:4.08:Problems After Upgrade 8.6 To 9.3 fc





    I get this error on the loginpage:

    ERROR: PleskFatalException
    Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to clean BackendCache in DB: Table psa.BackendCache doesnt exist

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Table psa.PersistentCache doesnt exist

    0: auth.php3:501

    Please help, i hope this can be fix easy.

    Best regards.

    DB:4.08:Problems After Upgrade 8.6 To 9.3 fc




    Thanks for your reaction. My problem was solved by placing back an older backup.

  • RELEVANCY SCORE 4.08

    DB:4.08:Error: Pleskmaindbexception Db Query Failed: Unknown Error 0 z1








    Warning: db_query() [a href=function.db-queryfunction.db-query/a]: Couldnt fetch mysqli in C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3 on line 229

    Warning: db_query() [a href=function.db-queryfunction.db-query/a]: Couldnt fetch mysqli in C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3 on line 229

    ERROR: PleskMainDBException

    DB query failed: Unknown error

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException

    DB query failed: Unknown error

    0: plib\common_func.php3:243

    db_query(string set names utf8)

    1: plib\common_func.php3:649

    reconnect()

    2: plib\common_func.php3:614

    db_connect()

    3: plib\head.php3:58

    get_current_logo_id()

    4: htdocs\top.php3:26

    DB:4.08:Error: Pleskmaindbexception Db Query Failed: Unknown Error 0 z1







    Warning: db_query() [a href=function.db-queryfunction.db-query/a]: Couldnt fetch mysqli in C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3 on line 229

    Warning: db_query() [a href=function.db-queryfunction.db-query/a]: Couldnt fetch mysqli in C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3 on line 229

    ERROR: PleskMainDBException

    DB query failed: Unknown error

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException

    DB query failed: Unknown error

    0: plib\common_func.php3:243

    db_query(string set names utf8)

    1: plib\common_func.php3:649

    reconnect()

    2: plib\common_func.php3:614

    db_connect()

    3: plib\head.php3:58

    get_current_logo_id()

    4: htdocs\top.php3:26

  • RELEVANCY SCORE 4.06

    DB:4.06:Upgraded Plesk 8.2.0 And Now Plesk Gives Mysql Error: Error: Pleskmaindbexception 78





    Hi,

    i updated Plesk from 8.1.1. to 8.2.0.

    but now have some serious problems:
    - when logging into Plesk everything looks fine, however when i click a client, want to see a domain extra it give the error below:

    +++++++++++++++++++++++++++++++++++++++++++
    ERROR: PleskMainDBException

    MySQL query failed: Unknown column uid in field list
    +++++++++++++++++++++++++++++++++++++++++++

    - also i updated from 8.1.1. to 8.2.0, but Plesk still gives the message that the system is on 8.1.1. While when i go to updater i says that 8.1.1. is installed and that i can install some additional **** for 8.2.0.

    Anyone any idea how to fix this?? Because i already tried to stop PSA, start it again.. didnt help anything. also booting the server didnt work out..

    FYI i have installed:
    - Redhat EL3
    - mysql 3.23.58-16.RHEL3.1
    - php 4.3.2-37.ent

    When i check the logs i also see this when i tried to install the other 8.2.0. things:

    - An error has occurred:
    exceptions.UnboundLocalError
    See /var/log/up2date for more information
    ERROR: The up2date utility failed to install the required packages.
    Attention! Your software might be inoperable.
    Please, contact product technical support.

    - Try to find rcfile...
    Autoinstaller rcfile not found.
    Check hostname is sucessfull.

    Hope that one of you guys can help me out.. because never had this problem before!

    kind regards,

    Bjorn

    DB:4.06:Upgraded Plesk 8.2.0 And Now Plesk Gives Mysql Error: Error: Pleskmaindbexception 78




    Hi,

    i updated Plesk from 8.1.1. to 8.2.0.

    but now have some serious problems:
    - when logging into Plesk everything looks fine, however when i click a client, want to see a domain extra it give the error below:

    +++++++++++++++++++++++++++++++++++++++++++
    ERROR: PleskMainDBException

    MySQL query failed: Unknown column uid in field list
    +++++++++++++++++++++++++++++++++++++++++++

    - also i updated from 8.1.1. to 8.2.0, but Plesk still gives the message that the system is on 8.1.1. While when i go to updater i says that 8.1.1. is installed and that i can install some additional **** for 8.2.0.

    Anyone any idea how to fix this?? Because i already tried to stop PSA, start it again.. didnt help anything. also booting the server didnt work out..

    FYI i have installed:
    - Redhat EL3
    - mysql 3.23.58-16.RHEL3.1
    - php 4.3.2-37.ent

    When i check the logs i also see this when i tried to install the other 8.2.0. things:

    - An error has occurred:
    exceptions.UnboundLocalError
    See /var/log/up2date for more information
    ERROR: The up2date utility failed to install the required packages.
    Attention! Your software might be inoperable.
    Please, contact product technical support.

    - Try to find rcfile...
    Autoinstaller rcfile not found.
    Check hostname is sucessfull.

    Hope that one of you guys can help me out.. because never had this problem before!

    kind regards,

    Bjorn

  • RELEVANCY SCORE 4.06

    DB:4.06:Pleskmaindbexception When Opening Server = Mail x7





    Hi all,

    I think the spectres of the bodged update are still in effect with my plesk. Ive been fixing DB problems as I find them but this one has me stumped. It was working fine before, it seems to have come from nowhere.

    When I click Server = Mail Im presented with this:

    MySQL query failed: Got error 28 from storage engine

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string SELECT COUNT(*) AS num FROM mail m, accounts a WHERE m.account_id=a.id AND a.type=plain AND a.password != GROUP BY m.mail_name, a.password having num 1)
    1: /usr/local/psa/admin/plib/cmd_mail.php3:1673
    short_pop3_names_compability()
    2: /usr/local/psa/admin/plib/class.ServerMailForm.php:106
    ServerMailForm-javascript(boolean true)
    3: /usr/local/psa/admin/plib/class.ServerMailForm.php:319
    ServerMailForm-assign(array, array, object of type SPFManager)
    4: /usr/local/psa/admin/htdocs/server/mail.php3:217

    Help, anyone?

  • RELEVANCY SCORE 4.05

    DB:4.05:Plesk Control Panel Stopped Working After A Update Of 8.3.0.1 kk





    When you access to the control panal by going to the address. You will receive

    Warning: db_query() [function.db-query]: Couldnt fetch mysqli in C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3 on line 199
    ERROR: PleskMainDBException DB query failed: Unknown error 0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:213 db_query(string set names utf8) 1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:619 reconnect() 2: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:584 db_connect() 3: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:79

    If you know the fix for this please do tell me?

  • RELEVANCY SCORE 4.05

    DB:4.05:Plesk 8.2.1 Db Problem 9x





    when I want to creat or display a domain, I get an error which is appear below

    Please help..

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column guid in field list

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Unknown column guid in field list

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`guid` from clients where `id`=6)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/class.Client.php3:69
    Client-Client(integer 6)
    4: /usr/local/psa/admin/plib/common_func.php3:2875
    objectMaker(string Client, integer 6)
    5: /usr/local/psa/admin/plib/class.Manager.php:679
    Manager-createMainObject(integer 2)
    6: /usr/local/psa/admin/plib/class.Manager.php:126
    Manager-Manager(integer 3, integer 6)
    7: /usr/local/psa/admin/htdocs/domains/create_domain.php:36

    DB:4.05:Plesk 8.2.1 Db Problem 9x




    This error message menas that upgrade was not properly completed. Particularly database was not upgraded. I suggest that you do one of the following:

    1) upgraded it manually with the scripts stored in /usr/local/psa/etc/db/
    2) contact support and open support case

  • RELEVANCY SCORE 4.05

    DB:4.05:Plesk Admin Wont Log In 99





    When trying to log in, plesk will send me back to the blank login screen.

    After trying to change the password, I then got this error:



    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away
    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string delete from lockout where login=admin)
    1: /usr/local/psa/admin/htdocs/login_up.php3:72

  • RELEVANCY SCORE 4.05

    DB:4.05:Pleskmaindbexception Error Cant Connect To Mysql Server kk





    I inherited a Windows 2003 server with Plesk 7.6.5. All of a sudden this morning Plesk control panel wont run, instead displaying:



    ERROR: PleskMainDBException
    [MySQL][ODBC 3.51 Driver]Cant connect to MySQL server on localhost (10061)

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:610
    reconnect()
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:592
    db_connect()
    2: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:63

    DB:4.05:Pleskmaindbexception Error Cant Connect To Mysql Server kk




    I inherited a Windows 2003 server with Plesk 7.6.5. All of a sudden this morning Plesk control panel wont run, instead displaying:



    ERROR: PleskMainDBException
    [MySQL][ODBC 3.51 Driver]Cant connect to MySQL server on localhost (10061)

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:610
    reconnect()
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:592
    db_connect()
    2: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:63

  • RELEVANCY SCORE 4.01

    DB:4.01:After Update 8.1 To 8.2 Fedora Core2 x1





    hallo after update to 8.2 on fedora core2
    i cant go to the databse menü on plesk

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column server_version in field list
    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select `id`,`host`,`port`,`type`,`admin_login`,`admin_password`,`last_error`,`server_version` from DatabaseServers where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/DatabaseServer.php:45
    DatabaseServer-__construct(string 1)
    4: /usr/local/psa/admin/plib/DatabaseServerManager.php:135
    DatabaseServerManager-getServer(string 1)
    5: /usr/local/psa/admin/plib/class.DataBasesList.php3:73
    DataBasesList-fetchDataBasesList()
    6: /usr/local/psa/admin/plib/class.cList.php3:103
    cList-fetchList()
    7: /usr/local/psa/admin/plib/class.cList.php3:123
    cList-init()
    8: /usr/local/psa/admin/htdocs/domains/databases/db.php3:35

    can any help my
    thanks

    DB:4.01:After Update 8.1 To 8.2 Fedora Core2 x1




    hallo after update to 8.2 on fedora core2
    i cant go to the databse menü on plesk

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column server_version in field list
    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select `id`,`host`,`port`,`type`,`admin_login`,`admin_password`,`last_error`,`server_version` from DatabaseServers where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/DatabaseServer.php:45
    DatabaseServer-__construct(string 1)
    4: /usr/local/psa/admin/plib/DatabaseServerManager.php:135
    DatabaseServerManager-getServer(string 1)
    5: /usr/local/psa/admin/plib/class.DataBasesList.php3:73
    DataBasesList-fetchDataBasesList()
    6: /usr/local/psa/admin/plib/class.cList.php3:103
    cList-fetchList()
    7: /usr/local/psa/admin/plib/class.cList.php3:123
    cList-init()
    8: /usr/local/psa/admin/htdocs/domains/databases/db.php3:35

    can any help my
    thanks

  • RELEVANCY SCORE 3.97

    DB:3.97:Error: Pleskmaindbexception 8d





    ERROR: PleskMainDBException
    MySQL query failed: Table sessions is read only

    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string update sessions set click_time=NOW() where sess_id=01d20731943667cd941e02c02d67b93e)
    1: /usr/local/psa/admin/plib/class.Session.php:416
    Session-init(string 87.2.223.34)
    2: /usr/local/psa/admin/auto_prepend/auth.php3:201

    DB:3.97:Error: Pleskmaindbexception 8d




    Seems something wrong with MySQL. Try to restart it and run



    delete from sessions;

  • RELEVANCY SCORE 3.95

    DB:3.95:Error: Pleskmaindbexception 3x





    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    0: C:\Plesk\admin\plib\common_func.php3:589
    reconnect()
    1: C:\Plesk\admin\plib\common_func.php3:561
    db_connect()
    2: C:\Plesk\admin\auto_prepend\auth.php3:67

    whats the prblem : (

    DB:3.95:Error: Pleskmaindbexception 3x




    Are you shure you SQL server is running ? Enable and Start your SQL server from services if you have disabled it. (Or at least verify that that its running)

  • RELEVANCY SCORE 3.93

    DB:3.93:Plesk Upgrade Error: Pleskmaindbexception 8j





    After upgrading tou plesk 8.0.0 I get this errors in the plesk page:

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.itmpl_data doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string SELECT control, state FROM itmpl_data WHERE page=/login_up.php3 AND itmpl_id=)
    1: /usr/local/psa/admin/plib/visibility.php:199
    getVisibilityCustomizations(string /login_up.php3)
    2: /usr/local/psa/admin/plib/visibility.php:434
    getVisibility(string login, boolean true, NULL null)
    3: /usr/local/psa/admin/plib/visibility.php:443
    isControlVisible(string login, boolean true)
    4: /usr/local/psa/admin/plib/elements.php3:341
    fetch_hideable_button(array)
    5: /usr/local/psa/admin/plib/elements.php3:254
    comm_button(string login, string , string return login_oC(document.forms[0], document.forms[1]), boolean true, integer 3)
    6: /usr/local/psa/admin/htdocs/login_up.php3:169

    Any help please?

    DB:3.93:Plesk Upgrade Error: Pleskmaindbexception 8j




    After upgrading tou plesk 8.0.0 I get this errors in the plesk page:

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.itmpl_data doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string SELECT control, state FROM itmpl_data WHERE page=/login_up.php3 AND itmpl_id=)
    1: /usr/local/psa/admin/plib/visibility.php:199
    getVisibilityCustomizations(string /login_up.php3)
    2: /usr/local/psa/admin/plib/visibility.php:434
    getVisibility(string login, boolean true, NULL null)
    3: /usr/local/psa/admin/plib/visibility.php:443
    isControlVisible(string login, boolean true)
    4: /usr/local/psa/admin/plib/elements.php3:341
    fetch_hideable_button(array)
    5: /usr/local/psa/admin/plib/elements.php3:254
    comm_button(string login, string , string return login_oC(document.forms[0], document.forms[1]), boolean true, integer 3)
    6: /usr/local/psa/admin/htdocs/login_up.php3:169

    Any help please?

  • RELEVANCY SCORE 3.71

    DB:3.71:After Update 8.1.1 p8





    Hello,

    add sub domain

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:211
    db_query(string select id id, displayName name, cl_id parent_id from domains where id in (4))
    1: /usr/local/psa/admin/plib/CachedResolver.php:143
    CachedResolver-findParentsOfIds(array)
    2: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:108
    CompatibilityUIPointer-importSessionParams(NULL null, boolean false)
    3: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:120
    CompatibilityUIPointer-importSessionParams(NULL null, boolean false)
    4: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:120
    CompatibilityUIPointer-importSessionParams(NULL null, boolean true)
    5: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:120
    CompatibilityUIPointer-importSessionParams()
    6: /usr/local/psa/admin/plib/UIPointer.php:766
    UIPointer::getCurrent()
    7: /usr/local/psa/admin/plib/common_func.php3:3791
    wizard_dispatch_next(integer 4511)
    8: /usr/local/psa/admin/htdocs/domains/subdomains/subdom_edit.php:101

    Thanks for you help

    DB:3.71:After Update 8.1.1 p8




    Hello,

    add sub domain

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:211
    db_query(string select id id, displayName name, cl_id parent_id from domains where id in (4))
    1: /usr/local/psa/admin/plib/CachedResolver.php:143
    CachedResolver-findParentsOfIds(array)
    2: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:108
    CompatibilityUIPointer-importSessionParams(NULL null, boolean false)
    3: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:120
    CompatibilityUIPointer-importSessionParams(NULL null, boolean false)
    4: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:120
    CompatibilityUIPointer-importSessionParams(NULL null, boolean true)
    5: /usr/local/psa/admin/plib/CompatibilityUIPointer.php:120
    CompatibilityUIPointer-importSessionParams()
    6: /usr/local/psa/admin/plib/UIPointer.php:766
    UIPointer::getCurrent()
    7: /usr/local/psa/admin/plib/common_func.php3:3791
    wizard_dispatch_next(integer 4511)
    8: /usr/local/psa/admin/htdocs/domains/subdomains/subdom_edit.php:101

    Thanks for you help

  • RELEVANCY SCORE 3.70

    DB:3.70:Mssql 2005 3c





    I have a problem at the registration:

    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b Fehler bei der Anmeldung für den Benutzer admin.

    0: C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3:594
    db_mssql_connection()
    1: C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3:623
    reconnect()
    2: C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3:584
    db_connect()
    3: C:\Program Files\Parallels\Plesk\admin\auto_prepend\auth.php3:79

    please help me.

    DB:3.70:Mssql 2005 3c




    Mine is doing it too. Just upgraded to 8.4 a couple of days ago and it was ok until tonight. From the error log, SQL EXPRESS is running as NETWORK SERVICE which is denied access to the data folder by the Deny ACL for the psaserv group.

    Theres a user with a long name who has a Permit entry ahead of the Denys. Maybe that should be the user which is running the SQL service? Maybe I got a bad install? Or maybe the reconfigurator (which I ran to fix another problem) messed up the service permissions?

  • RELEVANCY SCORE 3.70

    DB:3.70:Cant Apply Firewall Configuration Changes Due To Mysql Error 7s





    I cant activate my firewall configuration changes due to MySQL error:

    ERROR: PleskMainDBException
    MySQL query failed: Duplicate entry 1-0-2 for key configuration_id

    DB:3.70:Cant Apply Firewall Configuration Changes Due To Mysql Error 7s




    Hi ShoneA,

    did you made any changes to the firewall? If not, I could give you a dump of that table. It seems, that there is anything wrong. Did you tried already a bootstrapper repair?

  • RELEVANCY SCORE 3.69

    DB:3.69:Failed Upgrade From 8.6.0 To V9 cz





    Hi,

    I attempted an upgrade from V8.6.0 to 9 yesterday which didnt complete properly and Im not unable to access the control panel.

    When accessing the control panel I get the following error:



    ERROR: PleskFatalException
    Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to clean BackendCache in DB: Table psa.BackendCache doesnt exist

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Table psa.PersistentCache doesnt exist

    0: auth.php3:491

    DB:3.69:Failed Upgrade From 8.6.0 To V9 cz




    Extra Info

    From the email I received following the failed install, here is a section that may help:



    === Installing psa database
    Trying to start service mysqld... done
    Trying to define valid mysql credentials... Trying to establish test connection... connected
    done
    Trying to start service mysqld... done
    Trying to establish test connection... connected
    done
    Trying to check psa database... Trying to find psa database... version is 0860

    ERROR while trying to execute SQL query, the query was: DELETE FROM mysql.user WHERE user = ; FLUSH PRIVILEGES;
    Check the error reason(see log file: /tmp/psa_9.5.4_cos5.build95101209.08_upgrade.110215.15.02.log), fix and try again

    Aborting...

    error: %post(psa-9.5.4-cos5.build95101209.08.x86_64) scriptlet failed, exit status 1
    Trying to install PAM module... done
    Trying to start service mysqld... done
    Trying to establish test connection... connected
    done
    Trying to establish test connection... connected
    Trying to upgrade persistent database storage... done
    ERROR: PleskMainDBException
    MySQL query failed: Unknown column type in where clause

    0: common_func.php3:206
    db_query(string SELECT COUNT(*) FROM clients where type admin)
    1: common_func.php3:3569
    KeyLimitsChecker::getClientsUsed()
    2: common_func.php3:3459
    KeyLimitsChecker::checkEasyMisused(boolean false)
    3: common_func.php3:3299
    KeyLimitsChecker::checkKey(boolean false)
    4: common_func.php3:3497
    KeyLimitsChecker::resetKeyLocks()
    5: cmd_loginup.php:137
    createSession(string admin, string *********, boolean true, boolean false, integer -1)
    6: cu.php:619
    cu-setSession()
    7: cu.php:218
    cu-cu()
    8: update_notifications.php:83

    WARNING!
    During the cannot update notifications. Please rerun /usr/local/psa/admin/plib/scripts/update_notifications.php manyally found some problems(see log file: /tmp/psa-api-rpc_9.5.4_cos5.build95101209.08_upgrade.110215.15.02.log)

    Continue...

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column type in where clause

    0: common_func.php3:206
    db_query(string SELECT COUNT(*) FROM clients where type admin)
    1: common_func.php3:3569
    KeyLimitsChecker::getClientsUsed()
    2: common_func.php3:3459
    KeyLimitsChecker::checkEasyMisused(boolean false)
    3: common_func.php3:3299
    KeyLimitsChecker::checkKey(boolean false)
    4: common_func.php3:3497
    KeyLimitsChecker::resetKeyLocks()
    5: cmd_loginup.php:137
    createSession(string admin, string *********, boolean true, boolean false, integer -1)
    6: cu.php:619
    cu-setSession()
    7: cu.php:218
    cu-cu()
    8: create_default_templates.php:354

    WARNING!
    During the default tempaltes cannot be created found some problems(see log file: /tmp/psa-api-rpc_9.5.4_cos5.build95101209.08_upgrade.110215.15.02.log)

  • RELEVANCY SCORE 3.69

    DB:3.69:Error: Pleskmaindbexception px





    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not

    exist or access denied.

    0: common_func.php3:601
    db_mssql_connection()
    1: common_func.php3:630
    reconnect()
    2: common_func.php3:591
    db_connect()
    3: auth.php3:90

    DB:3.69:Error: Pleskmaindbexception px




    This seems to be an issue with your plesk database. provide all plesk database details

  • RELEVANCY SCORE 3.65

    DB:3.65:Help Please mj





    My Plesk will not Running:
    What is this?
    ERROR: PleskMainDBException
    MySQL query failed: Incorrect information in file: ./psa/misc.frm

    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:513
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:410
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:389
    db_connect_real(string localhost, string admin, string *****, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:369
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:87

    DB:3.65:Help Please mj




    Hi,

    Have you upgraded MySql recently?
    Have you changed some settings in the /etc/my.cnf ?

    Also you can try to restore Plesk database:
    its dump is stored daily in the /var/lib/psa/dumps directory by default.

    Also visit the following resource:
    http://bugs.mysql.com/bug.php?id=66

  • RELEVANCY SCORE 3.59

    DB:3.59:Pleskmaindbexception fx





    MySQL dying repeatedly

    Im getting these messages all the time....

    ERROR: PleskMainDBException
    MySQL query failed: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

    or many similar, basically keeps killing mysql, Im running 4.1 on FC4 and the whole server is fresh, only 3 days old.

    Also possibly related is httpd keeps dying as well, to the point where I have to stop it to try anything in the CP, as soon as I bring httpd back up plesk just sits there and usually ends up with one of the above messages or any number of variations, always resulting in a dead mysql.

    Any ideas, similar ?

    DB:3.59:Pleskmaindbexception fx




    Ive since discovered that this issue is actually a MySQL documented bug, that was fixed in the 4.1.17 release and Im on 4.1.16 however there are no FC4 binaries for this release and Im still working on getting it updated.

  • RELEVANCY SCORE 3.56

    DB:3.56:Cannot Upgrade From 9.2.2 1c





    I am currently running Plesk 9.2.2 on a Centos 5.4 64-bit box. When I go to Updates in the Plesk control panel it currently indicates (yellow icon) that there are updates to my 9.2.2 version, even though there are none. If I go ahead and install all updates for 9.2.2 it reports a success. However whenever I try to update to 9.2.3 or 9.3.0 I get the following:

    ERROR: PleskMainDBException MySQL query failed: MySQL server has gone away Additionally, an exception has occurred while trying to report this error: PleskMainDBException MySQL query failed: MySQL server has gone away
    0: common_func.php3:168 db_query(string select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=5)
    1: class.Table.php:183 Table-select()
    2: class.cObject.php:479 cObject-fetchAttrsFromTable_()
    3: DashboardPreset.php:29 DashboardPreset-__construct(integer 5)
    4: common_func.php3:3115 objectMaker(string DashboardPreset, integer 5, boolean false, NULL null)
    5: common_func.php3:3124 objectMakerEx(string DashboardPreset, integer 5)
    6: UserAdmin.php:205 UserAdmin-getDashboardCustomPreset()
    7: Favorites.php:100 Favorites::renderFavoritesDropDown(boolean false)
    8: class.Form.php:286 Form-assign()
    9: AutoInstallerInstallForm.php:124 AutoInstallerInstallForm-assignComponent(object of type AutoInstallerRelease, object of type AutoInstallerComponent, boolean true, array)
    10: AutoInstallerInstallForm.php:66 AutoInstallerInstallForm-assign(object of type AutoInstallerRelease, array, array, array, boolean false, boolean false, string , boolean false)
    11: autoinstaller_install.php:132

    I have restarted the MySQL server, and run an extended database check on the PSA database and it reports that all tables are OK

    So what now?

  • RELEVANCY SCORE 3.56

    DB:3.56:Error: Pleskmaindbexception a8





    Dear All;

    I didnt find mysql admin password or password change information. My server is down. Because I dont forget my database passwords.

    ERROR:

    PleskMainDBException
    [MySQL][ODBC 3.51 Driver]Access denied for user admin@localhost (using password: YES)

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:610
    reconnect()
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:592
    db_connect()
    2: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:63

    DB:3.56:Error: Pleskmaindbexception a8




    Hello,

    Please try the solution described in SWSoft Knowledge Base:

    http://kb.swsoft.com/en/1561

    This should help you to reset admin password.

  • RELEVANCY SCORE 3.41

    DB:3.41:Error: Pleskmaindbexception k8





    Hello Guys,

    I am getting this error when trying to visit plesk through my site:-

    ERROR: PleskMainDBException
    bSource:/b Microsoft JET Database Enginebr/bDescription:/b Unspecified error

    0: C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3:636
    reconnect()
    1: C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3:584
    db_connect()
    2: C:\Program Files\Parallels\Plesk\admin\auto_prepend\auth.php3:79

    I am still able to view my website however. But am not able to get to the plesk control panel itself.

    Any help?

    Thanks!

    DB:3.41:Error: Pleskmaindbexception k8




    Running the the Plesk reconfigurator - Correct Disk Permissions worked. Thanks Sanjay for heads up!!

  • RELEVANCY SCORE 3.41

    DB:3.41:Error: Pleskmaindbexception 1z





    When I click on Server - Mail I received the following error:

    MySQL query failed: Got error 28 from storage engine

    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string SELECT COUNT(*) AS num FROM mail m, accounts a WHERE m.account_id=a.id AND a.type=plain AND a.password != GROUP BY m.mail_name, a.password having num 1)
    1: /usr/local/psa/admin/plib/cmd_mail.php3:1673
    short_pop3_names_compability()
    2: /usr/local/psa/admin/plib/class.ServerMailForm.php:107
    ServerMailForm-javascript(boolean false)
    3: /usr/local/psa/admin/plib/class.ServerMailForm.php:320
    ServerMailForm-assign(array, array, object of type SPFManager)
    4: /usr/local/psa/admin/htdocs/server/mail.php3:236

    Please note: Its not a hard drive full issue as seen below:

    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/mapper/VolGroup00-LogVol00
    75639848 47054852 24680692 66% /
    /dev/sda1 295561 28544 251757 11% /boot
    tmpfs 517568 0 517568 0% /dev/shm
    /var/tmpmnt 483886 483886 0 100% /tmp

    Ok so it may be a full partition issue. When Im in /tmp I see a mail.send file which is taking up the full amount. I tried deleting it but got the following:
    $ rm mail.send
    rm: cannot remove `mail.send: Operation not permitted

    Now Im stuck. Can someone tell me what I should do?
    TIA Shane

    DB:3.41:Error: Pleskmaindbexception 1z




    Figured it out. I wasnt in su mode. But when I deleted the file and things appeared to be working again I noticed that all the forwarding of customers email addresses were no longer working. Further searching this forum I found someone recommending to use /usr/local/psa/admin/bin/mchk -v which thankfully worked.

    Further investigation though shows that email that should have been forwarded (as was set up in Plesk) was actually delivered to the users mailbox on the server even though that user wasnt configured with a mailbox in Plesk (only redirect was enabled). So my problem now is how do people retrieve email that was delivered locally (ie. /var/qmail/mailnames/domain.com/user123/Maildir/new) that dont have a mailbox enabled in Plesk?

    TIA Shane

  • RELEVANCY SCORE 3.41

    DB:3.41:After Update From 9.2 To 9.2.1 = Psa.Siteapps Doesnt Exist sj





    hello
    just after upgrading plesk starts correctly i get this message after successful admin connection :

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.SiteApps doesnt exist

    licence is ok
    I try ti use /usr/local/psa/admin/bin/autoinstaller
    When connecting to mysql on command line psa.mysql does not contains this table

    Any idea ?
    Thanks

    DB:3.41:After Update From 9.2 To 9.2.1 = Psa.Siteapps Doesnt Exist sj




    hello
    just after upgrading plesk starts correctly i get this message after successful admin connection :

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.SiteApps doesnt exist

    licence is ok
    I try ti use /usr/local/psa/admin/bin/autoinstaller
    When connecting to mysql on command line psa.mysql does not contains this table

    Any idea ?
    Thanks

  • RELEVANCY SCORE 3.41

    DB:3.41:Pleskmaindbexception After Update 91





    When I say email Click in the administration of a Abonoments on the tab, the following error message appears.
    However, this error only occurs with a single Abonoment. How can I fix this?

    Code:

    DB:3.41:Pleskmaindbexception After Update 91




    Thanks for the hint. It was the name of the webmail services with an umlaut. Why does this but only when a domain has been the case is beyond me. Also the Plesk this after updating to version 11.5 can no longer weak. Before the update it worked, and the software allows saving to.

    Solution: Change the name under Tools Settings - Email - Webmail
    Now change the name of the app.

  • RELEVANCY SCORE 3.38

    DB:3.38:Mysql Query Failed: Mysql Server Has Gone Away xx





    When I log-in to Plesk Control Panel and try to access the server section I get the following error:

    ERROR: PleskMainDBException
    MySQL query failed: Lost connection to MySQL server during query

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /opt/psa/admin/plib/common_func.php3:250
    db_query(string SELECT `id`, `ord`, `uri`, `parent_id`, `enabled`, `type`, `title`, `description` FROM `DashboardPresetConfig` WHERE `preset_id`=1 ORDER BY `ord` DESC)
    1: /opt/psa/admin/plib/dashboard/DashboardPreset.php:160
    DashboardPreset-fetchConfig()
    2: /opt/psa/admin/plib/dashboard/DashboardPreset.php:296
    DashboardPreset-getConfig()
    3: /opt/psa/admin/plib/dashboard/DashboardPreset.php:103
    DashboardPreset-getElementByURI(string /plesk/dashboard/#shortcuts)
    4: /opt/psa/admin/plib/dashboard/Dashboard.php:152
    Dashboard::getShortcutParent(object of type DashboardPreset, object of type plesk__server)
    5: /opt/psa/admin/plib/class.Form.php:244
    Form-assign()
    6: /opt/psa/admin/plib/class.ServerForm.php:172
    ServerForm-assign(object of type ComponentsChecker)
    7: /opt/psa/admin/htdocs/server/server.php3:115

    This first happened after the first server restart in 145 days, then, overnight it seemed to have resolved by itself. But today the error appeared again. If I do a mysqlcheck on the psa database I get: mysqlcheck: Got error: 2002: Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (111) when selecting the database

    Ive checked, the socket exists. The other databases work with no problem.

    DB:3.38:Mysql Query Failed: Mysql Server Has Gone Away xx




    see the timeout ... that could be the issue in my.cnf

  • RELEVANCY SCORE 3.38

    DB:3.38:Trouble After Plesk Update 8.4 To 8.6 jf





    Hello,

    after the Plesk update some Domains not running. If i want delete / Create /change a Domain or i only want to look in the dns setting:

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column serial in field list

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Unknown column serial in field list

    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string select `id`,`name`,`displayName`,`email`,`status`,`type`,`ttl`,`ttl_unit`,`refresh`,`refresh_unit`,`retry`,`retry_unit`,`expire`,`expire_unit`,`minimum`,`minimum_unit`,`serial`,`serial_format` from dns_zone where `id`=26)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/dns/DNSZone.php:56
    DNSZone-DNSZone(string 26)
    3: /usr/local/psa/admin/plib/common_func.php3:2930
    objectMaker(string DNSZone, string 26)
    4: /usr/local/psa/admin/plib/dns/DNSManager.php:37
    DNSManager::getDNSZone(string 26)
    5: /usr/local/psa/admin/plib/class.Domain.php:682
    Domain-getDNSZone()
    6: /usr/local/psa/admin/plib/ui/client.domain.dns.php:76
    plesk__client__domain__dns-getDNSZone()
    7: /usr/local/psa/admin/plib/ui_common/DNSUIPointer.php:88
    DNSUIPointer-getFlavor()
    8: /usr/local/psa/admin/plib/UIPointer.php:834
    UIPointer-getCaption(string done, string , NULL null, object of type UserAdmin, NULL null, string )
    9: /usr/local/psa/admin/plib/common_func.php3:3887
    wizard_get_done_message()
    10: /usr/local/psa/admin/htdocs/plesk.php:18

    DB:3.38:Trouble After Plesk Update 8.4 To 8.6 jf




    Internal Plesk error occurred: MySQL query failed: Unknown column serial in field

    My server crashed 2 days back because of the MySql database. Even the main PSA database behind Plesk got corrupted. and I re-installed my server after taking back-ups of all my web files and databases. When I restored my files, all my sites where up and Plesk was fully functional. But email would not work. When click on Domain-Mail the error Internal Plesk error occurred: MySQL query failed: Unknown column serial in field list gets displayed. Has anyone solved this kind of error??Please help..!

  • RELEVANCY SCORE 3.38

    DB:3.38:Error: Pleskmaindbexception Sql c3





    I installed Plesk 8.3 on a Windows Standard Server 2003 and get this error:



    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b Login failed for user admin. The user is not associated with a trusted SQL Server connection.

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:594
    db_mssql_connection()
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:623
    reconnect()
    2: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:584
    db_connect()
    3: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:79

    DB:3.38:Error: Pleskmaindbexception Sql c3




    I woudl be keen to know if fixed as well? I am not going to update to 8.6 may make things worse!!

  • RELEVANCY SCORE 3.38

    DB:3.38:Plesk 9.2 -Pleskmaindbexception xa





    Hi

    I got this error

    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    0: common_func.php3:600
    db_mssql_connection()
    1: common_func.php3:629
    reconnect()
    2: common_func.php3:590
    db_connect()
    3: auth.php3:87

    Let me know how to solve this issue

    Thanks
    Binesh S

    DB:3.38:Plesk 9.2 -Pleskmaindbexception xa




    Hi,

    Are you able to connect to the database see tables with contents from any of MySQL tools ? (e.g. Mysql administartor)

  • RELEVANCY SCORE 3.38

    DB:3.38:Database Problem Urgent.... s9





    Please I need some help:

    i was trying to change administrator plesk password than this error came out

    ERROR: PleskMainDBException
    DB query failed: Unknown error

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:211
    db_query(string set names utf8)
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:585
    reconnect()
    2: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:566
    db_connect()
    3: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:69

    then I cant access to the plesk administrator account ..
    at least could some body tell me where is the table that holds the passwords

    DB:3.38:Database Problem Urgent.... s9




    Hello Everybody,

    To fix this issue you should

    1. download updated modules plesksrvclient and php_plesk_util.dll from ftp://pleskwin.download.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/121385
    2. stop PleskControlPanel
    3. copy plesksrvclient to plesk\admin\bin and php_plesk_util.dll to plesk\admin\modules
    4. run plesksrvclient without parameters. Dialog box will appear.
    5. type old password and clear option Change Admin Password in Plesk SQL Server.
    6. click OK
    7. start PleskControlPanel

  • RELEVANCY SCORE 3.38

    DB:3.38:Login Problem... 97





    Hi There,

    Yesterday i create a new account client for one of our costumers, when he try to login, it gets this error:

    ERROR: PleskMainDBException
    DB query failed: Duplicate entry 4-190-custom for key 2

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    DB query failed: Duplicate entry 4-190-custom for key 2

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:213
    db_query(string insert into `DashboardPreset` ( `name`, `type`, `uri`) values( 4-190, custom, /plesk/client@/dashboard/))
    1: C:\Program Files\SWsoft\Plesk\admin\plib\class.Table.php:336
    Table-update(array)
    2: C:\Program Files\SWsoft\Plesk\admin\plib\class.cObject.php:333
    cObject-update()
    3: C:\Program Files\SWsoft\Plesk\admin\plib\dashboard\DashboardPreset.php:183
    DashboardPreset-update()
    4: C:\Program Files\SWsoft\Plesk\admin\plib\user\User.php:401
    User-addDashboardRecent(object of type plesk__client__properties)
    5: C:\Program Files\SWsoft\Plesk\admin\plib\class.Form.php:502
    Form-FastPrint()
    6: C:\Program Files\SWsoft\Plesk\admin\htdocs\clients\cl_ed.php3:336

    Solutions?

    I try to check instalation Plesk, but nothing.

    Thanks in Advance!

    DB:3.38:Login Problem... 97




    Silence1

    This error actually means that there is alreadt record exists in your plesk database for that client entry. You can check it with the following query:

    mysql SELECT * FROM DashboardPreset WHERE name = 4-190;

    and if returns some entries - just remove them manually:

    mysql DELETE FROM DashboardPreset WHERE name = 4-190;

    P.S. Please do not forget to backup original database before doing any changes - just in case.

  • RELEVANCY SCORE 3.38

    DB:3.38:Psa Database Problems After Upgrading To 8.0 ax





    Hi. I am running a Debian version of Plesk and after upgrading to 8.0 at least the domains and the general page all have this error and do not proceed.
    ERROR: PleskMainDBException
    MySQL query failed: Unknown column d.id in on clause
    0: /opt/psa/admin/plib/common_func.php3:229
    db_query(string select d.id from domains d, Limits l LEFT JOIN subdomains sd ON
    sd.dom_id = d.id where (d.limits_id=l.id) and (l.limit_name=disk_space) and (l.value=0)
    and (d.real_sizel.value) GROUP BY d.id)
    1: /opt/psa/admin/plib/class.DomainsList.php3:264
    DomainsList-fetchDomainsList()
    2: /opt/psa/admin/plib/class.cList.php3:100
    cList-fetchList()
    3: /opt/psa/admin/plib/class.cList.php3:120
    cList-init()
    4: /opt/psa/admin/htdocs/domains/domains.php3:265

    Any assistance would be appreciated.

    DB:3.38:Psa Database Problems After Upgrading To 8.0 ax







    Originally posted by BoiseComputer
    Any solution found for this problem?

  • RELEVANCY SCORE 3.38

    DB:3.38:Error: Pleskmaindbexception 7p





    Hello NG,

    i have a Problem, wil starting my Parallels Panel 10.2 and become this error.

    ERROR: PleskMainDBException
    DB query failed: Unknown error

    0: common_func.php3:114
    db_query(string set names utf8)
    1: common_func.php3:612
    reconnect()
    2: common_func.php3:577
    db_connect()
    3: auth.php3:148

    My server is Windows 2008 Webserver whis Plesk 10.2

    Can you help.
    Thanks
    Matthias

    DB:3.38:Error: Pleskmaindbexception 7p




    As I can see here still long time over and still no one has looked over the issue,then please contact the technical support team.

    __________________
    Macbook Pro 17 2.8Ghz; Host OS: Snow Leopard 10.6.2, 32-bit;Guest OS: Windows 7 Ultimate x64... Proud

  • RELEVANCY SCORE 3.36

    DB:3.36:Plesk - Mysql - Table Issue 9d





    centos plesk 10.3.1
    ------------------------------------------------
    adding into my.cnf LOWER_CASE_TABLE_NAMES = 1 which is necessary for my applications work which use mix case SQL queries produced the following error on plesk access.
    ------------------------------------------------
    ERROR: PleskMainDBException
    MySQL query failed: Table psa.skins doesnt exist

    0: common_func.php3:200
    db_query(string select `id`,`name`,`place` from Skins where `id`=1)
    1: Table.php:154
    Table-select()
    2: Skin.php:120
    Skin-__construct(integer 1)
    3: common_func.php3:3262
    objectMaker(string Skin, integer 1, boolean false, NULL null)
    4: common_func.php3:3271
    objectMakerEx(string Skin, integer 1)
    5: Skin.php:588
    Skin::initSkin()
    6: auth.php3:513
    ------------------------------------------------
    switching back LOWER_CASE_TABLE_NAMES = 0 or removing the entry reverses the issue

    Anyone with ideas ?

  • RELEVANCY SCORE 3.36

    DB:3.36:Plesk Wont Start Due To Problem With Mysql 1j





    I get the following error when i try launching Plesk. i checked the psa database through a separate install of phpmyadmin and psa.skins indeed doesnt exist. Is there any of restoring this. perhaps someone could send the ddl and data for this table.

    thank you

    amit

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.skins doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:214
    db_query(string select `id`,`name`,`place` from Skins where `id`=8)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/skin/Skin.php:63
    Skin-Skin(integer 8)
    3: /usr/local/psa/admin/plib/common_func.php3:2886
    objectMaker(string Skin, integer 8)
    4: /usr/local/psa/admin/auto_prepend/auth.php3:508

    DB:3.36:Plesk Wont Start Due To Problem With Mysql 1j




    I get the following error when i try launching Plesk. i checked the psa database through a separate install of phpmyadmin and psa.skins indeed doesnt exist. Is there any of restoring this. perhaps someone could send the ddl and data for this table.

    thank you

    amit

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.skins doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:214
    db_query(string select `id`,`name`,`place` from Skins where `id`=8)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/skin/Skin.php:63
    Skin-Skin(integer 8)
    3: /usr/local/psa/admin/plib/common_func.php3:2886
    objectMaker(string Skin, integer 8)
    4: /usr/local/psa/admin/auto_prepend/auth.php3:508

  • RELEVANCY SCORE 3.36

    DB:3.36:No Sites After Plesk Update 8.4 To 8.6 7z





    after the Plesk update NONE Domains not running....

    ALL Domains show Site Builder login page...

    If i want delete / Create /change a Domain or i only want to look in the dns setting i got:

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column serial in field list

    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string select `id`,`name`,`displayName`,`email`,`status`,`type`, `ttl`,`ttl_unit`,`refresh`,`refresh_unit`,`retry`, `retry_unit`,`expire`,`expire_unit`,`minimum`,`min imum_unit`,`serial`,`serial_format` from dns_zone where `id`=26)

    etc...

    Any help????

    DB:3.36:No Sites After Plesk Update 8.4 To 8.6 7z




    Problem solved

    Further searching brought up this useful post. The problem lies in the Plesk installer not modifying its own SQL tables. These needed to be edited manually. For those not versed in mysql, here is an annotated sequence to follow. Entries in blue are what you should enter:

    # mysql -u admin -p `cat /etc/psa/.psa.shadow` -D psa
    (Log in to mysql using Plesks stored password).

    mysql use psa
    (Select Plesks database)

    mysql describe dns_zone;
    (Check if there are rows titled serial and serial_format. If not, this should fix matters.)

    mysql ALTER TABLE `dns_zone` add `serial` VARCHAR( 12 ) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 0;
    mysql ALTER TABLE `dns_zone` add `serial_format` ENUM( UNIXTIMESTAMP, YYYYMMDDNN ) NOT NULL DEFAULT UNIXTIMESTAMP;
    (Add the appropriate rows to the dns_zone table.)

    describe dns_zone;
    Should look something like:

    Code:

  • RELEVANCY SCORE 3.35

    DB:3.35:Error: Pleskmaindbexception ss





    ERROR: PleskMainDBException (MSSQL Express reinstalled)

    Hi!
    We had reinstalled our MSSQL because it was slightly misconfigured... Now i cant log in to the Control Panel because of that error :-(
    I need to know were to set the new connectionstring for the DB, can anyone tell me this?

    thanks,
    Jens, EDV Gradl

    DB:3.35:Error: Pleskmaindbexception ss




    You can have a try with switching the plesk theme, may be only certain theme are affected someway.

  • RELEVANCY SCORE 3.35

    DB:3.35:Plesk 8.1 Problem jf





    Hello
    I use Suse 10.1 server with Plesk 8.1.
    All sites are working
    And mysql server working.
    But I can not access plesk.
    It gives that error.
    Please hepl javascript:smilie()
    confused

    ERROR: PleskMainDBException
    MySQL query failed: Lost connection to MySQL server during query

    0: /usr/local/psa/admin/plib/common_func.php3:213
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:492
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:389
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:368
    db_connect_real(string localhost, string admin, string *********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:348
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:87

    DB:3.35:Plesk 8.1 Problem jf




    Hello
    I use Suse 10.1 server with Plesk 8.1.
    All sites are working
    And mysql server working.
    But I can not access plesk.
    It gives that error.
    Please hepl javascript:smilie()
    confused

    ERROR: PleskMainDBException
    MySQL query failed: Lost connection to MySQL server during query

    0: /usr/local/psa/admin/plib/common_func.php3:213
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:492
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:389
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:368
    db_connect_real(string localhost, string admin, string *********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:348
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:87

  • RELEVANCY SCORE 3.35

    DB:3.35:Error: Pleskmaindbexception fx





    Ive searched the forums and google for a solution but Ive had trouble with this. Could anyone please help. The website works fine, everything except for email.

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.misc doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:168
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:587
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:484
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:463
    db_connect_real(string localhost, string admin, string ********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:443
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:90

    DB:3.35:Error: Pleskmaindbexception fx




    Ive searched the forums and google for a solution but Ive had trouble with this. Could anyone please help. The website works fine, everything except for email.

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.misc doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:168
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:587
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:484
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:463
    db_connect_real(string localhost, string admin, string ********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:443
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:90

  • RELEVANCY SCORE 3.34

    DB:3.34:Help! Something Wrong With Mysql And Plesk Admin f9





    I got this in my face this morning:

    -------------

    ERROR: PleskMainDBException
    MySQL query failed: Cant find file: misc.MYI (errno: 2)

    0: /opt/psa/admin/plib/common_func.php3:229
    db_query(string select param, val from misc)
    1: /opt/psa/admin/plib/common_func.php3:467
    get_param(string mysql41_compatible)
    2: /opt/psa/admin/plib/common_func.php3:364
    db_set_names()
    3: /opt/psa/admin/plib/common_func.php3:343
    db_connect_real(string localhost, string admin, string ***********, string psa)
    4: /opt/psa/admin/plib/common_func.php3:323
    db_connect()
    5: /opt/psa/admin/auto_prepend/auth.php3:85

    DB:3.34:Help! Something Wrong With Mysql And Plesk Admin f9




    Looks like your psa database is corrupt.

    Login to the server, and you can retrieve a working database from the daily backups at:

    /var/lib/psa/dumps/

    Use the mysql command line tool to clear the psa database, and import one of the backups (after you un-gzip one of them).

    Let me know if you need any more assistance in doing that.

    Regards,

    Limedrink.

  • RELEVANCY SCORE 3.34

    DB:3.34:Error: Pleskmaindbexception Db Query Failed: Unknown Error sx





    Hello,

    Im using plesk 9.5.4 when I enter the plesk url I give this error:

    ERROR: PleskMainDBException
    DB query failed: Unknown error

    0: common_func.php3:171
    db_query(string set names utf8)
    1: common_func.php3:626
    reconnect()
    2: common_func.php3:591
    db_connect()
    3: auth.php3:90

    I done this article:
    http://kb.parallels.com/en/115602
    but there is problem yet, I see administrator pass plesk and I can login to plesk mysql with same password but plesk has problem.
    I restart all services and finally reset the server but problem doesnt resolve.

    Please guide me

  • RELEVANCY SCORE 3.34

    DB:3.34:Plesk 9.5 Mysql Admin Account Password Reset dj





    I changed my password using plesksrvclient.exe and did not check the Change admin password in plesk SQL server. No when I try to log into Plesk, I get the following:



    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b Login failed for user admin.

    0: common_func.php3:601
    db_mssql_connection()
    1: common_func.php3:630
    reconnect()
    2: common_func.php3:591
    db_connect()
    3: auth.php3:90

    DB:3.34:Plesk 9.5 Mysql Admin Account Password Reset dj




    Also, the error has changed once I ran this: PleskSrvClient.exe



    ERROR: PleskMainDBException
    bSource:/b Providerbr/bDescription:/b Unspecified error

    0: common_func.php3:601
    db_mssql_connection()
    1: common_func.php3:630
    reconnect()
    2: common_func.php3:591
    db_connect()
    3: auth.php3:90

  • RELEVANCY SCORE 3.23

    DB:3.23:Error In Update... 1k





    This is the error that I get when I try to update from 8.3 - 8.4

    any ideas?

    ERROR: PleskMainDBException

    MySQL query failed: MySQL server has gone away
    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources)
    1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
    AutoInstallerVendorSource::getVendorSources()
    2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
    AutoInstallerManager-install(string PLESK_8_4_0, array, boolean false, string myemail@mydominname.com, boolean true)
    3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

    Thanks
    Matt

    DB:3.23:Error In Update... 1k




    It looks like you might be using MySQL 5 for the psa database. That could be your problem. Plesk only works with MySQL 4.

    I could be wrong, this is just a guess (cause type isnt quoted in that SQL statement).

  • RELEVANCY SCORE 3.21

    DB:3.21:Error After Updating Plesk Control Panel 9.5 9d





    After Updating Plesk Control Panel 9.5 when i try to log into Plesk i get following Errors

    ERROR: PleskMainDBException

    MySQL query failed: Table psa.lockout doesnt exist

    0: common_func.php3:206
    db_query(string delete from lockout where (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(last_wrong)) (30 * 60))
    1: cmd_loginup.php:82
    createSession(string admin, string ********)
    2: login_up.php3:22

    Whats wrong ?

    DB:3.21:Error After Updating Plesk Control Panel 9.5 9d




    Dear Mangoswiss, you solve my life. Thanks a lot



    Mangoswiss said:

  • RELEVANCY SCORE 3.21

    DB:3.21:Ms Sql Server Access Denied 7d





    I was initially having troubles with plesk adding domain names to microsoft dns, so I decided to upgrade plesk to the new 8.4 and install the BIND dns server. After restarting the system, Im now not able to pull up the control panel due to the following error:

    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    0: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:594
    db_mssql_connection()
    1: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:623
    reconnect()
    2: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:584
    db_connect()
    3: C:\Program Files (x86)\SWsoft\Plesk\admin\auto_prepend\auth.php3:79

    The service MMC shows the SQL Server as Started. Any would be greatly appreciated.

    DB:3.21:Ms Sql Server Access Denied 7d




    I was initially having troubles with plesk adding domain names to microsoft dns, so I decided to upgrade plesk to the new 8.4 and install the BIND dns server. After restarting the system, Im now not able to pull up the control panel due to the following error:

    ERROR: PleskMainDBException
    bSource:/b Microsoft OLE DB Provider for SQL Serverbr/bDescription:/b [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    0: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:594
    db_mssql_connection()
    1: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:623
    reconnect()
    2: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:584
    db_connect()
    3: C:\Program Files (x86)\SWsoft\Plesk\admin\auto_prepend\auth.php3:79

    The service MMC shows the SQL Server as Started. Any would be greatly appreciated.

  • RELEVANCY SCORE 3.20

    DB:3.20:Plesk Control Panel Errors Plesk 8 11





    Error when updating plesk 7.5.4 to 8.0

    I try to update my Plesk to new version 8, from my Control Panel and present/display the following error in the panel, please to help to repair this problem thank you very much me.

    THANKS,

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.DashboardPreset doesnt exist

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Table psa.DashboardPreset doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:230
    db_query(string replace DashboardPreset set `id`=0, `name`=1, `type`=custom, `uri`=/plesk/dashboard/)
    1: /usr/local/psa/admin/plib/class.Table.php:324
    Table- update(array)
    2: /usr/local/psa/admin/plib/class.cObject.php:330
    cObject- update()
    3: /usr/local/psa/admin/plib/dashboard/DashboardPreset.php:185
    DashboardPreset- update()
    4: /usr/local/psa/admin/plib/user/User.php:335
    User- addDashboardRecent(object of type UIPointer)
    5: /usr/local/psa/admin/plib/class.Form.php:477
    Form- FastPrint()
    6: /usr/local/psa/admin/htdocs/server/server.php3:187 ERROR: PleskMainDBException

    DB:3.20:Plesk Control Panel Errors Plesk 8 11




    How to safely swtich back to 7.5.4, please advice with steps. I am in big trouble.

  • RELEVANCY SCORE 3.19

    DB:3.19:Error In Plesk Database cf





    Hello, trying cinfigurar aller databases, I equiboque and set plesk database and the database of users, ie, set the one in plesk / mysql /. The question is ue change the port from 8306 to 3306 and I was wrong then he went back to port to 8306 and it only gives me the following error:
    ERROR: PleskMainDBException
    DB query failed: Unknown error

    0: common_func.php3:114
    db_query(string set names utf8)
    1: common_func.php3:612
    reconnect()
    2: common_func.php3:577
    db_connect()
    3: auth.php3:148

    DB:3.19:Error In Plesk Database cf




    Hello, trying cinfigurar aller databases, I equiboque and set plesk database and the database of users, ie, set the one in plesk / mysql /. The question is ue change the port from 8306 to 3306 and I was wrong then he went back to port to 8306 and it only gives me the following error:
    ERROR: PleskMainDBException
    DB query failed: Unknown error

    0: common_func.php3:114
    db_query(string set names utf8)
    1: common_func.php3:612
    reconnect()
    2: common_func.php3:577
    db_connect()
    3: auth.php3:148

  • RELEVANCY SCORE 3.19

    DB:3.19:Control Panel Error 9z





    A upgrade from 8.6.0.5 to 9.0 and my control panel now show

    ERROR: PleskMainDBException
    DB query failed: Table psa.persistentcache doesnt exist

    DB:3.19:Control Panel Error 9z




    Error in UserManager?



    Ryan11433 said:

  • RELEVANCY SCORE 3.19

    DB:3.19:Mysql Error - Unknown Column Displayhost zx





    ERROR: PleskMainDBException

    MySQL query failed: Unknown column displayHost in field list

    0: /usr/local/psa/admin/plib/common_func.php3:234
    db_query(string select `id`,`dns_zone_id`,`type`,`displayHost`,`host`,`displayVal`,`val`,`opt`,`time_stamp` from dns_recs where `id`=3755)

    It seems my ps database is running but not on all cylinders. Does anyone have all the psa.tables so I can add the columns needed to get my Plesk 8.0.1 up and running.

    DB:3.19:Mysql Error - Unknown Column Displayhost zx




    Fixed by Fastservers.net

    Well I must commend fastservers.net and their support they seem to have fixed the problem. Kudos to them.

  • RELEVANCY SCORE 3.19

    DB:3.19:Mysql Query Failed: Table Psa.Misc Doesnt Exist ( Pls Help Me ) f3





    I cant login in plesk admin.

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.misc doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:211
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:490
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:387
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:366
    db_connect_real(string localhost, string admin, string **************, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:346
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:87

    Please help me ..

  • RELEVANCY SCORE 3.14

    DB:3.14:Error: Pleskmaindbexception z9





    Hello,

    I have Plesk 8.2 and i upgraded to 8.6 today. And i have the following problem now;

    ERROR: PleskMainDBException
    DB query failed: Unknown column guid in field list

    0: plib\common_func.php3:243
    db_query(string select `id`, `name`, `displayName`, `cr_date`, `status`, `dns_zone_id`, `htype`, `cl_id`, `limits_id`, `params_id`, `cert_rep_id`, `real_size`, `guid` from `domains` where `id`=52)
    1: plib\class.Table.php:189
    Table-select()
    2: plib\class.Domain.php:140
    Domain-fetchAttrsFromTable_()
    3: plib\class.Domain.php:90
    Domain-Domain(integer 52)
    4: plib\class.PhDomain.php:71
    PhDomain-PhDomain(integer 52)
    5: plib\common_func.php3:2929
    objectMaker(string PhDomain, integer 52)
    6: auto_prepend\auth.php3:278

    Please help me paralles team or anyone. I need your help immediately.
    Best regards.

    DB:3.14:Error: Pleskmaindbexception z9




    My problem solved

    Hello again,

    I saw the following link and run on my server;
    ftp://download1.swsoft.com/Plesk/Au...0/139967/Plesk_8.2_to_8.6_DatabaseUpgrade.exe

    Problem is solved. Thanks for other topic...

  • RELEVANCY SCORE 3.14

    DB:3.14:Trouble Login To Plesk Panel zp





    This is the error i get

    ERROR: PleskMainDBException
    MySQL query failed: Incorrect information in file: ./psa/misc.frm

    0: common_func.php3:168
    db_query(string select param, val from misc)
    1: common_func.php3:587
    get_param(string mysql41_compatible)
    2: common_func.php3:484
    db_set_names()
    3: common_func.php3:463
    db_connect_real(string localhost, string admin, string **********************, string psa)
    4: common_func.php3:443
    db_connect()
    5: auth.php3:90

    DB:3.14:Trouble Login To Plesk Panel zp




    trouble solved as i comment skip-innodb in my.cnf

  • RELEVANCY SCORE 3.14

    DB:3.14:Error: Pleskmaindbexception - After Restore Of Mysql Db ms





    I just backed up and re-imaged my server after I could no longer access my server through Plesk Control Panel. Once complete, I was able to access Plesk 9 correctly.

    However, I restored All databases in mySQL that I had backed up using the mysqldump --all-databases command. It appears as though I overwrote the default Plesk DB in MySQL.

    Is there a location that I can obtain the default MySQL Plesk DB so that I can restore it and fix this issue? This is the error I know receive when I try to access the Admin page of plesk.

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column c1.type in field list

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Unknown column c1.type in field list

    0: /usr/local/psa/admin/plib/common_func.php3:168
    db_query(string select c1.id, c1.type
    from (((clients c1
    inner join clients c2 on c1.parent_id=c2.id)
    inner join ip_pool p1 on c1.pool_id = p1.id)
    inner join ip_pool p2 on c2.pool_id = p2.id)
    inner join IP_Addresses ip on ip.id = p1.ip_address_id
    where p2.type=exclusive and ip.ip_address = 217.160.248.124 and p2.ip_address_id = p1.ip_address_id)
    1: /usr/local/psa/admin/plib/common_func.php3:215
    db_query_ex(string select c1.id, c1.type
    from (((clients c1
    inner join clients c2 on c1.parent_id=c2.id)
    inner join ip_pool p1 on c1.pool_id = p1.id)
    inner join ip_pool p2 on c2.pool_id = p2.id)
    inner join IP_Addresses ip on ip.id = p1.ip_address_id
    where p2.type=exclusive and ip.ip_address = ?(ip) and p2.ip_address_id = p1.ip_address_id, array)
    2: /usr/local/psa/admin/plib/elements.php3:911
    getCustomPageTitle(object of type UserNone)
    3: /usr/local/psa/admin/plib/elements.php3:884
    getPleskTitle()
    4: /usr/local/psa/admin/htdocs/login.php3:23

    DB:3.14:Error: Pleskmaindbexception - After Restore Of Mysql Db ms




    restore of mysql DB

    I am stuck with the same issue as well. Does anyone have the table structure for the missing BackendCache table?

    Thanks.

  • RELEVANCY SCORE 3.14

    DB:3.14:Pleskmaindbexception: Mysql Query Failed: Data Truncated For Column Fp At Row 1 ap





    Hi,
    We are using Plesk 8.1 and we did some mySQL performance tuning and we suspect somehow it breaks Plesk. Right now, we cannot successfully create a domain. We keep getting these errors, can someone point us to the right fix for this problem? The last time we had this error, we have to re-install the whole server, we hope we do not have to resort to that again. Thanks.

    Here is the details of the error:

    0: /usr/local/psa/admin/plib/common_func.php3:211
    db_query(string replace hosting set `dom_id`=5, `sys_user_id`=10, `ip_address_id`=2, `ssl`=true, `same_ssl`=true, `fp`=, `fp_ssl`=, `fp_enable`=, `fp_adm`=, `fp_pass`=, `ssi`=, `php`=, `php_safe_mode`=true, `cgi`=, `perl`=, `python`=, `fastcgi`=, `miva`=, `coldfusion`=, `asp`=, `asp_dot_net`=, `webstat`=none, `at_domains`=)
    1: /usr/local/psa/admin/plib/class.Table.php:328
    Table-update(array)
    2: /usr/local/psa/admin/plib/class.cObject.php:347
    cObject-update()
    3: /usr/local/psa/admin/plib/class.PHosting.php:776
    PHosting-update()
    4: /usr/local/psa/admin/plib/class.PHostingManager.php:610
    PHostingManager-update()
    5: /usr/local/psa/admin/htdocs/domains/hosting/phosting_setup.php:217

    DB:3.14:Pleskmaindbexception: Mysql Query Failed: Data Truncated For Column Fp At Row 1 ap




    It is something of the sql-mode. I had same case with a client and they have set these modes in my.cnf

    sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    I believe it is caused but the STRICT_TRANS_TABLES
    I commented that line , restarted mysql and it worked fine.

  • RELEVANCY SCORE 3.14

    DB:3.14:Mysql Query Failed Psa.Skins Doesnt Exist 1c





    I get this error in title:



    ERROR: PleskMainDBException
    MySQL query failed: Table psa.skins doesnt exist

    0: common_func.php3:220
    db_query(string select `id`,`name`,`place` from Skins where `id`=1)
    1: Table.php:154
    Table-select()
    2: Skin.php:130
    Skin-__construct(integer 1)
    3: cu.php:523
    cu-setSession()
    4: cu.php:215
    cu-cu()
    5: upgrade-complete:18
    ERROR: PleskMainDBException
    MySQL query failed: Table psa.skins doesnt exist

    0: common_func.php3:220
    db_query(string select `id`,`name`,`place` from Skins where `id`=1)
    1: Table.php:154
    Table-select()
    2: Skin.php:130
    Skin-__construct(integer 1)
    3: cu.php:523
    cu-setSession()
    4: cu.php:215
    cu-cu()
    5: fix_apsc_password:24

    DB:3.14:Mysql Query Failed Psa.Skins Doesnt Exist 1c




    Solved but a littlebit mystery....

    I restart server. Same error.
    I try to connect to mysql with no luck.
    Reset mysql password
    tell it plesk
    restart daemon of plesk
    now it works fine... But why? Only password change? I cant believe it...

  • RELEVANCY SCORE 3.14

    DB:3.14:Error: Pleskmaindbexception m9





    This is a copy of a mesage I sent to SwSoft on July 28 2007

    Hello,
    If you look at http://forum.swsoft.com/forumdisplay.php?s=forumid=183

    you will see there are issues with the update from Plesk 8.1.1 to 8.2
    I am also having problems with my update, cannot access domains or clients get error (included at the bottom of this message).
    The reason I am contacting you directly is I assume your head office is located in Washington. I dont want to talk to anybody else but the people at the top. You need to know the levels of dis-satisfaction users of Plesk, including myself are facing.
    I updated the Plesk on my server using the Updater in the Server Administration section.
    It performed the update and then all of a sudden I cannot access domains or clients. I cannot activate the spam assassin and am getting pummelled with spam messsages daily.
    This happened during the Plesk software update, so I fully expected an update to correct the issue.
    No update and no support from your support group. I was told I need to pay for the swsoft staff to fix it. So now I am looking at paying $150 /hour to get swsoft techs to fix their own bugs? That is rediculous. I am going to submit a copy of this messge to webproworld and see what others think. I will wait until I get a repy from you before I do, however, in case you agree with me and get my server fixed no charge. If you dont agree then I will submit this email to get other webmasters opinions and the instablity of Plesk software.

    Here is the error I get trying to access domains or accounts;

    ERROR: PleskMainDBException


    MySQL query failed: Unknown column uid in field list

    --------------------------------------------------------------------------------

    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`uid`,`ownership` from clients where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/class.Client.php3:74
    Client-Client(string 1)
    4: /usr/local/psa/admin/plib/common_func.php3:2867
    objectMaker(string Client, string 1)
    5: /usr/local/psa/admin/plib/class.DomainControlForm.php:268
    DomainControlForm-assign(object of type BsDomain)
    6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152

    DB:3.14:Error: Pleskmaindbexception m9




    This is a copy of a mesage I sent to SwSoft on July 28 2007

    Hello,
    If you look at http://forum.swsoft.com/forumdisplay.php?s=forumid=183

    you will see there are issues with the update from Plesk 8.1.1 to 8.2
    I am also having problems with my update, cannot access domains or clients get error (included at the bottom of this message).
    The reason I am contacting you directly is I assume your head office is located in Washington. I dont want to talk to anybody else but the people at the top. You need to know the levels of dis-satisfaction users of Plesk, including myself are facing.
    I updated the Plesk on my server using the Updater in the Server Administration section.
    It performed the update and then all of a sudden I cannot access domains or clients. I cannot activate the spam assassin and am getting pummelled with spam messsages daily.
    This happened during the Plesk software update, so I fully expected an update to correct the issue.
    No update and no support from your support group. I was told I need to pay for the swsoft staff to fix it. So now I am looking at paying $150 /hour to get swsoft techs to fix their own bugs? That is rediculous. I am going to submit a copy of this messge to webproworld and see what others think. I will wait until I get a repy from you before I do, however, in case you agree with me and get my server fixed no charge. If you dont agree then I will submit this email to get other webmasters opinions and the instablity of Plesk software.

    Here is the error I get trying to access domains or accounts;

    ERROR: PleskMainDBException


    MySQL query failed: Unknown column uid in field list

    --------------------------------------------------------------------------------

    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`uid`,`ownership` from clients where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/class.Client.php3:74
    Client-Client(string 1)
    4: /usr/local/psa/admin/plib/common_func.php3:2867
    objectMaker(string Client, string 1)
    5: /usr/local/psa/admin/plib/class.DomainControlForm.php:268
    DomainControlForm-assign(object of type BsDomain)
    6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152

  • RELEVANCY SCORE 3.11

    DB:3.11:Error: Pleskmaindbexception 8s





    In the last period I receive often the following error when i attempt to connect at the control panel web page

    ERROR: PleskMainDBException
    Unknown database psa

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:129
    ERROR: PleskMainDBException
    Unknown database psa

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:129

    DB:3.11:Error: Pleskmaindbexception 8s




    Thanks Abdi,
    but restore the database psa temporarily resolves, after some time the error recurs

  • RELEVANCY SCORE 3.11

    DB:3.11:Mayor Error ja





    Hello

    After made a update of my license key update the fallow error shows up:

    ERROR: PleskMainDBException
    No connection could be made because the target machine actively refused it.

    0: common_func.php3:619
    reconnect()
    1: common_func.php3:582
    db_connect()
    2: auth.php3:146
    ERROR: PleskMainDBException
    No connection could be made because the target machine actively refused it.

    0: common_func.php3:619
    reconnect()
    1: common_func.php3:582
    db_connect()
    2: auth.php3:146

    my webs ites are on but no the Panel when I try log in mysql or psa i cannot connect.

    please help

    DB:3.11:Mayor Error ja




    I havent need that information dude, I needed information about how Plesk interact with the database but nvm.

    thanks for nothing.

  • RELEVANCY SCORE 3.10

    DB:3.10:Im Willing To Pay To Get Help On This. k7





    One year trying to upgrade from 8.4 to 8.6 (now 9.0) with no success.

    I try to contact plesk support and I dont get any help.

    The error is :



    ERROR: PleskMainDBException
    Up LevelUp Level
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:214
    db_query(string SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources)
    1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
    AutoInstallerVendorSource::getVendorSources()
    2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
    AutoInstallerManager-install(string PLESK_8_4_0, array, boolean false, string morfin108@gmail.com, boolean true)
    3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

  • RELEVANCY SCORE 3.09

    DB:3.09:Error Upgrading From 9.2.3 To 9.3 9p





    I leave the default upgrade checkboxes checked and after a while this error shows:

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: common_func.php3:168
    db_query(string select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=6)
    1: class.Table.php:183
    Table-select()
    2: class.cObject.php:479
    cObject-fetchAttrsFromTable_()
    3: DashboardPreset.php:29
    DashboardPreset-__construct(integer 6)
    4: common_func.php3:3110
    objectMaker(string DashboardPreset, integer 6, boolean false, NULL null)
    5: common_func.php3:3119
    objectMakerEx(string DashboardPreset, integer 6)
    6: UserAdmin.php:205
    UserAdmin-getDashboardCustomPreset()
    7: Favorites.php:100
    Favorites::renderFavoritesDropDown(boolean false)
    8: class.Form.php:286
    Form-assign()
    9: AutoInstallerInstallForm.php:124
    AutoInstallerInstallForm-assignComponent(object of type AutoInstallerRelease, object of type AutoInstallerComponent, boolean true, array)
    10: AutoInstallerInstallForm.php:66
    AutoInstallerInstallForm-assign(object of type AutoInstallerRelease, array, array, array, boolean false, boolean false, string , boolean false)
    11: autoinstaller_install.php:132

  • RELEVANCY SCORE 3.09

    DB:3.09:Error: Pleskmaindbexception Mysql Query Failed: Unknown Table Engine Innodb j3





    Hi,

    Suddenly I can´t connect with my dedicated server, receive this error:

    ERROR: PleskMainDBException
    MySQL query failed: Unknown table engine InnoDB

    0: common_func.php3:206
    db_query(string select param, val from misc)
    1: common_func.php3:625
    get_param(string mysql41_compatible)
    2: common_func.php3:522
    db_set_names()
    3: common_func.php3:501
    db_connect_real(string localhost, string admin, string ***********, string psa)
    4: common_func.php3:481
    db_connect()
    5: auth.php3:90

    Linux server with Centos 5.

    Regards

  • RELEVANCY SCORE 3.09

    DB:3.09:Upgraded, Odbc Error Loading Plesk ma





    Upgrade to 7.6 from 7.5.6 seemed to work fine, except that the plesk system wont work
    https://localhost:8443 gives the following:

    ERROR: PleskMainDBException
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    0: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:608
    reconnect()
    1: C:\Program Files\SWsoft\Plesk\admin\plib\common_func.php3:590
    db_connect()
    2: C:\Program Files\SWsoft\Plesk\admin\auto_prepend\auth.php3:63

    anyone got any ideas? since the files are encrypted so i cant read the lines of code and work it out myself.

    DB:3.09:Upgraded, Odbc Error Loading Plesk ma




    managed to fix this by installing the mysql odbc driver vr 3.51.
    shouldnt plesk have done this for me?
    ah well, at least its working now (it seems)

  • RELEVANCY SCORE 3.09

    DB:3.09:Cannot Access Admin c1





    hi, I just upgraded to 10.3 and I cannot access the admin part! I get the message below once trying to access the admin part. I have done the set password as described, but no luck...

    ERROR: PleskMainDBException
    mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(your_existing_password). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

    0: common_func.php3:619
    reconnect()
    1: common_func.php3:582
    db_connect()
    2: auth.php3:146
    ERROR: PleskMainDBException
    mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(your_existing_password). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

    0: common_func.php3:619
    reconnect()
    1: common_func.php3:582
    db_connect()
    2: auth.php3:146

    DB:3.09:Cannot Access Admin c1




    Thanks, I did follow thoose instructions but I get the same error message in command prompt!

  • RELEVANCY SCORE 3.09

    DB:3.09:Database Problem, How To Rerun Setup? kk





    Hi,

    Just attempted the plesk 8 upgrade and all seems to have run but have the following problem when logging in to plesk now:

    ERROR: PleskMainDBException
    MySQL query failed: Table psa.NewsArticles doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string select id, class, data from NewsArticles where id 0 order by id)
    1: /usr/local/psa/admin/plib/news/NewsManager.php:57
    NewsManager-getArticles(integer 0)
    2: /usr/local/psa/admin/plib/news/NewsManager.php:35
    NewsManager-getNewArticles()
    3: /usr/local/psa/admin/plib/class.Form.php:330
    Form-assign()
    4: /usr/local/psa/admin/plib/dashboard/DashboardForm.php:100
    DashboardForm-assign(array, object of type UserAdmin)
    5: /usr/local/psa/admin/plib/dashboard/DashboardLocation.php:56
    DashboardLocation-access(string GET)
    6: /usr/local/psa/admin/plib/UIPointer.php:423
    UIPointer-access(string GET)
    7: /usr/local/psa/admin/htdocs/plesk.php:14

    Any help is appericated.

    DB:3.09:Database Problem, How To Rerun Setup? kk




    Need to repair the failed 7.5.4 to 8.0.0 upgrade without losing customer data or plesk config.. have tried to upgrade again but continues to come back saying nothing to upgrade (0 packages to install)

  • RELEVANCY SCORE 3.07

    DB:3.07:Mysql 5.1 And Plesk m8





    Hi, i installed php 5.1.15 (from source), mysql works fine, but plesk shows this errors:



    ERROR: PleskMainDBException
    MySQL query failed: Cant find file: misc (errno: 2)

    0: /usr/local/psa/admin/plib/common_func.php3:213
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:492
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:389
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:368
    db_connect_real(string localhost, string admin, string ********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:348
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:87

    DB:3.07:Mysql 5.1 And Plesk m8




    Hi, i installed php 5.1.15 (from source), mysql works fine, but plesk shows this errors:



    ERROR: PleskMainDBException
    MySQL query failed: Cant find file: misc (errno: 2)

    0: /usr/local/psa/admin/plib/common_func.php3:213
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:492
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:389
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:368
    db_connect_real(string localhost, string admin, string ********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:348
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:87

  • RELEVANCY SCORE 3.07

    DB:3.07:Plesk 8.6 To 9.5 Updater Problem 31





    Hi,

    Im trying to update my panel from 8.6 to 9.5. When i use the updater under serverupdater getting the error below. Any idea how can i fix the problem?



    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string select flags, sort, filter, page, page_size from ListsParams where user_id=0 and user_type=1 and parentList_id=0 and list_name=autoinstallerreleaseslist)
    1: /usr/local/psa/admin/plib/class.cList.php3:190
    cList-fetchListParams()
    2: /usr/local/psa/admin/plib/class.cList.php3:91
    cList-cList()
    3: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerReleasesList.php:24
    AutoInstallerReleasesList-AutoInstallerReleasesList(object of type AutoInstaller)
    4: /usr/local/psa/admin/plib/ui/server.autoinstaller.php:73
    plesk__server__autoinstaller-accessItem(string GET, NULL null)
    5: /usr/local/psa/admin/plib/UIPointer.php:519
    UIPointer-access(string GET)
    6: /usr/local/psa/admin/htdocs/plesk.php:19

    DB:3.07:Plesk 8.6 To 9.5 Updater Problem 31




    Hi,

    Im trying to update my panel from 8.6 to 9.5. When i use the updater under serverupdater getting the error below. Any idea how can i fix the problem?



    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:250
    db_query(string select flags, sort, filter, page, page_size from ListsParams where user_id=0 and user_type=1 and parentList_id=0 and list_name=autoinstallerreleaseslist)
    1: /usr/local/psa/admin/plib/class.cList.php3:190
    cList-fetchListParams()
    2: /usr/local/psa/admin/plib/class.cList.php3:91
    cList-cList()
    3: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerReleasesList.php:24
    AutoInstallerReleasesList-AutoInstallerReleasesList(object of type AutoInstaller)
    4: /usr/local/psa/admin/plib/ui/server.autoinstaller.php:73
    plesk__server__autoinstaller-accessItem(string GET, NULL null)
    5: /usr/local/psa/admin/plib/UIPointer.php:519
    UIPointer-access(string GET)
    6: /usr/local/psa/admin/htdocs/plesk.php:19

  • RELEVANCY SCORE 3.07

    DB:3.07:8.2 - 8.6 Upgrade Problems , Urgent Help j9





    after upgrading from plesk 8.2 to 8.6 and when click on domains this error apears :

    ERROR: PleskMainDBException
    DB query failed: Unknown column guid in field list

    0: plib\common_func.php3:243
    db_query(string select `id`, `name`, `displayName`, `cr_date`, `status`, `dns_zone_id`, `htype`, `cl_id`, `limits_id`, `params_id`, `cert_rep_id`, `real_size`, `guid` from `domains` where `id`=4)
    1: plib\class.Table.php:189
    Table-select()
    2: plib\class.Domain.php:140
    Domain-fetchAttrsFromTable_()
    3: plib\class.Domain.php:90
    Domain-Domain(integer 4)
    4: plib\class.PhDomain.php:71
    PhDomain-PhDomain(integer 4)
    5: plib\common_func.php3:2929
    objectMaker(string PhDomain, integer 4)
    6: auto_prepend\auth.php3:278

    Also webmail(Horde) does not work too.
    If anybody know solution , Please help urgent

    DB:3.07:8.2 - 8.6 Upgrade Problems , Urgent Help j9




    after upgrade to 8.6.0.1 ,there are new errors has been showed with Previous request has not completed!

    for example :

    Previous request has not completed!
    ---------------------- Debug Info -------------------------------
    0: plib\common_func.php3:1241
    plesk_exec(string D:\Program Files\SWsoft\Plesk\/admin/bin/sysinfo all, array, integer 1)
    1: plib\common_func.php3:1241
    lst_exec(string D:\Program Files\SWsoft\Plesk\/admin/bin/sysinfo all)
    2: plib\common_func.php3:1185
    util_exec(string sysinfo, array, string lst)
    3: plib\class.StatInfo.php:226
    StatInfo-_callSysInfo(string all)
    4: plib\class.StatInfo.php:240
    StatInfo-getSysInfo(string cpu)
    5: plib\class.StatInfo.php:303
    StatInfo-getCPU()
    6: plib\class.SystemStatisticsForm.php:37
    SystemStatisticsForm-assign(object of type StatInfo)
    7: htdocs\server\statistics.php3:27

    Most of plesk activities does not work , and also webmail(horde).

  • RELEVANCY SCORE 3.07

    DB:3.07:Error: Pleskmaindbexception - Urgent Help Needed! 7c





    After upgrading to 8.0.1 today, users cannot send mail, and this error appears when I try to create a new mail account. Any assistance would be greatly appreciated.

    MySQL query failed: Unknown column host in field list

    --------------------------------------------------------------------------------

    0: /usr/local/psa/admin/plib/common_func.php3:234
    db_query(string INSERT INTO exp_event (source, event_type, event_time, obj_class, obj_id, host, user, flushed) VALUES (plesk, created, NOW(), mailname, mikes2@mca2.com, 68.80.76.95, admin, false))
    1: /usr/local/psa/admin/plib/api-rpc/loger.php:295
    Log2Expand-Log2Expand(object of type ActionLog)
    2: /usr/local/psa/admin/plib/class.ActionLog.php:510
    ActionLog-submit()
    3: /usr/local/psa/admin/plib/mail/MailName.php:1046
    Mailname-update()
    4: /usr/local/psa/admin/htdocs/domains/mail/mail_name_preferences.php:87

    DB:3.07:Error: Pleskmaindbexception - Urgent Help Needed! 7c




    As a follow-up to my original post, we had numerous problems after the upgrade, such as corrupt PSA database tables, E-mail aliases not working, horde address books missing and Plesk Updater not working properly.

    So we hired the Plesk engineers to re-do the migration and for $150 (and 5 days) they got everything working properly, except for the updater which they said would be fixed in an upcoming patch.

    So, I guess its good to know that we have this option to fall back on when needed. Overall it was a fairly positive experience. The Russian engineers were responsive and stuck with it till it was fixed.

  • RELEVANCY SCORE 3.07

    DB:3.07:Error 7z





    guys wondering if you can help me ive got up today and noticed all my sites had gone down
    so i tried to log into plesk and this is what i got

    ERROR: PleskMainDBException
    MySQL query failed: Incorrect information in file: ./psa/misc.frm

    0: common_func.php3:168
    db_query(string select param, val from misc)
    1: common_func.php3:587
    get_param(string mysql41_compatible)
    2: common_func.php3:484
    db_set_names()
    3: common_func.php3:463
    db_connect_real(string localhost, string admin, string ********, string psa)
    4: common_func.php3:443
    db_connect()
    5: auth.php3:90

    i havnt got a clue what the problem is or what happend
    could some one shed some light on either how i can correct this without lossing my db or how it happend cheers

    DB:3.07:Error 7z




    Hello

    Seems misc table is corrupted. The simplest way is to restore whole Plesk database from backup:
    gunzip -dc /var/lib/psa/dumps/mysql.daily.dump.0.gz | mysql -uadmin -p`cat /etc/psa/.psa.shadow`
    Or, you can try to repair tables:
    http://www.softwareprojects.com/res...to-fix-mysql-database-myisam-innodb-1634.html

  • RELEVANCY SCORE 3.07

    DB:3.07:Error: Pleskmaindbexception - Update After Big Problem Plesk Panel :( 8x





    error code:



    MySQL query failed: Table psa.GL_settings doesnt exist

    0: common_func.php3:168
    db_query(string SELECT `value` FROM GL_settings WHERE param = enabled)
    1: common_func.php3:215
    db_query_ex(string SELECT `value` FROM GL_settings WHERE param = ?(paramName), array)
    2: GreyListManager.php:1077
    GreyListManager-_getSetting(string enabled, string false)
    3: GreyListManager.php:111
    GreyListManager-isCheckingEnabled()
    4: SpamFilter.php:1313
    SpamFilter::getGreyListingStatus()
    5: SpamFilterUIPointer.php:43
    SpamFilterUIPointer-checkGreyListing()
    6: client.domain.mail.mailname.spam-filter.php:34
    plesk__client__domain__mail__mailname__spam_filter-checkGreyListing()
    7: SpamFilterUIPointer.php:16
    SpamFilterUIPointer-validateItem(object of type UserAdmin)
    8: UIPointer.php:1123
    UIPointer-validate()
    9: elements.php3:174
    uipointer_button_desc(object of type plesk__client__domain__mail__mailname__spam_filter, NULL null, NULL null, string , array, boolean true)
    10: elements.php3:254
    uipointer_button(object of type plesk__client__domain__mail__mailname__spam_filter, NULL null, NULL null, string , array, boolean true)
    11: DashboardElement.php:1513
    DashboardElement_button-renderHtml(object of type UserDomain, NULL null)
    12: DashboardElement.php:689
    DashboardElement-renderHtml_buttons(array, object of type UserDomain, NULL null)
    13: DashboardElement.php:637
    DashboardElement-renderHtml_common(array, object of type UserDomain, NULL null)
    14: DashboardElement.php:1057
    DashboardElement_section-renderHtml(object of type UserDomain, NULL null)
    15: DashboardElement.php:640
    DashboardElement-renderHtml_common(array, object of type UserDomain, NULL null)
    16: DashboardElement.php:647
    DashboardElement-renderHtml(object of type UserDomain, NULL null)
    17: DashboardElement.php:1013
    DashboardElement_column-renderHtml(object of type UserDomain, NULL null)
    18: DashboardElement.php:654
    DashboardElement::renderHtml_columns(array, object of type UserDomain, NULL null)
    19: Dashboard.php:251
    Dashboard::renderHtml(object of type DashboardPreset, object of type UserDomain)
    20: DashboardForm.php:164
    DashboardForm-assign(object of type DashboardPreset, object of type UserDomain)
    21: DashboardLocation.php:39
    DashboardLocation-accessItem(string GET)
    22: client.domain.dashboard.php:22
    plesk__client__domain__dashboard-accessItem(string GET, NULL null)
    23: UIPointer.php:596
    UIPointer-access(string GET)
    24: plesk.php:38

    DB:3.07:Error: Pleskmaindbexception - Update After Big Problem Plesk Panel :( 8x




    problem after update

    Hi

    Ive just got the same error and its due to me (stupidly) skipping an upgrade version... going straight from 8.9 to 9.2 without stopping at 9.0 first!

    Call your provider and they will raise a ticket with Parallels. Ive been told this can be sorted by the Plesk team in 24 hours or so.

    thanks
    paul

  • RELEVANCY SCORE 2.99

    DB:2.99:Error When I Log In Into The Plesk am





    I have this error when I login at the plesk panel

    ERROR: PleskMainDBException
    MySQL query failed: Incorrect information in file: ./psa/misc.frm

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string select param, val from misc)
    1: /usr/local/psa/admin/plib/common_func.php3:515
    get_param(string mysql41_compatible)
    2: /usr/local/psa/admin/plib/common_func.php3:412
    db_set_names()
    3: /usr/local/psa/admin/plib/common_func.php3:391
    db_connect_real(string localhost, string admin, string **********, string psa)
    4: /usr/local/psa/admin/plib/common_func.php3:371
    db_connect()
    5: /usr/local/psa/admin/auto_prepend/auth.php3:84

    What can do to fix this...
    thank you very much

    DB:2.99:Error When I Log In Into The Plesk am




    I found this solution on the Net. I didnt try it but it seems a good one according to some users: (be careful anyway)
    http://kysapop.blogspot.com/2007/08/plesk-wont-start-after-tweaking-mysql.html

    Hope this helps anyone facing similar issue

  • RELEVANCY SCORE 2.99

    DB:2.99:After Upgrade 8.2 To 8.3 =Error: Pleskmaindbexception In App Vault c7





    After upgrading, I open Application Vault we got following error

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column categories in field list

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string select `id`,`name`,`version`,`release`,`description`,`categories`,`integrated`,`access_level`,`package_type`,`params_id` from SiteAppPackages where `id`=182)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/SiteApps/class.cSiteApp.php:48
    cSiteApp-cSiteApp(integer 182)
    3: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackage.php:92
    SiteAppPackage-__construct(string 182)
    4: /usr/local/psa/admin/plib/common_func.php3:2875
    objectMaker(string SiteAppPackage, string 182)
    5: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:381
    SiteAppPackageManager-registerSiteAppPackage(string Tellme-1.2-21)
    6: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:274
    SiteAppPackageManager-syncWithDatabase()
    7: /usr/local/psa/admin/htdocs/server/site_app_pkgs.php:42

    How cah we solve this.
    My Server is CentOs 4.2

    Regards,
    Kanagaraj

    DB:2.99:After Upgrade 8.2 To 8.3 =Error: Pleskmaindbexception In App Vault c7




    Make sure that you upgraded Application Vault in proper way.
    Go to Server in Plesk panel - Updater - Plek 8.3 - application vauilt.
    if you see - the version is up to dated - it is OK. In other case you should upgrade it - select item and click Install.

  • RELEVANCY SCORE 2.98

    DB:2.98:Error: Pleskmaindbexception 87





    Hi There.

    I was upgrading from earlier versions of Plesk and all was going fine until I got to the last upgrade to 8.1 .

    This is the error I get when I try to access any function with any of the domains i have hosted on my server.

    I am by no means experienced with database mgt or server mgt. so any help would be greatly appreciated.

    THanks!

    ERROR: PleskMainDBException
    Add To FavoritesAdd To Favorites
    Up LevelUp Level
    MySQL query failed: Unknown column uid in field list

    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`uid`,`ownership` from clients where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/class.Client.php3:74
    Client-Client(string 1)
    4: /usr/local/psa/admin/plib/common_func.php3:2867
    objectMaker(string Client, string 1)
    5: /usr/local/psa/admin/plib/class.DomainControlForm.php:268
    DomainControlForm-assign(object of type BsDomain)
    6: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:152

    DB:2.98:Error: Pleskmaindbexception 87




    note!
    its highly not recommended to manually change Plesk database!

  • RELEVANCY SCORE 2.96

    DB:2.96:Cannot Access My Panel... fm





    I rebooted server restarted the internet service but cannot get it fixed.

    Warning: db_query() [function.db-query]: Couldnt fetch mysqli in C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3 on line 229
    ERROR: PleskMainDBException DB query failed: Unknown error 0: plib\common_func.php3:243 db_query(string set names utf8) 1: plib\common_func.php3:649 reconnect() 2: plib\common_func.php3:614 db_connect() 3: auto_prepend\auth.php3:80

    DB:2.96:Cannot Access My Panel... fm




    I rebooted server restarted the internet service but cannot get it fixed.

    Warning: db_query() [function.db-query]: Couldnt fetch mysqli in C:\Program Files\Parallels\Plesk\admin\plib\common_func.php3 on line 229
    ERROR: PleskMainDBException DB query failed: Unknown error 0: plib\common_func.php3:243 db_query(string set names utf8) 1: plib\common_func.php3:649 reconnect() 2: plib\common_func.php3:614 db_connect() 3: auto_prepend\auth.php3:80

  • RELEVANCY SCORE 2.96

    DB:2.96:Error: Pleskmaindbexception z7





    After upgrading, when I login I have the following error:

    ERROR: PleskMainDBException


    MySQL query failed: Unknown column uid in field list

    --------------------------------------------------------------------------------

    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`uid`,`ownership` from clients where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/class.Client.php3:74
    ....

    and the release is still 8.1

    Running the updater again does not solve the problem.

    Indeas?

    DB:2.96:Error: Pleskmaindbexception z7







    Originally posted by vesterman
    Ok I tried it and now I get error 1046 : NO database selected.
    What is the database plesk uses in mysql?

    Thanks for your help on this.

    I think I guessed it, psa, used the command again and it said database changed. I will now login to plesk and check to see if the error is gone. Will post the results when I get them.

    Thank you very much phoenixisp!

    Ok now I get an error in plesk
    MySQL query failed: Unknown column ownership in field list

    Can I use the same command but change to
    mysql ALTER TABLE clients ADD ownership VARCHAR(36);

    Went ahead and did that and Horray! it works now!
    thanks again for your excellent help on my issue phoenix!

  • RELEVANCY SCORE 2.96

    DB:2.96:Plesk Panel Is Not Accessible After Update To 12 1x





    After update, my plesk panel 12 for windows is not accessable any more.
    its giving this error

    ERROR: PleskMainDBException: DB query failed: Unknown column description in field list (db.php:61)

    please help

    also
    health monitor, sql server, plesk website service not starting.

    DB:2.96:Plesk Panel Is Not Accessible After Update To 12 1x




    i follow ai.exe --console but no help. the issue remains.

  • RELEVANCY SCORE 2.96

    DB:2.96:After Update Problems .. d1





    Hi, a friend of mine did some plesk updates, and after he did that, he wasnt able to view the domains anymore ...

    ERROR: PleskMainDBException
    MySQL query failed: Unknown column guid in field list

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Unknown column guid in field list

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string select `id`,`cr_date`,`cname`,`pname`,`login`,`account_id`,`status`,`phone`,`fax`,`email`,`address`,`city`,`state`,`pcode`,`country`,`locale`,`limits_id`,`params_id`,`perm_id`,`pool_id`,`logo_id`,`tmpl_id`,`sapp_pool_id`,`guid` from clients where `id`=1)
    1: /usr/local/psa/admin/plib/class.Table.php:180
    Table-select()
    2: /usr/local/psa/admin/plib/class.cObject.php:443
    cObject-fetchAttrsFromTable_()
    3: /usr/local/psa/admin/plib/class.Client.php3:69
    Client-Client(integer 1)
    4: /usr/local/psa/admin/plib/common_func.php3:2875
    objectMaker(string Client, integer 1)
    5: /usr/local/psa/admin/plib/class.Manager.php:679
    Manager-createMainObject(integer 2)
    6: /usr/local/psa/admin/plib/class.Manager.php:126
    Manager-Manager(integer 3, integer 1)
    7: /usr/local/psa/admin/htdocs/domains/domains.php3:68

    i tried to insert manuelly the DB Update for plesk 8.3.0 but it isnt working .. i hope u can help me ..

    cYa Silent.aT

    DB:2.96:After Update Problems .. d1




    Hi, it indicates of the broken Plesk upgrade.
    Check how many psa-8.2.0* packages are installed:
    rpm -qa | grep psa-8.2.0- | grep -v locale
    Your current Plesk version:
    cat /usr/local/psa/version

    Try downloading Plesk 8.3 autoinstaller for your OS from :
    http://www.parallels.com/en/download/plesk83/
    and run it like described in the Release Notes (found on the same page, as well as here: ftp://download1.parallels.com/Plesk/Plesk8.3/
    and let it install base packages of Plesk.
    If it does not sort it out, then I guess, there is no easy solution, and it should be looked into. Otherwise, if you have Plesk backup, I suppose making a clean 8.3 install and then restoring the data is good idea.

  • RELEVANCY SCORE 2.96

    DB:2.96:Table Psa.Mass_Mail_Domains Doesnt Exist pc





    After upgrading from Plesk 8.1.0 to 8.1.1 I tried to remove a domain and got the following error:



    ERROR: PleskMainDBException

    MySQL query failed: Table psa.mass_mail_domains doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:211
    db_query(string DELETE FROM mass_mail_domains WHERE dom_id IN (33))
    1: /usr/local/psa/admin/plib/mass-mail/MassMailManager.php:118
    MassMailManager:nDomainsDelete(array)
    2: /usr/local/psa/admin/plib/class.PhDomain.php:260
    PhDomain-reset(integer 0, boolean true, boolean false)
    3: /usr/local/psa/admin/plib/class.BsDomain.php:313
    BsDomain-reset(integer 0)
    4: /usr/local/psa/admin/plib/class.BsDomain.php:307
    BsDomain-delete(integer 0)
    5: /usr/local/psa/admin/plib/class.BsDomain.php:540
    mdeleteDomains(array)
    6: /usr/local/psa/admin/plib/class.Manager.php:352
    Manager-removeDomains(array)
    7: /usr/local/psa/admin/htdocs/domains/domains.php3:209

    DB:2.96:Table Psa.Mass_Mail_Domains Doesnt Exist pc




    looks like upgrade was not full,

    and db was not upgraded properly,

    generally, you need to restore psa database from backup before upgrade and try to upgrade once more.

  • RELEVANCY SCORE 2.96

    DB:2.96:Sql Erorr 79





    Wondering if anyone has any experience with this error message. It seems to have come out of nowhere and can be seen when navigating to the login page.

    Thanks for any help.

    Warning: db_query() [function.db-query]: Couldnt fetch mysqli in C:\Program Files (x86)\Parallels\Plesk\admin\plib\common_func.php3 on line 156
    ERROR: PleskMainDBException DB query failed: Unknown error 0: common_func.php3:170 db_query(string set names utf8) 1: common_func.php3:625 reconnect() 2: common_func.php3:590 db_connect() 3: auth.php3:87

    DB:2.96:Sql Erorr 79




    Wondering if anyone has any experience with this error message. It seems to have come out of nowhere and can be seen when navigating to the login page.

    Thanks for any help.

    Warning: db_query() [function.db-query]: Couldnt fetch mysqli in C:\Program Files (x86)\Parallels\Plesk\admin\plib\common_func.php3 on line 156
    ERROR: PleskMainDBException DB query failed: Unknown error 0: common_func.php3:170 db_query(string set names utf8) 1: common_func.php3:625 reconnect() 2: common_func.php3:590 db_connect() 3: auth.php3:87

  • RELEVANCY SCORE 2.96

    DB:2.96:Error: Pleskmaindbexception c1





    Hello,

    Yesterday my server was still ok but now when I log in to Plesk, I get the following message.

    _______________________________________________________
    ERROR: PleskMainDBException
    MySQL query failed: Table psa.skins doesnt exist

    0: /usr/local/psa/admin/plib/common_func.php3:168
    db_query(string select `id`,`name`,`place` from Skins where `id`=18)
    1: /usr/local/psa/admin/plib/class.Table.php:183
    Table-select()
    2: /usr/local/psa/admin/plib/skin/Skin.php:52
    Skin-Skin(integer 18)
    3: /usr/local/psa/admin/plib/common_func.php3:3115
    objectMaker(string Skin, integer 18)
    4: /usr/local/psa/admin/auto_prepend/auth.php3:485
    _______________________________________________________

    Any idea what i can do.

    Thanks
    Georg

    DB:2.96:Error: Pleskmaindbexception c1




    Now its runing i used this :

    http://kb.odin.com/article_17_881_en.html

  • RELEVANCY SCORE 2.96

    DB:2.96:Microsoft Jet Database Engine Unrecognized Database Format Psa.Mdb s8





    When going to the Plesk login page the following error shows:

    ERROR: PleskMainDBException
    bSource:/b Microsoft JET Database Enginebr/bDescription:/b Unrecognized database format C:\Program Files\SWsoft\Plesk\admin\db\psa.mdb.

    0: plib\common_func.php3:666
    reconnect()
    1: plib\common_func.php3:614
    db_connect()
    2: auto_prepend\auth.php3:80

    Anyone seen this before?

    Thanks,
    jacko

  • RELEVANCY SCORE 2.96

    DB:2.96:Problem On Plesk Update az





    When I try to use the Plesk Updates, the following error appears:

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: common_func.php3:168
    db_query(string select `id`,`name`,`type`,`uri` from DashboardPreset where `id`=5)
    1: class.Table.php:183
    Table-select()
    2: class.cObject.php:479
    cObject-fetchAttrsFromTable_()
    3: DashboardPreset.php:29
    DashboardPreset-__construct(integer 5)
    4: common_func.php3:3110
    objectMaker(string DashboardPreset, integer 5, boolean false, NULL null)
    5: common_func.php3:3119
    objectMakerEx(string DashboardPreset, integer 5)
    6: UserAdmin.php:205
    UserAdmin-getDashboardCustomPreset()
    7: Favorites.php:100
    Favorites::renderFavoritesDropDown(boolean false)
    8: class.Form.php:286
    Form-assign()
    9: AutoInstallerInstallForm.php:124
    AutoInstallerInstallForm-assignComponent(object of type AutoInstallerRelease, object of type AutoInstallerComponent, boolean true, array)
    10: AutoInstallerInstallForm.php:66
    AutoInstallerInstallForm-assign(object of type AutoInstallerRelease, array, array, array, boolean false, boolean false, string , boolean false)
    11: autoinstaller_install.php:132

    What should I do to fix the problem?

    Thank you.

    DB:2.96:Problem On Plesk Update az




    It looks like psa database inconsistency for DashboardPreset table. Database correction is required there (DashboardPreset, DashboardPresetConfig tables) If you cant correct it by yourself, please contact support team.

  • RELEVANCY SCORE 2.94

    DB:2.94:Plesk Says Mysql Gone Away ... But It Is Working j3





    While adding new domain we get;

    ERROR: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: MySQL server has gone away

    0: /usr/local/psa/admin/plib/common_func.php3:216
    db_query(string delete from Limits where `id`=791)
    1: /usr/local/psa/admin/plib/class.Table.php:392
    Table-delete()
    2: /usr/local/psa/admin/plib/class.aListSQL.php:193
    aListSQL-deleteList()
    3: /usr/local/psa/admin/plib/class.BsDomain.php:374
    BsDomain-update()
    4: /usr/local/psa/admin/htdocs/domains/create_domain.php:164

    MySQL Status is OK and Working

    re-trying the same action works

    anybody has a similar issue?

    knocx

    DB:2.94:Plesk Says Mysql Gone Away ... But It Is Working j3




    http://forum.swsoft.com/showthread.php?p=187807highlight=mysql#post187807

  • RELEVANCY SCORE 2.93

    DB:2.93:Logging Into Plesk: Error: Pleskmaindbexception kk





    Ive just come across this error, and unable to find the issue. Could someone advise.

    I have followed this guide however no luck! http://kb.parallels.com/en/115602

    HTML:

    DB:2.93:Logging Into Plesk: Error: Pleskmaindbexception kk




    I have partially fixed this issue, but require further help.

    It looks like a change was made to the firewall settings (I think this was done by .net microsoft patch)

    I have manually added mysql-nt to the firewall ruleset, and this has allowed MySql to talk to the application. (Wordpress websites are now working)
    However
    I still get the same error when i try to log in to the control panel.
    ERROR: PleskMainDBException
    MySQL server has gone away

    0: common_func.php3:637
    reconnect()
    1: common_func.php3:600
    db_connect()
    2: auth.php3:134

    Is there a list of firewall rules that need to be in place to allow Plesk to work?

  • RELEVANCY SCORE 2.93

    DB:2.93:Can Anyone Help?? Error: Pleskmaindbexception zf





    Hi all,

    Have recently updated mysql to version:
    Server version: 5.2.0-falcon-alpha

    And now I cant login to plesk? Any ways around this?

    Thanks

    Johnny

    MySQL 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 release) = AdvancedPoll-2.03-14 at line 1

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string SELECT id FROM SiteAppPackages WHERE CONCAT(name, -, version, -, release) = AdvancedPoll-2.03-14)
    1: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:281
    SiteAppPackageManager::getSiteAppPackageId(string AdvancedPoll-2.03-14)
    2: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:246
    SiteAppPackageManager-syncWithDatabase()
    3: /usr/local/psa/admin/htdocs/license.php3:27

    DB:2.93:Can Anyone Help?? Error: Pleskmaindbexception zf




    Hi all,

    Have recently updated mysql to version:
    Server version: 5.2.0-falcon-alpha

    And now I cant login to plesk? Any ways around this?

    Thanks

    Johnny

    MySQL 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 release) = AdvancedPoll-2.03-14 at line 1

    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string SELECT id FROM SiteAppPackages WHERE CONCAT(name, -, version, -, release) = AdvancedPoll-2.03-14)
    1: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:281
    SiteAppPackageManager::getSiteAppPackageId(string AdvancedPoll-2.03-14)
    2: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:246
    SiteAppPackageManager-syncWithDatabase()
    3: /usr/local/psa/admin/htdocs/license.php3:27

  • RELEVANCY SCORE 2.93

    DB:2.93:Error: Pleskmaindbexception pz





    Apparently Plesks database has been corrupted due to a bad-parsed my.cnf file during a reboot, at least 10 tables appear to have the Incorrect information problem. I tried a variety of things in the SSH I found online to repair the MySQL, but unfortunately nothing has happened.

    Service mysqld is running

    Code:

    DB:2.93:Error: Pleskmaindbexception pz




    Apparently Plesks database has been corrupted due to a bad-parsed my.cnf file during a reboot, at least 10 tables appear to have the Incorrect information problem. I tried a variety of things in the SSH I found online to repair the MySQL, but unfortunately nothing has happened.

    Service mysqld is running

    Code:

  • RELEVANCY SCORE 2.93

    DB:2.93:Error: Pleskmaindbexception a9





    I updated my plesk version to 10x, but the panel is in error.

    ERROR: PleskMainDBException
    mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(your_existing_password). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

    0: common_func.php3:630
    reconnect()
    1: common_func.php3:593
    db_connect()
    2: auth.php3:129
    ERROR: PleskMainDBException
    mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(your_existing_password). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

    0: common_func.php3:630
    reconnect()
    1: common_func.php3:593
    db_connect()
    2: auth.php3:129