MySQL Syntax Error while installing DZCP | Newbie | | Join Date: Jun 2007
Posts: 2
| |
Hi,
I hope you can help me. As I try to install Devil'z Clanportal, i only recieve this error message: - MySQL-Query failed:
-
-
-
ErrorNo = 1064
-
Error = 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 '2', `reg_forum` int(1) NOT NULL default '0', `reg_cw' at line 3
-
Query = CREATE TABLE dzcp_settings ( `clanname` varchar(50) NOT NULL default 'Dein Clanname hier!', `pfad` varchar(50) NOT NULL default '\', `balken_vote` varchar(3) NOT NULL default '2', `reg_forum` int(1) NOT NULL default '0', `reg_cwcomments` int(1) NOT NULL default '0', `counter_start` int(10) NOT NULL default '0', `balken_vote_menu` varchar(3) NOT NULL default '0.9', `balken_cw` varchar(3) NOT NULL default '2.4', `reg_dl` int(1) NOT NULL default '0', `reg_artikel` int(1) NOT NULL default '0', `reg_newscomments` int(1) NOT NULL default '0', `tmpdir` varchar(100) NOT NULL default 'modern', `wmodus` int(1) NOT NULL default '0', `persinfo` int(1) NOT NULL default '1', `iban` varchar(100) NOT NULL default '', `bic` varchar(100) NOT NULL default '', `badwords` text NOT NULL, `pagetitel` varchar(50) NOT NULL default 'Dein Seitentitel hier!', `last_backup` int(20) NOT NULL default '0', `squadtmpl` int(1) NOT NULL default '1', `i_domain` varchar(50) NOT NULL default 'www.deineUrl.de', `i_autor` varchar(249) NOT NULL default 'Max Mustermann', `k_nr` varchar(100) NOT NULL default '123456789', `k_inhaber` varchar(50) NOT NULL default 'Max Mustermann', `k_blz` varchar(100) NOT NULL default '123456789', `k_bank` varchar(200) NOT NULL default 'Musterbank', `k_waehrung` varchar(15) NOT NULL default '€', `ftp_host` varchar(100) NOT NULL default '', `ftp_login` varchar(100) NOT NULL default '', `ftp_pwd` varchar(100) NOT NULL default '', `language` varchar(50) NOT NULL default 'deutsch', `domain` varchar(200) NOT NULL default 'active2clan.de', `gametiger` varchar(20) NOT NULL default 'cstrike', `regcode` int(1) NOT NULL default '1', `ts_ip` varchar(200) NOT NULL default '', `mailfrom` varchar(200) NOT NULL default 'support@active2clan.de', `ts_port` int(10) NOT NULL default '0', `ts_sport` int(10) NOT NULL default '0', `ts_width` int(10) NOT NULL default '0', `bl_path` varchar(249) NOT NULL default '' ) TYPE=MyISAM
-
thanks a lot for your help
|  | Moderator | | Join Date: Nov 2006 Location: Iceland
Posts: 3,748
| | | re: MySQL Syntax Error while installing DZCP
Hi, and welcome to TSDN.
The error is telling you that there is a problem with your CREATE TABLE query. The weird thing is that the query you gave us seemes to be ok.
If you have the code that creates this, please show us the part that generates the error and we will do our best to help you to fix it.
If you didn't write the code yoursef you might want to contact the one who did and ask him about it.
| | Newbie | | Join Date: Jun 2007
Posts: 2
| | | re: MySQL Syntax Error while installing DZCP
I do not know if this is, what you mean, but have a look at it - $httphost = $_SERVER['HTTP_HOST'];
-
$host = str_replace('www.','',$httphost);
-
$qry = db("DROP TABLE IF EXISTS ".$db['settings']."");
-
$qry = db("CREATE TABLE ".$db['settings']." (
-
`clanname` varchar(50) NOT NULL default 'Dein Clanname hier!',
-
`pfad` varchar(50) NOT NULL default '".$pfad."',
-
`balken_vote` varchar(3) NOT NULL default '2',
-
`reg_forum` int(1) NOT NULL default '0',
-
`reg_cwcomments` int(1) NOT NULL default '0',
-
`counter_start` int(10) NOT NULL default '0',
-
`balken_vote_menu` varchar(3) NOT NULL default '0.9',
-
`balken_cw` varchar(3) NOT NULL default '2.4',
-
`reg_dl` int(1) NOT NULL default '0',
-
`reg_artikel` int(1) NOT NULL default '0',
-
`reg_newscomments` int(1) NOT NULL default '0',
-
`tmpdir` varchar(100) NOT NULL default 'modern',
-
`wmodus` int(1) NOT NULL default '0',
-
`persinfo` int(1) NOT NULL default '1',
-
`iban` varchar(100) NOT NULL default '',
-
`bic` varchar(100) NOT NULL default '',
-
`badwords` text NOT NULL,
-
`pagetitel` varchar(50) NOT NULL default 'Dein Seitentitel hier!',
-
`last_backup` int(20) NOT NULL default '0',
-
`squadtmpl` int(1) NOT NULL default '1',
-
`i_domain` varchar(50) NOT NULL default 'www.deineUrl.de',
-
`i_autor` varchar(249) NOT NULL default 'Max Mustermann',
-
`k_nr` varchar(100) NOT NULL default '123456789',
-
`k_inhaber` varchar(50) NOT NULL default 'Max Mustermann',
-
`k_blz` varchar(100) NOT NULL default '123456789',
-
`k_bank` varchar(200) NOT NULL default 'Musterbank',
-
`k_waehrung` varchar(15) NOT NULL default '€',
-
`ftp_host` varchar(100) NOT NULL default '',
-
`ftp_login` varchar(100) NOT NULL default '',
-
`ftp_pwd` varchar(100) NOT NULL default '',
-
`language` varchar(50) NOT NULL default 'deutsch',
-
`domain` varchar(200) NOT NULL default '".$host."',
-
`gametiger` varchar(20) NOT NULL default 'cstrike',
-
`regcode` int(1) NOT NULL default '1',
-
`ts_ip` varchar(200) NOT NULL default '',
-
`mailfrom` varchar(200) NOT NULL default 'support@".$host."',
-
`ts_port` int(10) NOT NULL default '0',
-
`ts_sport` int(10) NOT NULL default '0',
-
`ts_width` int(10) NOT NULL default '0',
-
`bl_path` varchar(249) NOT NULL default ''
-
) TYPE=MyISAM");
-
| | Moderator | | Join Date: Nov 2006 Location: Iceland
Posts: 3,748
| | | re: MySQL Syntax Error while installing DZCP
Yea thats it, but I can't spot any errors there :/
I tried this on my localhost and it works fine. I'm running PHP 5.2.2 and MySQL 5.0.
What versions of PHP and MySQL are you running? Might be some minor bug in some version of MySQL.
Also, if you can locate that db() function it's possible there might be an error in there.
|  |
Similar MySQL Database bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,439 network members.
|
