Re: Error when trying to create a group
I do think we’ve zeroed in on the problem. In phpMyAdmin, this (which resembles the syntax that BP is creating) results in the syntax error that follows:
CREATE TABLE testme (
field1 int(11) ,
field2 varchar(100) NOT NULL
) DEFAULT CHARACTER SET utf8
#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 ‘DEFAULT CHARACTER SET utf8’ at line 4
The following works, however (removing the word “DEFAULT” from the last line):
CREATE TABLE testme (
field1 int(11) ,
field2 varchar(100) NOT NULL
) CHARACTER SET utf8
If I type in “DEFAULT CHARACTER SET utf8” or “DEFAULT CHARACTER SET latin1” or anything with the word “DEFAULT,” I get the syntax error. I’m running MySQL 5.0.32 and PHP 4.4.9
As a temporary workaround, what if I simply nuked the word “DEFAULT” from the code for now? Reckless?
