Arcade_MOD_v2.0.6 eingebaut und nun Fehlermeldung

[~zicke~]

Ich habe mir den ArcadeMod eingebaut und bekomme nun diesen Fehler...Weiß jemand was das bedeutet?


Could not query announcements information

DEBUG MODE

SQL Error : 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 ') AND t.topic_time <= 1110561949 AND t.topic_poster =

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS pt, phpbb_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1110561949 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC

Line : 86
File : portal_poll.php


Link:
http://zicke.zi.funpic.de/phpBB2/portal.php

[agent-7]

Ja du musst mod_install.php ausführen ! dann wird es wohl gehen ...

[~zicke~]

die hatte ich ausgeführt und nun hab ich den Fehler.
In der Datenbank sind die Einträge auch gemacht worden...*grübel*

[Eloi]

Hallo Leute,
habe auch den „Arcade_MOD_v2.0.8“ installiert. Anschließend habe ich versucht, den „mod_install.php“ im Browser zu starten, aber ich bekomme immer die folgende Fehlermeldung:

Parse error: parse error, unexpected T_STRING in /www/htdocs/meinDatenbankname/phpbb/mod_install.php on line 240

Kann mir bitte jemand sagen, woran das liegt und wie ich diese Fehlermeldung bzw. die SQL Daten in meiner Datenbank bekomme?

Ich bedanke mich schon mal für eure Hilfe.

Gruß, Eloi

[Eloi]

...habe den Fehler, in der „mod_install.php“, gefunden.

Vorher:

Code: Alles auswählen

$sql[] = "CREATE TABLE " . iNA_USER_DATA (
							`user_id` mediumint(8) NOT default '0',
							`last_played` varchar(25) default NULL,
							`last_played_date` int(11) default NULL,
							`first_places` mediumint(9) default '0',
							`at_first_paces` mediumint(9) default '0',
						PRIMARY KEY  (`user_id`))";

Nacher:

Code: Alles auswählen

$sql[] = "CREATE TABLE " . iNA_USER_DATA . " (
							`user_id` mediumint(8) NOT default '0',
							`last_played` varchar(25) default NULL,
							`last_played_date` int(11) default NULL,
							`first_places` mediumint(9) default '0',
							`at_first_paces` mediumint(9) default '0',
						PRIMARY KEY  (`user_id`))";

Aber jetzt bekomme ich folgende Fehlermeldung, nachdem ich den „mod_install.php“ im Browser gestartet habe:

Code: Alles auswählen

Information
Database type    :: mysql4
phpBB version    :: 2.0.17

Updating database schema & data
Progress :: .................................................... Done
Result   :: Some queries failed, the statements and errors are listing below 

