|
|
|
|
|
|
Re: FUD files exist, database doesn't [message #34287 is a reply to message #34282] |
Tue, 17 October 2006 21:34 |
seagull
Messages: 10 Registered: January 2006 Location: Holland
Karma: 0
|
Junior Member |
|
|
I changed the admin password and checked that it worked by getting me into the admin control panel. Then I did the datadump. When I came to do the import everything went fine until the end.
Processed 10000 queries
Processed 20000 queries
Processed 30000 queries
Processed 40000 queries
Processed 50000 queries
Processed 60000 queries
Processed 70000 queries
Your current login (admin) is not found in the imported database.
Therefor you'll need to re-login once the import process is complete
Recompiling Templates
Correcting Avatar Paths
Correcting Attachment Paths
Import process is now complete
To finalize the import process you should now run the consistency checker.
I even made sure that the admin password on the new installation was the same as on the old installation.
No matter what password I use I still can't get in and the forum is disabled.
[Updated on: Tue, 17 October 2006 21:34] Report message to a moderator
|
|
|
|
|
|
Re: FUD files exist, database doesn't [message #34320 is a reply to message #34316] |
Fri, 20 October 2006 10:39 |
seagull
Messages: 10 Registered: January 2006 Location: Holland
Karma: 0
|
Junior Member |
|
|
Yes, there are several users with users_opt returned after running the query. The values of the users_opt are anything from -1858780027 to 1389967628. There doesn't seem to be any pattern to the value, or who has a none 0 entry.
If I try to log in as one of these users I get a fatal error message:
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/eme85/domains/85eme.org/FUD/include/core.inc on line 188
I can't look at the query log because the files are 'locked' and I don't have rights to view them. I'm looking at a way of 'unlocking' the files so that I can do some more investigation.
[Updated on: Fri, 20 October 2006 10:39] Report message to a moderator
|
|
|
|
|
|
Re: FUD files exist, database doesn't [message #34370 is a reply to message #34356] |
Tue, 24 October 2006 13:47 |
seagull
Messages: 10 Registered: January 2006 Location: Holland
Karma: 0
|
Junior Member |
|
|
Okay, thanks for that. I at least get a bit further along.
Now I'm getting a different error. Basically it's saying one of the tables doesn't exist, yet I know it does and have browsed the contents using phpMyAdmin.
?1228 ?1161695374?(/.../public_html/forum/index.php:75
/.../public_html/forum/index.php:175
/.../public_html/forum/index.php:274
/.../public_html/forum/index.php:946
/.../public_html/forum/index.php:1141
) 1146: Table 'eme85_rdl.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='cd38a0d50d497d44b49a76c316a7ef55' AND s.time_sec > 1161677374
_GET: array ( 't' => 'msg', 'S' => 'cd38a0d50d497d44b49a76c316a7ef55', 'th' => '213', 'goto' => '2807', )
Server Version: 4.1.11-standard
|
|
|
|
|