Any way to know if conversion is actually running ?

Started by Mornagest, October 20, 2021, 11:39:52 AM

Previous topic - Next topic

Mornagest

Hello,

I installed a local SMF 2.0.18 and a vB 4.2.3 with a copy of our database to make some tests and see what happens (spoiler alert: nothing  ;D ).

So I'm stuck on the first step: converting members.

I THINK I'm stuck, because I don't see any way to know if the process is running or not.

So the question is: is there any gear, or something like this to be sure that the process hasn't freeze for twelve hours or so?

Or the only way is to guess what the situation is?

Thank you for your answers! :)

Doug Heffernan

Can you post a screenshot of the conversion page?

P.s. Did you install both forums on the same database? Or if you used different databases, does the db user has permisisons to both databases?

Mornagest

Hello Doug,

Thank you for your answer!

Yes, I pointed to the same db than vB when I installed SMF on my computer. I created a superadmin account for MySQL (since it's mostly for test purposes) and this account can do everything in MySQL (i.e. create or prune databases).

Here's a screenshot:


Doug Heffernan

Quote from: Mornagest on October 20, 2021, 12:17:10 PMHello Doug,

Thank you for your answer!

Yes, I pointed to the same db than vB when I installed SMF on my computer. I created a superadmin account for MySQL (since it's mostly for test purposes) and this account can do everything in MySQL (i.e. create or prune databases).

Here's a screenshot:



No problem :)

It looks like the converter is running normally looking at that screenshot. How many members do you have? In large forums it is normal that it takes some time.

Anyways, without any message shown up, it is hard to pinpoint the real issue imo. All one can do is guess I am afraid.

Mornagest

We have about 5000 members; script is running for one hour and half now.

I'll wait until tomorrow but I hope it will work at last.

Thank you for your answer :)

Doug Heffernan

Quote from: Mornagest on October 20, 2021, 01:13:30 PMWe have about 5000 members; script is running for one hour and half now.

I'll wait until tomorrow but I hope it will work at last.

Thank you for your answer :)

You are welcome :)

It should not take that long to convert 5000 members imo. Can you check the smf_members table of your smf forum and see if it has been populated? How many rows are there?

Mornagest