Error :: Table 'phpbb_ina_data' already exists
SQL   :: CREATE TABLE phpbb_ina_data ( version VARCHAR(255) DEFAULT NULL )


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 'cat_id` mediumint(8) default NULL, `game_name` varchar(
SQL   :: CREATE TABLE phpbb_ina_games ( `game_id` mediumint(9) NOT NULL auto_increment, `date_added int(11) default 0, `cat_id` mediumint(8) default NULL, `game_name` varchar(50) default NULL, `game_path` varchar(255) default NULL, `image_path` varchar(255) default NULL, `game_desc` varchar(255) default NULL, `game_charge` int(11) unsigned default '0', `game_reward` int(11) unsigned NOT NULL default '0', `game_bonus` smallint(5) unsigned default '0', `at_game_bonus` smallint(5) default '0', `game_use_gl` tinyint(3) unsigned default '0', `game_flash` tinyint(1) unsigned NOT NULL default '0', `game_show_score` tinyint(1) NOT NULL default '1', `game_avail` tinyint(1) unsigned default '1', `allow_guest` tinyint(1) unsigned default '0', `win_width` smallint(6) NOT NULL default '0', `win_height` smallint(6) NOT NULL default '0', `highscore_limit` int(11) default NULL, `at_highscore_limit` int(10) default '0', `reverse_list` tinyint(1) NOT NULL default '0', `played` int(10) unsigned NOT NULL default '0', `instructions` text, `score_type` smallint(1) default NULL, `game_autosize` smallint(1) NOT NULL default '0', `rank_required` smallint(5) default NULL, `level_required` tinyint(4) default NULL, PRIMARY KEY (`game_id`))


Error :: Table 'phpbb_ina_scores' already exists
SQL   :: CREATE TABLE phpbb_ina_scores ( `game_name` varchar(50) default NULL, `player_id` mediumint(8) default NULL, `player_ip` varchar(16) default NULL, `score` decimal(12,4) unsigned default NULL, `date` int(11) default NULL )


Error :: Table 'phpbb_ina_at_scores' already exists
SQL   :: CREATE TABLE phpbb_ina_at_scores ( `game_name` varchar(50) default NULL, `player_id` mediumint(8) default NULL, `player_ip` varchar(16) default NULL, `score` decimal(12,4) unsigned default NULL, `date` int(11) default NULL )


Error :: Table 'phpbb_ina_sessions' already exists
SQL   :: CREATE TABLE phpbb_ina_sessions ( `arcade_hash` varchar(33) default NULL, `user_id` mediumint(8) NOT NULL default '0', `start_time` int(11) NOT NULL default '0', `session_ip` varchar(8) NOT NULL default '', `page` int(1) NOT NULL default '0', `game_name` varchar(50) default NULL, `user_ip` varchar(16) default '0', `ip_name` varchar(255) default NULL)


Error :: Table 'phpbb_ina_banned' already exists
SQL   :: CREATE TABLE phpbb_ina_banned ( `username` varchar(25) default NULL, `user_id` mediumint(8) default NULL, `player_ip` varchar(16) default NULL, `game` varchar(50) default NULL, `score` mediumint(8) default NULL, `date` varchar(16) default NULL)


Error :: Table 'phpbb_ina_cat' already exists
SQL   :: CREATE TABLE phpbb_ina_cat ( `cat_id` mediumint(8) NOT NULL auto_increment, `mod_id` mediumint(8) default NULL, `cat_name` varchar(100) default NULL, `cat_desc` text, `cat_icon` varchar(255) default NULL, `special_play` smallint(5) NOT NULL default '0', `last_game` varchar(25) default NULL, `last_player` mediumint(8) default NULL, `last_time` int(11) default NULL, PRIMARY KEY (`cat_id`) )


Error :: Table 'phpbb_ina_fav' already exists
SQL   :: CREATE TABLE phpbb_ina_fav ( `user_id` mediumint(8) NOT NULL default '0', `game_id` mediumint(9) NOT NULL default '0')


Error :: Table 'phpbb_ina_tour' already exists
SQL   :: CREATE TABLE phpbb_ina_tour ( `tour_id` mediumint(5) NOT NULL auto_increment, `tour_name` varchar(25) default NULL, `tour_desc` text, PRIMARY KEY (`tour_id`))


Error :: Table 'iNA_PMs_TABLE' already exists
SQL   :: CREATE TABLE iNA_PMs_TABLE ( `to_id` mediumint(8) NOT NULL default '0', `from_id` mediumint(8) NOT NULL default '0', `last_sent` int(11) NOT NULL default '0', `total_sent` mediumint(8) default NULL, `code` tinyint(4) default NULL)


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 'default '0', `last_played` varchar(25) default NULL, 
SQL   :: CREATE TABLE iNA_USER_DATA ( `user_id` mediumint(8) NOT default '0', `last_played` varchar(25) default NULL, `last_played_date` int(11) default NULL, `first_places` mediumint(9) default '0', `at_first_paces` mediumint(9) default '0', PRIMARY KEY (`user_id`))


Error :: Table 'wooky.phpbb_ina_games' doesn't exist
SQL   :: INSERT INTO phpbb_ina_games (`game_id`, `game_name`, `game_path`, `image_path`, `game_desc`, `game_charge`, `game_reward`, `game_bonus`, `game_use_gl`, `game_flash`, `game_show_score`, `win_width`, `win_height`, `highscore_limit`, `reverse_list`, `played`, `instructions`, `game_avail`, `allow_guest`, `cat_id`) VALUES (1, 'donkeykong', 'games/donkeykong/', '', 'The Classic - Donkey Kong', 0, 0, 0, 0, 1, 1, 448, 600, 0, 0, 0, 'CLICK where it says \'Press Space Bar To Start\' to start the game :(', 1, 1, NULL)


Error :: Duplicate entry 'default_reward_dbfield' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('default_reward_dbfield','user_points')


Error :: Duplicate entry 'default_cash' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('default_cash','0')


Error :: Duplicate entry 'use_rewards_mod' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('use_rewards_mod','0')


Error :: Duplicate entry 'use_cash_system' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('use_cash_system','0')


Error :: Duplicate entry 'report_cheater' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('report_cheater','0')


Error :: Duplicate entry 'warn_cheater' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('warn_cheater','0')


Error :: Duplicate entry 'use_point_system' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('use_point_system','0')


Error :: Duplicate entry 'use_gamelib' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('use_gamelib','0')


Error :: Duplicate entry 'games_path' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_path','games/')


Error :: Duplicate entry 'games_gl_path' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_gl_path','')


Error :: Duplicate entry 'gamelib_path' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('gamelib_path','')


Error :: Duplicate entry 'use_gk_shop' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('use_gk_shop','0')


Error :: Duplicate entry 'use_allowance_system' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('use_allowance_system','0')


Error :: Duplicate entry 'games_per_page' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_per_page','20')


Error :: Duplicate entry 'games_default_img' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_default_img','templates/subSilver/images/games.gif')


Error :: Duplicate entry 'games_default_txt' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_default_txt','More games available to Registered Members - No Fee - No Catch.
')


Error :: Duplicate entry 'games_default_id' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_default_id','0')


Error :: Duplicate entry 'games_offline' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_offline','0')


Error :: Duplicate entry 'games_cheat_mode' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_cheat_mode','1')


Error :: Duplicate entry 'games_guest_highscore' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_guest_highscore', '1')


Error :: Duplicate entry 'games_auto_size' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_auto_size', '1')


Error :: Duplicate entry 'games_at_highscore' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_at_highscore', '1')


Error :: Duplicate entry 'games_show_stats' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_show_stats', '1')


Error :: Duplicate entry 'games_image_width' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_image_width', '50')


Error :: Duplicate entry 'games_image_height' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_image_height', '50')


Error :: Duplicate entry 'games_cat_image_width' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_cat_image_width', '80')


Error :: Duplicate entry 'games_cat_image_height' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_cat_image_height', '80')


Error :: Duplicate entry 'games_per_admin_page' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_per_admin_page', '20')


Error :: Duplicate entry 'games_tournament_max' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_tournament_max', '10')


Error :: Duplicate entry 'games_tournament_games' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_tournament_games', '6')


Error :: Duplicate entry 'games_tournament_players' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_tournament_players', '12')


Error :: Duplicate entry 'games_moderators_mode' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_moderators_mode', '0')


Error :: Duplicate entry 'games_posts_required' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_posts_required', '1')


Error :: Duplicate entry 'games_use_pms' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_use_pms', '1')


Error :: Duplicate entry 'games_total_top' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_total_top', '10')


Error :: Duplicate entry 'games_new_games' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_new_games', '1')


Error :: Duplicate entry 'games_cat_zero' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_cat_zero', 'Show all the Games')


Error :: Duplicate entry 'games_use_comments' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_use_comments', '0')


Error :: Duplicate entry 'games_use_rating' for key 1
SQL   :: INSERT INTO phpbb_config VALUES ('games_use_rating', '0')


Contact me so I can fix the errors.

Was läuft da schief???

Gruß, Eloi

[modbo]

>Was läuft da schief???
Nix. Die Einträge sind schon vorhanden (already exists; Duplicate entry)

Der Mod ist aber nach wie vor Buggy und in der ALPHA Version.