Eroare conectare la MYSQL

[weez]

Deci am server war3ft si am avut 1000 de probleme cu baza de date mysql , pana ieri a mers azi am incercat sa pun sa se salveze in baza de date de la host TNI. dar cand dau rr la server arata asa.

Code: Select all

[WAR3FT] MySQL X database connection successful
L 01/01/2014 - 16:41:21: [war3ft.amxx] [MYSQLX] Error in querying database, location: 1
L 01/01/2014 - 16:41:21: [MYSQLX] Error in querying database, location: 1
L 01/01/2014 - 16:41:21: [war3ft.amxx] [MYSQLX] Message: 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 '(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KE' at line 1 (1064)
L 01/01/2014 - 16:41:21: [MYSQLX] Message: 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 '(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KE' at line 1 (1064)
L 01/01/2014 - 16:41:21: [war3ft.amxx] [MYSQLX] Query statement: CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`plL 01/01/2014 - 16:41:21: [MYSQLX] Query statement: CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY  (`player_id`), KEY `player_name` (`player_name`), KL 01/01/2014 - 16:41:21: [war3ft.amxx] [MYSQLX] Error in querying database, location: 7
L 01/01/2014 - 16:41:21: [MYSQLX] Error in querying database, location: 7
L 01/01/2014 - 16:41:21: [war3ft.amxx] [MYSQLX] Message: Table 'vuser331.wc3_config' doesn't exist (1146)
L 01/01/2014 - 16:41:21: [MYSQLX] Message: Table 'vuser331.wc3_config' doesn't exist (1146)
L 01/01/2014 - 16:41:21: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id`, `config_value` ) VALUES ( 'level0_xp', '0' ); 
L 01/01/2014 - 16:41:21: [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id`, `config_value` ) VALUES ( 'level0_xp', '0' ); 

De la ce poate fi ?

[MaimutaVirtuala]

Cum sa fie eroare la conectare cand spune clar: "[WAR3FT] MySQL X database connection successful" ca este conectat cu succes.Tu ai eroare in interogare(query), acel query este scris gresi sau are un semn in plus.

[weez]

Si cum se poate remedia asta ?

[MaimutaVirtuala]

Sa rescrii interogarile si sa verifici daca tabela wc3_config exista in baza de date "vuser331".

[weez]

Nu prea ma pricep sa ma conectez la mysql :| o sa caut pe cineva sa ma ajute . Multumesc oricum.

[MaimutaVirtuala]

Pune aici war3ft.sma. sau da-mi mesaj privat cu el.

Code: Select all

 CREATE TABLE IF NOT EXISTS `wc3_config`(
        `config_id` int(11) unsigned NOT NULL auto_increment,
        `config_value` varchar(255)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;