Invalid SQL schema. Get help from Developers

mikenchi

Hi, I am installing osTicket v1.6 RC4 today and got an error during initial configuration.

Apache version 2.2.9

PHP version 5.2.6

MySQL version 4.1.22-standard

Architecture x86_64 Linux

I had done this earlier and was successful, using my master db account that had all privs. It was working fine, all functions seemed to be fully functional, I could change configs/save things etc all successfully. I wanted to start over using a less priv'd account so I deleted everything and started over using a lesser db acct, created for this purpose, with perms to CREATE, DROP and ALTER tables as described in the installation doc. Then when I saw the error I modified setup/index.php to show detailed errors.

At the top of the page, I get 'Invalid SQL schema. Get help from Developers', and in the Database section I get:

You have an error in your SQL syntax INSERT INTO ost_config SET isonline=1, updated=NOW()

So, I gave useraccount_osadmin INSERT privs, and setup was successful. Maybe the documentation should be updated with this info?

mikenchi

Then, Fatal Error: Contact site admin.

I then get this error when trying to log in for the first time. As others have noted, giving the db account full privs seems to fix the issue. Is it safe to give the DB account full privs? I usually prefer to give least amount of privs that are needed in any given situation, but here I'm not sure of the risks involved with giving all privs to this db account.

clayton

I'm receiving this error message also. I'd rather not grant extra privileges if it's not needed.

crueldog

I have the same, help!

You have an error in your SQL syntax CREATE TABLE `ost_api_key` ( `id` int(10) unsigned NOT NULL auto_increment, `isactive` tinyint(1) NOT NULL default \'1\', `ipaddr` varchar(16) NOT NULL, `apikey` varchar(255) NOT NULL, `updated` datetime NOT NULL default \'0000-00-00 00\', `created` datetime NOT NULL default \'0000-00-00 00\', PRIMARY KEY (`id`), UNIQUE KEY `ipaddr` (`ipaddr`) ) ENGINE=MyISAM