Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Error need help with

Asked Modified Viewed 739 times
P
Penehoff
P
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 5 threads in the forums
  • Started this discussions
asked
Newbie

Old php .. flashchat php integration into php fusion 7.02 .. getting this error

Could not create DB table 'fusmh_fc_bans'
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 '(14) NOT NULL, userid int(11) default NULL, banneduserid int(11) default NULL, r' at line 1

I know it has something to do with the new mysql updates from the old mysql .. i believe this is the code thats erroring out :

CREATE TABLE bans (
id int(11) NOT NULL auto_increment,
created timestamp(14) NOT NULL,
userid int(11) default NULL,
banneduserid int(11) default NULL,
roomid int(11) default NULL,
ip varchar(16) default NULL,
KEY id (id),
KEY userid (userid),
KEY created (created)
) TYPE=MyISAM;
0 replies

1 post

D
douwe_yntema
D
  • Senior Member, joined since
  • Contributed 667 posts on the community forums.
  • Started 57 threads in the forums
  • Answered 1 question
answered
Senior Member

Replace TYPE=MyISAM with ENGINE=MyISAM for all tables is the in fusion.php file

And infuse again
0 replies

Category Forum

General Discussion

Labels

None yet

Statistics

  • Views 0 views
  • Posts 1 post
  • Votes 0 votes
  • Topic users 2 members

2 participants

D
D
  • Senior Member, joined since
  • Contributed 667 posts on the community forums.
  • Started 57 threads in the forums
  • Answered 1 question
P
P
  • Newbie, joined since
  • Contributed 7 posts on the community forums.
  • Started 5 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet