phpBB.de

SQL-Befehl:

CREATE TABLE `phpbb_sportsuite_config` (
`config_name` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
`config_value` varchar( 255 ) COLLATE utf8_bin NOT NULL default '',
PRIMARY KEY ( `config_name` )
)

MySQL meldet: Dokumentation
#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 'collate utf8_bin NOT NULL default '',
`config_value` varchar

#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 'collate utf8_bin NOT NULL default '0',
`config_value` varcha

CREATE TABLE `phpbb_sportsuite_config` (
`config_name` varchar(255) collate utf8_bin NOT NULL default '',
`config_value` varchar(255) collate utf8_bin NOT NULL default '',
PRIMARY KEY (`config_name`)
);

INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f656e61626c6564, 0x31);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f6e616d65, 0x53706f727473626f6f6b);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f726573756c745f706f696e7473, 0x33);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f73636f72655f706f696e7473, 0x35);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f666978747572655f74696d65, 0x3534303030);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f666978747572655f64617973, 0x3331);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f74696d655f696e6372656d656e7473, 0x31);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f757365725f73746174735f6c696d6974, 0x3135);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f64656661756c745f666978747572655f74797065, 0x31);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f706173745f666978747572655f6c696d6974, 0x32363738343030);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73706f727473756974655f76657273696f6e, 0x7665722e20302e322e3161);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f6661696c5f706f696e74735f6f6e, 0x31);
INSERT INTO `phpbb_sportsuite_config` VALUES (0x73626f6f6b5f666978747572655f6175746f636c6f7365, 0x2d31);

CREATE TABLE `phpbb_sportsuite_leagues` (
`league_id` smallint(5) NOT NULL auto_increment,
`league_name` varchar(30) collate utf8_bin NOT NULL default '',
`league_type` tinyint(2) NOT NULL default '0',
`league_points_win` tinyint(2) NOT NULL default '3',
`league_points_draw` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`league_id`)
);

CREATE TABLE `phpbb_sportsuite_sbook_fixtures` (
`fixture_id` int(11) NOT NULL auto_increment,
`league_id` smallint(5) NOT NULL default '0',
`fixture_type` tinyint(2) NOT NULL default '0',
`fixture_user_id` mediumint(8) NOT NULL default '0',
`fixture_time` int(11) NOT NULL default '0',
`team_id_home` smallint(5) NOT NULL default '0',
`team_id_away` smallint(5) NOT NULL default '0',
`fixture_score_home` smallint(5) NOT NULL default '-1',
`fixture_score_away` smallint(5) NOT NULL default '-1',
`fixture_process_user_id` mediumint(8) NOT NULL default '-1',
PRIMARY KEY (`fixture_id`),
KEY `league_id` (`league_id`),
KEY `fixture_type` (`fixture_type`)
);

CREATE TABLE `phpbb_sportsuite_sbook_user_bets` (
`user_id` mediumint(8) NOT NULL default '0',
`fixture_id` mediumint(11) NOT NULL default '0',
`bet_home_score` tinyint(3) NOT NULL default '0',
`bet_away_score` tinyint(3) NOT NULL default '0',
KEY `user_id` (`user_id`)
);

CREATE TABLE `phpbb_sportsuite_sbook_user_stats` (
`user_id` mediumint(8) NOT NULL default '0',
`stats_predictions` int(11) NOT NULL default '0',
`stats_fails` int(11) NOT NULL default '0',
`stats_results` int(11) NOT NULL default '0',
`stats_scores` int(11) NOT NULL default '0',
`stats_points` int(11) NOT NULL default '0',
`stats_superceded` tinyint(1) NOT NULL,
PRIMARY KEY (`user_id`)
);

CREATE TABLE `phpbb_sportsuite_teams` (
`team_id` smallint(5) NOT NULL auto_increment,
`team_name` varchar(30) collate utf8_bin NOT NULL default '',
`league_id` smallint(5) NOT NULL default '0',
PRIMARY KEY (`team_id`)
);

CREATE TABLE `phpbb_sportsuite_sbook_hth_team_stats` (
`team_id` smallint(5) NOT NULL,
`team_points` mediumint(7) NOT NULL,
`team_gd` mediumint(7) NOT NULL,
`team_hp` smallint(5) NOT NULL,
`team_hw` smallint(5) NOT NULL,
`team_hl` smallint(5) NOT NULL,
`team_hd` smallint(5) NOT NULL,
`team_hf` mediumint(7) NOT NULL,
`team_ha` mediumint(7) NOT NULL,
`team_ap` smallint(5) NOT NULL,
`team_aw` smallint(5) NOT NULL,
`team_al` smallint(5) NOT NULL,
`team_ad` smallint(5) NOT NULL,
`team_af` mediumint(7) NOT NULL,
`team_aa` mediumint(7) NOT NULL,
UNIQUE KEY `team_id` (`team_id`)
);

MySQL meldet: Dokumentation
#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 'collate utf8_bin NOT NULL default '',`config_value` varchar(255

Dr.Death hat geschrieben:Hi,

der Autor des MODs hat nicht an MySQl Datenbanken kleiner als Version 4.1.3 gedacht.

In früheren MySQL Versionen gab es noch keine echte UTF-8 Unterstützung.

Entferne aus den Statements einfach alle

Code: Alles auswählen
COLLATE utf8_bin



EDIT: Huch, sehe ich erst jetzt..... der Autor hat sogar die INSERTs in HEX Code angegeben ... örgs

Sorry, damit Du den MOD testen kannst hast Du nur 2 Möglichkeiten:

1. Du benötigst eine Datenbank mit UTF8 Support ( MySQL >= 4.1.3 )
2. Informiere den MOD Autor, das er es auch für kleiner Datenbank Versionen anbietet.