Seite 1 von 1

Arcade Mod / mod_install.php fehlerhaft?

Verfasst: 03.07.2005 16:24
von UserXY
Hi Leute.... also ich hab versucht den Arcade Mod einzubauen aber leider ist mir da irgendwo ein fehler unterlaufen, beim aufruf kommt nur:

Incorrect Installation, Version Missmatch v2.0.0 should be v2.0.7. Run mod_upgrade.php

hm toll gibt keine mod_upgrade.php datei im ordner, aber es gibt z.b mod_upgrade_201_204.php aber wenn ich keine version vorher installiert hab muss ich ja nix updaten oder?

Achja bei der mod_install.php kommt folgender fehler:

Parse error: parse error in /usr/local/apache/www/web4/board/mod_install.php on line 240
$sql[] = "CREATE TABLE " . iNA_USER_DATA (
`user_id` mediumint(8) NOT NULL 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`))";
Ich glaube der fehler liegt da oben da fehlt ein . " oder?
also so ungefähr:

$sql[] = "CREATE TABLE " . iNA_USER_DATA . " (

nun gut so bearbeitet raufgeladen und ausgeführt...

kommt folgendes:
nformation

Database type :: mysql4
phpBB version :: 2.0.16
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 near 'cat_id` mediumint(8) default NULL, `game_name` varchar(50) default NULL, ' at line 3
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 :: Table 'phpbb_ina_user_data' already exists
SQL :: CREATE TABLE phpbb_ina_user_data ( `user_id` mediumint(8) NOT NULL 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 :: Unknown column 'image_path' in 'field list'
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.
Gut einige sachen gibts scho, woher ka aber egal aber was ist mit den anderen sachen?

Verfasst: 03.07.2005 18:08
von modbo

Verfasst: 03.07.2005 20:14
von UserXY
Also hab den jetzt eingebaut
Database type :: mysql4
phpBB version :: 2.0.16
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 :: Table 'phpbb_ina_games' already exists
SQL :: CREATE TABLE phpbb_ina_games ( `game_id` mediumint(9) NOT NULL auto_increment, `cat_id` mediumint(8) default NULL, `game_name` varchar(25) 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, PRIMARY KEY (`game_id`))

* Error :: Table 'phpbb_ina_scores' already exists
SQL :: CREATE TABLE phpbb_ina_scores ( `game_name` varchar(255) 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(255) 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(25) 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(25) 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, `name` varchar(100) default NULL, `desc` text, `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 :: Duplicate entry '1' for key 1
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','')

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

* 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','')

* 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_per_admin_page' for key 1
SQL :: INSERT INTO phpbb_config VALUES ('games_per_admin_page', '')
Na gut nicht nur das wenn ich im Admin menü worauf gehe steht:
ERROR, No Game Data Received


DEBUG MODE

SQL Error : 1054 Unknown column 'name' in 'field list'

SELECT cat_id, name FROM phpbb_ina_cat ORDER BY cat_id

Line : 661
File : admin_arcade.php
na gut wenn ich im menü auf games gehe komm ich auch nicht zu den spielen weil angeblich der ordner nicht existiert.
Warning: getimagesize(): Unable to access games/donkeykong/donkeykong.swf in /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php on line 130

Warning: getimagesize(games/donkeykong/donkeykong.swf): failed to open stream: Datei oder Verzeichnis nicht gefunden in /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php on line 130

Warning: getimagesize(): Unable to access games/donkeykong/donkeykong.swf in /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php on line 130

Warning: getimagesize(games/donkeykong/donkeykong.swf): failed to open stream: Datei oder Verzeichnis nicht gefunden in /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php on line 130

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php:130) in /usr/local/apache/www/web4/html/JP/board/board/includes/page_header.php on line 514

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php:130) in /usr/local/apache/www/web4/html/JP/board/board/includes/page_header.php on line 516

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache/www/web4/html/JP/board/board/includes/functions_arcade.php:130) in /usr/local/apache/www/web4/html/JP/board/board/includes/page_header.php on line 517
Diese errormeldung erhalte ich auch noch im admin panel
hmm nice nice
AHHH bitte helft mir den mod einzubauen..

Verfasst: 03.07.2005 20:24
von UserXY
jetzt n update gemacht:
Database type :: mysql4
phpBB version :: 2.0.16
Updating database schema & data

Progress :: .............................. Done
Result :: Some queries failed, the statements and errors are listing below

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

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

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

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

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

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

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

* Error :: Duplicate entry 'games_use_pms' for key 1
SQL :: INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_use_pms', '0')

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

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

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

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

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

* Error :: Unknown column 'name' in 'phpbb_ina_cat'
SQL :: ALTER TABLE phpbb_ina_cat CHANGE `name` `cat_name` VARCHAR( 100 ) DEFAULT NULL

* Error :: Unknown column 'desc' in 'phpbb_ina_cat'
SQL :: ALTER TABLE phpbb_ina_cat CHANGE `desc` `cat_desc` TEXT DEFAULT NULL

Verfasst: 03.07.2005 21:23
von modbo
Die ganzen SQL errors kannst du mal vergessen. Sagen nur aus, dass die Einträge bereits existieren.

Der Mod sollte auch bereits in der 2.0.6er Version funktionieren (bis auf Fehlermeldung im ACP).
Lösch bitte mal alle Datenbankeinträge den Activity Mod betreffend. Anschließend nur die mod_install.php aus der 2.0.6er version und anschließend die mod_upgrade.php aus der 2.0.7er version ausführen.

Verfasst: 03.07.2005 21:28
von MartinWilli83
verlinke in zukunft vieleicht die ferhlermeldungen als textdatei da die ja doch ziemlich lang sind