|
|
|
|
|
|
|
|
|
|
| Re: FUD files exist, database doesn't [message #34282 is a reply to message #34279] |
Tue, 17 October 2006 15:55   |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You need to use the admin account from the original forum, as all the users were replaced with the ones from the data dump.
FUDforum Core Developer
|
|
|
|
| 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 #34295 is a reply to message #34287] |
Wed, 18 October 2006 13:44 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Can select the users_opt column from the users table for the user that is supposedly an admin and post its value here?
FUDforum Core Developer
|
|
|
|
|
|
| Re: FUD files exist, database doesn't [message #34316 is a reply to message #34300] |
Fri, 20 October 2006 01:08 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
This is why, it does not work, value of 0 effectively means no access. Can you see if any users have users_opt field matching the following bitmask.
You can get this information by running a query such as this:
SELECT * FROM fud26_users WHERE users_opt & 1048576;
FUDforum Core Developer
|
|
|
|
| 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
|
|
|
|
| Re: FUD files exist, database doesn't [message #34372 is a reply to message #34370] |
Tue, 24 October 2006 14:34 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Does the table exist in the "eme85_rdl" database? If it does perhaps the table is corrupt you can try to repair it using "REPAIR TABLE fud26_users" command. If it is fine, you may need to check MySQL permissions to ensure that the user account you are using has access to this table.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]