i have both the old phpBB and new SMF databases online and both work. all are on the same server and domain. running the converter i get this error message ...
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FWAIpWG2.png&hash=5b9fea06807851ec6639e8d0babe365a5197e8ea)
The error is more or less self-explanatory... Let's try to explain it better.
Your phpBB is configured to use a certain database, user and password. Check your forum/config.php file, you'll have something like:
$dbname = 'xyzxyz';
$dbuser = 'abcabc';
$dbpasswd = 'defdef';
This means that phpBB will connect the the database "xyzxyz" with the user "abcabc"
Now, check SMF's settings, in the file tmaforum/Settings.php
$db_name = 'smf_database';
$db_user = 'smf_user';
$db_passwd = 'smf_user_password';
The same way, SMF will connect to the database "smf_database" with the user "smf_user".
When the converter runs, all it is able to use are SMF's credentials. But it needs to access both databases...
This means that the converter will connect to the database "xyzxyz" with the user "smf_user".
That error tells you that the user "smf_user" is not allowed to access the database "xyzxyz" (where phpBB data is).
You either:
- go to your cPanel --> Databases and add the user "smf_user" to the database "xyzxyz", or
- install SMF in the "xyzxyz" database with the same credentials user by phpBB
thanx for your help, got it all squared away and was able to kick off the conversion, which never fully completed and hung up with this error message ....
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2Fjm4Y2je.png&hash=894f2d6c277929d7dd02b9a9d0d300e99a129f40)
viewing the SMF conversion results show none of the forums have posts past 2012 (should have all years up to today) ...
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FoBsYPAz.png&hash=0a839bcbcdcaa60b6b10cdcbf3aaa29fd5d3fb9f)
Try this converter
http://www.simplemachines.org/community/index.php?action=dlattach;topic=543296.0;attach=246529
same error message as above.
Check your phpBB database, table "prefix_posts". There should be a column "post_edit_count"
Click on the column name, it should order the table through it. Is there any NULL value?
Quote from: margarett on June 27, 2016, 07:00:26 PM
Check your phpBB database, table "prefix_posts". There should be a column "post_edit_count"
Click on the column name, it should order the table through it. Is there any NULL value?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FOW7sSEN.png&hash=f3b36a1695f707180cc09fe18a4fd7c0a633c6d7)
That's structure view, we need the table contents ;)
Quote from: margarett on June 27, 2016, 07:34:17 PM
That's structure view, we need the table contents ;)
sorry, mysql data base dumb, have no clue what yer asking for. you want access to the db?
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2Fk0lCsaX.png&hash=307efe3ef07dc42d3e118db23d7deff5506901f6)
Yes, if you don't mind, please PM me access to your cPanel. But I'm going to bed now so only tomorrow
Quote from: margarett on June 27, 2016, 07:54:36 PM
Yes, if you don't mind, please PM me access to your cPanel. But I'm going to bed now so only tomorrow
roger that, very much obliged. will pm now and hit the hay as well. talk tomorrow.
bruno (margarett) - trying to contact you vis a vis the conversion ... ?
Saw this same issue on another conversion lately for phpbb3. been looking for a fix
margarett (bruno) solved it by modifying the phpbb-smf conversion code. unfortunately, at this point only he has that fix ....
problem solved with bruno's convert code (PHPBB3 to SMF2)