[rt-users] SQL syntax error when creating database

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110909/6d963692/attachment.sig>