The script is written for MySQL version 4 or below.
It can run on MySQL 5, however you will need to turn of SQL strict mode.
Open your MySQL my.ini file and locate the following line:
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
And change to:
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Save the file and restart MySQL.