I stumbled over a few errors in Database restore, Because a friend tried to restore his DB and ran into error´s.
To me it look´s like something in the Backup Utility is asigning Default´s to lines in tables there no default should be.
Due to that 9 Tables are´nt created on restore and could show up as errors during post´s
I´ve listed the Original and backup tables In the spoiler
Spoiler: [ Show ]
Spoiler: [ Hide ]
Original
## ICY PHOENIX LOGS - BEGIN
CREATE TABLE `phpbb_logs` (
`log_id` int(11) unsigned NOT NULL auto_increment,
`log_time` varchar(11) NOT NULL,
`log_page` varchar(255) NOT NULL DEFAULT '',
`log_user_id` int(10) NOT NULL,
`log_action` varchar(60) NOT NULL DEFAULT '',
`log_desc` varchar(255) NOT NULL DEFAULT '',
`log_target` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`log_id`)
);
## ICY PHOENIX LOGS – END
--------------------------------------------------------------
Backup
# Table: ip_logs
DROP TABLE IF EXISTS ip_logs;
CREATE TABLE ip_logs(
log_id int(11) unsigned NOT NULL auto_increment,
log_time varchar(11) DEFAULT '' NOT NULL,
log_page varchar(255) DEFAULT '' NOT NULL,
log_user_id int(10) DEFAULT '' NOT NULL,
log_action varchar(60) DEFAULT '' NOT NULL,
log_desc varchar(255) DEFAULT '' NOT NULL,
log_target int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (log_id)
--------------------------------------------------------------------------
Original
CREATE TABLE phpbb_dl_auth (
cat_id INT(11) NOT NULL,
group_id INT(11) NOT NULL,
auth_view TINYINT(1) DEFAULT '1' NOT NULL,
auth_dl TINYINT(1) DEFAULT '1' NOT NULL,
auth_up TINYINT(1) DEFAULT '1' NOT NULL,
auth_mod TINYINT(1) DEFAULT '0' NOT NULL
);
--------------------------------------------------------------------------
Backup
# Table: ip_dl_auth
DROP TABLE IF EXISTS ip_dl_auth;
CREATE TABLE ip_dl_auth(
cat_id int(11) DEFAULT '' NOT NULL,
group_id int(11) DEFAULT '' NOT NULL,
auth_view tinyint(1) DEFAULT '1' NOT NULL,
auth_dl tinyint(1) DEFAULT '1' NOT NULL,
auth_up tinyint(1) DEFAULT '1' NOT NULL,
auth_mod tinyint(1) DEFAULT '0' NOT NULL
);
--------------------------------------------------------------------------
Original
## AJAX Shoutbox - BEGIN
CREATE TABLE phpbb_ajax_shoutbox (
shout_id MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT(8) NOT NULL,
shouter_name VARCHAR(30) NOT NULL DEFAULT 'guest',
shout_text TEXT NOT NULL,
shouter_ip VARCHAR(8) NOT NULL DEFAULT '',
shout_time INT(11) NOT NULL,
PRIMARY KEY ( shout_id )
);
CREATE TABLE `phpbb_ajax_shoutbox_sessions` (
`session_id` int(10) NOT NULL,
`session_user_id` mediumint(8) NOT NULL DEFAULT '0',
`session_username` varchar(25) NOT NULL DEFAULT '',
`session_ip` varchar(8) NOT NULL DEFAULT '0',
`session_start` int(11) NOT NULL DEFAULT '0',
`session_time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`session_id`)
);
## AJAX Shoutbox – END
------------------------------------------------------------------------------
Backup
# Table: ip_ajax_shoutbox
DROP TABLE IF EXISTS ip_ajax_shoutbox;
CREATE TABLE ip_ajax_shoutbox(
shout_id mediumint(9) unsigned NOT NULL auto_increment,
user_id mediumint(8) DEFAULT '' NOT NULL,
shouter_name varchar(30) DEFAULT 'guest' NOT NULL,
shout_text text DEFAULT '' NOT NULL,
shouter_ip varchar(8) DEFAULT '' NOT NULL,
shout_time int(11) DEFAULT '' NOT NULL,
PRIMARY KEY (shout_id)
);
# Table: ip_ajax_shoutbox_sessions
DROP TABLE IF EXISTS ip_ajax_shoutbox_sessions;
CREATE TABLE ip_ajax_shoutbox_sessions(
session_id int(10) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_username varchar(25) DEFAULT '' NOT NULL,
session_ip varchar(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id)
);
-----------------------------------------------------------------------------
Original
CREATE TABLE `phpbb_ctracker_filescanner` (
`id` smallint(5) NOT NULL,
`filepath` text,
`safety` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
CREATE TABLE `phpbb_ctracker_ipblocker` (
`id` mediumint(8) unsigned NOT NULL,
`ct_blocker_value` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`)
);
---------------------------------------------------------------------------------
Backup
# Table: ip_ctracker_filescanner
DROP TABLE IF EXISTS ip_ctracker_filescanner;
CREATE TABLE ip_ctracker_filescanner(
id smallint(5) DEFAULT '' NOT NULL,
filepath text,
safety smallint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
# Table: ip_ctracker_ipblocker
DROP TABLE IF EXISTS ip_ctracker_ipblocker;
CREATE TABLE ip_ctracker_ipblocker(
id mediumint(8) unsigned DEFAULT '' NOT NULL,
ct_blocker_value varchar(250),
PRIMARY KEY (id)
);
------------------------------------------------------------------------------------
Original
CREATE TABLE phpbb_dl_bug_history (
report_his_id INT(11) AUTO_INCREMENT NOT NULL,
df_id INT(11) NOT NULL DEFAULT '0',
report_id INT(11) NOT NULL,
report_his_type VARCHAR(10) DEFAULT '',
report_his_date INT(11) DEFAULT '0',
report_his_value VARCHAR(255),
PRIMARY KEY (report_his_id)
);
------------------------------------------------------------------------------
Backup
# Table: ip_dl_bug_history
DROP TABLE IF EXISTS ip_dl_bug_history;
CREATE TABLE ip_dl_bug_history(
report_his_id int(11) NOT NULL auto_increment,
df_id int(11) DEFAULT '0' NOT NULL,
report_id int(11) DEFAULT '' NOT NULL,
report_his_type varchar(10) DEFAULT '',
report_his_date int(11) DEFAULT '0',
report_his_value varchar(255),
PRIMARY KEY (report_his_id)
);
-------------------------------------------------------------------------------
Original
## `phpbb_force_read_users`
CREATE TABLE `phpbb_force_read_users` (
`user` varchar(255) NOT NULL DEFAULT '',
`read` int(1) NOT NULL DEFAULT '0',
`time` int(10) NOT NULL DEFAULT '0'
);
## `phpbb_force_read_users`
---------------------------------------------------------------------------------
Backup
# Table: ip_force_read_users
DROP TABLE IF EXISTS ip_force_read_users;
CREATE TABLE ip_force_read_users(
user varchar(255) DEFAULT '' NOT NULL,
read int(1) DEFAULT '0' NOT NULL,
time int(10) DEFAULT '0' NOT NULL
);
---------------------------------------------------------------------------------
Original
## `phpbb_megamail`
CREATE TABLE `phpbb_megamail` (
`mail_id` smallint unsigned NOT NULL auto_increment,
`mailsession_id` varchar(32) NOT NULL,
`mass_pm` tinyint(1) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL,
`group_id` mediumint(8) NOT NULL,
`email_subject` varchar(255) NOT NULL,
`email_body` text,
`email_format` tinyint(1) NOT NULL default '0',
`batch_start` mediumint(8) NOT NULL,
`batch_size` smallint UNSIGNED NOT NULL,
`batch_wait` smallint NOT NULL,
`status` smallint NOT NULL,
PRIMARY KEY (`mail_id`)
);
## `phpbb_megamail`
---------------------------------------------------------------------------------
Backup
# Table: ip_megamail
DROP TABLE IF EXISTS ip_megamail;
CREATE TABLE ip_megamail(
mail_id smallint(5) unsigned NOT NULL auto_increment,
mailsession_id varchar(32) DEFAULT '' NOT NULL,
mass_pm tinyint(1) DEFAULT '0' NOT NULL,
user_id mediumint(8) DEFAULT '' NOT NULL,
group_id mediumint(8) DEFAULT '' NOT NULL,
email_subject varchar(255) DEFAULT '' NOT NULL,
email_body text,
email_format tinyint(1) DEFAULT '0' NOT NULL,
batch_start mediumint(8) DEFAULT '' NOT NULL,
batch_size smallint(5) unsigned DEFAULT '' NOT NULL,
batch_wait smallint(6) DEFAULT '' NOT NULL,
status smallint(6) DEFAULT '' NOT NULL,
PRIMARY KEY (mail_id)
);
## ICY PHOENIX LOGS - BEGIN
CREATE TABLE `phpbb_logs` (
`log_id` int(11) unsigned NOT NULL auto_increment,
`log_time` varchar(11) NOT NULL,
`log_page` varchar(255) NOT NULL DEFAULT '',
`log_user_id` int(10) NOT NULL,
`log_action` varchar(60) NOT NULL DEFAULT '',
`log_desc` varchar(255) NOT NULL DEFAULT '',
`log_target` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`log_id`)
);
## ICY PHOENIX LOGS – END
--------------------------------------------------------------
Backup
# Table: ip_logs
DROP TABLE IF EXISTS ip_logs;
CREATE TABLE ip_logs(
log_id int(11) unsigned NOT NULL auto_increment,
log_time varchar(11) DEFAULT '' NOT NULL,
log_page varchar(255) DEFAULT '' NOT NULL,
log_user_id int(10) DEFAULT '' NOT NULL,
log_action varchar(60) DEFAULT '' NOT NULL,
log_desc varchar(255) DEFAULT '' NOT NULL,
log_target int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (log_id)
--------------------------------------------------------------------------
Original
CREATE TABLE phpbb_dl_auth (
cat_id INT(11) NOT NULL,
group_id INT(11) NOT NULL,
auth_view TINYINT(1) DEFAULT '1' NOT NULL,
auth_dl TINYINT(1) DEFAULT '1' NOT NULL,
auth_up TINYINT(1) DEFAULT '1' NOT NULL,
auth_mod TINYINT(1) DEFAULT '0' NOT NULL
);
--------------------------------------------------------------------------
Backup
# Table: ip_dl_auth
DROP TABLE IF EXISTS ip_dl_auth;
CREATE TABLE ip_dl_auth(
cat_id int(11) DEFAULT '' NOT NULL,
group_id int(11) DEFAULT '' NOT NULL,
auth_view tinyint(1) DEFAULT '1' NOT NULL,
auth_dl tinyint(1) DEFAULT '1' NOT NULL,
auth_up tinyint(1) DEFAULT '1' NOT NULL,
auth_mod tinyint(1) DEFAULT '0' NOT NULL
);
--------------------------------------------------------------------------
Original
## AJAX Shoutbox - BEGIN
CREATE TABLE phpbb_ajax_shoutbox (
shout_id MEDIUMINT(9) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT(8) NOT NULL,
shouter_name VARCHAR(30) NOT NULL DEFAULT 'guest',
shout_text TEXT NOT NULL,
shouter_ip VARCHAR(8) NOT NULL DEFAULT '',
shout_time INT(11) NOT NULL,
PRIMARY KEY ( shout_id )
);
CREATE TABLE `phpbb_ajax_shoutbox_sessions` (
`session_id` int(10) NOT NULL,
`session_user_id` mediumint(8) NOT NULL DEFAULT '0',
`session_username` varchar(25) NOT NULL DEFAULT '',
`session_ip` varchar(8) NOT NULL DEFAULT '0',
`session_start` int(11) NOT NULL DEFAULT '0',
`session_time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`session_id`)
);
## AJAX Shoutbox – END
------------------------------------------------------------------------------
Backup
# Table: ip_ajax_shoutbox
DROP TABLE IF EXISTS ip_ajax_shoutbox;
CREATE TABLE ip_ajax_shoutbox(
shout_id mediumint(9) unsigned NOT NULL auto_increment,
user_id mediumint(8) DEFAULT '' NOT NULL,
shouter_name varchar(30) DEFAULT 'guest' NOT NULL,
shout_text text DEFAULT '' NOT NULL,
shouter_ip varchar(8) DEFAULT '' NOT NULL,
shout_time int(11) DEFAULT '' NOT NULL,
PRIMARY KEY (shout_id)
);
# Table: ip_ajax_shoutbox_sessions
DROP TABLE IF EXISTS ip_ajax_shoutbox_sessions;
CREATE TABLE ip_ajax_shoutbox_sessions(
session_id int(10) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_username varchar(25) DEFAULT '' NOT NULL,
session_ip varchar(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id)
);
-----------------------------------------------------------------------------
Original
CREATE TABLE `phpbb_ctracker_filescanner` (
`id` smallint(5) NOT NULL,
`filepath` text,
`safety` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
CREATE TABLE `phpbb_ctracker_ipblocker` (
`id` mediumint(8) unsigned NOT NULL,
`ct_blocker_value` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`)
);
---------------------------------------------------------------------------------
Backup
# Table: ip_ctracker_filescanner
DROP TABLE IF EXISTS ip_ctracker_filescanner;
CREATE TABLE ip_ctracker_filescanner(
id smallint(5) DEFAULT '' NOT NULL,
filepath text,
safety smallint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
# Table: ip_ctracker_ipblocker
DROP TABLE IF EXISTS ip_ctracker_ipblocker;
CREATE TABLE ip_ctracker_ipblocker(
id mediumint(8) unsigned DEFAULT '' NOT NULL,
ct_blocker_value varchar(250),
PRIMARY KEY (id)
);
------------------------------------------------------------------------------------
Original
CREATE TABLE phpbb_dl_bug_history (
report_his_id INT(11) AUTO_INCREMENT NOT NULL,
df_id INT(11) NOT NULL DEFAULT '0',
report_id INT(11) NOT NULL,
report_his_type VARCHAR(10) DEFAULT '',
report_his_date INT(11) DEFAULT '0',
report_his_value VARCHAR(255),
PRIMARY KEY (report_his_id)
);
------------------------------------------------------------------------------
Backup
# Table: ip_dl_bug_history
DROP TABLE IF EXISTS ip_dl_bug_history;
CREATE TABLE ip_dl_bug_history(
report_his_id int(11) NOT NULL auto_increment,
df_id int(11) DEFAULT '0' NOT NULL,
report_id int(11) DEFAULT '' NOT NULL,
report_his_type varchar(10) DEFAULT '',
report_his_date int(11) DEFAULT '0',
report_his_value varchar(255),
PRIMARY KEY (report_his_id)
);
-------------------------------------------------------------------------------
Original
## `phpbb_force_read_users`
CREATE TABLE `phpbb_force_read_users` (
`user` varchar(255) NOT NULL DEFAULT '',
`read` int(1) NOT NULL DEFAULT '0',
`time` int(10) NOT NULL DEFAULT '0'
);
## `phpbb_force_read_users`
---------------------------------------------------------------------------------
Backup
# Table: ip_force_read_users
DROP TABLE IF EXISTS ip_force_read_users;
CREATE TABLE ip_force_read_users(
user varchar(255) DEFAULT '' NOT NULL,
read int(1) DEFAULT '0' NOT NULL,
time int(10) DEFAULT '0' NOT NULL
);
---------------------------------------------------------------------------------
Original
## `phpbb_megamail`
CREATE TABLE `phpbb_megamail` (
`mail_id` smallint unsigned NOT NULL auto_increment,
`mailsession_id` varchar(32) NOT NULL,
`mass_pm` tinyint(1) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL,
`group_id` mediumint(8) NOT NULL,
`email_subject` varchar(255) NOT NULL,
`email_body` text,
`email_format` tinyint(1) NOT NULL default '0',
`batch_start` mediumint(8) NOT NULL,
`batch_size` smallint UNSIGNED NOT NULL,
`batch_wait` smallint NOT NULL,
`status` smallint NOT NULL,
PRIMARY KEY (`mail_id`)
);
## `phpbb_megamail`
---------------------------------------------------------------------------------
Backup
# Table: ip_megamail
DROP TABLE IF EXISTS ip_megamail;
CREATE TABLE ip_megamail(
mail_id smallint(5) unsigned NOT NULL auto_increment,
mailsession_id varchar(32) DEFAULT '' NOT NULL,
mass_pm tinyint(1) DEFAULT '0' NOT NULL,
user_id mediumint(8) DEFAULT '' NOT NULL,
group_id mediumint(8) DEFAULT '' NOT NULL,
email_subject varchar(255) DEFAULT '' NOT NULL,
email_body text,
email_format tinyint(1) DEFAULT '0' NOT NULL,
batch_start mediumint(8) DEFAULT '' NOT NULL,
batch_size smallint(5) unsigned DEFAULT '' NOT NULL,
batch_wait smallint(6) DEFAULT '' NOT NULL,
status smallint(6) DEFAULT '' NOT NULL,
PRIMARY KEY (mail_id)
);
Please don´t care about phpbb and ip prefixes, since original is from install file and backup comes directly from
server.
All this are tables that are deleted but not created on restore due to default´s in places there they should´nd be.
Can someone confirm this please