CREATE TABLEn | Peter's Sports League Standings | Forum
Back to the sports standings script page
Log In
Home
Topic RSS
9:16 pm
hi,
I getting a error when I try to insert the satndingssql.sql, I am trying to do it by copy and paste the code on my mysql but when I try I get the error
"ERROR 1064: 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_unicode_ci' NOT NULL default '',
would you please help me?
1:43 am
Offline
Hi, this was an oversight on my part. Open standingssql.sql and do a “find and replace” operation to remove all instances of “collate utf8_unicode_ci” (or download this file for version 1.3 only). That line is trying to use a character set that your database isn’t configured for. I will remove all such instances in the future to make the script more compatible.
