Solved: 7 Years, 2 Months, 2 Weeks ago troubles when importing BBFlux with sqlite database
#1
Solved: 7 Years, 2 Months, 2 Weeks ago
Hello !

1 / first : sorry for my english spoken ... I'm french Undecided

2 / general question : Why merge system only knows "SQLITE 3" version of dataBase from BBFlux (all versions of BBFlux are only SQLITE 2 and it's the mean reason I try to convert my BBFlux forum to a new myBB forum Huh

3 / my trouble :

before trying on my server, I try on my PC with uWamp server (dbhost = localhost).
After converting my old sqlite 2 database to an sqlite 3 database Angel , I've download Merge system. I've copy the directory 'merge' under my myBB forum : so, the organization is this :

uWamp/www/myBB_1.8 <-- wich works fine (I can admin without trouble)
and :

uWamp/www/myBB_1.8/merge (with index.php, license.txt, loginconvert.php ... and the directories /boards, /images, /langages etc )

my new/old sqlite file is located here : c:\tmp\forum3.sqlite (Windows 7)
my new Sqlite database is www/myBB_1.8/forummyBB.sqlite

Now I begin Merge System : localhost/myBB_1.8/merge/index.php

When I'm on 'FluxBB Database Configuration' and select SQLITE3 , /tmp/forum3.sqlite, nothing for table_prefix and no encode for UTF-8, I click next and I have the error :

********************
Error

There seems to be one or more errors with the database configuration information that you supplied:

Could not connect to the database server at '' with the supplied username and password. Are you sure the hostname and user details are correct?
********************

I was thinking that sqlite base have not need of user details ?

What's the bug and how could I fixe it, please ?
Reply
#2
Solved: 7 Years, 2 Months, 2 Weeks ago
The error message is a general one and is always used when the connection failed (no matter whether it's an issue with username/password or with the host).

You should use the full path for SQLite, in this case "C:\tmp\forum3.sqlite".
Support PMs will be ignored!
Reply
#3
Solved: 7 Years, 2 Months, 2 Weeks ago
Sorry Jones H. I've tried :
c:\tmp\forum3.sqlite,
c:/tmp/forum3.sqlite,
C:\tmp\forum3.sqlite,
C:/tmp/forum3.sqlite

always the same error Sad
Reply
#4
Solved: 7 Years, 2 Months, 2 Weeks ago
Seems like you found an issue then. I can't test it atm, probably someone else could help you.

BTW: would you send me your database for testing purposes?
Support PMs will be ignored!
Reply
#5
Solved: 7 Years, 2 Months, 2 Weeks ago
OK ... thanks again. Send you a PM with link to my SQLITE 3 base Wink
Reply
#6
Solved: 7 Years, 2 Months, 2 Weeks ago
Got it, I'll test it later today. Thanks for it.
Support PMs will be ignored!
Reply
#7
Solved: 7 Years, 2 Months, 2 Weeks ago
Got it working. You need to do a few edits to get the merge System working:

open /merge/resources/class_converter.php, search:
if(!$connection || $connection == -1)
and replace with
if(!$connection || $connection === -1)

Next open /merge/resources/modules/threads.php, search:
'import_poll',
and add in a new line after that:
'import_firstpost',

Last open /merge/boards/fluxbb/posts.php, search:
$insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['message']), "posts", "posts");
and add after that:
if(strlen($insert_data['message']) > 65535)
{
	$insert_data['message'] = substr($insert_data['message'], 0, 65532)."...";
}

It worked for me after that changes.
Support PMs will be ignored!
Reply
#8
Solved: 7 Years, 2 Months, 2 Weeks ago
I'm so sorry, Jones H. I've made the 3 modifications :

1 - posts.php :
76 - $insert_data['message'] = encode_to_utf8($this->bbcode_parser->convert($data['message']), "posts", "posts");
77 - if(strlen($insert_data['message']) > 65535)
78 - {
79 - $insert_data['message'] = substr($insert_data['message'], 0, 65532)."...";
80 - }
81 - $insert_data['ipaddress'] = my_inet_pton($data['poster_ip']);

2 - threads.php :
40 - public $integer_fields = array(
41 - 'import_tid',
42 - 'import_poll',
43 - 'import_firstpost',

et 3 - class_converter.php :
137 - // -1 is returned if we can connect to the server but not to the database
138 - //if(!$connection || $connection == -1) YESS !!
139 - if(!$connection || $connection === -1)

But :
***************
The FluxBB 1 database could not be found in 'c:\tmp\forum3.sqlite'. Please ensure FluxBB 1 exists at this database and with this table prefix.
***************

It' better but not yet perfect Wink
Good night tomorrow will be fine as said Leonard Cohen Wink
Reply
#9
Solved: 7 Years, 2 Months, 2 Weeks ago
Have you cleared the table prefix field after you changed the db engine to sqlite?
Support PMs will be ignored!
Reply
#10
Solved: 7 Years, 2 Months, 2 Weeks ago
Yes yes yes !!


... but ... must clean a cache or somethings else ?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)