FUDforum: How To » Help: Import Failure

Home » FUDforum » How To » Help: Import Failure

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

Help: Import Failure [message #34867]

Tue, 21 November 2006 14:43

appscontent

Messages: 33
Registered: November 2006

Karma: 0

Member

I reran install.php, recreated the forums, unlocked the files, ran repair against the db in MySQL and tried importing with two different backups...

I get the same error ...

(/home/mypath/FUDforum/include/theme/default/db.inc:72
/home/mypath/FUDforum/include/theme/default/db.inc:132
/home/mypath/public_html/forums/adm/admimport.php:223
) 1146: Table 'mytable_forums.fud26_users' doesn't exist
Query: SELECT id FROM fud26_users WHERE login='admin' AND users_opt>=1048576 AND (users_opt & 1048576) > 0
_POST: array ( 'S' => 'de91ea52626f5998da09598e7212fc50', 'SQ' => 'c777606de3def1dc1b1d157d376e5fed', 'path' => '/home/mypath/FUDforum/FUDforum_20_11_2006_11_07.fud.gz', 'btn_submit' => 'Import Data', )
Server Version: 4.0.25-standard
[Referring Page] http://www.mydomain.com/forums/adm/admimport.php?S=de91ea52626f5998da09598e 7212fc50&SQ=c777606de3def1dc1b1d157d376e5fed

This is in the error_log ....

[21-Nov-2006 08:55:30] PHP Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/mypath/FUDforum/include/core.inc on line 188

[21-Nov-2006 09:33:39] PHP Parse error: syntax error, unexpected T_BOOLEAN_OR in /home/mypath/public_html/forums/adm/admimport.php(218) : eval()'d code on line 1
[21-Nov-2006 09:33:39] PHP Warning: Invalid argument supplied for foreach() in /home/mypath/FUDforum/include/glob.inc on line 80

[Updated on: Tue, 21 November 2006 15:10]

Report message to a moderator

Re: Help: Import Failure [message #34871 is a reply to message #34867]

Tue, 21 November 2006 15:19

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Have you tried running the import script via command line?

FUDforum Core Developer

Report message to a moderator

Re: Help: Import Failure [message #34875 is a reply to message #34871]

Tue, 21 November 2006 16:36

appscontent

Messages: 33
Registered: November 2006

Karma: 0

Member

Forgive my ignorance ... how do run the import script via command line? What is the name of the script and where is it located?

Report message to a moderator

Re: Help: Import Failure [message #34885 is a reply to message #34875]

Wed, 22 November 2006 04:32

appscontent

Messages: 33
Registered: November 2006

Karma: 0

Member

1.. My backup (FUDforum_20_11_2006_11_07.fud.gz) was created successfully, according to the log

2. I deleted FudForum completely from my system

3. I dropped and recreated the database

4. I reinstalled from scratch and was able to login and use the "vanilla" system

5. I tried to import FUDforum_20_11_2006_11_07.fud.gz, again through the form .... still I immediately get the following error:

?797 ?1164167196?(/home/eunivers/FUDforum/include/theme/default/db.inc:72 
/home/eunivers/FUDforum/include/theme/default/db.inc:132 
/home/eunivers/public_html/forums/adm/admimport.php:224 
) 1146: Table 'eunivers_forums.fud26_users' doesn't exist 
Query: SELECT id FROM fud26_users WHERE login='ttpadmin' AND users_opt>=1048576 AND (users_opt & 1048576) > 0 
_POST: array (
'S' => '7447009c4cff94f44655dafad7535c56',
'SQ' => 'fc822b9ef5600d73def0f95e33af290a',
'path' => '/home/eunivers/FUDforum/FUDforum_20_11_2006_11_07.fud.gz',
'btn_submit' => 'Import Data',
) 
Server Version: 4.0.25-standard 
[Referring Page] http://www.peopleapps.com/forums/adm/admimport.php?S=7447009c4cff94f44655da fad7535c56&SQ=fc822b9ef5600d73def0f95e33af290a 

6. Reinstalled FUDforum again
7. Changed admimport.php

changed => @set_time_limit(60000);
uncommented => define('recovery_mode', 1);
added => $_POST['path'] = '/home/eunivers/FUDforum/FUDforum_20_11_2006_11_07.fud.gz';

8. Ran Forum Consistency

9. Unlocked forum's files

10. Ran from the command line:

php -q admimport.php

Nothing appeared to happen ... no new entries in error log

11. commented out => define('recovery_mode', 1);

12. I tried to import FUDforum_20_11_2006_11_07.fud.gz, again through the form

?692 ?1164169603?(/home/eunivers/FUDforum/include/theme/default/db.inc:72 
/home/eunivers/FUDforum/include/theme/default/db.inc:132 
/home/eunivers/public_html/forums/adm/admimport.php:224 
) 1146: Table 'eunivers_forums.fud26_users' doesn't exist 
Query: SELECT id FROM fud26_users WHERE login='' AND users_opt>=1048576 AND (users_opt & 1048576) > 0 
_POST: array (
'path' => '/home/eunivers/FUDforum/FUDforum_20_11_2006_11_07.fud.gz',
'btn_submit' => 'Import Data',
) 
Server Version: 4.0.25-standard 
[Referring Page] http://www.peopleapps.com/forums/adm/admimport.php?S=d1a67ab222bc233c02a51e 474cf1c3c8&SQ=5424c6bfea2ab738ced8a81089427efd 

13. So now ....

SELECT id FROM fud26_users WHERE login=''

I used another admin user (which also existed in the backup)

Can anyone ... anyone at all ... please help me restore???

[Updated on: Wed, 22 November 2006 04:32]

Report message to a moderator

Re: Help: Import Failure [message #34886 is a reply to message #34885]

Wed, 22 November 2006 05:04

appscontent

Messages: 33
Registered: November 2006

Karma: 0

Member

Last entry in the SQL Error Log ....

Wed Nov 22 4:54:52 GMT 2006 (/home/eunivers/public_html/forums/index.php:75
/home/eunivers/public_html/forums/index.php:175
/home/eunivers/public_html/forums/index.php:274
/home/eunivers/public_html/forums/index.php:946
/home/eunivers/public_html/forums/index.php:1141
) 1146: Table 'eunivers_forums.fud26_ses' doesn't exist
Query: SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.topics_per_page, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc FROM fud26_ses s INNER JOIN fud26_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN fud26_themes t ON t.id=u.theme WHERE s.ses_id='8e5e040bae4faf72da1f965c529a05c3'
Server Version: 4.0.25-standard

Also did a repair in MySQL prior ....

Repairing Database
eunivers_forums is now being repaired.

eunivers_forums.fud26_action_log OK
eunivers_forums.fud26_ann_forums OK
eunivers_forums.fud26_announce OK
eunivers_forums.fud26_attach OK
eunivers_forums.fud26_avatar OK
eunivers_forums.fud26_blocked_logins OK
eunivers_forums.fud26_buddy OK
eunivers_forums.fud26_cat OK
eunivers_forums.fud26_custom_tags OK
eunivers_forums.fud26_email_block OK
eunivers_forums.fud26_ext_block OK
eunivers_forums.fud26_fc_view OK
eunivers_forums.fud26_fl_1 OK
eunivers_forums.fud26_fl_pm OK
eunivers_forums.fud26_forum OK
eunivers_forums.fud26_forum_notify OK
eunivers_forums.fud26_forum_read OK
eunivers_forums.fud26_geoip OK
eunivers_forums.fud26_group_cache OK
eunivers_forums.fud26_group_members OK
eunivers_forums.fud26_group_resources OK
eunivers_forums.fud26_groups OK
eunivers_forums.fud26_index OK
eunivers_forums.fud26_ip_block OK
eunivers_forums.fud26_level OK
eunivers_forums.fud26_mime OK
eunivers_forums.fud26_mlist OK
eunivers_forums.fud26_mod OK
eunivers_forums.fud26_mod_que OK
eunivers_forums.fud26_msg OK
eunivers_forums.fud26_msg_report OK
eunivers_forums.fud26_msg_store OK
eunivers_forums.fud26_nntp OK
eunivers_forums.fud26_pmsg OK
eunivers_forums.fud26_poll OK
eunivers_forums.fud26_poll_opt OK
eunivers_forums.fud26_poll_opt_track OK
eunivers_forums.fud26_read OK
eunivers_forums.fud26_replace OK
eunivers_forums.fud26_search OK
eunivers_forums.fud26_search_cache OK
eunivers_forums.fud26_ses OK
eunivers_forums.fud26_smiley OK
eunivers_forums.fud26_stats_cache OK
eunivers_forums.fud26_themes OK
eunivers_forums.fud26_thr_exchange OK
eunivers_forums.fud26_thread OK
eunivers_forums.fud26_thread_notify OK
eunivers_forums.fud26_thread_rate_track OK
eunivers_forums.fud26_title_index OK
eunivers_forums.fud26_tv_1 OK
eunivers_forums.fud26_user_ignore OK
eunivers_forums.fud26_users OK

[Updated on: Wed, 22 November 2006 05:18]

Report message to a moderator

Re: Help: Import Failure [message #34900 is a reply to message #34886]

Wed, 22 November 2006 15:40

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

When you installed the new forum it was fully operational I presume? Then you went to admin import panel and tried to import the data dump, did it give you any progress messages or right away jumped to an error?

FUDforum Core Developer

Report message to a moderator

Re: Help: Import Failure [message #34914 is a reply to message #34900]

Thu, 23 November 2006 13:49

appscontent

Messages: 33
Registered: November 2006

Karma: 0

Member

Yes...reinstalled as fully operational...original backup log showed backup created successfully. Import failed immediately ... no progress.

It is apparent this code is buggy. I've lost 3 weeks of work if I can't restore. Any way to break apart the .FUD backup file to retore the database only?

Report message to a moderator

Re: Help: Import Failure [message #34920 is a reply to message #34914] Thu, 23 November 2006 14:28

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

How big is your backup file?

You can also try to open the admimport.php script and uncomment the


<?php
define('recovery_mode', 1);
?>

line.

FUDforum Core Developer

Report message to a moderator

Re: Help: Import Failure [message #34922 is a reply to message #34867]

Fri, 24 November 2006 04:36

appscontent

Messages: 33
Registered: November 2006

Karma: 0

Member

Import file is 101MB

changed => @set_time_limit(60000);
uncommented => define('recovery_mode', 1);
added => $_POST['path'] = '/home/eunivers/FUDforum/FUDforum_20_11_2006_11_07.fud';

figured out how to run from command line ... success!!!

Thanks to all for assistance

Report message to a moderator

Previous Topic:	IP filter
Next Topic:	Changing colours

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 21:14:42 GMT 2024

Total time taken to generate the page: 0.07940 seconds