xoops database restore dump ERROR 1064 (42000) at line 811:

error code

ERROR 1064 (42000) at line 811: 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 'join (instanceid,visible,weight)
) TYPE=MyISAM' at line 11

解決方法

join包起來即可
PRIMARY KEY (instanceid),
KEY `join` (instanceid,visible,weight)

參考網址

http://sunrise-msn.spaces.live.com/Blog/cns!487A9984929026B7!220.entry