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. 
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 
|
Calendar
Search
Help
Members
Register
Login
Home
]