Invalid SQL schema

[simonknight]

Hi Guys,

Its taken me a week to get this far but i have come across the next problem. Im using

MYSQL 6.0.3
PHP 5.0.51a
osticket 1.6.rc3

After clicking install im seeing "You have an error in your SQL syntax"

Any Ideas?

Simon.

[trancer01]

I'm getting the same error
using
SQL 5.0.51a
PHP 5.2.5
OST RC3
and Windows Server 2003 (finally got everything working well together)
Tried the suggestions in the other threads, editing the error line in the index.php, modifying the osticket.php (%table_prefix%)
and I'm still getting this error.

I've pre-created the database (ost) created a table (ost_config) but I don't know what columns to add to it.

any ideas?
thanks

[simonknight]

modifying the osticket.php (%table_prefix%)
Have you got the link to this thread? havent seen this one, every other but this!

[trancer01]

http://osticket.com/forums/showthread.php?t=100
about half way down

Ok... weird... You can add the tables into your database manually

First, make a blank database (named something like 'osticket') if you haven't already.

Next you will need to modify the osticket.sql file....
Find the './setup/osticket.sql' file on the server, and open it in wordpad.
Find and replace anywhere where it reads '%TABLE_PREFIX%' with the desired table prefix. (default is 'ost_')

Finally, import the modified file using the PHPMyAdmin interface into your new database.

Edit: After adding the tables, you may also want to check your ./config.php file to make sure it is pointing to your mysql server correctly:

#Mysql Login info
define('DBTYPE','mysql');
define('DBHOST','youhostserver');
define('DBNAME','osticket');
define('DBUSER','username');
define('DBPASS','password');
#Table prefix
define('TABLE_PREFIX','ost_');

[trancer01]

But remember, I said I'm still having the same issue.
but if it works for you....let me know

[trancer01]

does anyone have any idea about this? We really need to get this working. I deleted the database, recreated it, set the user, and tried to create a table but it needs a row....what should I put in there?

[4ice]

does anyone have any idea about this? We really need to get this working. I deleted the database, recreated it, set the user, and tried to create a table but it needs a row....what should I put in there?

You already said that you've tried suggestions from other threads, but did you see this one as well:
http://www.osticket.com/forums/showthread.php?t=199

Perhaps this will do the trick.

[trancer01]

thanks 4ice, I actually found another thread that helped
http://www.osticket.com/forums/showthread.php?p=1365
and then I had the issue where my admin account didn't work so I used Dackr's advice here
http://www.osticket.com/forums/showthread.php?t=100&page=2

thanks

simonknight, these should both work for you!