FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Cannot reload 3.0.3 RC1 backup
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Cannot reload 3.0.3 RC1 backup [message #166912] Sat, 24 March 2012 02:33 Go to next message
Atomicrun is currently offline  Atomicrun   Sweden
Messages: 54
Registered: November 2010
Location: Lund
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 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 Shocked
Very Happy
Re: Cannot reload 3.0.3 RC1 backup [message #166913 is a reply to message #166912] Sat, 24 March 2012 03:14 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
It's a bug in the RC1 release.
Quick fix: DELETE FROM fud30_calendar;
Re: Cannot reload 3.0.3 RC1 backup [message #166914 is a reply to message #166912] Sat, 24 March 2012 03:21 Go to previous message
Atomicrun is currently offline  Atomicrun   Sweden
Messages: 54
Registered: November 2010
Location: Lund
Karma: 0
Member
add to buddy list
ignore all messages by this user
I have my forum working again.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Addslashes needed
Next Topic: A bunch of patches
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 18 17:34:39 EST 2017

Total time taken to generate the page: 0.00658 seconds