Installation Help

carlday

When I try and install I get this error Invalid SQL schema. Get help from Developers.

Any ideas how to fix it. I have download the latest version.

Thanks

Carl

xrat

Please quote the exact error message including the trailing parts.

carlday

The message appears at the top of the page on a pink background.

Invalid SQL schema. Get help from Developers.

Thats all thats there.

Carl

Kelli

is osTicket installed on a Windows server, by chance?

Turn on error reporting and then see what that gives you.

In in /main.inc.php:

#Don't display errors

ini_set('display_errors',0);

ini_set('display_startup_errors',0);

Change this to

error_reporting(E_ALL);

ini_set('display_errors',1);

ini_set('display_startup_errors',1);

carlday

I have turned error reporting on and i still get the same there is no more information. My domain was hosted on a windows server but because i was unsure if osticket would work on a mssql database I moved it to linux. Will os ticket work on mssql or not at the moment I have a windows hosting package doing nothing if osticket will work on windows I will move it back.

Carl

Kelli

It will work on Windows, but only with MySQL.

It sounds like your schema file, located in setup/inc/osticket-rc5.sql is either corrupt or incompatible with your version of mysql.