FUDforum: Bug Reports » Cannot reload 3.0.3 RC1 backup

Home » FUDforum Development » Bug Reports » Cannot reload 3.0.3 RC1 backup

Show: Today's Messages :: Polls :: Message Navigator

Cannot reload 3.0.3 RC1 backup [message #166912]

Sat, 24 March 2012 06:33

Atomicrun

Messages: 54
Registered: November 2010
Location: Lund

Karma: 0

Member

I try to upgrade from 3.0.3 RC1 to the latest 3.0.3 version.
But then the upgrade fail due to write protection on some file like .htaccess (that has a file protection that the apache cannot modify, so the write fail).
And then the upgrade is aborted, and the the entire forum was destroyed. Oooops!
And now, I must new install the forum, so I can run the backup function.
And the backup fail:

Restore forum files...
Drop and recreate database tables...
Start loading database tables...
Process table fud30_action_log:
...56 rows loaded.
Process table fud30_announce:
...1 rows loaded.
Process table fud30_attach:
...4 rows loaded.
Process table fud30_avatar:
...39 rows loaded.
Process table fud30_buddy:
...1 rows loaded.
Process table fud30_calendar:
Fatal error: Uncaught exception 'Exception' with message '(D:\FUDforum\include\theme\default\db.inc:104
D:\Apache\htdocs\forum\adm\admimport.php:175
) 1048: Column 'event_day' cannot be null
Query: INSERT INTO fud30_calendar VALUES ('1',NULL,NULL,NULL,NULL,'New Year''s Day'),('2',NULL,NULL,NULL,NULL,'Valentine''s Day'),('3',NULL,NULL,NULL,NULL,'St. Patrick''s'),('4',NULL,NULL,NULL,NULL,'All Fool''s Day'),('5',NULL,NULL,NULL,NULL,'Earth Day'),('6',NULL,NULL,NULL,NULL,'Cinco de Mayo'),('7',NULL,NULL,NULL,NULL,'D-Day'),('8',NULL,NULL,NULL,NULL,'United Nations Day'),('9',NULL,NULL,NULL,NULL,'Halloween'),('10',NULL,NULL,NULL,NULL,'Veterans Day'),('11',NULL,NULL,NULL,NULL,'Christmas Day'),('12',NULL,NULL,NULL,NULL,'Second day of the month, do your time sheets.')
_POST: array ( 'SQ' => '1fb2f84d5cd872e84c9be5ef88776269', 'path' => 'D:/FUDforum/tmp/RAND_PC_23.fud.gz', 'skipsearch' => 'y', 'btn_submit' => 'Import Data', )
Database version: 5.1.51-community
[Referring Page] http://www.randomserver.dyndns.org/forum/adm/admimport.php?&SQ=1fb2f84d5cd872e84c9be5ef88776269
' in D:\FUDforum\include\core.inc:232 Stack trace: #0 D:\FUDforum\include\theme\default\db.inc(104): fud_sql_error_handler('INSERT INTO fud...', 'Column 'event_d...', 1048, '5.1.51-communit...') #1 D:\Apache\htdocs\forum\adm\admimport.php(175): q('INSERT INTO fud...') #2 {main} thrown in D:\FUDforum\include\core.inc on line 232 

->
FATAL ERROR: No session, check your forum's URL and COOKIE settings.

The script DROP the table, and build a new one:

DROP TABLE IF EXISTS {SQL_TABLE_PREFIX}calendar;

CREATE TABLE {SQL_TABLE_PREFIX}calendar
(
	id		INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	event_day	VARCHAR(2) NOT NULL,
	event_month	VARCHAR(2) NOT NULL,
	event_year	VARCHAR(4) NOT NULL,
	link		VARCHAR(255),
	descr		TEXT NOT NULL
);

The discrepancy is that "NOT NULL" don't go with

INSERT INTO {SQL_TABLE_PREFIX}calendar (event_day, event_month, event_year, descr) VALUES ('1', '1', '*', 'New Year''s Day');

PLEASE KINDLY NOTE THAT THE ISSUE IS TO INSERT SOME SPECIAL HOLIDAY NAMES that we don't use here anyway (Sweden) and I don't use the calendar anyway. Twisted Evil

Editing the backup data stream, and not modifying or altering (local) stream length by overwriting the NOT with spaces:

CREATE TABLE {SQL_TABLE_PREFIX}calendar
(
	id		INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	event_day	VARCHAR(2)     NULL,
	event_month	VARCHAR(2)     NULL,
	event_year	VARCHAR(4)     NULL,
	link		VARCHAR(255),
	descr		TEXT NOT NULL
);

allow the backup to go in without errors Shocked