View Full Version : Database
gmonnet
12-14-2007, 03:36 PM
Hi!
OsTicket is compatible with MySQL 5 ?
because he does not want to install...
Thanks...
peter
12-14-2007, 04:14 PM
It should be. What kind of errors are you getting?
gmonnet
12-14-2007, 04:50 PM
Here the error:
Erreur
requête SQL:
DROP TABLE IF EXISTS % TABLE_PREFIX % config;
MySQL a répondu:
#1064 - 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 '%TABLE_PREFIX%config' at line 1
peter
12-15-2007, 01:53 AM
You shouldn't be getting such errors if you are using the installer. The current SQL schema file is only meant to be used by the installer.
gmonnet
12-15-2007, 01:46 PM
I don't have error with the installer.
But I install with the installer, it said me OK.
And when I click on the link for terminate the install to acced on the admin section, I have the message "change your password..." and I have an error on the page and the link change password don't work...
Sorry for my English but I'm French...
Thanks for your help..
Nice day
peter
12-15-2007, 01:56 PM
PM me your info and I will help.
ojobello
01-04-2008, 06:26 PM
Hi,
After setup, I get blank admin page. Then I enabled the error display in main.inc.php as adviced. The error (see below) is same as was reported in some previous threads. Please advice how to fix this problem and proceed. I have spent at least 10hrs each day over the last 4days and still can't resolve this.
====start of error message====
Warning: main(): open_basedir restriction in effect. File(/usr/share/pear/PEAR.php) is not within the allowed path(s): (/home/httpd/vhosts/vangage.net/httpdocs:/tmp) in /home/httpd/vhosts/vangage.net/httpdocs/support/include/pear/Mail/mimeDecode.php on line 65
Warning: main(PEAR.php): failed to open stream: Operation not permitted in /home/httpd/vhosts/vangage.net/httpdocs/support/include/pear/Mail/mimeDecode.php on line 65
Fatal error: main(): Failed opening required 'PEAR.php' (include_path='.:/usr/share/pear:/home/httpd/vhosts/vangage.net/httpdocs/support/include/:/home/httpd/vhosts/vangage.net/httpdocs/support/include/pear/') in /home/httpd/vhosts/vangage.net/httpdocs/support/include/pear/Mail/mimeDecode.php on line 65
====end of error message====
Your help will be appreciated.
Rgds
Dare
See:
http://www.osticket.com/forums/showpost.php?p=502&postcount=13