On Fri, Sep 09, 2011 at 10:28:29AM -0500, Raymond Norton wrote: > I am getting the following error when attempting to create the database:
It appears you're using one of the packaged versions of RT? You also didn't include an RT version or a mysql version. You may get more information out of RT by setting Set($LogToScreen, 'debug') in your RT_SiteConfig.pm -kevin > > sudo /usr/sbin/rt-setup-database --action init --dba root > --prompt-for-dba-password > In order to create or update your RT database, this script needs to > connect to your mysql instance on localhost as root > Please specify that user's database password below. If the user has > no database > password, just press return. > > Password: > Working with: > Type: mysql > Host: localhost > Name: > User: rtuser > DBA: root > Now creating a mysql database for RT. > Couldn't finish 'create' step. > > ERROR: 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 '' at line 1
pgpeUTD5h45fh.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011