Datenbank Backup funtzt net.. :(

[Remus]

Meine Backup Datei lässt sich nicht uploaden. Fehlermeldung: Keine nur der unten gezeigte Text erscheind.

Powered by phpBB 2.0.17 © 2001 phpBB Group

Gehe im phpbb Adminbereich auf Datenbank wiederherstellen, danach such ich den Pfad auf meiner hdd klicke auf Wiederherstellung beginnen und er uppt die SQL Datei heißt genau so wie die DB! Wenn er fertig ist gibts keinerlei Meldung.. DB ist ca 13MB groß!

Kann mir einer weiterhelfen??


phpbb Version Powered by phpBB 2.0.17 © 2001

[Markus67]

Hi ...

vergiss die Importfunktion im Adminbereich.
KB:mysqlbackup

Mein persönlicher Favorit ... KB:bigdump

Markus

[gloriosa]

Hallo,
in der Knowledge Base ist dieser Beitrag >>> KB:mysqlbackup <<< enthalten, welcher weiterhelfen sollte !

[Remus]

Danke Jungs für die super schnellen Antworten gleich mal prob

[Remus]

Jetzt bekomme ich die FM :

phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('ebc409090a1864500c981552969d371d', 2, 1129579656, 1129579656, '5498570f', 0, 1, 0)

Line : 172
File : sessions.php

[gott]

spiel noch mal die

update_to_latest.php auf bzw. noch schneller

Code: Alles auswählen

ALTER TABLE phpbb_sessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL; 

[Remus]

Updating to latest stable release

Information

Database type :: mysql4
Previous version :: 2.0.13
Updated version :: 2.0.17
Updating database schema

Progress :: . Done
Result :: No errors
Updating data

Progress :: . .
Updating version and optimizing tables

Progress :: . . Done
Result :: No errors
Update completed

Please make sure you have updated your board files too, this file is only updating your database.

You should now visit the General Configuration settings page in the Administration Panel and check the General Configuration of the board. If you updated from versions prior to RC-3 you must update some entries. If you do not do this emails sent from the board will contain incorrect information. Don't forget to delete this file!

Danach bekomme ich die Meldung:
phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('ae2002dd289742e73bd72ce31b43957c', 2, 1129580466, 1129580466, '5498570f', 0, 1, 0)

Line : 172
File : sessions.php

[gott]

damit wird die Fehlermeldung deutlicher

Code: Alles auswählen

 

#
#-----[ OPEN ]------------------------------------------------
#
includes/functions.php
#
#-----[ FIND ]------------------------------------------------
#
   if(defined('HAS_DIED'))
#
#-----[ BEFORE, ADD ]-----------------------------------------
#
//+MOD: Fix message_die for multiple errors MOD
   static $msg_history;
   if( !isset($msg_history) )
   {
      $msg_history = array();
   }
   $msg_history[] = array(
      'msg_code'   => $msg_code,
      'msg_text'   => $msg_text,
      'msg_title'   => $msg_title,
      'err_line'   => $err_line,
      'err_file'   => $err_file,
      'sql'      => $sql
   );
//-MOD: Fix message_die for multiple errors MOD

#
#-----[ FIND ]------------------------------------------------
#
      die("message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?");
#
#-----[ REPLACE WITH ]----------------------------------------
#
//+MOD: Fix message_die for multiple errors MOD

      //
      // This message is printed at the end of the report.
      // Of course, you can change it to suit your own needs. ;-)
      //
      $custom_error_message = 'Please, contact the %swebmaster%s. Thank you.';
      if ( !empty($board_config) && !empty($board_config['board_email']) )
      {
         $custom_error_message = sprintf($custom_error_message, '<a href="mailto:' . $board_config['board_email'] . '">', '</a>');
      }
      else
      {
         $custom_error_message = sprintf($custom_error_message, '', '');
      }
      echo "<html>\n<body>\n<b>Critical Error!</b><br />\nmessage_die() was called multiple times.<br />&nbsp;<hr />";
      for( $i = 0; $i < count($msg_history); $i++ )
      {
         echo '<b>Error #' . ($i+1) . "</b>\n<br />\n";
         if( !empty($msg_history[$i]['msg_title']) )
         {
            echo '<b>' . $msg_history[$i]['msg_title'] . "</b>\n<br />\n";
         }
         echo $msg_history[$i]['msg_text'] . "\n<br /><br />\n";
         if( !empty($msg_history[$i]['err_line']) )
         {
            echo '<b>Line :</b> ' . $msg_history[$i]['err_line'] . '<br /><b>File :</b> ' . $msg_history[$i]['err_file'] . "</b>\n<br />\n";
         }
         if( !empty($msg_history[$i]['sql']) )
         {
            echo '<b>SQL :</b> ' . $msg_history[$i]['sql'] . "\n<br />\n";
         }
         echo "&nbsp;<hr />\n";
      }
      echo $custom_error_message . '<hr /><br clear="all">';
      die("</body>\n</html>");
//-MOD: Fix message_die for multiple errors MOD
#
#-----[ FIND ]------------------------------------------------
#
   define(HAS_DIED, 1);
#
#-----[ REPLACE WITH ]----------------------------------------
#
   define('HAS_DIED', 1);
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM 

[Remus]

hmm kann keinen Fehler finden hab die sessions table im phpadmin geleert nicht gelöscht bringt auch nix

[Remus]

HURRA es geht weis zwar nimmer wie aber es geht !