New Install v. You have an error in your SQL syntax

New Install v. You have an error in your SQL syntax

by Jared Lelos -
Number of replies: 0

Hi I have just done a clean install of version 1.9 beta 3 but after all the setup stuff finishes I get this:

"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 'ORDER BY pos' at line 3."

I can get to some pages if type in the address completely but most of the site is completely unreachable. I tried the Moodle Unit Test and everything that comes up is a fail until it gets to: "Could not create all the test tables!"

What is this and how can I fix it? I've tried deleting all the folders and SQL database and reinstalling from scratch but with the same result

I'm running this on a hosted site which is running:

PHP: 5.2.0

MYSQL: 4.1.22

Thanks a lot

Jared

Average of ratings: -