Environment: RedHat Linux (RHEL) 6.5
DB: MySql 5.1.71
Web Server: Apache httpd
Issue:
History: I have run this script many times, even last week and everything was working perfectly. But when I ran the script on Oct 3rd Friday, I could not get Phabrictor up and had to skip all the steps in the script and go directly to Apache httpd.
Script: http://www.phabricator.com/rsrc/install/update_phabricator.sh
+ ROOT=/app
+ cd /app/libphutil
+ git pull
Already up-to-date.
+ cd /app/arcanist
+ git pull
Already up-to-date.
+ cd /app/phabricator
+ git pull
Already up-to-date.
+ /app/phabricator/bin/phd stop
There are no running Phabricator daemons.
+ sudo /etc/init.d/httpd stop
Stopping httpd: [FAILED]
+ /app/phabricator/bin/storage upgrade
Before running storage upgrades, you should take down the Phabricator webinterface and stop any running Phabricator daemons (you can disable this warning with --force).
Are you ready to continue? [y/N] :y
Applying patch 'phabricator:db.almanac'...
[2014-10-06 10:31:33] EXCEPTION: (AphrontQueryException) #1064: 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 'binary' at line 1 at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:308]
#0 AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at <phutil>/src/aphront/storage/connection/mysql/AphrontBase
MySQLDatabaseConnection.php:275]
#1 AphrontBaseMySQLDatabaseConnection::throwQueryException(mysqli) called at <phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:181] #2 AphrontBaseMySQLDatabaseConnection::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6] #3 queryfx(AphrontMySQLiDatabaseConnection, string, string, string) called at <phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:119] #4 PhabricatorStorageManagementAPI::createDatabase(string) called at <phabricator>/src/infrastructure/storage/management/PhabricatorStorageManageme
ntAPI.php:169]
#5 PhabricatorStorageManagementAPI::applyPatch(PhabricatorStoragePatch) called at <phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementUpgradeWorkflow.php:168] #6 PhabricatorStorageManagementUpgradeWorkflow::execute(PhutilArgumentParser) called at <phutil>/src/parser/argument/PhutilArgumentParser.php:394] #7 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:290] #8 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/sql/manage_storage.php:163]
My first thought was the database connection, but I can rule that out, as I am able to bring up Phabricator an .
We have been using Phabricator for over 6 months now, and we LOVE it....