Iam getting the following error at the last stage before I proceed to create tables … any suggestions on what i should do to resolve this ?
DB Error: syntax error
SET table_type=innodb [nativecode=1064 ** You have an error in your SQL syntax near 'table_type=innodb' at line 1]
Regards
Your version of MySQL is too low (3.23.x). You need to upgrade to MySQL v4.0.
You need Innodb table support in whatever version of mysql you're using to use Matrix.
or he simple dont have all rights to the sql base… i had the same problem myself… 
This isn't quite accurate - I'm using mysql 3.23.58 with Inno DB support which is listed as supported, however I'm getting the same error.
Is there a way to generate the sql manually, or is there a .sql file that I can just run? I'm happy to do that and debug it…
(guessing that the syntax is mysql 4.x compliant and doesn't work for 3.23.x?)
Thanks,
Chris
That’s correct – you can use the CLI-based install method as detailed in this thread to manually install Matrix.
The web-based installer will be updated to handle MySQL v3 with InnoDB support soon.
Hi Avi,
The CLI installer has the same issue. Do you have a .sql file I can run to create all the tables manually? At least then I can tweak the syntax myself and let you know what I find.
Cheers,
Chris
Partly in response to Faredge’s post in the CLI thread as well to as this thread:
The “SET table_type=innodb” statement that we use was only added to MySQL in version 4.0.3. It is used in both the CLI and the Web Based Installer (as their code base is essentially the same), which explains why you are getting the same error in both cases.
A fix is being worked on that will allow MySQL < 4.0.3 (including 3.23.58+) to work properly; it probably will not appear for the CLI installer until RC2 is released, however it should appear in an updated web based installer shortly.
And just a note that we can't just provide .sql files, as the installer has to create all the system assets as well. These are created as part of Step 16 in the web-based installer.
Okay, the patch has been been picked up in the last nightly build and is now available in the download of the Web Based Installer (I have also manually updated the .ZIP version so it’s in both downloads).
Try that and let us know how that goes.