conversion from 2.0, duplicate usernames

[Sulla]

Hi P,

I was reading some of the other posts about converting from VB to phpbb.

Noticed this, could it be a problem?

Also im trying to use phpBB 3.0.6 to convert as i think the newer versions have issues with the convertor since its so old.

I ran the converter again after renaming the userconv to phpbb_userconv. It now runs with no errors, but actually seems to now do nothing?

Any ideas mate, am getting near hair pulling out!

TIA Rgds - Shaun

[Sulla]

I can give out server login etc if anyone can would have a look.

It must be something really obvious, just not to me. All usernames etc have gone over, just not been cleaned, I am presuming, posts etc wont go over until users are sorted?

Once I get this sorted, I would like to incorporate phpbb with one of the CMS's. I always used Xikula, after Post_Nuke, but not sure either are still active. Joomla looks a good bet, but I have hear there is an existing bridge to Druphal? Any suggestions welcome!

Just once ..........

Cheers - Shaun

[Brf]

Your listing is showing you have duplicates of those three names: aiden, david, hoth

[Sulla]

Cheers mate,

But the forum has 7,770+ users, with over 100,000+ posts I doubt those 3 VERY ordinary names are the only problems it found. Some of the name I would expect it to show are not showing and the conversion script, just sits there, after I hit next and says details are all fine, then next and nothing!

http://www.closecombat.org/csoforums/in ... anguage=en

So am open to ideas and help, thanks for the comment, Brf!

Cheers - Shaun

[Brf]

The error message you are getting, about duplicate names, is for those three names.

[Sulla]

The problem is,

I only get those 3 names running a query in mysqlphpadmin. Running the conversion script now throw up nothing and just sits there, not doing anything, finding any names anything, As in the previous post link and screen.

This is what I used to get:

Old VB Board:
http://www.closecombat.org/forums/index.php

New PHPBB board:
http://www.closecombat.org/csoforums/index.php?

The problems start when I try an run the converter/importer. It is set-up fine and says ready, but once I start importing, I get the following error msg.

-----------------------------------------------
"Fatal conversion error
Fatal conversion error

functions_vb30.php [ 1828 ]

Colliding usernames were found on your old board. In order to complete the conversion please delete or rename these users so that there is only one user on your old board for each clean username."
-----------------------------------------------

Now when I hit the converter nothing happens, the names are all in the phpbb table, but thats as far as it goes. I only get those errors running a query in mysql.

Code: Select all

CODE: SELECT ALL
SELECT username_clean
      FROM phpbb_userconv
      GROUP BY username_clean
      HAVING COUNT(user_id) > 1;

Cheers - Shaun

[Brf]

Did you fix those three names in the old board, so they are not duplicate anymore?
You need to do that first. Then truncate the userconv table, so you can run the convert again.

[Sulla]

Hia Mate,

Ok, Did you fix those three names in the old board, so they are not duplicate anymore?

// You mean remove or change those 3 names?

You need to do that first.

Then truncate the userconv table, so you can run the convert again.

// How do I truncate the userconv table?

Sorry mate, I got very ill a while ago and its taken/taking me time to get back up to speed, had bad heart [99% congenital blockage], kidney probs and major arthritis [age 43] etc. So my old days of 18 hrs and finding things v easy to grasp are past.

Am swimming as fast as I can

Cheers - Shaun

[Brf]

Yes. You need to change or remove the duplicate names.
You run a truncate statement they same way you ran your select statement that found your duplicates, but instead of running the select, you run:
truncate userconv;

[Sulla]

This is what I get when I show the list of users.

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

How do I change or delete any name?

Cheers - Shaun

[Brf]

I wouldn't know. This is support for phpBB, not VB.

[Sulla]

http://www.closecombat.org/csoforums/collisions.php

General Error
SQL ERROR [ mysqli ]

Table 'stratek5_php3forum.phpbb_phpbb_userconv' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

[Brf]

Why are you trying to run collisions.php?
That was the script you made to try to read the userconv table and see what the duplicates are. There is no need to run that, since you already know the three duplicate names.

[Sulla]

The table is in phpbb, not VB.

I just need to know how to edit the names out, which I thought the script would have done. Its a standard install of VB 3 and a brand new install of phpBB, which is what the conversion readme asks for.

I have spent days so far and am no further forward. I am not a code monkey or I would have worked it out myself. As I said before, I was very ill for a while, its taken until now for me to be in any kind of position to do this.

I found this set of conversion scripts and was like yeeha, I can dump the crappy ever hacked VB for a decent board.

I have been asking for help and am getting nowhere fast. I know its user support, I know its a user created conversion, but some useful help, [not everyone is a php genius and not everyone using phpbb or the conversion script will be a php genius! - I thought that was the point?] in getting my board back up and running would be so welcome. Oh and I know you are NOT VB support!

Rgds - Shaun

[Brf]

You need to go into your VB board and fix the names.
It cannot be converted until you remove the duplicates in your VB board.