[Swedie]

Originally Posted by cdoyle

I'm trying to install it, and when I run the insert.sql this is the error I get


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL



Does anyone know what I"m doing wrong?

The insert should look like this:

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
`name` varchar(100) default '',
`description` varchar(255) default '',
`text` text,
`lastupdate` varchar(20) default '',
`bordersize` smallint(6) NOT NULL default '5',
`bordercolor` varchar(10) NOT NULL default '#EDF0FF',
`bgcolor` varchar(10) default '#FFFFFF',
`fontface` varchar(100) NOT NULL default 'Arial, Helvetica',
`fontcolor` varchar(10) NOT NULL default '#000000',
`fontsize` char(3) NOT NULL default '2',
`vbcodeorhtml` varchar(10) NOT NULL default 'vbcode',
`usesmilies` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

What are you running this SQL command through? I hope it is not the vBulletin area.