News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] YaBB SE 1.5.4

Started by JayBachatero, January 08, 2007, 11:25:48 AM

Previous topic - Next topic

JasonMonette

#100
The supermod database is named:

jbmaudio.yabbse

The prefix for supermod tables is:

yabbsm

The Simple Machines database is  named:

jbmaudio.smf1

the prefix for my simple machines tables are:

smf


I hope this helps

JayBachatero

Ok do this.

Find
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Replace with
$from_prefix = '`yabbse`.yabbsm_';
Follow me on Twitter

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

JasonMonette

QuoteOk do this.

Find
$from_prefix = eval('return "' . $convert_data['from_prefix'] . '";');
Replace with
$from_prefix = '`yabbse`.yabbsm_';

Ok I made that change and now I get the following error :

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of YaBB SE 1.5.x. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'jbmaudio_smf1'@'localhost' for table 'yabbsm_members'


I went back to the orginal convert.php and got this error:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

    UPDATE `jbmaudio_smf1`.smf_boards
    SET memberGroups = '-1,0,2', lastUpdated = 1201121972
    WHERE ID_CAT = 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'



Any suggestions

JayBachatero

Follow me on Twitter

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

JasonMonette

I did this, i have added the user to both databases.  it can access it the data base when i use the original covert.php.  why can't it access it with the modified one?  The SMF user has all privileges for my supermod database so why would i be getting this error?

JasonMonette



as you can see my smf user is on all of my databases.  Unless I am not understanding what you are saying.

Just incase you can't see the image

Click here for a bigger copy

JayBachatero

What permissions did you give to that user on that database though?
Follow me on Twitter

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

JasonMonette

all privileges.  the user should have total access

JayBachatero

Is it possible for you to PM me access to your site or can you contact me on IM?
Follow me on Twitter

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

JasonMonette


JasonMonette


JayBachatero

Follow me on Twitter

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

dig7er

Hello! We're trying to convert our YaBB SE 1.5.5 installation to SMF. With the converter on the site we couldn't do it. There were some errors. After we tried yabbse_to_smf.sql which one can get in this topic it worked! But all our messages on the new SMF are like "???????? ?????". Obviously we are experiencing problems with the encoding. Actually the encoding on the YaBB SE is windows-1251 (cp1251) and database encoding and collation is latin1. Any ideas on how can we convert messages so they stay like normal messages and not question marks?

Appreciate your help!

SleePy

Are you using the convert.php script linked in the first post of this topic?

That one has a convert.php that lets you choose your SMF encoding. Choose UTF-8 for it and it should hopefully convert things correctly.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

dig7er

#114
Thank you for your reply, but i don't see convert.php in the first post.

I found convert.php in the neighbour-topic "[SMF Converter] Yabb - 2.1", but it didn't help with my problem :(

SleePy

Ohh, sorry thank you. I fixed it

Quote
convert.php
Use this convert.php with the .sql file attached in this topic.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

dig7er

Looks like it worked! Thank you very much for such a wonderful support, SleePy!

TheRealWaldo

The convert.php link links to http://www.simplemachines.org/community/index.php?topic=140741.0 which links back to here.... circular... Where can I get this convert.php file?

W.

TheRealWaldo

Scratch that, a little confusing, but the file was actually attached at the end of that linked thread, but not visible at all if you aren't logged in.

TheRealWaldo

I get the error:

Fatal error: Cannot redeclare ip2range() (previously declared in /home/nwrsuser/public_html/convert.php(910) : eval()'d code:1) in /home/nwrsuser/public_html/convert.php(913) : eval()'d code on line 20

Suggestions?

W.

Advertisement: