Advertisement:

Author Topic: [SMF Converter] Yabb - 2.1  (Read 373539 times)

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #440 on: August 02, 2008, 01:09:39 PM »
It is the smf password it uses to connect to the database. This is for security reasons only.

Okay, so if I'm installing SMF via cPanel that would be the admin password I put in right?  If so, that hasn't been working...

I've also tried creating a mySQL user with a password and adding it to the SMF database, but that isn't working either.  Is there any kind of coding file that I could look through to find the password?

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,640
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb - 2.1
« Reply #441 on: August 02, 2008, 01:15:10 PM »
If you installed SMF via cpanel, you most likely where not told the mysql database password.

Open the Settings.php file, in there is a $db_passwd field. It contains your database password inside the quotes.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #442 on: August 02, 2008, 01:19:07 PM »
If you installed SMF via cpanel, you most likely where not told the mysql database password.

Open the Settings.php file, in there is a $db_passwd field. It contains your database password inside the quotes.

Awesome, I'll try that and that should most likely work.

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #443 on: August 02, 2008, 01:28:29 PM »
Successfully converted everything except for poll votes, no big deal.  Except that when I go to the SMF board, there are no posts there, just looks like the members, boards and categories transferred over.  Guess I'll re-read through this thread to see what went wrong.

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #444 on: August 02, 2008, 01:43:49 PM »
Okay, it doesn't look like the conversion is completing because of the poll votes error.  Here's some screenshots of the error, any suggestions?


Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,640
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb - 2.1
« Reply #445 on: August 02, 2008, 01:47:15 PM »
Give the one attached to the first post in this topic a try  :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #446 on: August 02, 2008, 01:50:01 PM »
Give the one attached to the first post in this topic a try  :)

Just ran that on a clean install no change.  Based on the other guy that had poll problems seems like I might have to try and delete the multiple poll IDs... no idea how to do that, though.  I'd rather not have to delete all my polls.

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #447 on: August 02, 2008, 01:53:49 PM »
I can easily see the duplicate on the error message, but I'm not sure how I'd go about finding that in the YaBB files.

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #448 on: August 02, 2008, 02:21:46 PM »
Any suggestions, nothing obvious sticks out to me after looking at the yabb poll file.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,640
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb - 2.1
« Reply #449 on: August 02, 2008, 02:45:15 PM »
Give this one a test. It is a bit untested as I fixed some issues I found while updating the converter for Yabb 2.2, but it should work and ignore those poll duplicate errors.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline shanksta13

  • Jr. Member
  • **
  • Posts: 227
Re: [SMF Converter] Yabb - 2.1
« Reply #450 on: August 02, 2008, 03:26:27 PM »
Give this one a test. It is a bit untested as I fixed some issues I found while updating the converter for Yabb 2.2, but it should work and ignore those poll duplicate errors.

Worked like a charm, thanks a ton!

Offline Exposed_Bone

  • Semi-Newbie
  • *
  • Posts: 34
Re: [SMF Converter] Yabb - 2.1
« Reply #451 on: November 08, 2008, 10:45:57 AM »
What does mean the "Warning: set_time_limit() has been disabled for security reasons in /home/****/public_html/smf/convert.php on line 29" ?

ThorstenE

  • Guest
Re: [SMF Converter] Yabb - 2.1
« Reply #452 on: November 08, 2008, 02:24:03 PM »
the convert.php uses set_time_limit() to increase the maximum execution time for itself... On bigger board the conversion took a while and most hosts have limitations for executing scripts.
the error above means that your host doesn't allow to increase the script execution time.

If you have a smaller board the conversion is possible, if you have a big board the conversion possibly fails. Then you can only make a backup of your old board, install a local webserver enrironment (XAMPP for example) and convert on your local computer.

Offline dreampeople

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] Yabb - 2.1
« Reply #453 on: December 01, 2008, 11:07:26 AM »
Give this one a test. It is a bit untested as I fixed some issues I found while updating the converter for Yabb 2.2, but it should work and ignore those poll duplicate errors.

Hi Sleepy,

Conversion worked really well for my site, everything I needed seems to have been converted.  Have just noticed the user "post count" is not incrementing, same for all users and admin.  Any thoughts?

Thanks

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,640
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Yabb - 2.1
« Reply #454 on: December 02, 2008, 02:10:35 PM »
Have you tried to go to Admin -> Boards.
Then check each board to make sure Count posts option is checked? This may not be checked.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline dreampeople

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] Yabb - 2.1
« Reply #455 on: December 03, 2008, 05:51:52 AM »
Aghhhhhhhhhh you are right, looking for the difficult option I totally missed the obvious! Its odd that another fresh install I made of SMF was fine, but the yabb conversation wasnt.

Thanks, help is very much appreciated

Offline enna

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb - 2.1
« Reply #456 on: January 25, 2009, 12:21:54 AM »
does it really take more than 12 hours to complete the "clean up"??

it has been converting for more than 12 hours now.... im getting worried about this.

ThorstenE

  • Guest
Re: [SMF Converter] Yabb - 2.1
« Reply #457 on: January 25, 2009, 02:00:39 AM »
does it really take more than 12 hours to complete the "clean up"??

it has been converting for more than 12 hours now.... im getting worried about this.
Uhh, sounds like you are using our old Yabb Converter. You'll find a new version attached. The old converter removes some indexes from the SMF database tables during the conversion. Therefore it's better to start with new SMF installation, then use the attached converter..

Offline enna

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] Yabb - 2.1
« Reply #458 on: January 25, 2009, 08:39:37 AM »
thanks i got it running again but then another error occured.. i got an unsuccessful convert with registering statistics

it says:

Converting...
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `NAME_forum`.NAME_topics
    ADD PRIMARY KEY (ID_TOPIC),
    ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD),
    ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
    ADD UNIQUE poll (ID_POLL, ID_TOPIC);

Caused the error:

    Duplicate entry '0' for key 1


well i know i already posted this... so sorry for the double post... just gets confusing sometimes.
« Last Edit: January 25, 2009, 02:14:17 PM by enna »

ThorstenE

  • Guest
Re: [SMF Converter] Yabb - 2.1
« Reply #459 on: January 25, 2009, 09:02:34 AM »
ok, maybe we can solve this without re-conversion. can you try this please:
go to phpMyAdmin ( What is phpMyAdmin? ) and execute the following database queries:

Code: [Select]
UPDATE smf_topics SET ID_LAST_MSG = ID_LAST_MSG + 1000000;
UPDATE smf_topics SET ID_LAST_MSG = ID_FIRST_MSG + 1000000;

then go to SMF - Admin - Forum Maintenance and click "Find and repair any errors" and "Recount all forum totals and statistics".