Advertisement:
NameCheap

Author Topic: [SMF Converter] Vanilla 1.1.x  (Read 28481 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
[SMF Converter] Vanilla 1.1.x
« on: February 07, 2008, 04:33:54 PM »
Software: Vanilla
Version: 1.1.x

This is a converter for Vanilla board.  This just convert Members, Boards, Topics, Posts and Basic Settings.  I add any add-ons support, so this will just convert a vanilla install of Vanilla ;) :P.

Notes:
- Set SMF to UTF-8 mode since Vanilla is set to UTF-8 by default.

Changelog
! Convert some basic settings.
! Initial upload.

convert.php
Use this convert.php with the .sql file attached in this topic.
« Last Edit: October 25, 2008, 09:03:52 PM by SleePy »
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline johnblade

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] Vanilla 1.1.x
« Reply #1 on: February 14, 2008, 08:10:33 PM »
Thank you so much, this is just what I've been needing!  With this I can make the switch back to SMF!

I had some difficulties at first because it wasn't finding the right Vanilla tables because the prefix for some reason wasn't in the Vanilla configuration file.

So I changed the SQL file to: ---~ from_prefix: "`$Configuration[DATABASE_NAME]`.LUM_"

and it worked a treat.
« Last Edit: February 14, 2008, 08:12:04 PM by johnblade »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] Vanilla 1.1.x
« Reply #2 on: February 15, 2008, 12:52:19 AM »
Umm.  I guess that if you don't change the prefix the variable doesn't get created.  Need to make a change for that.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline shirasnetwork

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] Vanilla 1.1.x
« Reply #3 on: May 08, 2008, 03:15:57 PM »
Guys... any one know how to fix this error.

Notice: Undefined index: DATABASE_TABLE_PREFIX in /home/****/public_html/forums/convert.php(398) : eval()'d code on line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.User' at line 2

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,947
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Vanilla 1.1.x
« Reply #4 on: May 08, 2008, 10:17:10 PM »
What version of Vanilla are you using?
This converter was made for the 1.1 version.

The error says that the database table prefix variable it was looking for couldn't be found.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #5 on: June 02, 2008, 01:31:40 AM »
Software: Vanilla
Version: 1.1.x

This is a converter for Vanilla board.  This just convert Members, Boards, Topics, Posts and Basic Settings.  I add any add-ons support, so this will just convert a vanilla install of Vanilla ;) :P.


Thanks... finally a converter.... how does this work, exactly? How do I install it?

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,947
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #8 on: June 03, 2008, 02:51:13 AM »
i'm getting an error, #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '---~ name: "vanilla"
---~ version: "SMF 1.1"
---~ settings: "/conf/database.' at line 1
« Last Edit: June 03, 2008, 03:50:39 AM by tmchukudzi »

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,947
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Vanilla 1.1.x
« Reply #9 on: June 03, 2008, 11:47:24 AM »
Try to redownload the file with a different browser.
The file is corrupted.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #10 on: June 03, 2008, 05:27:24 PM »
i was using firefox before, now i've tried IE and it's the same error...

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,947
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Vanilla 1.1.x
« Reply #11 on: June 03, 2008, 06:38:00 PM »
Are you trying to run it in phpmyadmin?

The script does not get run in phpmyadmin. You use the attached convert.php with it.
Both of these get uploaded to the SMF folder and ran through the browser. The .sql has instructions for the convert.php file on how to complete the conversion.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #12 on: June 03, 2008, 06:48:56 PM »
Ok, thanks, so could you tell me what to do, exactly, step by step, if you don't mind? Sorry to bother you...this is a little frustrating and my boss wanted it three hours ago....when I click on the convert.php link, i get to a page that does not have vanilla in the list. The .sql says 'the convert.php does everything for you.' if someone could explain it to me like i was a 2 year old and had no clue what any of this stuff is, that would be nice. i'm new to this forum so i don't exactly know how everything works and where everything is.thanks in advance.

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,947
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Vanilla 1.1.x
« Reply #13 on: June 03, 2008, 08:50:26 PM »
The convert.php is the page you want.
It should say path to vanilla which is your key that it has the right .sql file.

You just tell it the path to vanilla, then SMF (shouldn't need changed if you uploaded convert.php to the same directory as your SMF files) and then your SMF mysql password (for security reasons).
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #14 on: June 07, 2008, 01:56:25 AM »
ok, now i have a SELECT command denied error. i've tried to add the smf database to the vanilla database as recommended on the common errors page but it doesn't seem to be working, am i doing it wrong? how do i add one database to another? i have cpanel.

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #15 on: June 07, 2008, 01:57:47 AM »
..any chance i could just pay someone to do this for me? i'm sure it would take seconds but it's frustrating me and i'm working for someone..

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] Vanilla 1.1.x
« Reply #16 on: June 07, 2008, 02:10:10 AM »
If you can't add the SMF database user to the vanilla database then I suggest that you install SMF in the same database as vanilla with the same credentials.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline tmchukudzi

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] Vanilla 1.1.x
« Reply #17 on: June 07, 2008, 02:44:55 AM »
sigh. i don't know what you're talking about, but i'll do what i can and if it doesn't work out then it doesn't. thanks.

Offline vivek_cbe

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] Vanilla 1.1.x
« Reply #18 on: June 07, 2008, 04:05:23 AM »
Thank you so much, this is just what I've been needing!  With this I can make the switch back to SMF!

I had some difficulties at first because it wasn't finding the right Vanilla tables because the prefix for some reason wasn't in the Vanilla configuration file.

So I changed the SQL file to: ---~ from_prefix: "`$Configuration[DATABASE_NAME]`.LUM_"

and it worked a treat.

thanks to you buddy, this worked like a charm!

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,947
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] Vanilla 1.1.x
« Reply #19 on: June 07, 2008, 07:03:23 PM »
sigh. i don't know what you're talking about, but i'll do what i can and if it doesn't work out then it doesn't. thanks.

Don't be afraid to ask your host for help on how to have the same mysql user be able to access two databases. Since these things may differ for each host, it is best to ask them so you are getting the specifics on how to accomplish this :)

The converter uses a single mysql connection to the same mysql database. So it uses the same login conditionals that SMF uses. This is why the MySQL user for SMF has to have access to the Vanilla database.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+