Results 1 to 3 of 3
  1. #1

    Cpanel/Fantastico Drupal 7 issue

    Does anybody face issues with installing Drupal 7 from Cpanel fantastico. I have installed it and everything went fine but when I access the drupal site it showing the following error:

    Error message
    PDOException: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'TRADITIONAL' in lock_may_be_available() (line 165 of /public_html/domain/includes/

    The server is Cent OS 4.9 (Final), with default installation of apache and mysql.

    <<signatures to be set up in your profile>>
    Last edited by bear; 10-26-2011 at 08:08 AM.

  2. #2
    It's mysql issue which is already posted on drupal official site.

  3. #3
    Thanks for the response, Managed to fix it with the patch mentioned .

    (includes/database/mysql/ Line: 65

    New file
    < $this->exec("SET sql_mode='ANSI,ONLY_FULL_GROUP_BY'");
    Old file
    > $this->exec("SET sql_mode='ANSI,TRADITIONAL'");

    <<signatures to be set up in your profile>>
    Last edited by bear; 10-26-2011 at 08:08 AM.

Similar Threads

  1. Drupal PHP 5.3.2 Drigg issue
    By Arena Hosts in forum Programming Discussion
    Replies: 10
    Last Post: 05-17-2010, 06:08 PM
  2. my shared hosting modsecurity issue and drupal
    By fivefive in forum Web Hosting
    Replies: 5
    Last Post: 09-29-2009, 07:21 AM
  3. got a drupal issue.....
    By Flumps in forum Web Design and Content
    Replies: 5
    Last Post: 08-15-2009, 06:25 AM
  4. Replies: 0
    Last Post: 08-06-2009, 11:47 AM
  5. cPanel: Fantastico Issue
    By PyroPixel in forum Hosting Software and Control Panels
    Replies: 9
    Last Post: 10-24-2004, 06:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts