Error creating tables

[Penehoff]

I working with some older php coding which was meant for earlier versions of MySQL but I have found anyone yet to help me pin point the errors. The error I am getting is :

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

Trying to integrate flash chat into php fusion 7.02

[Penehoff]

@Penehoff

I working with some older php coding which was meant for earlier versions of MySQL but I have found anyone yet to help me pin point the errors. The error I am getting is :

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

Trying to integrate flash chat into php fusion 7.02

---

mysqlDefault.zip (730 Bytes)

mysqlMyISAM.zip (715 Bytes)

[GavinSD1]

Hi, just looking at the mysqlDefault in your messages table you have placed txt as varcher instead of varchar. Just thought i’d let you know.