Wedge

Public area => The Pub => Importing into Wedge => Topic started by: Bunstonious on January 30th, 2014, 11:42 AM

Title: MyBB Import
Post by: Bunstonious on January 30th, 2014, 11:42 AM
Not sure if this is the right place to post this but i get a deprecated command message when I try to import from MyBB 1.6.

(http://i.imgur.com/3AECDrj.png)

I have tried adding php variables that ignore deprecation warnings but still same thing.
Title: Re: MyBB Import
Post by: MultiformeIngegno on January 30th, 2014, 12:37 PM
Redownload the importer from github. It was updated yesterday. Next time read at least the previous page though
Title: Re: MyBB Import
Post by: Nao on January 30th, 2014, 07:47 PM
Quote from Bunstonious on January 30th, 2014, 11:42 AM
Not sure if this is the right place to post this but i get a deprecated command message when I try to import from MyBB 1.6.
Like Lorenzo said. Update your files.
Generally speaking, if you ever have any bug in anything related to Wedge, make sure you have the latest version of everything installed. I can't possibly ask everyone of you whether you're up to date...

Also, would like for you to keep me posted on whether MyBB 1.6 is properly imported...

(And as a reminder: Wedge is in alpha; please do not use it in production until it gets stable.)
Title: Re: MyBB Import
Post by: Bunstonious on January 30th, 2014, 10:12 PM
Sorry guys,

Thought  was up to date but clearly I am on something. :P

Worked ok, although not sure if how you are going with the importer but it does wipe any post / user that w's created before the import (on the wedge side).

And don't worry, been waiting patiently for 3 years for wedge, and have seen all of the "Its only alpha" posts. My forum is only a small personal forum with a few friends to co-ordinate with my Minecraft server (although feel free to sign up ;) ) :P
Quote from Nao on January 30th, 2014, 07:47 PM
Quote from Bunstonious on January 30th, 2014, 11:42 AM
Not sure if this is the right place to post this but i get a deprecated command message when I try to import from MyBB 1.6.
Like Lorenzo said. Update your files.
Generally speaking, if you ever have any bug in anything related to Wedge, make sure you have the latest version of everything installed. I can't possibly ask everyone of you whether you're up to date...

Also, would like for you to keep me posted on whether MyBB 1.6 is properly imported...

(And as a reminder: Wedge is in alpha; please do not use it in production until it gets stable.)
Title: Re: MyBB Import
Post by: Bunstonious on January 30th, 2014, 10:26 PM
Oh, I forgot to mention the single poll I had (whether to migrate fully to Wedge, lol) failed for some reason.

Only the options (sorry I closed the error before I screencapped)

Edit 1: I might run up a test site and replicate.


Title: Re: MyBB Import
Post by: Bunstonious on January 31st, 2014, 03:55 AM
I redid the tests, these are the errors I got:

(http://i.imgur.com/WuiK2Ob.png)

(http://i.imgur.com/fgdovNX.png)

Fixed the first one by deleting the poll choices, other one not sure what's wrong but I think it times out after that.

Also, the boards all import but sub boards are just dumped in the main section and you can't see them in the list of "boards" available to move them.

Edit1: I also noticed that users don't get added to the "post count" positions.
Title: Re: MyBB Import
Post by: Pandos on January 31st, 2014, 10:29 AM
Quote from Bunstonious on January 31st, 2014, 03:55 AM
(http://wedge.org/)

Fixed the first one by deleting the poll choices, other one not sure what's wrong but I think it times out after that.

Also, the boards all import but sub boards are just dumped in the main section and you can't see them in the list of "boards" available to move them.

Edit1: I also noticed that users don't get added to the "post count" positions.
As far as I can see there are two things that went wrong:
1. id_attach is autoincrement. So there are duplicate entries for different attachments?
2. Column count doesn't match means that there are 5 columns in wedge table, but e.g. your last line refers only two columns.
Title: Re: MyBB Import
Post by: Bunstonious on January 31st, 2014, 11:20 AM
Quote from Pandos on January 31st, 2014, 10:29 AM
Quote from Bunstonious on January 31st, 2014, 03:55 AM
(http://wedge.org/)

Fixed the first one by deleting the poll choices, other one not sure what's wrong but I think it times out after that.

Also, the boards all import but sub boards are just dumped in the main section and you can't see them in the list of "boards" available to move them.

Edit1: I also noticed that users don't get added to the "post count" positions.
As far as I can see there are two things that went wrong:
1. id_attach is autoincrement. So there are duplicate entries for different attachments?
2. Column count doesn't match means that there are 5 columns in wedge table, but e.g. your last line refers only two columns.
Probably, data wasn't important.
Title: Re: MyBB Import
Post by: Nao on January 31st, 2014, 02:45 PM
Pandos, I'm asking for the result of that query... not for the query itself... I'm not a SQL champ but I can still write those without help... I hope :lol:

Bun', I'm thinking this might be a problem with the mybb import script because the SMF version is working fine for everyone Herr...

At worst, you could always convert to SMF 2 and then use the converted again for Wedge...?
Title: Re: MyBB Import
Post by: Bunstonious on January 31st, 2014, 02:57 PM
Quote from Nao on January 31st, 2014, 02:45 PM
Pandos, I'm asking for the result of that query... not for the query itself... I'm not a SQL champ but I can still write those without help... I hope :lol:

Bun', I'm thinking this might be a problem with the mybb import script because the SMF version is working fine for everyone Herr...

At worst, you could always convert to SMF 2 and then use the converted again for Wedge...?
Nah it's all good, I managed to get it working by removing the offending data (and then readding it manually), but it might be an idea to note it down for future revisions so larger sites don't have as many issues.

Mine is a small site that has like 10 users :P
Title: Re: MyBB Import
Post by: Bunstonious on February 1st, 2014, 12:33 PM
Quote from Nao on January 31st, 2014, 04:15 PM
@Bun, well the good thing about this importer is that it's relatively forgiving with DB errors, but still, that's something to fix...
Yeah its just some feedback so some myBB extraordinaire can fix one day.
Title: Re: MyBB Import
Post by: TE on February 2nd, 2014, 09:48 AM
checked the URL from your screenshots, the board seems imported?
Title: Re: MyBB Import
Post by: Bunstonious on February 2nd, 2014, 10:00 AM
Quote from TE on February 2nd, 2014, 09:48 AM
checked the URL from your screenshots, the board seems imported?
I removed the offending data and the board imported ok.

Just reported my experience.
Title: Re: MyBB Import
Post by: Norodo on February 2nd, 2014, 02:54 PM
Ooooooh. There's a MyBB importer? Now I'm even more interested in getting Wedge to work.
Title: Re: MyBB Import
Post by: Nao on February 2nd, 2014, 11:22 PM
I still don't get why you didn't vote when the original 5.2 vs 5.3 poll took place... :^^;:

And you know, you've had access to the importer for a long time, and it already had the MyBB script in it..? ;)
Posted: February 2nd, 2014, 11:01 PM

(And yes, I still haven't been to your website to check out what's wrong and try to fix it... Sorry! A bit overwhelmed, these days...)
Title: Re: MyBB Import
Post by: Norodo on February 2nd, 2014, 11:25 PM
Don't worry. It's not like I need to switch anytime soon.
Title: Re: MyBB Import
Post by: Bunstonious on February 3rd, 2014, 12:43 AM
The importer works well, has a few quirks tho.

8/10 would recommend.
Title: Re: MyBB Import
Post by: Nao on February 3rd, 2014, 01:31 PM
I've updated the importer with a tentative fix for MyBB and count_posts. It's only going to work if MySQL understands the word 'yes' as '1' when working on an integer field. I couldn't find any information on that, but I'm going to assume that was the reason it didn't work. MyBB's usepostcounts works the same way as Wedge's count_posts, so there's really no reason not to do a direct import of that field.
Title: Re: MyBB Import
Post by: TE on February 4th, 2014, 06:16 PM
Quote from Bunstonious on February 3rd, 2014, 12:43 AM
The importer works well, has a few quirks tho.

8/10 would recommend.
Thanks, which version was your MyBB @Bunstonious ? I haven't used MyBB for a while, maybe they changed their database layout meanwhile..
Title: Re: MyBB Import
Post by: Nao on February 4th, 2014, 06:36 PM
I doubt they'd change it within the same major version...
1.6 has usepostcounts as a boolean, as I said, so the only issue in your import script was that it tested against != 'yes', instead of just importing it straight away.
Title: Re: MyBB Import
Post by: TE on February 4th, 2014, 06:52 PM
ah ok, I'll re-install MyBB and do some tests...
I think Poll choices  is a "must have" and avatar filenames need cleaning:
http://i.imgur.com/fgdovNX.png
Title: Re: MyBB Import
Post by: Nao on February 4th, 2014, 08:20 PM
Oh... Indeed :lol:
Title: Re: MyBB Import
Post by: Bunstonious on February 4th, 2014, 09:47 PM
Quote from TE on February 4th, 2014, 06:16 PM
Quote from Bunstonious on February 3rd, 2014, 12:43 AM
The importer works well, has a few quirks tho.

8/10 would recommend.
Thanks, which version was your MyBB @Bunstonious ? I haven't used MyBB for a while, maybe they changed their database layout meanwhile..
I had just upgraded to 1.6.12, but there had been no DB changes since 1.6.10 which I was on for 6months to. Year.
Title: Re: MyBB Import
Post by: Gerriet on May 21st, 2014, 06:56 PM
Hello all ;D

I have two Problems, at first I love this forensoftware ;D But Wegde is not for productionssites right ? So I will go and that is my second problem, I search a Mybb converter for SMF 2.0.7,  So now I what I can do ?

I can search now a mybb converter for smf or I wait on the first release ... bad thing ..But I will not wait, so my question, can I wegde install als productionsforum ?

Greetings

Gerriet
Title: Re: MyBB Import
Post by: Pandos on May 21st, 2014, 07:04 PM
Hi Gerriet,

what others declare as RC is ways behind Wedge's actual developement status.
It's really stable.
There are some known issues (Look in Bug Reports). But nothing that will stop you from using this software on production sites.

It's up to you, if you can live with those bugs meanwhile...
Title: Re: MyBB Import
Post by: Gerriet on May 21st, 2014, 07:14 PM
Hi Pandros ;D

Thanks for fhe fast answer. Ok, is the Mybb Importer test with fhe mybb 1.6-13 ?
Title: Re: MyBB Import
Post by: Pandos on May 21st, 2014, 07:21 PM
I think it's 1.6.12 as mentioned above from @Bunstonious ?
Don't know about the DB changes in MyBB, Sorry. Give it a try and if there's an issue, you are welcome to post the erros here. That's the only way we can get informed about errors in the importer script.
Title: Re: MyBB Import
Post by: Gerriet on May 21st, 2014, 09:02 PM
OK, I have now ímportet in a wegde forum and have become this messages

Code: [Select]
Sorry, the database connection information used in the specified installation of Wedge cannot access your data. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it. Make sure that both the original forum and your Wedge forum are using the same MySQL server and database.

The error MySQL gave was: 'SELECT command denied to user 'db72203_25'@'local3' for table 'mybbff_users'

I not know, what is wrong, I have the datenbank from mybb imported in the datenbank from the wegde forum.
Title: Re: MyBB Import
Post by: Pandos on May 21st, 2014, 09:07 PM
OK, translate it to German: :)

Du benötigst eine Datenbank Wedge und eine Datenbank von deiner MyBB Installation.

Die Informationen besagen eigentlich, dass Du keinen Zugriff auf die Datenbank hast (Rechte falsch?)
Title: Re: MyBB Import
Post by: Gerriet on May 21st, 2014, 09:55 PM
Na das macht es ja einfacher ;D

ne eigentlich nicht, hab die mybb datenbank genommen und den prefix umbenannt und dann halt in der wegde db importiert. Das ist ja das seltsame, das passwort ist richtig. Aber ich werde das morgen nochmal durchspielen, ist schon ziemlich spät ..

Greetings

Gerriet
Title: Re: MyBB Import
Post by: Pandos on May 22nd, 2014, 07:57 AM
Versuche es einfach mit zwei getrennten Datenbanken.
Title: Re: MyBB Import
Post by: Gerriet on May 22nd, 2014, 08:29 AM
Nein, habs anders gemacht, hab mein forum auf die Db von dem Wedge db gesetzt. Das Script ist durchgelaufen, danach kam diese Fehlermeldung

Unknown column 'message_labels' in 'field list'

Ich glaube in Mybb 1.6.13 haben die einige Änderungen vorgenommen, ich werde es mal mit der 12er versuchen, da hab ich noch ein backup.

Mal was anderes, warum wird meine Sig nicht mehr drangehängt ?
Title: Re: MyBB Import
Post by: Pandos on May 22nd, 2014, 08:32 AM
Ja, wenn das so klappen würde, wäre es natürlich das Beste.

Signatur?
Ich sehe keine in Deinem Account?
Title: Re: MyBB Import
Post by: Gerriet on May 22nd, 2014, 08:40 AM
Ab 10 Beiträge wird meine Sig sichtbar .. ok, ist einleuchtend ;D

Ok das mit der andere DB backup hat nicht geklappt, da kommt dieselbe Error Message

Inwieweit wurde der Importer eigentlich getestet ?

Aber trotzdem erstmal danke fürs helfen ;D

Nachtrag: Ich werde mal ein Versuch über SMF machen, mal obs funktioniert ..

Tschöö

Gerriet
Title: Re: MyBB Import
Post by: Gerriet on May 22nd, 2014, 10:54 AM
Ok, I have now import my mybb forum over smf. At first I have import in a SMF forum an then imported to Wedge ;D

Is a long way, but I think is good way ;D

Have a nice day ;D