[18:14:08] <Thumann> hi, what database tables are checked when a user is logged in? (Aparantly it's not only phpbb_users)
[18:14:32] <Marshalrusty> lmao
[18:14:37] <Marshalrusty> whoops
[18:14:58] <Marshalrusty> Thatbitextra: phpbb_users primarily
[18:15:12] <Marshalrusty> That was @ Thumann
[18:15:16] <Thumann> yeah well
[18:16:04] <Thumann> i was using the phpbb installation customized to it would integrate with joomla (the cms) so they shared the user database.. i used a phpbb v. 2.0.10 and i'm now moving the phpbb to a native phpbb installation
[18:16:07] <Thumann> i've moved everything
[18:16:16] <Thumann> and checked that the database tables are 'identical'
[18:16:21] <Thumann> how ever.. i can see all my users..
[18:16:24] <Thumann> all the posts etc..
[18:16:33] <Thumann> see the users in the members list and in the various user groups
[18:16:37] <Thumann> but none of them can login :/
[18:16:40] * deejayalive has left #phpbb ("Oh my God, you killed Kenny!")
[18:16:44] <Thumann> i can register a new user, and he can login
[18:16:55] <Thumann> all the ~500 old users can't
[18:17:01] <Thumann> even though i md5 change the password
[18:17:22] <Marshalrusty> I was about to ask...
[18:17:29] <Marshalrusty> Are you sure the password is md5 hashed?
[18:17:35] <Thumann> aye
[18:18:01] <Marshalrusty> And the error users get when trying to login is...
[18:18:29] <Thumann> "You have specified an incorrect or inactive username, or an invalid password"
[18:18:42] <Thumann> and i make the new registered user an admin by changing the user level manually
[18:18:49] <Thumann> and go into user administration
[18:19:01] <Thumann> and click on the find user button, i can by '*' see all of them
[18:19:06] <Thumann> i then click select on one of them
[18:19:12] <Thumann> and then,.. well.. same error
[18:19:14] <Thumann> user doesn't exist
[18:19:17] <Thumann> >.<
[18:19:17] * Mungo has joined #phpbb
[18:19:29] <Thumann> even though i can see them in the memberlist and in all the old posts
[18:20:03] <Marshalrusty> Is user_active set to 1 for the users?
[18:20:08] <Thumann> aye, all of them
[18:20:37] <Thumann> could this be cookie related?
[18:20:42] <Thumann> no
[18:20:48] <Thumann> then the admin part would still work
[18:21:58] <Marshalrusty> No, it can't be a cookie issues
[18:22:07] <Marshalrusty> Is the code in login.php from the native phpBB?
[18:22:12] <Thumann> yes
[18:22:23] <Thumann> what was changed in the joomla port
[18:22:26] <Marshalrusty> In that case, one of the things you have told me in incorrect :)
[18:22:31] <Thumann> was like.. user_id was id
[18:22:47] <Marshalrusty> I would have to see it to tell you anything...
[18:23:06] <Thumann> can i pm you login info? it's a test installation anyways
[18:23:09] <Thumann> so no harm done
[18:23:11] <Marshalrusty> How large is the database?
[18:23:19] <Marshalrusty> Ah, that's even better
[18:23:33] <Marshalrusty> Well the login info isn't going to tell me anything
[18:23:35] <Thumann> well.. i've just moved the users and groups this time.. so not that big.. but other than that.. 46megs if i recall
[18:23:39] <Marshalrusty> I imagine I'll get the same error
[18:23:46] <Thumann> i mean login info to the sql db
[18:23:50] <Thumann> phpmyadmin
[18:23:58] <Marshalrusty> Sure, that will work
[18:24:03] <Thumann> hang on
[18:24:08] <Marshalrusty> I'll be home in 2.5 hours and can take a look then
[18:24:11] <Thumann> ahh
[18:24:14] <Thumann> deal
[18:24:17] <Marshalrusty> :)
[18:25:41] <Thumann> i figured it would be easies to go from the modified old version to a native old version, and then upgrade to newest
[18:25:50] <Thumann> *easiest
[18:26:14] * naderman has joined #phpbb
[18:26:15] * ChanServ sets mode: +o naderman
[18:28:07] <Thumann> btw.. are the phpbb_search_wordlist needed? since they take up say.. more than half my database space
[18:28:17] <Thumann> from what i can see they're like indexes right?
[18:28:36] <Marshalrusty> yes
[18:28:45] <K5WTF> If you don;t care to have the search function work you can safely empty it i believe
[18:28:45] <Marshalrusty> The search tables can be rebuilt at any time
[18:29:14] <Thumann> rebuilding it is
[18:29:23] <Thumann> import time reduced by 200 hours
[18:30:36] * Alley^Away has left #phpbb ("thx for 0")
[18:34:39] <Marshalrusty> 200 O_O
[18:35:06] <Marshalrusty> What are you restoring, Google?
[18:35:34] <Marshalrusty> email be a copy of Google plz
[18:35:45] <Thumann> yeah, google cache board
[18:35:50] <Thumann> you haven't been there?
[18:35:51] <Thumann> :D
[18:36:42] <Thumann> nah. it's around 450.000 queries for a complete insert (no bulk inserts)
[18:36:46] <Thumann> which takes time! :D