Hi Guys,

i need a nice, easy little forum and this seemed ideal :)
However y cmurrent host is running mysql 4.0.17 and php 4.4.9 (Hosting company called netearth one) and they say that this is the most up to date versions available to my hosting, so upgrading this appears to not be an option.

I uploaded the folder extracted from the download zip, I have created the database, changed chmod on the files recommended on the readme, then ran the script, i then get a big list of errors as the install script attempts to run -

# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'CURRENT_TIMESTAMP, last_reply timestamp NOT NULL default '0000-)
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'CURRENT_TIMESTAMP, last_logout timestamp NOT NULL default '0000)
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'CURRENT_TIMESTAMP, ip varchar(255) NOT NULL default '', logins )
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)
# SQL error (MySQL: 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 'COLLATE=utf8_general_ci' at line 1)

Obviously this all points to a deficiency in the version of mysql on the server, but could some kind soul point me in the direction as to how i resolve the above, as google has returned very little and i have only found 2 posts with the same (initial) error message.

thanks
Peter.