Hello. I am excited about emplimenting this ticket solution for our site, however I am having some issues.
We are hosted remotely, and the database server is seperate from our website server. I set up the MySql database on the remote database server and pointed the install to that server, it looks like it connects just fine, but then it stops and tells me it can't find the 'create.sql' and 'upgrade.sql' files.
I ftp into the server and can see the files there, but cannot browse to them (probably because the .sql extension). If I change the extension then they show up in my browser so I know they are there, but it just won't find them.
I thought maybe it was a permissions issue, so I just 777'd the whole install folder and I still get the same problem.
I also tried absolute paths to the files and still fot the same error.
--------------------------------------
Install
Step 2:
Database connection established...
Found database...
Innitialising database...
Error: Cannot locate 'create.sql'.
Error: Cannot locate 'upgrade.sql'
--------------------------------------
Database Server is DBSERVER.HOSTINGCOMPANY.COM
My Site is hosted on a seperate server than where the database is located. I don't know if this is an issue or not, but I wanted to make sure that was clear. Both servers are hosted off site and the database server is different than my website server.
I believe we are on an IIS server.
Any suggestions?