Hi, hope someone can help as I'm having issues moving our fudforum v3.0.4 to a new host
Bear with me while I try to explain the problem and what I've tried so far
1. Installed both empty fudforum 3.4.0 (and 3.4.1) on both the new host and within an additional test system running within XAMPP on my PC - no problems with these, the empty clean forums work fine
2. Performed multiple 'make forum datadump' on the current live forum and transferred this backup to my pc and new host for separate testing
3. When I run admimport.php (mostly via the control panel link) I get the following
[this is taken from my pc test XAMPP as its easier to test import on this than actual new host given I end up having to reinstall fudforum after each failure]
Cleanup old files...
Restore files from backup...
Drop and recreate database tables...
Start loading database tables...
Process table forum_action_log:
...12 rows loaded.
Process table forum_ann_forums:
...3 rows loaded.
Process table forum_announce:
...3 rows loaded.
Process table forum_attach:
...670 rows loaded.
Process table forum_bookmarks:
...25 rows loaded.
snip
...43 rows loaded.
Process table forum_mod:
...116 rows loaded.
Process table forum_msg:
Warning: mysqli::query(): MySQL server has gone away in C:\xampp\htdocs\FUDforum\include\theme\default\db.inc on line 110
Warning: mysqli::query(): Error reading result set's header in C:\xampp\htdocs\FUDforum\include\theme\default\db.inc on line 110
Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 65488 bytes) in C:\xampp\htdocs\FUDforum\include\theme\default\db.inc on line 54
4. I'm not very good with SQL errors like these nor understanding php code so tried editing admimport.php to increase
/* main */
@ini_set('memory_limit', '256M');
@set_time_limit(0);
to 1024M but still get the same error
One thing I've been thinking is our forum may have missed the 3.0 upgrade when it went from 2.x to 3.x as our globals.php layout is missing some things present in fresh installs of 3.4.0 but mostly our tables are prefixed forum_ not fud30_ . To try rule out table prefix issues I've also tested having the empty fudforum use forum_ from the initial install wizard (rather than the default fud30_) but still get the same result
This is our live forum globals.php (with sensitive info ***** out)
<?php
$GLOBALS['FORUM_TITLE'] = 'Honda-Forums.com';
$GLOBALS['FORUM_DESCR'] = 'Hairy arsed bikers talking about baking cakes';
$GLOBALS['DISABLED_REASON'] = 'Undergoing maintenance, please come back later.';
$GLOBALS['WWW_ROOT'] = 'http://www.honda-forums.com/';
$GLOBALS['CUSTOM_AVATAR_MAX_SIZE'] = 409600;
$GLOBALS['CUSTOM_AVATAR_MAX_DIM'] = '176x120';
$GLOBALS['COOKIE_PATH'] = '/';
$GLOBALS['COOKIE_TIMEOUT'] = 604800;
$GLOBALS['SESSION_TIMEOUT'] = 604800;
$GLOBALS['COOKIE_DOMAIN'] = '.honda-forums.com';
$GLOBALS['COOKIE_NAME'] = 'honda-forum';
$GLOBALS['DBHOST'] = 'localhost';
$GLOBALS['DBHOST_USER'] = '*****';
$GLOBALS['DBHOST_PASSWORD'] = '***********';
$GLOBALS['DBHOST_DBNAME'] = 'honda';
$GLOBALS['DBHOST_TBL_PREFIX'] = 'forum_';
$GLOBALS['FUD_SMTP_SERVER'] = 'smtp.*********.co.uk';
$GLOBALS['FUD_SMTP_PORT'] = 25;
$GLOBALS['FUD_SMTP_TIMEOUT'] = 10;
$GLOBALS['FUD_SMTP_LOGIN'] = '********@*********.co.UK';
$GLOBALS['FUD_SMTP_PASS'] = '*********';
$GLOBALS['PRIVATE_ATTACHMENTS'] = 1;
$GLOBALS['PRIVATE_ATTACH_SIZE'] = 150000;
$GLOBALS['MAX_PMSG_FLDR_SIZE'] = 30000;
$GLOBALS['MAX_PMSG_FLDR_SIZE_PM'] = 1000000;
$GLOBALS['MAX_PMSG_FLDR_SIZE_AD'] = 1000000;
$GLOBALS['FORUM_IMG_CNT_SIG'] = 1;
$GLOBALS['FORUM_SIG_ML'] = 400;
$GLOBALS['FUD_OPT_4'] = 7;
$GLOBALS['DBHOST_SLAVE_HOST'] = '';
$GLOBALS['ADMIN_EMAIL'] = '********@*********.co.UK';
$GLOBALS['POSTS_PER_PAGE'] = 20;
$GLOBALS['THREADS_PER_PAGE'] = 40;
$GLOBALS['WORD_WRAP'] = 60;
$GLOBALS['FLOOD_CHECK_TIME'] = 60;
$GLOBALS['MOD_FIRST_N_POSTS'] = 0;
$GLOBALS['POST_MIN_LEN'] = 0;
$GLOBALS['POSTS_BEFORE_LINKS'] = 0;
$GLOBALS['SERVER_TZ'] = 'Europe/London';
$GLOBALS['MEMBERS_PER_PAGE'] = 40;
$GLOBALS['THREAD_MSG_PAGER'] = 5;
$GLOBALS['GENERAL_PAGER_COUNT'] = 15;
$GLOBALS['EDIT_TIME_LIMIT'] = 15;
$GLOBALS['LOGEDIN_TIMEOUT'] = 10;
$GLOBALS['MAX_IMAGE_COUNT'] = 15;
$GLOBALS['NOTIFY_FROM'] = '********@*********.co.UK';
$GLOBALS['ANON_NICK'] = 'unregistered user';
$GLOBALS['MAX_LOGIN_SHOW'] = 25;
$GLOBALS['MAX_LOCATION_SHOW'] = 25;
$GLOBALS['UNCONF_USER_EXPIRY'] = 7;
$GLOBALS['MOVED_THR_PTR_EXPIRY'] = 0;
$GLOBALS['DATA_DIR'] = '/var/www/honda-forums.com/honda_FUDforum/';
$GLOBALS['WWW_ROOT_DISK'] = '/var/www/honda-forums.com/html/';
$GLOBALS['SHOW_N_MODS'] = 0;
$GLOBALS['MAX_SMILIES_SHOWN'] = 17;
$GLOBALS['POLLS_PER_PAGE'] = 40;
$GLOBALS['TREE_THREADS_MAX_DEPTH'] = 15;
$GLOBALS['TREE_THREADS_MAX_SUBJ_LEN'] = 75;
$GLOBALS['REG_TIME_LIMIT'] = 30;
$GLOBALS['SEARCH_CACHE_EXPIRY'] = 172800;
$GLOBALS['STATS_CACHE_AGE'] = 600;
$GLOBALS['POST_ICONS_PER_ROW'] = 9;
$GLOBALS['MAX_LOGGEDIN_USERS'] = 25;
$GLOBALS['PHP_COMPRESSION_LEVEL'] = 9;
$GLOBALS['MNAV_MAX_DATE'] = 31;
$GLOBALS['MNAV_MAX_LEN'] = 256;
$GLOBALS['FEED_AUTH_ID'] = 0;
$GLOBALS['FEED_MAX_N_RESULTS'] = 10;
$GLOBALS['FEED_CACHE_AGE'] = 600;
$GLOBALS['PDF_PAGE'] = 'A4';
$GLOBALS['PDF_WMARGIN'] = 15;
$GLOBALS['PDF_HMARGIN'] = 15;
$GLOBALS['PDF_MAX_CPU'] = 60;
$GLOBALS['FUD_WHOIS_SERVER'] = 'whois.arin.net';
$GLOBALS['MIN_TIME_BETWEEN_LOGIN'] = 10;
$GLOBALS['PHP_CLI'] = '/usr/local/bin/php';
$GLOBALS['FUD_OPT_2'] = 2139846526;
$GLOBALS['FUD_OPT_1'] = 1633613599;
$GLOBALS['FUD_OPT_3'] = 114762848;
$GLOBALS['INCLUDE'] = '/var/www/honda-forums.com/honda_FUDforum/include/';
$GLOBALS['ERROR_PATH'] = '/var/www/honda-forums.com/honda_FUDforum/errors/';
$GLOBALS['MSG_STORE_DIR'] = '/var/www/honda-forums.com/honda_FUDforum/messages/';
$GLOBALS['TMP'] = '/var/www/honda-forums.com/honda_FUDforum/tmp/';
$GLOBALS['FILE_STORE'] = '/var/www/honda-forums.com/honda_FUDforum/files/';
$GLOBALS['FORUM_SETTINGS_PATH'] = '/var/www/honda-forums.com/honda_FUDforum/cache/';
$GLOBALS['PLUGIN_PATH'] = '/var/www/honda-forums.com/honda_FUDforum/plugins/';
$GLOBALS['DBHOST_DBTYPE'] = 'mysql';
/* DO NOT EDIT FILE BEYOND THIS POINT UNLESS YOU KNOW WHAT YOU ARE DOING */
require($INCLUDE.'core.inc');
?>
Question is what can I do if our forum is a bit of a mix of 2.x and 3.x given its now 3.0.4 or is it quite normal for a forum which did start out many years ago as at least 2.x (maybe even 1.x) and is now on v3.0.4 to still have forum_ table prefixes?
For Info the forum db size is 440MB (after a bit of pruning) and the resulting FUDforum_12_04_2013_12_12.fud.gz backup file 880MB (I had to resort to unticking the compress backup during the backups as the resulting .gz file was 'broken' when I downloaded it to my PC and tested unzipping with 7z it but thats another issue now resolved by the untick unless the .fud file is still possibly broken)
[Updated on: Fri, 12 April 2013 12:21]
Report message to a moderator
Calendar
Search
Help
Members
Register
Login
Home
]