Seite 1 von 2

Board wiederherstellen

Verfasst: 04.12.2002 16:48
von water2k
Hallo zusammen
ich habe das Board laufen und ist für meine Klasse gedacht. Gestern muss ich irgend etwas falsch gemacht haben und die ganze Software ist mir abgeschmiert. Da ich immer wenn ich online bin ein Datenbank-Backup mache habe ich gedacht, dass es eigentlich kein Problem sein sollte, das Teil wiederherzustellen - Fehlanzeige. Auch nach neuem Upload der Boardsoftware ist es mir nicht möglich, es wiederherzustellen. Die Wiederherstellung fängt gut, an, er bricht aber nach einiger Zeit ab und bring folgende Fehlermeldung: Error importing backup file

Die Foren hat er dann schon angeordnet und er schreibt dann sogar wieder hin, wie viel Posts in dem Forum sind, die Foren sind dann aber leer, die Benutzer sind auch noch nicht wiederhergestellt.

Kann mir jemand bei diesem Problem helfen???
Vielen Dank schon mal im Vorraus

Gruß
Water2k

Verfasst: 04.12.2002 16:53
von Mister_X
Wie groß ist den die Backupfile ? Ansonsten probiere auch mal mit der Methode hier einzuspielen: http://www.phpbb.de/viewtopic.php?t=6197

Verfasst: 04.12.2002 19:40
von water2k
die datei ist 174 kb groß.

für die andere methode ist es zu spät, war zu voreilig...

Verfasst: 04.12.2002 20:29
von Mister_X
174 kb ist aber sehr klein, wieviel Beiträge hattest du den in deinem Forum ? (ca.) Ich würde fast sagen, da hat die Backupfunktion von phpBB2 mal wieder Mist gebaut ... :o

Verfasst: 05.12.2002 10:19
von water2k
es waren ca. 189 threats, dazu ca. 500 posts, wenn ich mich nicht täusch. hast du ne idee, wie ich es wiederherstellen kann oder ist alles futsch?

Verfasst: 05.12.2002 12:38
von Mister_X
hm für 500 Posts erscheint mit 174 kb wirklich klein, nenne mal den Anfang und das Ende der Datei (also ein paar Zeilen vom Anfang und ein paar vom Ende hierher posten) oder hast du per GZIP gespeichert ?

Verfasst: 05.12.2002 13:31
von water2k
also es ist nicht gzip, hab das teil einfach mal im editor geöffnet:

#
# phpBB Backup Script
# Dump of tables for ebler_reparaturen_de
#
# DATE : 03-12-2002 15:06:01 GMT
#
#
# TABLE: phpbb_auth_access
#
DROP TABLE IF EXISTS phpbb_auth_access;
CREATE TABLE phpbb_auth_access(
group_id mediumint(8) NOT NULL,
forum_id smallint(5) unsigned NOT NULL,
auth_view tinyint(1) NOT NULL,
auth_read tinyint(1) NOT NULL,
auth_post tinyint(1) NOT NULL,
auth_reply tinyint(1) NOT NULL,
auth_edit tinyint(1) NOT NULL,
auth_delete tinyint(1) NOT NULL,
auth_sticky tinyint(1) NOT NULL,
auth_announce tinyint(1) NOT NULL,
auth_vote tinyint(1) NOT NULL,
auth_pollcreate tinyint(1) NOT NULL,
auth_attachments tinyint(1) NOT NULL,
auth_mod tinyint(1) NOT NULL,
KEY group_id (group_id),
KEY forum_id (forum_id)
);

#
# Table Data for phpbb_auth_access
#

INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '11', '13', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '12', '13', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '8', '13', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '19', '13', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '15', '13', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '15', '18', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '12', '18', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '8', '18', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '11', '18', '1', '1', '1', '1', '1', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '11', '16', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '14', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '18', '9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '18', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '14', '18', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES( '14', '15', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_

.
.
.




ad>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- link rel="stylesheet" href="../templates/subRed/subRed.css" type="text/css" -->
<style type="text/css">
<!--

/*
The subRed Theme for phpBB version 2+
Created by Karl Tauber
http://www.ktauber.com

Based on the original subSilver Theme for phpBB version 2+
Created by subBlue design
http://www.subBlue.com

NOTE: These CSS definitions are stored within the main page body so that you can use the phpBB2
theme administration centre. When you have finalised your style you could cut the final CSS code
and place it in an external file, deleting this section to save bandwidth.
*/


