Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Fantastico not working - cpanel logs show mysql error

Discussion in 'General Discussion' started by ksingh, Feb 22, 2007.

  1. ksingh

    ksingh Active Member

    Joined:
    Mar 21, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    156
    Hello,

    I have
    CPanel version 10.9.0-C136
    WHM 10.8.0
    MySQL 4.1.21

    When any user clicks on fantastico link through his cpanel, firefox prompts with downloading of index.php file.

    To diagnose this matter I re-installed fantastico and also ran /scripts/fixcommonproblems. To check whether it was a PHP issue, I put a test.php file in fantastico folder and it worked as expected.

    Eventually when I looked into /usr/local/cpanel/logs/error_log. There I found

    DBD::mysql::db do 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 'CREATE_TMP_TABLE, INDEX, ALTER, SELECT, LOCK_TABLES, INSERT ON `user_osc1`.* TO ' at line 1 at /usr/local/cpanel/Cpanel/Mysql.pm line 938.

    Upon further diagnosing I found it was executing this mysql statement

    GRANT CREATE, DROP, REFERENCES, UPDATE, DELETE, CREATE_TMP_TABLE, INDEX, ALTER, SELECT, LOCK_TABLES, INSERT ON `user\_osc1`.* TO 'user_osc1'@'192.168.1.%'

    Above statement I think is valid for MySQL 5 version. Could this be source of problem?

    Any help is appreciated.

    K Singh
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,470
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    You need to get support for Fantastico from the developers over at www.netenberg.com
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice