There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unclosed quote @ 124
STR: '
SQL:
CREATE TABLE `xoops_users` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`uname` varchar(25) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`user_avatar` varchar(30) NOT NULL default 'blank.gif',
`user_regdate` int(10) unsigned NOT NULL default '0',
`user_icq` varchar(15) NOT NULL default '',
`user_from` varchar(100) NOT NULL default '',
`user_sig` tinytext NOT NULL,
`user_viewemail` tinyint(1) unsigned NOT NULL default '0',
`actkey` varchar(8) NOT NULL default '',
`user_aim` varchar(18) NOT NULL default '',
`user_yim` varchar(25) NOT NULL default '',
`user_msnm` varchar(100) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`posts` mediumint(8) unsigned NOT NULL default '0',
`attachsig` tinyint(1) unsigned NOT NULL default '0',
`rank` smallint(5) unsigned NOT NULL default '0',
`level` tinyint(3) unsigned NOT NULL default '1',
`theme` varchar(100) NOT NULL default '',
`timezone_offset` float(3,1) NOT NULL default '0.0',
`last_login` int(10) unsigned NOT NULL default '0',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) unsigned NOT NULL default '0',
`notify_method` tinyint(1) NOT NULL default '1',
`notify_mode` tinyint(1) NOT NULL default '0',
`user_occ` varchar(100) NOT NULL default '',
`bio` tinytext NOT NULL,
`user_intrest` varchar(150) NOT NULL default '',
`user_mailok` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
KEY `email` (`email`),
KEY `uiduname` (`uid`,`uname`),
KEY `unamepass` (`uname`,`pass`)
) TYPE=MyISAM AUTO_INCREMENT=521 ;
--
-- Dumping data for table `xoops_users`
--
INSERT INTO `xoops_users` (`uid`, `name`, `uname`, `email`, `url`, `user_avatar`, `user_regdate`, `user_icq`, `user_from`, `user_sig`, `user_viewemail`, `actkey`, `user_aim`, `user_yim`, `user_msnm`, `pass`, `posts`, `attachsig`, `rank`, `level`, `theme`, `timezone_offset`, `last_login`, `umode`, `uorder`, `notify_method`, `notify_mode`, `user_occ`, `bio`, `user_intrest`, `user_mailok`) VALUES (1, 'Shamsul Erzwan b. Samsudin', 'erzwan', 'mesol86@gmail.com', 'http://erzwan.com/', 'cavt44f36b98996b0.jpg', 1145417064, '', '', '[url=http://www.erzwan.com/]OpenSource Supporter[/url]\r\n\r\n[img]http://img154.imageshack.us/img154/5166/userbar110235qk4.gif[/img]\r\n[img]http://img157.imageshack.us/img157/9738/userbar110260vt8.gif[/img]', 1, '', '', 'mesol86', '', '4bf2cbe733d25a9d679f2986904e8027', 338, 1, 7, 5, 'xt_plus_katisuhara', 8.0, 1184927318, 'thread', 0, 2, 0, 'Undergraduate', '', 'Computing', 1);
SQL query:
CREATE TABLE `xoops_users` ( `uid` mediumint(8) unsigned NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `uname` varchar(25) NOT NULL default '', `email` varchar(60) NOT NULL default '', `url` varchar(100) NOT NULL default '', `user_avatar` varchar(30) NOT NULL default 'blank.gif', `user_regdate` int(10) unsigned NOT NULL default '0', `user_icq` varchar(15) NOT NULL default '', `user_from` varchar(100) NOT NULL default '', `user_sig` tinytext NOT NULL, `user_viewemail` tinyint(1) unsigned NOT NULL default '0', `actkey` varchar(8) NOT NULL default '', `user_aim` varchar(18) NOT NULL default '', `user_yim` varchar(25) NOT NULL default '', `user_msnm` varchar(100) NOT NULL default '', `pass` varchar(32) NOT NULL default '', `posts` mediumint(8) unsigned NOT NULL default '0', `attachsig` tinyint(1) unsigned NOT NULL default '0', `rank` smallint(5) unsigned NOT NULL default '0', `level` tinyint(3) unsigned NOT NULL default '1', `theme` varchar(100) NOT NULL default '', `timezone_offset` float(3,1) NOT NULL default '0.0', `last_login` int(10) unsigned NOT NULL default '0', `umode` varchar(10) NOT NULL default '', `uorder` tinyint(1) unsigned NOT NULL default '0', `notify_method` tinyint(1) NOT NULL default '1', `notify_mode` tinyint(1) NOT NULL default '0', `user_occ` varchar(100) NOT NULL default '', `bio` tinytext NOT NULL, `user_intrest` varchar(150) NOT NULL default '', `user_mailok` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`uid`), KEY `uname` (`uname`), KEY `email` (`email`), KEY `uiduname` (`uid`,`uname`), KEY `unamepass` (`uname`,`pass`) ) TYPE=MyISAM AUTO_INCREMENT=521 ; -- -- Dumping data for table `xoops_users` -- INSERT INTO `xoops_users` (`uid`, `name`, `uname`, `email`, `url`, `user_avatar`, `user_regdate`, `user_icq`, `user_from`, `user_sig`, `user_viewemail`, `actkey`, `user_aim`, `user_yim`, `user_msnm`, `pass`, `posts`, `attachsig`, `rank`, `level`, `theme`, `timezone_offset`, `last_login`, `umode`, `uorder`, `notify_method`, `notify_mode`, `user_occ`, `bio`, `user_intrest`, `user_mailok`) VALUES (1, 'Shamsul Erzwan b. Samsudin', 'erzwan', 'mesol86@gmail.com', 'http://erzwan.com/', 'cavt44f36b98996b0.jpg', 1145417064, '', '', '[url=http://www.erzwan.com/]OpenSource Supporter[/url]\r\n\r\n[img]http://img154.imageshack.us/img154/5166/userbar110235qk4.gif[/img]\r\n[img]http://img157.imageshack.us/img157/9738/userbar110260vt8.gif[/img]', 1, '', '', 'mesol86', '', 'xxxxxxxxxxxxxxx', 338, 1, 7, 5, 'xt_plus_katisuhara', 8.0, 1184927318, 'thread', 0, 2, 0, 'Undergraduate', '', 'Computing', 1);
MySQL said: Documentation
#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 ''',
`uname` varchar(25) NOT NULL default '',
`email` varchar(60) NOT N' at line 3
--
-- Table structure for table `xoops_users`
--
DROP TABLE IF EXISTS `xoops_users`;
CREATE TABLE `xoops_users` (
`uid` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`uname` varchar(25) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`user_avatar` varchar(30) NOT NULL default 'blank.gif',
`user_regdate` int(10) unsigned NOT NULL default '0',
`user_icq` varchar(15) NOT NULL default '',
`user_from` varchar(100) NOT NULL default '',
`user_sig` tinytext NOT NULL,
`user_viewemail` tinyint(1) unsigned NOT NULL default '0',
`actkey` varchar(8) NOT NULL default '',
`user_aim` varchar(18) NOT NULL default '',
`user_yim` varchar(25) NOT NULL default '',
`user_msnm` varchar(100) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`posts` mediumint(8) unsigned NOT NULL default '0',
`attachsig` tinyint(1) unsigned NOT NULL default '0',
`rank` smallint(5) unsigned NOT NULL default '0',
`level` tinyint(3) unsigned NOT NULL default '1',
`theme` varchar(100) NOT NULL default '',
`timezone_offset` float(3,1) NOT NULL default '0.0',
`last_login` int(10) unsigned NOT NULL default '0',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) unsigned NOT NULL default '0',
`notify_method` tinyint(1) NOT NULL default '1',
`notify_mode` tinyint(1) NOT NULL default '0',
`user_occ` varchar(100) NOT NULL default '',
`bio` tinytext NOT NULL,
`user_intrest` varchar(150) NOT NULL default '',
`user_mailok` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
KEY `email` (`email`),
KEY `uiduname` (`uid`,`uname`),
KEY `unamepass` (`uname`,`pass`)
) TYPE=MyISAM AUTO_INCREMENT=521 ;
--
-- Dumping data for table `xoops_users`
--
INSERT INTO `xoops_users` (`uid`, `name`, `uname`, `email`, `url`, `user_avatar`, `user_regdate`, `user_icq`, `user_from`, `user_sig`, `user_viewemail`, `actkey`, `user_aim`, `user_yim`, `user_msnm`, `pass`, `posts`, `attachsig`, `rank`, `level`, `theme`, `timezone_offset`, `last_login`, `umode`, `uorder`, `notify_method`, `notify_mode`, `user_occ`, `bio`, `user_intrest`, `user_mailok`) VALUES (1, 'Shamsul Erzwan b. Samsudin', 'erzwan', 'mesol86@gmail.com', 'http://erzwan.com/', 'cavt44f36b98996b0.jpg', 1145417064, '', '', '[url=http://www.erzwan.com/]OpenSource Supporter[/url]rnrn[img]http://img154.imageshack.us/img154/5166/userbar110235qk4.gif[/img]rn[img]http://img157.imageshack.us/img157/9738/userbar110260vt8.gif[/img]', 1, '', '', 'mesol86', '', 'xxxxxxxxxxxxxx', 338, 1, 7, 5, 'xt_plus_katisuhara', 8.0, 1184927318, 'thread', 0, 2, 0, 'Undergraduate', '', 'Computing', 1);
/* General definitions */
html { scrollbar-face-color: #eeeeee; scrollbar-highlight-color: #ffffff; scrollbar-shadow-color: #d5d5d5; scrollbar-3dlight-color: #000000; scrollbar-arrow-color: #000000; scrollbar-track-color: #ffffff; scrollbar-darkshadow-color: #000000;}
body { background-color : #E9F0F7; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 0px; padding: 0px;}
img {border: none;}
hr { height: 3px; border: 3px #E18A00 solid; width: 95%;}
ul { margin: 2px; padding: 2px; list-style: decimal inside; text-align: left;}
li { margin-left: 2px; list-style: square inside; color: #000000;}
h1 { font-size: 20px;}
h2 { font-size: 18px;}
h3 { font-size: 16px;}
h4 { font-size: 14px;}
th {background-color: #56BAFA; color: #FFFFFF; padding : 4px; vertical-align : middle;}
a:link {text-decoration: none; color: #4177A6; font-weight: bold; background-color: transparent;}
a:visited {text-decoration: none; color: #4177A6; font-weight: bold; background-color: transparent;}
a:hover {text-decoration: underline; color: #FF4500; font-weight: bold; background-color: transparent;}
/* Code and Quote Definition */
div.xoopsCode { font-size: 11px; color: #006600; background-color: #FAFAFA; border: #c2cdd6 1px dashed;}
div.xoopsQuote { font-size: 11px; color: #444444; line-height: 125%; text-align: justify; background-color: #FAFAFA; border: #c2cdd6 1px dashed;}
/* Links for Quotes */
div.xoopsQuote a:link, div.xoopsQuote a:visited { color: #444444; font-weight: bold; background-color: transparent;}
div.xoopsQuote a:hover, div.xoopsQuote a:active { color: #1778cb; background-color: transparent;}
/* Redirect messages */
div.errorMsg {
background-color: #1E90FF;
color: White;
text-align: center;
border: 1px solid #0081FD;
padding: 8px;
font-weight: bold;
}
div.confirmMsg {
background-color : #FFF09B;
color: #FF4500;
text-align:center;
border: 1px solid #FFD700;
font-weight : bold;
width: 80%;
margin: 0 auto;
padding: 8px;
}
/* General small */
.fontSmall { font-size : 10px; background-color: transparent;}
a.fontSmall { color: #006699;}
a.fontSmall:hover { color: #C23030; text-decoration: underline;}
/*forms elements*/
input,textarea,select {
border: 1px solid #CCCCCC;
font-size: 11px;
font-family: Arial, Helvetica, sans-serif;
background-color: #FFFFFF;
}
input:focus, textarea:focus, select:focus{
border: 1px solid #999999;
}
.outer {border: 1px solid #CCCCCC;}
.head {background-color: #EBEBEB; padding: 5px; font-weight: bold;}
.even {background-color: #FFFFFF; padding: 5px; border-bottom: 1px solid #CCCCCC; }
.odd {background-color: #EFEFEF; padding: 5px; border-bottom: 1px solid #CCCCCC; }
.foot {background-color: #E1E7EF; padding: 5px; font-weight: bold;}
tr.head td {background-color: #BDE3FB; padding: 5px; font-weight: bold;}
tr.even td {background-color: #FFFFFF; padding: 5px; border-bottom: 1px solid #CCCCCC;}
tr.odd td {background-color: #EFEFEF; padding: 5px; border-bottom: 1px solid #CCCCCC; }
tr.foot td {background-color: #E1E7EF; padding: 5px; font-weight: bold;}
/**
* Declaraciones para nuevo formato
* @author BitC3R0
*/
div#logoHead{
padding: 0;
text-align: left;
background: url(images/bgheader.jpg) repeat-x;
border-bottom: 3px solid #9ACD32;
}
div#navbarCP{
background: #F1F1FC;
/*padding: 4px;*/
border-top: 1px solid #FFFFFF;
border-bottom: 1px solid #CCCCCC;
font-weight: normal;
font-family: Arial, Helvetica, sans-serif;
height: 24px;
}
div#navbarCP ul{
list-style: none;
padding: 0;
margin: 0;
}
div#navbarCP ul li{
list-style: none;
padding: 0;
float: left;
margin: 0;
margin-left: 3px;
position: relative;
}
div#navbarCP ul li a{
padding: 4px;
display: block;
color: #000000;
font-weight: normal;
border: 1px solid #F1F1FC;
}
div#navbarCP ul li a:hover{
background-color: #E7F4F7;
border-color: #ADD8E6;
}
div#navbarCP ul li ul{
display: none;
position: absolute;
top: 1em;
left: 0;
background: #FFFFFF;
border: 1px solid #CCCCCC;
padding: 0;
margin: 0;
}
div#navbarCP ul li ul a{
color: #666666;
font-weight: normal;
background: url(images/item.png) no-repeat left;
padding-left: 20px;
*padding-left: 4px;
border: 1px solid #FFFFFF;
}
div#navbarCP ul li ul a:hover{
color: #000000;
background-color: #E7F4F7;
border-color: #ADD8E6;
}
div#navbarCP ul li ul li{
width: 150px;
margin: 0;
*width: auto;
}
div#navbarCP ul li > ul {
top: auto;
left: auto;
}
div#navbarCP ul li:hover ul, div#navbarCP li.over ul{ display: block; }
div#navbarCP ul li ul li{
float: none;
}
div#bodyCP{
width: 95%;
margin: 0 auto;
background-color: #FFFFFF;
border: 1px solid #CCCCCC;
padding: 8px;
}
div#containBodyCP{
padding: 0;
margin: 0;
border-top: 1px solid #FFFFFF;
border-bottom: 1px solid #CCCCCC;
}
div#navOptionsCP{
padding: 0px 5px 0px 5px;
text-align: right;
background: #F1F1FC;
border-top: 1px solid #FFFFFF;
border-bottom: 1px solid #CCCCCC;
height: 35px;
}
div#navOptionsCP a{
border: 1px solid #DFE0FD;
height: 32px;
display: block;
width: 32px;
float: right;
margin: 0;
margin-right: 2px;
}
div#navOptionsCP a:hover{
background-color: #E7F4F7;
border-color: #ADD8E6;
}
div#navOptionsCP .modname{
float: left;
font-size: 18px;
font-weight: bold;
color: Silver;
margin-top: 4px;
}
.CPrssLinks{
padding: 4px;
}
.CPrssLinks a{
font-size: 12px;
background: url(images/item.png) no-repeat left;
padding: 2px;
display: block;
padding-left: 18px;
}
div.CPfoot{
padding: 4px;
background-color: #F1F1FC;
border-bottom: 1px solid #CCCCCC;
border-top: 1px solid #FFFFFF;
text-align: center;
font-size: 10px;
font-weight: bold;
color: #666666;
}
/* General definitions */
html { scrollbar-face-color: #eeeeee; scrollbar-highlight-color: #ffffff; scrollbar-shadow-color: #d5d5d5; scrollbar-3dlight-color: #000000; scrollbar-arrow-color: #000000; scrollbar-track-color: #ffffff; scrollbar-darkshadow-color: #000000;}
body { background-color : transparent; font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif; margin: 0px; padding: 0px;}
img {border: none;}
hr { height: 3px; border: 3px #E18A00 solid; width: 95%;}
ul { margin: 2px; padding: 2px; list-style: decimal inside; text-align: left;}
li { margin-left: 2px; list-style: square inside; color: #000000;}
h1 { font-size: 20px;}
h2 { font-size: 18px;}
h3 { font-size: 16px;}
h4 { font-size: 14px;}
th {background-color: #2F5376; color: #FFFFFF; padding : 2px; vertical-align : middle;}
a:link {text-decoration: none; color: #666666; font-weight: bold; background-color: transparent;}
a:visited {text-decoration: none; color: #666666; font-weight: bold; background-color: transparent;}
a:hover {text-decoration: none; color: #ff9966; font-weight: bold; background-color: transparent;}
/* Code and Quote Definition */
div.xoopsCode { font-size: 11px; color: #006600; background-color: #FAFAFA; border: #c2cdd6 1px dashed;}
div.xoopsQuote { font-size: 11px; color: #444444; line-height: 125%; text-align: justify; background-color: #FAFAFA; border: #c2cdd6 1px dashed;}
/* Links for Quotes */
div.xoopsQuote a:link, div.xoopsQuote a:visited { color: #444444; font-weight: bold; background-color: transparent;}
div.xoopsQuote a:hover, div.xoopsQuote a:active { color: #1778cb; background-color: transparent;}
/* Redirect messages */
div.errorMsg { background-color: #FF3737; color: White; text-align: center; border-top: 1px solid #DDDDFF; border-left: 1px solid #DDDDFF; border-right: 1px solid #AAAAAA; border-bottom: 1px solid #AAAAAA; font-weight: bold; padding: 10px;}
div.confirmMsg { background-color : #DDFFDF; color: #136C99; text-align:center; border-top: 1px solid #DDDDFF; border-left: 1px solid #DDDDFF; border-right: 1px solid #AAAAAA; border-bottom: 1px solid #AAAAAA; font-weight : bold;}
/* General small */
.fontSmall { font-size : 10px; background-color: transparent;}
a.fontSmall { color: #006699;}
a.fontSmall:hover { color: #C23030; text-decoration: underline;}
/*forms elements*/
input { border-right: #000000 1px solid; border-top: #000000 1px solid; font: 11px verdana, arial, helvetica, sans-serif; border-left: #000000 1px solid;color: #000000; border-bottom: #000000 1px solid; background-color: #ffffff;}
textarea { border: #000000 1px solid; width: 430px; font: 11px verdana, arial, helvetica, sans-serif;}
input.formTextBox { border: #000000 1px solid; background: #ffffff; font: 11px verdana, arial, helvetica, sans-serif;}
select { border: #000000 1px solid; font: 11px verdana, arial, helvetica, sans-serif;}
div.content { text-align: left; padding: 0px 15px 0px 15px;}
.xoopsCenter { text-align:center;}
.bg1 { background-color: #E6E6E6;}
.bg2 { background-color: #2F5376;}
.bg3 { background-color: #2F5376; color: #ffffff;}
.bg4 { background-color: #ECECEC;}
.bg5 { background-color: #ECECEC;}
.outer {border: 1px solid silver;}
.head {background-color: #c2cdd6; padding: 5px; font-weight: bold;}
.even {background-color: #dee3e7; padding: 5px;}
.odd {background-color: #E6E6E6; padding: 5px;}
.foot {background-color: #c2cdd6; padding: 5px; font-weight: bold;}
tr.head td {background-color: #c2cdd6; padding: 5px; font-weight: bold;}
tr.even td {background-color: #dee3e7; padding: 5px;}
tr.odd td {background-color: #E6E6E6; padding: 5px;}
tr.foot td {background-color: #c2cdd6; padding: 5px; font-weight: bold;}
Invalid data received in '%s'