/* General page style. The scroll bar colours only visible in IE5.5+ */
body {
background-color: #fffcfc;
scrollbar-face-color: #f7eeee;
scrollbar-highlight-color: #FFFFFF;
scrollbar-shadow-color: #f7eeee;
scrollbar-3dlight-color: #F5E9E9;
scrollbar-arrow-color: #800000;
scrollbar-track-color: #fbf5f5;
scrollbar-darkshadow-color: #cc9999;
}

/* General font families for common tags */
font,th,td,p { font-family: Verdana, Arial, Helvetica, sans-serif }
p, td { font-size : 11; color : #000000; }
a:link,a:active,a:visited { color : #800000; }
a:hover { text-decoration: underline; color : #DD6900; }
hr { height: 0px; border: solid #F5E9E9 0px; border-top-width: 1px;}
h1,h2 { font-family: "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; font-size : 22px; font-weight : bold; text-decoration : none; line-height : 120%; color : #000000;}


/* This is the border line & background colour round the entire page */
.bodyline { background-color: #FFFFFF; border: 1px #cc9999 solid; }

/* This is the outline round the main forum tables */
.forumline { background-color: #FFFFFF; border: 2px #BC8F8F solid; }


/* Main table cell colours and backgrounds */
td.row1 { background-color: #fbf5f5; }
td.row2 { background-color: #f7eeee; }
td.row3 { background-color: #F5E9E9; }


/*
This is for the table cell above the Topics, Post & Last posts on the index.php page
By default this is the fading out gradiated silver background.
However, you could replace this with a bitmap specific for each forum
*/
td.rowpic {
background-color: #FFFFFF;
background-image: url(../templates/subRed/images/subRed/cellpic2.jpg);
background-repeat: repeat-y;
}

/* Header cells - the blue and silver gradient backgrounds */
th {
color: #FFB572; font-size: 11px; font-weight : bold;
background-color: #800000; height: 25px;
background-image: url(../templates/subRed/images/subRed/cellpic3.gif);
}

td.cat,td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom {
background-image: url(../templates/subRed/images/subRed/cellpic1.gif);
background-color:#F5E9E9; border: #FFFFFF; border-style: solid; height: 28px;
}


/*
Setting additional nice inner borders for the main table cells.
The names indicate which sides the border will be on.
Don't worry if you don't understand this, just ignore it :-)
*/
td.cat,td.catHead,td.catBottom {
height: 29px;
border-width: 0px 0px 0px 0px;
}
th.thHead,th.thSides,th.thTop,th.thLeft,th.thRight,th.thBottom,th.thCornerL,th.thCornerR {
font-weight: bold; border: #FFFFFF; border-style: solid; height: 28px; }
td.row3Right,td.spaceRow {
background-color: #F5E9E9; border: #FFFFFF; border-style: solid; }

th.thHead,td.catHead { font-size: 12px; border-width: 1px 1px 0px 1px; }
th.thSides,td.catSides,td.spaceRow { border-width: 0px 1px 0px 1px; }
th.thRight,td.catRight,td.row3Right { border-width: 0px 1px 0px 0px; }
th.thLeft,td.catLeft { border-width: 0px 0px 0px 1px; }
th.thBottom,td.catBottom { border-width: 0px 1px 1px 1px; }
th.thTop { border-width: 1px 0px 0px 0px; }
th.thCornerL { border-width: 1px 0px 0px 1px; }
th.thCornerR { border-width: 1px 1px 0px 0px; }


/* The largest text used in the index page title and toptic title etc. */
.maintitle {
font-weight: bold; font-size: 22px; font-family: "Trebuchet MS",Verdana, Arial, Helvetica, sans-serif;
text-decoration: none; line-height : 120%; color : #000000;
}


/* General text */
.gen { font-size : 12px; }
.genmed { font-size : 11px; }
.gensmall { font-size : 10px; }
.gen,.genmed,.gensmall { color : #000000; }
a.gen,a.genmed,a.gensmall { color: #800000; text-decoration: none; }
a.gen:hover,a.genmed:hover,a.gensmall:hover { color: #DD6900; text-decoration: underline; }


/* The register, login, search etc links at the top of the page */
.mainmenu { font-size : 11px; color : #000000 }
a.mainmenu { text-decoration: none; color : #800000; }
a.mainmenu:hover{ text-decoration: underline; color : #DD6900; }


/* Forum category titles */
.cattitle { font-weight: bold; font-size: 12px ; letter-spacing: 1px; color : #800000}
a.cattitle { text-decoration: none; color : #800000; }
a.cattitle:hover{ text-decoration: underline; }


/* Forum title: Text and link to the forums used in: index.php */
.forumlink { font-weight: bold; font-size: 12px; color : #800000; }
a.forumlink { text-decoration: none; color : #800000; }
a.forumlink:hover{ text-decoration: underline; color : #DD6900; }


/* Used for the navigation text, (Page 1,2,3 etc) and the navigation bar when in a forum */
.nav { font-weight: bold; font-size: 11px; color : #000000;}
a.nav { text-decoration: none; color : #800000; }
a.nav:hover { text-decoration: underline; }



/* Name of poster in viewmsg.php and viewtopic.php and other places */
.name { font-size : 11px; color : #000000;}

/* Location, number of posts, post date etc */
.postdetails { font-size : 10px; color : #000000; }


/* The content of the posts (body of text) */
.postbody { font-size : 12px; line-height: 18px}
a.postlink:link { text-decoration: none; color : #800000 }
a.postlink:visited { text-decoration: none; color : #b00000; }
a.postlink:hover { text-decoration: underline; color : #DD6900}


/* Quote & Code blocks */
.code {
font-family: Courier, 'Courier New', sans-serif; font-size: 11px; color: #800000;
background-color: #FAFAFA; border: #F5E9E9; border-style: solid;
border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px
}

.quote {
font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #444444; line-height: 125%;
background-color: #FAFAFA; border: #F5E9E9; border-style: solid;
border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px
}


/* Copyright and bottom info */
.copyright { font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #444444; letter-spacing: -1px;}
a.copyright { color: #444444; text-decoration: none;}
a.copyright:hover { color: #000000; text-decoration: underline;}


/* Form elements */
input,textarea, select {
color : #000000;
font: normal 11px Verdana, Arial, Helvetica, sans-serif;
border-color : #000000;
}

/* The text input fields background colour */
input.post, textarea.post, select {
background-color : #FFFFFF;
}

input { text-indent : 2px; }

/* The buttons used for bbCode styling in message post */
input.button {
background-color : #fbf5f5;
color : #000000;
font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif;
}

/* The main submit button option */
input.mainoption {
background-color : #FAFAFA;
font-weight : bold;
}

/* None-bold submit button */
input.liteoption {
background-color : #FAFAFA;
font-weight : normal;
}

/* This is the line in the posting page which shows the rollover
help line. This is actually a text box, but if set to be the same
colour as the background no one will know ;)
*/
.helpline { background-color: #f7eeee; border-style: none; }


/* Import the fancy styles for IE only (NS4.x doesn't use the @import function) */
@import url("../templates/subRed/formIE.css");
-->
</style>
<title>TGI-E - Forum - </title>
</head>
<body bgcolor="#fffcfc" text="#000000" link="#800000" vlink="#b00000">

<a name="top"></a>


<br /><br />

<table width="100%" cellpadding="4" cellspacing="1" border="0" class="forumline">
<tr>
<th class="thHead" align="center">Allgemeiner Fehler</th>
</tr>
<tr>
<td class="row1" width="100%" align="center"><span class="gen">Failed in get_table_def (show fields)</span></td>
</tr>
</table>

<br />


<!--

Please note that the following copyright notice
MUST be displayed on each and every page output
by phpBB. You may alter the font, colour etc. but
you CANNOT remove it, nor change it so that it be,
to all intents and purposes, invisible. You may ADD
your own notice to it should you have altered the
code but you may not replace it. The hyperlink must
also remain intact. These conditions are part of the
licence this software is released under. See the
LICENCE and README files for more information.

The phpBB Group : 2001

//-->

<div align="center"><span class="copyright">Powered by phpBB 2.0.3 &copy; 2001 <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB Group</a><br /></span></div>

</body>
</html>


greetz
water

Verfasst: 05.12.2002 13:33
von water2k
oh, im editor war es kleiner, sorry

Verfasst: 05.12.2002 13:52
von Mister_X
also der Teil am Schluss ist nicht richtig, da hat die Backupfunktion Mist gebaut.
Suche mal ob du
Zeilen mit
INSERT INTO phpbb_users
und
INSERT INTO phpbb_posts

findest ?

Verfasst: 05.12.2002 14:08
von water2k
also die zeile INSERT INTO phpbb_post ist da (ca. 500 mal) aber die zeile INSERT INTO phpbb_users fehlt.