Deiwos
June 27th, 2010, 12:57 PM
Hi,
A few days ago I installed Ubuntu Server 9.04 onto my pc because for some reason, PHP and SQL hate eachother on windows and I got fed up.
Everything was working fine until it got to installing the DB's into SQL. SQL won't process the queries due to some syntax problem, but I know for a fact that there isn't anything wrong with the queries because it imported fine with Windows...
Currently Running: SQL Server 5.0
Error: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COL' at line 8I have tried re-installing SQL server and making small changes to the script, but I don't have any idea what the error report is suggesting I do.
I also cannot connect to the SQL server from any of the other computers on my network, but that is a problem for a different post.
I need to know why the queries wont process, and what to do to fix it.
Thanks in Advance
A few days ago I installed Ubuntu Server 9.04 onto my pc because for some reason, PHP and SQL hate eachother on windows and I got fed up.
Everything was working fine until it got to installing the DB's into SQL. SQL won't process the queries due to some syntax problem, but I know for a fact that there isn't anything wrong with the queries because it imported fine with Windows...
Currently Running: SQL Server 5.0
Error: 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COL' at line 8I have tried re-installing SQL server and making small changes to the script, but I don't have any idea what the error report is suggesting I do.
I also cannot connect to the SQL server from any of the other computers on my network, but that is a problem for a different post.
I need to know why the queries wont process, and what to do to fix it.
Thanks in Advance