phpBB.de

Error in retrieving solutions

DEBUG MODE

SQL Error : 1146 Table 'DB119776.phpbb_sudoku_starts' doesn't exist

SELECT game_pack, game_num FROM phpbb_sudoku_starts ORDER BY game_pack DESC, game_num DESC LIMIT 1

Line : 60
File : game_pack_2.php

fgew hat geschrieben:Hallo zusammen!

Habe mir den Sudoku Mod installiert und er funktioniert einwandfrei.
Nun wollte ich die Game Packs installieren.
Leider bekomme ich beim Aufruf der "game_pack_2.php" folgende Fehlermeldung:

Error in retrieving solutions

DEBUG MODE

SQL Error : 1146 Table 'DB119776.phpbb_sudoku_starts' doesn't exist

SELECT game_pack, game_num FROM phpbb_sudoku_starts ORDER BY game_pack DESC, game_num DESC LIMIT 1

Line : 60
File : game_pack_2.php

Weiß jemand wie ich dieses Problem beheben kann?

Vielen Dank

fgew

INSERT INTO `phpbb_womoconfig` ( `config_name` , `config_value` ) VALUES ( 'sudoku_version', '1.0.7' )
+++ Error: Duplicate entry 'sudoku_version' for key 1

ALTER TABLE `phpbb_womousers` ADD `user_sudoku_playing` INT( 1 ) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'user_sudoku_playing'

CREATE TABLE `phpbb_womosudoku_solutions` ( `game_pack` int(5) NOT NULL default '0', `game_num` int(5) NOT NULL default '0', `line_1` varchar(20) NOT NULL default '', `line_2` varchar(20) NOT NULL default '', `line_3` varchar(20) NOT NULL default '', `line_4` varchar(20) NOT NULL default '', `line_5` varchar(20) NOT NULL default '', `line_6` varchar(20) NOT NULL default '', `line_7` varchar(20) NOT NULL default '', `line_8` varchar(20) NOT NULL default '', `line_9` varchar(20) NOT NULL default '', KEY `game_pack` (`game_pack`) )
+++ Error: Table 'phpbb_womosudoku_solutions' already exists

CREATE TABLE `phpbb_womosudoku_stats` ( `user_id` int(11) NOT NULL default '0', `played` int(11) NOT NULL default '0', `points` int(11) NOT NULL default '0', KEY `user_id` (`user_id`) )
+++ Error: Table 'phpbb_womosudoku_stats' already exists

CREATE TABLE `phpbb_womosudoku_sessions` ( `user_id` INT( 11 ) NOT NULL , `session_time` INT( 11 ) NOT NULL )
+++ Error: Table 'phpbb_womosudoku_sessions' already exists

INSERT INTO `phpbb_womosudoku_solutions` VALUES (1, 1, '7a1a5a2a3a4a9a8a6', '6a4a3a1a8a9a5a7a2', '8a2a9a6a7a5a1a3a4', '8a7a9a3a6a1a4a5a2', '4a5a1a2a9a8a7a3a6', '2a6a3a5a4a7a9a8a1', '5a9a8a1a4a7a6a2a3', '3a6a7a8a2a5a9a1a4', '4a1a2a3a9a6a7a5a8')
+++ Successful

Der Rest stimmt dann bis 20
Dann kommt wieder eine Fehlermeldung

CREATE TABLE `phpbb_womosudoku_starts` ( `game_pack` int(5) NOT NULL default '0', `game_num` int(5) NOT NULL default '0', `game_level` int(1) NOT NULL default '0', `line_1` varchar(20) NOT NULL default '', `line_2` varchar(20) NOT NULL default '', `line_3` varchar(20) NOT NULL default '', `line_4` varchar(20) NOT NULL default '', `line_5` varchar(20) NOT NULL default '', `line_6` varchar(20) NOT NULL default '', `line_7` varchar(20) NOT NULL default '', `line_8` varchar(20) NOT NULL default '', `line_9` varchar(20) NOT NULL default '', KEY `game_pack` (`game_pack`) )
+++ Error: Table 'phpbb_womosudoku_starts' already exists

INSERT INTO `phpbb_womosudoku_starts` VALUES (1, 1, 1, 'xaxaxa2axa4a9a8ax', '6axa3axaxaxa5axa2', 'xaxaxa6axa5axa3a4', '8axa9axaxaxa4axa2', 'xaxaxa2axa8axaxax', '2axa3axaxaxa9axa1', '5a9axa1axa7axaxax', '3axa7axaxaxa9axa4', 'xa1a2a3axa6axaxax')
+++ Successful

Der Rest stimmt dann wieder bis 20
Dann kommt wieder eine Fehlermeldung

CREATE TABLE `phpbb_womosudoku_users` ( `user_id` int(11) NOT NULL default '0', `game_pack` int(5) NOT NULL default '0', `game_num` int(5) NOT NULL default '0', `game_level` int(1) NOT NULL default '0', `line_1` varchar(30) NOT NULL default '', `line_2` varchar(30) NOT NULL default '', `line_3` varchar(30) NOT NULL default '', `line_4` varchar(30) NOT NULL default '', `line_5` varchar(30) NOT NULL default '', `line_6` varchar(30) NOT NULL default '', `line_7` varchar(30) NOT NULL default '', `line_8` varchar(30) NOT NULL default '', `line_9` varchar(30) NOT NULL default '', `points` int(11) NOT NULL default '0', `done` int(1) NOT NULL default '0', KEY `user_id` (`user_id`) )
+++ Error: Table 'phpbb_womosudoku_users' already exists

Error in retrieving Sudoku grid data

DEBUG MODE

SQL Error : 1146 Table 'anna.phpbb_sudoku_starts' doesn't exist

SELECT game_pack FROM phpbb_sudoku_starts ORDER BY game_pack DESC LIMIT 1

Line : 61
File : sudoku.php