Ich kann keine Backups mehr wiederherstellen, wenn ich in einen Thread gehen will folgende Fehler
Code: Alles auswählen
SQL ERROR [ mysql4 ]
Tabelle 'usr_web171_3.phpbb3_posts' existiert nicht [1146]
SQL
SELECT p.post_id FROM phpbb3_posts p WHERE p.topic_id = 68 ORDER BY p.post_time ASC LIMIT 30
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()
FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: viewtopic.php
LINE: 896
CALL: dbal_mysql->sql_query_limit()
und
Code: Alles auswählen
SQL ERROR [ mysql4 ]
BLOB- oder TEXT-Spalte 'post_text' wird in der Schlüsseldefinition ohne Schlüssellängenangabe verwendet [1170]
SQL
CREATE TABLE phpbb3_posts( post_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL, forum_id mediumint(8) unsigned DEFAULT '0' NOT NULL, poster_id mediumint(8) unsigned DEFAULT '0' NOT NULL, icon_id mediumint(8) unsigned DEFAULT '0' NOT NULL, poster_ip varchar(40) DEFAULT '' NOT NULL, post_time int(11) unsigned DEFAULT '0' NOT NULL, post_approved tinyint(1) unsigned DEFAULT '1' NOT NULL, post_reported tinyint(1) unsigned DEFAULT '0' NOT NULL, enable_bbcode tinyint(1) unsigned DEFAULT '1' NOT NULL, enable_smilies tinyint(1) unsigned DEFAULT '1' NOT NULL, enable_magic_url tinyint(1) unsigned DEFAULT '1' NOT NULL, enable_sig tinyint(1) unsigned DEFAULT '1' NOT NULL, post_username varchar(255) DEFAULT '' NOT NULL, post_subject varchar(100) DEFAULT '' NOT NULL, post_text mediumtext NOT NULL, post_checksum varchar(32) DEFAULT '' NOT NULL, post_attachment tinyint(1) unsigned DEFAULT '0' NOT NULL, bbcode_bitfield varchar(255) DEFAULT '' NOT NULL, bbcode_uid varchar(8) NOT NULL, post_postcount tinyint(1) unsigned DEFAULT '1' NOT NULL, post_edit_time int(11) unsigned DEFAULT '0' NOT NULL, post_edit_reason varchar(255) DEFAULT '' NOT NULL, post_edit_user mediumint(8) unsigned DEFAULT '0' NOT NULL, post_edit_count smallint(4) unsigned DEFAULT '0' NOT NULL, post_edit_locked tinyint(1) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), KEY poster_ip (poster_ip), KEY poster_id (poster_id), KEY post_approved (post_approved), KEY tid_post_time (topic_id, post_time), KEY post_subject (post_subject), KEY post_text (post_text), KEY post_content (post_subject, post_text) )
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()
FILE: includes/acp/acp_database.php
LINE: 325
CALL: dbal_mysql->sql_query()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_database->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Kann man Backups auch ohne Adminmenü starten?