Yet Another PHPBB2 --> YabbSE 1.5 Request

[groundup]

thats y ppl are not contacting you!

heh.. no skin off my back. I offer a premium service where I would be creating a good converter for sites large and small but I am not going to do it for free and have it be crappy

thx omar

[[Unknown]]

Alright, here's what I've done:

Written a basic template that is extensible, and thus may be changed to convert more.  (I'll get to it later, but someone may have more time than I.)

Currently, it converts the members ONLY.  No topics, messages, boards, or EVEN ADMINISTRATORS are copied.  This means you will need to know a bit of SQL to get it working.  (one way is just to run this just before completing the installer, and then insert the administrator.)  It also emails the new passwords to the users.

Please note that I do not use phpBB, and thus I have no real way to test this except with my puny database.  It may or may not even work.  However, I started it off...

What's to be done:
- other tables.
- add more steps so everything isn't done at once.
- testing.

Use at your own risk.  I provide no warranty, not even the suggested warranty of usability.  Copyright 2003 by myself.  All rights reserved.  Do not redistribute without my permission.  Only for use with YaBB SE and pfaBB.

http://gbaetc.homeip.net/yypack/converter.zip

-[Unknown]

[Trios]

Finished users => members.
Warning: fsockopen() [function.fsockopen]: php_hostconnect: connect failed in c:\inetpub\wwwroot\forum\Sources\Subs.php on line 451

Warning: fsockopen() [function.fsockopen]: unable to connect to :25 in c:\inetpub\wwwroot\forum\Sources\Subs.php on line 451

Fatal error: Call to undefined function: fatal_error() in c:\inetpub\wwwroot\forum\Sources\Subs.php on line 452

However, it does appear that it copied the users over just fine, including my admin user who is still considered an admin, so it doesnt seem that any SQL work is needed. What IS needed, however, is a way to convert categories/posts . Wish I knew PHP...

EDIT: Grr, it shows them in the member list, but when you try to login it says that username doesn't exist. Bleh


Trios

[[Unknown]]

Finished users => members.
Warning: fsockopen() [function.fsockopen]: php_hostconnect: connect failed in c:\inetpub\wwwroot\forum\Sources\Subs.php on line 451

Warning: fsockopen() [function.fsockopen]: unable to connect to :25 in c:\inetpub\wwwroot\forum\Sources\Subs.php on line 451

Fatal error: Call to undefined function: fatal_error() in c:\inetpub\wwwroot\forum\Sources\Subs.php on line 452

However, it does appear that it copied the users over just fine, including my admin user who is still considered an admin, so it doesnt seem that any SQL work is needed. What IS needed, however, is a way to convert categories/posts . Wish I knew PHP...

EDIT: Grr, it shows them in the member list, but when you try to login it says that username doesn't exist. Bleh


Trios

Uhhh.... the errors you see are because you didn't set up the sendmail/smtp for YaBB SE.

It NEEDS this to send out the new passwords.... (the old ones DO NOT work!)

-[Unknown]

[Trios]

There is NO way to set up SMTP in 1.5.1 as near as I can tell. And I don't believe that sendmail works on 2k running IIS, does it?

Trios

[[Unknown]]

There is a sendmail for NT.

However, to set up SMTP you must use the settings in 'Mods' Settings and Options not Forum Preferences and Settings.

The old ones have no effect any longer.

-[Unknown]

[Trios]

I just added in my SMTP info and got the same error.

Mind opening your Trillian so's we can get some real-time help here?

[groundup]

I just added in my SMTP info and got the same error.

Mind opening your Trillian so's we can get some real-time help here?

you should just wait for help on the board. That is what they are here for. Maybe unknown is away? Maybe he isn't coming online becaue he doesn't want to be hounded? Patience is a virtue (don't take this as me being an ass btw)

[Trios]

I've spoken with Unknown many times before this, we have gotten to know each other fairly well, so I figured it wouldn't be too bad for me to ask him to come online. Also, once he did, we got my problem straightened out (actually a problem with his converter) and now my board works, though accounts arent validated yet.

Although I must say, you did ask that in a very respectful tone, and I award you kudos.

Trios

[[Unknown]]

Updated it:

Currently, it converts the members ONLY.  No topics, messages, or boards are copied.  However, you will keep your administrators and global moderators.  It also emails the new passwords to the users.

Please note that I do not use phpBB, and thus I have no real way to test this except with my puny database.  It may or may not even work.  However, I started it off...

What's to be done:
- other tables.
- add more steps so everything isn't done at once.
- more testing.

Use at your own risk.  I provide no warranty, not even the suggested warranty of usability.  Copyright 2003 by myself.  All rights reserved.  Do not redistribute without my permission.  Only for use with YaBB SE and pfaBB.

http://gbaetc.homeip.net/yypack/converter.zip

-[Unknown]

[[Unknown]]

Updated it again:

Currently, it converts the members, categories, boards, topics, and posts.  You shouldl keep your administrators and global moderators.  All moderators will become global moderators  It also emails the new passwords to the users.

Please note that I do not use phpBB, and thus I have no real way to test this except with my puny database.  It may or may not even work.  However, I started it off...

What's to be done:
- other tables. (polls?)
- add more steps so everything isn't done at once.
- more testing.

Use at your own risk.  I provide no warranty, not even the suggested warranty of usability.  Copyright 2003 by myself.  All rights reserved.  Do not redistribute without my permission.  Only for use with YaBB SE and pfaBB.

http://gbaetc.homeip.net/yypack/converter.zip

Tested.  It works to some extent; the only known bug is that it doesn't convert ubbc tags properly.

-[Unknown]

[Darkknight550]

When i try to run the converter this is what i get.

Finished users => members.
Finished categories => categories.
Finished forums => boards.
Finished topics => topics.
Finished posts => messages.
Finished posts_text => messages.
User 'XXXXX' has exceeded the 'max_questions' resource (current value: 36000)

How many more items does the converter convert? After I run this my forums come up blank. Only thing on them is the yabbse logo and the date and time. I'm guessing that the converter has more steps to it that it can't do because it hits my host powwebs mysql limits.

[[Unknown]]

When i try to run the converter this is what i get.

Finished users => members.
Finished categories => categories.
Finished forums => boards.
Finished topics => topics.
Finished posts => messages.
Finished posts_text => messages.
User 'XXXXX' has exceeded the 'max_questions' resource (current value: 36000)

How many more items does the converter convert? After I run this my forums come up blank. Only thing on them is the yabbse logo and the date and time. I'm guessing that the converter has more steps to it that it can't do because it hits my host powwebs mysql limits.

The only thing I can recommend is that you attempt to set up a local server for the conversion.

Here's a topic where someone did it for YaBB:
http://www.yabbse.org/community/index.php?board=132;action=display;threadid=19346

You will need to be able to download your phpBB database to do this though...

I will try to rewrite the converter soon - right now it's all one step, and that's what's causing the problem.

-[Unknown]

[szr]

Finished users => members.
Finished categories => categories.
Finished forums => boards.
Finished topics => topics.
Finished posts => messages.
Finished posts_text => messages.

Fatal error: Call to undefined function: database_error() in Sources/Subs.php on line 73

------------------------------------------------------------------------

Line 73:  

Code Select Expand

         $result = mysql_query("SELECT memberName,realName FROM {$db_prefix}members ORDER BY dateRegistered DESC LIMIT 1") or database_error(__FILE__, __LINE__);

------------------------------------------------------------------------

YaBBSE:  1.5.1
PHP:  4.3.1
Apache:  1.3.27
MySQL:  3.23.56

[haase]

I got this error too, but everything seems to be working fine.  I'm not sure what this query was supposed to do?

**edit***

This is in the update stats function in Subs.  I'm not sure what was to be done, because my stats all appear to be correct.