|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Nope, don't see it. I've even looked in the source of the page and don't see it there either. What browser are you using?
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
i'm assuming the oddities are the way phpbb stored things vs now though
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Nope, don't see it. I've even looked in the source of the page and don't see it there either. What browser are you using? I'm using FFox... I'll get you a screencap
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I'm using FFox... I'll get you a screencapp Odd, same here.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, the [quote] issue is the way they store the actual code when quoting a particular user. I think I can fix that in the import script.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
also, the quote behavior acts like that for special chars too: "'& etc
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ahh, got it. That's the IP which only the admin can see. They store the IP in base64_encoded format. I thought I had that decoded but apparently not. Will need to fix that.
Can you point me to where you are seeing the & stuff?
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
I thought I saw & somewhere too but I can't find it now (and the search displays nothing for either & or ")
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Holy cow the user_groups are messy. So there can be personal user groups and "group" user groups?
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
yup lol... Scary huh? It's all sorts of wrong lol... see why i advise against using phpbb?
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, so it looks like they are actually storing " signs as " and & signs as &. Looks like I'll need to convert those when doing the import.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
I wish I could give you any others, but I'm not sure which ones are and aren't used lol...
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Yeah, I'm going to take a crack at importing the "group" usergroups, but not exactly sure if I'll be able to pull it off. Might be something I'll have to revisit later depending on how much time it takes.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
At the very least it looks like I can "probably" import the actual groups and at least get the users into the groups. The permissions for those groups might not make it over, but at least all the users will be in the groups they are supposed to be in.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Thats a good comprimise imo hehe...
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, so I'm going to make a few more changes and then I'll scp the new phpbb_importer to your site for when you have the time to give it another shot.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, it's sitting in my home directory on your server. I'm sure you can get in there to copy it out 
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
kk, will do  . We're slow so its not like it'll impact anything lol
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
I'd have to beat myself if I coudln't when I assigned your account the perms hehe; I won't be able to do it till later tongiht
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
No rush, I've got plenty to keep myself occoupied
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Go fig, I go to update and:
Processing users 1 - 201 of 1085
Script:
Line#:
SQL Error:
SQL Error #: 0
Query: select old_group,new_group from group_temp
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Woops. Line 419 of phpbb_import.php should be:
from grouptemp
not
from group_temp
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Scratch this post, seems wordpad is blatently blind...
Last edited by Gizmo; 09/15/2006 6:07 PM.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Processing users 1 - 201 of 1091
Script:
Line#:
SQL Error:
SQL Error #: 0
Query: select old_group,new_group from grouptemp
lol
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Holy cow, I'm off today  Line 419 should be: from {$config['TABLE_PREFIX']}grouptemp not: from grouptemp
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Well that worked, but for some reason none of my members got imported...
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Hmm, did you get any errors at all?
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Blah, I found it. Sorry Gizmo, I thought this was going to be an easy change on the groups, so I didn't test it. This *should* be the last change you need to make Lines 511 and 512 make reference to $sti. If you change both of those to $sti2, that'll fix it.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Odd, after updating those two lines I'm getting:
Checking...
Unable to query from the phpbb_Users table, it doesn't appear your import database settings are correct.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Hmm, that's odd. Didn't change anything in that area. Did you start over fresh?
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
yup, I nuked the db and ran createtable.php and then ran the importer...
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Hmm, did you fill in your phpbb prefix correctly?  Honestly, I'm stumped. Basically, that error is like 300 lines away from the code you changed.
$query = "show tables like '{$dbprefix}users%'";
$sth = mysql_query($query,$dbhimport);
list($check) = mysql_fetch_array($sth);
if (!$check) {
echo "Unable to query from the {$dbprefix}Users table, it doesn't appear your import database settings are correct.";
exit;
}
It just checks to see if the users table exists, so if you have your prefix at phpbb_ I can't see why it would fail.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
I'll give it a run again then I guess; everything else got imported, just shows no users...
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Just updated to latest importer to run things through and i've noticed that where it seems to populate everythig properly (didn't check all yet) it ignores my current phpbb2 usergroups and doesnt' import them...
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
Humm, scratch that, it's still importing " as "
|
|
|
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,373 Likes: 129 |
i'm thinking the current importer isn't what we worked on ...
|
|
|
|
1 members (Morgan),
69
guests, and
100
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
