Simple Machines Community Forum

SMF Support => Converting to SMF => phpBB => Topic started by: RFD on January 26, 2017, 07:15:11 PM

Title: conversion process ...
Post by: RFD on January 26, 2017, 07:15:11 PM
i'd assume that converting from an offline copy of a frozen live data base is the preferred way to convert.

however, in a test scenario, can a live online and active data base be subjected to an SMF conversion?
Title: Re: conversion process ...
Post by: vbgamer45 on January 26, 2017, 07:19:51 PM
You should put in read only/maintenance mode the forum data being converted just in case.
Title: Re: conversion process ...
Post by: RFD on January 29, 2017, 06:18:09 PM
gotcha - good advice, thanx.  8)
Title: Re: conversion process ...
Post by: RFD on February 06, 2017, 07:54:52 AM
i installed an SMF 2.13 forum on my server. 

both the SMF and PHPBB forums are in different sub-directories, different MYSQL databases.

when i run the SMF convert.php, with the correct location sub-directories each forum, then enter the SMF database password, the convert immediately errors out ...

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FNqUa6vO.png&hash=813774669b7bfde2da2ec6cf6811f5f9155048fb)

???????
Title: Re: conversion process ...
Post by: Illori on February 06, 2017, 07:58:55 AM
read http://www.simplemachines.org/community/index.php?topic=146192.0 and/or http://wiki.simplemachines.org/smf/Converting#Database_Access
Title: Re: conversion process ...
Post by: RFD on February 06, 2017, 08:16:00 AM
re: "Problem: SELECT command denied to user
Info: The cause of this error is that SMF and Software X are in separate databases and the SMF database user does not have access to Software X's database.
Fix: If your host has cPanel you can add the SMF database user to Software X's database.  If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as Software X."

i do have a domain control panel and i have two MYSQL databases, PHPBB and SMF.  i see no control panel provision to meld the two databases, and even so, when the conversion to SMF is successful, how would i delete the PHPBB database?

why doesn't the convert software just ask for the pwds to each database?   
Title: Re: conversion process ...
Post by: Illori on February 06, 2017, 08:26:53 AM
even if it has the password for both databases that does not mean it would have access to write to them correctly. if you dont know how to grant the access to both databases under the same username as your host if they can help you with that.
Title: Re: conversion process ...
Post by: RFD on February 06, 2017, 09:10:55 AM
figured it out, just needed to add the same db user/password to both databases.

conversion process started and then hung up here ...

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FP8p3nGK.png&hash=f6f5f8d29f416484fbe9f4ad84b7fcc686e8c74e)

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FxqPNFSt.png&hash=a177247038c4516a0107781e0bb9dc4e6652f023)

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FsLDu5Rm.png&hash=467d30529ce6e2d1d7c337cbc78b3512fef60662)

... forum partially migrated, missing posts past 2013.
Title: Re: conversion process ...
Post by: RFD on February 06, 2017, 09:50:42 AM
finally found maragrett's conversion code and ran it - worked Perfectly.  8) ;D ;)
Title: Re: conversion process ...
Post by: Illori on February 06, 2017, 09:53:47 AM
Quote from: RFD on February 06, 2017, 09:50:42 AM
finally found maragrett's conversion code and ran it - worked Perfectly.  8) ;D ;)

might help others if you attach it to your next reply so they can use it as well.
Title: Re: conversion process ...
Post by: RFD on February 06, 2017, 09:59:10 AM
bruno's tweaked PHPBB3 conversion code to SMF2 ...