All I get is this :(

edit : argh I realized I created a specific db for SMF!!! I had to use the one of vBulletin, I guess...?   :-[

+----------------------+-----------------------+------+-----+------------+----------------+
| Field                | Type                  | Null | Key | Default    | Extra          |
+----------------------+-----------------------+------+-----+------------+----------------+
| id_member            | mediumint(8) unsigned | NO   | PRI | NULL       | auto_increment |
| member_name          | varchar(80)           | NO   | MUL |            |                |
| date_registered      | int(10) unsigned      | NO   | MUL | 0          |                |
| posts                | mediumint(8) unsigned | NO   | MUL | 0          |                |
| id_group             | smallint(5) unsigned  | NO   | MUL | 0          |                |
| lngfile              | varchar(255)          | NO   | MUL |            |                |
| last_login           | int(10) unsigned      | NO   | MUL | 0          |                |
| real_name            | varchar(255)          | NO   | MUL |            |                |
| instant_messages     | smallint(5)           | NO   |     | 0          |                |
| unread_messages      | smallint(5)           | NO   |     | 0          |                |
| new_pm               | tinyint(3) unsigned   | NO   |     | 0          |                |
| buddy_list           | text                  | NO   |     | NULL       |                |
| pm_ignore_list       | varchar(255)          | NO   |     |            |                |
| pm_prefs             | mediumint(8)          | NO   |     | 0          |                |
| mod_prefs            | varchar(20)           | NO   |     |            |                |
| message_labels       | text                  | NO   |     | NULL       |                |
| passwd               | varchar(64)           | NO   |     |            |                |
| openid_uri           | text                  | NO   |     | NULL       |                |
| email_address        | varchar(255)          | NO   |     |            |                |
| personal_text        | varchar(255)          | NO   |     |            |                |
| gender               | tinyint(4) unsigned   | NO   |     | 0          |                |
| birthdate            | date                  | NO   | MUL | 0001-01-01 |                |
| website_title        | varchar(255)          | NO   |     |            |                |
| website_url          | varchar(255)          | NO   |     |            |                |
| location             | varchar(255)          | NO   |     |            |                |
| icq                  | varchar(255)          | NO   |     |            |                |
| aim                  | varchar(255)          | NO   |     |            |                |
| yim                  | varchar(32)           | NO   |     |            |                |
| msn                  | varchar(255)          | NO   |     |            |                |
| hide_email           | tinyint(4)            | NO   |     | 0          |                |
| show_online          | tinyint(4)            | NO   |     | 1          |                |
| time_format          | varchar(80)           | NO   |     |            |                |
| signature            | text                  | NO   |     | NULL       |                |
| time_offset          | float                 | NO   |     | 0          |                |
| avatar               | varchar(255)          | NO   |     |            |                |
| pm_email_notify      | tinyint(4)            | NO   |     | 0          |                |
| karma_bad            | smallint(5) unsigned  | NO   |     | 0          |                |
| karma_good           | smallint(5) unsigned  | NO   |     | 0          |                |
| usertitle            | varchar(255)          | NO   |     |            |                |
| notify_announcements | tinyint(4)            | NO   |     | 1          |                |
| notify_regularity    | tinyint(4)            | NO   |     | 1          |                |
| notify_send_body     | tinyint(4)            | NO   |     | 0          |                |
| notify_types         | tinyint(4)            | NO   |     | 2          |                |
| member_ip            | varchar(255)          | NO   |     |            |                |
| member_ip2           | varchar(255)          | NO   |     |            |                |
| secret_question      | varchar(255)          | NO   |     |            |                |
| secret_answer        | varchar(64)           | NO   |     |            |                |
| id_theme             | tinyint(4) unsigned   | NO   | MUL | 0          |                |
| is_activated         | tinyint(3) unsigned   | NO   |     | 1          |                |
| validation_code      | varchar(10)           | NO   |     |            |                |
| id_msg_last_visit    | int(10) unsigned      | NO   |     | 0          |                |
| additional_groups    | varchar(255)          | NO   |     |            |                |
| smiley_set           | varchar(48)           | NO   |     |            |                |
| id_post_group        | smallint(5) unsigned  | NO   | MUL | 0          |                |
| total_time_logged_in | int(10) unsigned      | NO   | MUL | 0          |                |
| password_salt        | varchar(255)          | NO   |     |            |                |
| ignore_boards        | text                  | NO   |     | NULL       |                |
| warning              | tinyint(4)            | NO   | MUL | 0          |                |
| passwd_flood         | varchar(12)           | NO   |     |            |                |
| pm_receive_from      | tinyint(4) unsigned   | NO   |     | 1          |                |
+----------------------+-----------------------+------+-----+------------+----------------+
60 rows in set (0,00 sec)

Doug Heffernan

Quote from: Mornagest on October 20, 2021, 01:53:43 PMAll I get is this :(

edit : argh I realized I created a specific db for SMF!!! I had to use the one of vBulletin, I guess...?   :-[


Indeed. The best way would be to install your smf forum in the same db that you are using for your vb forum. Hence why I asked in my first post if you used the same database for both forums.

Or if you use a different databases like it appears, it would be best to assign the db user from the vb db  and give/grant it full permissions/privileges or both db users have full permissions/privileges to each other databases.

But the first way is the best way to go about it imho. Hope it helps.

Mornagest

Yeah I reinstalled SMF using the same database, sorry for being dumb...  :-[

I'll make another try tomorrow; I think there is a problem with my local install of vBulletin, because of PHP version (7.2 on my machine and online we have a far older version because of vB which is old).

So I'll update vBulletin locally first to get it compatible with PHP 7.2 :)

Thank you for your answers; I'll give some news when I have them!

Mornagest

#9
So I installed my vBulletin forum locally on my computer and then reinstalled SMF 2.0.18 pointing to the same database (I double checked).

Unfortunately, while running the convert.php script, I immediately get this error on the first step:

QuoteConverting members...
Notice: Undefined property: mysqli_result::$EOF in /var/www/cctest/convert.php on line 2731

Notice: Undefined property: mysqli_result::$Fields in /var/www/cctest/convert.php on line 2735

Notice: Trying to get property of non-object in /var/www/cctest/convert.php on line 2736

Fatal error: Call to undefined method mysqli_result::MoveNext() in /var/www/cctest/convert.php on line 2741

I don't really know what that means... any idea?

Thank you!


Edit: OK so the point is I have to install vBulletin and SMF with PHP 5.6 but convert.php needs PHP 7.1 to run properly  ;D

It is actually running, I hope it will work... I give news when I have some!


Second edit: well that seems to fail like the first time: nobody in smf_members and the script seems to run an infinite loop while converting members.

What's wrong?  :(

Mornagest

Double post, sorry... but I have another question :)

What are the requirements to run the convert.php script correctly? I mean, do I need a specific version of PHP, Apache2, MySQL...?

As I saw yesterday that with PHP 5.6 the script was failing at the very beginning, I can imagine that 7.1 isn't the appropriate version of PHP. Could it be 7.2, or so?

Thank you for your answers!

Mornagest

OK so I got some answers by trying things found here: https://www.simplemachines.org/community/index.php?msg=4011029 :)

I used this .sql file instead of the one for vB 4: https://github.com/SimpleMachines/converters/tree/master/SMF2.0/Vbulletin/3.7 [nofollow]

And this version of convert.php: https://github.com/SimpleMachines/converters/blob/master/SMF2.0/convert.php [nofollow]

Also, I edited /etc/mysql/mysql.conf.d/mysqld.cnf and added

sql_mode =""
after [mysqld]

then restarted MySQL with sudo systemctl restart mysql

And at last, I ran convert.php and it worked. It took only a second to convert our 5000 members, but it took more time for posts (about 450,000 posts).

It is still running for the moment, I'll try to log in but I guess it will be difficult since every link leads to the online site instead of the local copy ^^


PS: running with PHP 7.1; don't know if that works with 5.6

Advertisement: