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

plesk - mysql - table issue

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by cpartassides, Sep 17, 2011.

  1. cpartassides

    cpartassides New Pleskian

    22
    73%
    Joined:
    Jul 3, 2008
    Messages:
    18
    Likes Received:
    0
    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' doesn't 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 ?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    There a lot of system tables with uppercase names in psa database and I think it is not good idea to do something with LOWER_CASE_TABLE_NAMES option.

     
  3. cpartassides

    cpartassides New Pleskian

    22
    73%
    Joined:
    Jul 3, 2008
    Messages:
    18
    Likes Received:
    0
    I always thought that plesk panel uses its own http server and db for some reason .

    Switching from windows to linux did seem as easy as i thought !!!

    C.
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Yes, Plesk admin's interface uses own sw-cp-server (modified lighttpd) and own psa database. But when you modify /etc/my.cnf file it affects all databases on MySQL server - system Plesk databases and customer databases.
     
  5. cpartassides

    cpartassides New Pleskian

    22
    73%
    Joined:
    Jul 3, 2008
    Messages:
    18
    Likes Received:
    0
    Is it possible to force plesk to read a different version of my.cnf ?

    C.
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    I think that it is impossible.
     
Loading...