Help With W5c Topsite Script

**rukiya** · 25.03.08, 18:32

friends i have following error with my sql tables, whenever i create tables in sql database i get following error:
Error
SQL query:

--
-- Dumping data for table `sites`
--
-- --------------------------------------------------------
--
-- Table structure for table `tusers`
--
CREATE TABLE `tusers` (

`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 30 ) NOT NULL default '',
`pass` varchar( 60 ) NOT NULL default '',
`admin` int( 5 ) NOT NULL default '0',
`banned` int( 5 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` )

MySQL said:

#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 '' at line 8

==================================
and my sql table is as following:
CREATE TABLE `cats` (
`id` int(10) NOT NULL auto_increment,
`name
fb5
` varchar(30) NOT NULL default '',
`dscr` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ;

--
-- Dumping data for table `cats`
--
-- --------------------------------------------------------

--
-- Table structure for table `misc`
--

CREATE TABLE `misc` (
`id` int(10) NOT NULL auto_increment,
`dscr` varchar(200) NOT NULL default '',
`text` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) ;

--
-- Dumping data for table `misc`
--

INSERT INTO `misc` VALUES (1, 'CLR', '2006-04-01');

-- --------------------------------------------------------

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
`id` int(10) NOT NULL auto_increment,
`sitename` varchar(30) NOT NULL default '',
`cid` int(10) NOT NULL default '0',
`sitelink` varchar(200) NOT NULL default '',
`slogo` varchar(200) NOT NULL default '',
`uid` int(10) NOT NULL default '0',
`hin` int(10) NOT NULL default '0',
`hout` int(10) NOT NULL default '0',
`dhits` int(10) NOT NULL default '0',
`thits` int(12) NOT NULL default '0',
`banned` int(5) NOT NULL default '0',
`dscr` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `sitelink` (`sitelink`)
) ;

--
-- Dumping data for table `sites`
--
-- --------------------------------------------------------

--
-- Table structure for table `tusers`
--

CREATE TABLE `tusers` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pass` varchar(60) NOT NULL default '',
`admin` int(5) NOT NULL default '0',
`banned` int(5) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
I am hosting my site with www.freetzi.com...
please help me solve this problem, also this sql tables is of topsite script of w5c, download following attachment to see script....

what change i will have to make please tell....[/b]

Code:

CREATE TABLE `tusers` (

`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 30 ) NOT NULL default &#39;&#39;,
`pass` varchar( 60 ) NOT NULL default &#39;&#39;,
`admin` int( 5 ) NOT NULL default &#39;0&#39;,
`banned` int( 5 ) NOT NULL default &#39;0&#39;,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `name` ( `name` ) );

put ); when u r missing to copy it

Help With W5c Topsite Script

Help With W5c Topsite Script

Comment