|
Re:phpBB 1 Year ago
|
|
Cromfel wrote:
After reading 33 pages about this converter I still havent found solution to the following problem. (Even when someone had the same problem and solved it, he didnt post the answer). I have done everything as told here, using the latest file for the converter and I get this error message.
| Code: |
ALTER TABLE `jos_fb_messages` ADD `phpbb_userid` int(10) NOT NULL default '1'
Duplicate column name 'phpbb_userid'
|
I have been browsing the database on phpmyadmin and havent found any dublicated columns or such. Any help would be most apreciated.
Thanks in advance!
During the loading of the messages the script adds an extra column so that it can then do another pass remapping the userids to the new ids. If the script fails part way through this column is left on the jos_fb_messages table. You need to go in with phpmyadmin and drop that column before you can rerun the script.
I had to do this a number of times while debugging problems with the script.
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 1 Year ago
|
|
|
Hi all
I want to convert my phpbb to fireboard! but i have a serious problem is that my phpbb and joomla are not in the same data base, and phpbb is with mysql 4.0 and joomla is with mysql 5.0!
So please how can i convert my board?
Help please! i really like fireboard.
|
|
nizart (User)
Junior Boarder
Posts: 20
|
|
|
|
|
Last Edit: 2007/06/28 21:46 By nizart.
|
|
|
Proud to be arab
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 1 Year ago
|
|
|
I'm not sure if there will be a problem with the mysql versions.
Export your phpbb data and import to your joomla database.
|
|
Rapid (User)
Junior Boarder
Posts: 29
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 1 Year ago
|
|
|
Yes ! that's what i ve done, but i didn't work.
there are no error message and i really dont understand anything!
PS : i am hosted in 1and1.
|
|
nizart (User)
Junior Boarder
Posts: 20
|
|
|
|
|
Proud to be arab
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 1 Year ago
|
|
has anyone figured out how to add a pause to the script so its doesn;t exhaust memory ?
the script always stops, because of memory, and then it errors:
Connecting to Database... OK
Invalid query:
ALTER TABLE `jos_fb_messages` ADD `phpbb_userid` int(10) NOT NULL default '1'
Duplicate column name 'phpbb_userid'
If you delete the phpbb_userid column, the scripts starts from srtach again
please help 
|
|
|
|
|
|
|
Last Edit: 2007/07/06 04:41 By ankh2054.
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 1 Year ago
|
|
|
hi,
first, great tool, but I have a problem.
I used the last version of the converter,
installed joomla 1.0.12
CBE Beta1 half 0702
fireboard-forum-1-0-1-beta
after using the fonverter I get this:
Importing data from phpBB2
Connecting to Database... OK
Populating Categories... OK
Populating Messages Table... OK
Populating Messages_Text Table... OK
Populating Users Table... MSG-Bot1, D.Kottwitz62, admin63, pukle64, Kottwitz65, Bintig66, Kottwitz Test67, Szielasko68, hunwartsen69, hansen70, Bockstahler71, Filbig72, kopf73, Klose74, Quabeck75, Lotter76, Wiesenauer77, Eggemann78, Hasenkrug79, Jungnitsch80, Strittmatter81, Ronge82, Ege83, M?hle84, Buschold85, Hermann Pieprzytza86, Pieprzytza87, Reinhardt88, Fiedler89, Frank90, Arnold91, Zabel92, Langer93, Haug94, Meyer95, Vorbach96, Bax97, P.J.Schulz98, Bauck99, Janzen100, Kerzel101, Amelung102, Schwippl103, Voss104, Illmer105, Bauriedel106, Dux107, Neukam108, OK
Complete...
so it seems to work, the postings are all converted, but if I want to look at the userlist, there is just my own (admin) account, no other. and the postings have no connection to the users postet it.
my usertable data are also a bit ... empty ...
INSERT INTO `jos_fb_users` VALUES (1, 'flat', '', 0, 0, 0, NULL, 0, 0, 1, 0);
INSERT INTO `jos_fb_users` VALUES (62, 'flat', '', 0, 0, 0, NULL, 0, 0, 1, 0);
INSERT INTO `jos_fb_users` VALUES (63, 'flat', '', 0, 0, 0, NULL, 0, 0, 1, 0);
INSERT INTO `jos_fb_users` VALUES (64, 'flat', '', 0, 0, 0, NULL, 0, 0, 1, 0);
confusingly the Users are in joomla, but not in the Fireboard.
what may there be wrong? any ideas?
|
|
dirk (User)
Fresh Boarder
Posts: 1
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 12 Months ago
|
|
Agent X20 wrote:
You need to go in with phpmyadmin and drop that column before you can rerun the script.
[/quote]
Hi all!
How do I drop a column? Only rows can be checked... Or am I the dumb one? 
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 12 Months ago
|
|
Hi,
I used the latest version of the script to upgrade MDForum, (phpbb integrated into MDPro), to fireboard. Everything went well, and I was able to convert 800 users and 10000+ posts without a hitch. The only problem is that when I'm in the fireboard administration area and I go into a forum user's profile, I have this at the top:
[quote]// bbCode control by // subBlue design // www.subBlue.com // adapted for Simpleboard by the Two Shoes Module Factory (www.tsmf.jigsnet.com) // Startup variables var imageTag = false; var theSelection = false; // Check for Browser & Platform for PC & IE specific bits // More details from: http://www.mozilla.org/docs/web-develope...er/browser_type.html var clientPC = navigator.userAgent.toLowerCase(); // Get client info var clientVer = parseInt(navigator.appVersion); // Get browser version var is_ie = ((clientPC.indexOf("msie"  != -1) && (clientPC.indexOf("opera"  == -1)); var is_nav = ((clientPC.indexOf('mozilla'  != -1) && (clientPC.indexOf('spoofer'  == -1) && (clientPC.indexOf('compatible'  == -1) && (clientPC.indexOf( 'opera'  == -1) && (clientPC.indexOf('webtv'  == -1) && (clientPC.indexOf('hotjava'  == -1)); var is_moz = 0; var is_win = ((clientPC.indexOf("win"  != -1) || (clientPC.indexOf("16bit"  != -1)); var is_mac = (clientPC.indexOf("mac"  != -1); // Define the bbCode tags bbcode = new Array(); bbtags = new Array(' ', '', ' ', '', ' ', '', ' ', '', ' ', ' ', ' ', ' ', '  ', ' ', '', ' ', ''  ; imageTag = false; // Shows the help messages in the helpline window function helpline(help) { document.adminForm.helpbox.value = eval(help + "_help"  ; } // Replacement for arrayname.length property function getarraysize(thearray) { for (i = 0; i = 4) && is_ie && is_win) { theSelection = document.selection.createRange().text; // Get text selection if (theSelection) { // Add tags around selection document.selection.createRange().text = bbtags[bbnumber] + theSelection + bbtags[bbnumber + 1]; txtarea.focus(); theSelection = ''; return; } } else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0)) { mozWrap(txtarea, bbtags[bbnumber], bbtags[bbnumber + 1]); return; } // Find last occurance of an open tag the same as the one just clicked for (i = 0; i = 4) && is_ie && is_win) { theSelection = document.selection.createRange().text; if (!theSelection) { txtarea.value += bbopen + bbclose; txtarea.focus(); return; } document.selection.createRange().text = bbopen + theSelection + bbclose; txtarea.focus(); return; } else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0)) { mozWrap(txtarea, bbopen, bbclose); return; } else { txtarea.value += bbopen + bbclose; txtarea.focus(); } storeCaret(txtarea); } //####################################################### //code used in My Profile (userprofile.php) function textCounter(field, countfield, maxlimit) { if (field.value.length > maxlimit) { field.value = field.value.substring(0, maxlimit); } else { countfield.value = maxlimit - field.value.length; } } //********************************************************* // Insert emoticons function emo($e) { document.adminForm.message.value = document.adminForm.message.value + $e; document.adminForm.message.focus(); } function submitForm() { submitme = 1; formname = document.adminForm.fb_authorname.value; if ((formname.length
|
|
NateM (User)
Fresh Boarder
Posts: 17
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 12 Months ago
|
|
Hi,
I used the latest version of the script to upgrade MDForum, (phpbb integrated into MDPro), to fireboard. Everything went well, and I was able to convert 800 users and 10000+ posts without a hitch. The only problem is that when I'm in the fireboard administration area and I go into a forum user's profile, I have this at the top:
[quote]// bbCode control by // subBlue design // www.subBlue.com // adapted for Simpleboard by the Two Shoes Module Factory (www.tsmf.jigsnet.com) // Startup variables var imageTag = false; var theSelection = false; // Check for Browser & Platform for PC & IE specific bits // More details from: http://www.mozilla.org/docs/web-develope...er/browser_type.html var clientPC = navigator.userAgent.toLowerCase(); // Get client info var clientVer = parseInt(navigator.appVersion); // Get browser version var is_ie = ((clientPC.indexOf("msie"  != -1) && (clientPC.indexOf("opera"  == -1)); var is_nav = ((clientPC.indexOf('mozilla'  != -1) && (clientPC.indexOf('spoofer'  == -1) && (clientPC.indexOf('compatible'  == -1) && (clientPC.indexOf( 'opera'  == -1) && (clientPC.indexOf('webtv'  == -1) && (clientPC.indexOf('hotjava'  == -1)); var is_moz = 0; var is_win = ((clientPC.indexOf("win"  != -1) || (clientPC.indexOf("16bit"  != -1)); var is_mac = (clientPC.indexOf("mac"  != -1); // Define the bbCode tags bbcode = new Array(); bbtags = new Array(' ', '', ' ', '', ' ', '', ' ', '', ' ', ' ', ' ', ' ', '  ', ' ', '', ' ', ''  ; imageTag = false; // Shows the help messages in the helpline window function helpline(help) { document.adminForm.helpbox.value = eval(help + "_help"  ; } // Replacement for arrayname.length property function getarraysize(thearray) { for (i = 0; i = 4) && is_ie && is_win) { theSelection = document.selection.createRange().text; // Get text selection if (theSelection) { // Add tags around selection document.selection.createRange().text = bbtags[bbnumber] + theSelection + bbtags[bbnumber + 1]; txtarea.focus(); theSelection = ''; return; } } else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0)) { mozWrap(txtarea, bbtags[bbnumber], bbtags[bbnumber + 1]); return; } // Find last occurance of an open tag the same as the one just clicked for (i = 0; i = 4) && is_ie && is_win) { theSelection = document.selection.createRange().text; if (!theSelection) { txtarea.value += bbopen + bbclose; txtarea.focus(); return; } document.selection.createRange().text = bbopen + theSelection + bbclose; txtarea.focus(); return; } else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0)) { mozWrap(txtarea, bbopen, bbclose); return; } else { txtarea.value += bbopen + bbclose; txtarea.focus(); } storeCaret(txtarea); } //####################################################### //code used in My Profile (userprofile.php) function textCounter(field, countfield, maxlimit) { if (field.value.length > maxlimit) { field.value = field.value.substring(0, maxlimit); } else { countfield.value = maxlimit - field.value.length; } } //********************************************************* // Insert emoticons function emo($e) { document.adminForm.message.value = document.adminForm.message.value + $e; document.adminForm.message.focus(); } function submitForm() { submitme = 1; formname = document.adminForm.fb_authorname.value; if ((formname.length
|
|
NateM (User)
Fresh Boarder
Posts: 17
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
Re:phpBB 12 Months ago
|
|
Hi,
I used the latest version of the script to upgrade MDForum, (phpbb integrated into MDPro), to fireboard. Everything went well, and I was able to convert 800 users and 10000+ posts without a hitch. The only problem is that when I'm in the fireboard administration area and I go into a forum user's profile, I have this at the top:
[quote]// bbCode control by // subBlue design // www.subBlue.com // adapted for Simpleboard by the Two Shoes Module Factory (www.tsmf.jigsnet.com) // Startup variables var imageTag = false; var theSelection = false; // Check for Browser & Platform for PC & IE specific bits // More details from: http://www.mozilla.org/docs/web-develope...er/browser_type.html var clientPC = navigator.userAgent.toLowerCase(); // Get client info var clientVer = parseInt(navigator.appVersion); // Get browser version var is_ie = ((clientPC.indexOf("msie"  != -1) && (clientPC.indexOf("opera"  == -1)); var is_nav = ((clientPC.indexOf('mozilla'  != -1) && (clientPC.indexOf('spoofer'  == -1) && (clientPC.indexOf('compatible'  == -1) && (clientPC.indexOf( 'opera'  == -1) && (clientPC.indexOf('webtv'  == -1) && (clientPC.indexOf('hotjava'  == -1)); var is_moz = 0; var is_win = ((clientPC.indexOf("win"  != -1) || (clientPC.indexOf("16bit"  != -1)); var is_mac = (clientPC.indexOf("mac"  != -1); // Define the bbCode tags bbcode = new Array(); bbtags = new Array(' ', '', ' ', '', ' ', '', ' ', '', ' ', ' ', ' ', ' ', '  ', ' ', '', ' ', ''  ; imageTag = false; // Shows the help messages in the helpline window function helpline(help) { document.adminForm.helpbox.value = eval(help + "_help"  ; } // Replacement for arrayname.length property function getarraysize(thearray) { for (i = 0; i = 4) && is_ie && is_win) { theSelection = document.selection.createRange().text; // Get text selection if (theSelection) { // Add tags around selection document.selection.createRange().text = bbtags[bbnumber] + theSelection + bbtags[bbnumber + 1]; txtarea.focus(); theSelection = ''; return; } } else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0)) { mozWrap(txtarea, bbtags[bbnumber], bbtags[bbnumber + 1]); return; } // Find last occurance of an open tag the same as the one just clicked for (i = 0; i = 4) && is_ie && is_win) { theSelection = document.selection.createRange().text; if (!theSelection) { txtarea.value += bbopen + bbclose; txtarea.focus(); return; } document.selection.createRange().text = bbopen + theSelection + bbclose; txtarea.focus(); return; } else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0)) { mozWrap(txtarea, bbopen, bbclose); return; } else { txtarea.value += bbopen + bbclose; txtarea.focus(); } storeCaret(txtarea); } //####################################################### //code used in My Profile (userprofile.php) function textCounter(field, countfield, maxlimit) { if (field.value.length > maxlimit) { field.value = field.value.substring(0, maxlimit); } else { countfield.value = maxlimit - field.value.length; } } //********************************************************* // Insert emoticons function emo($e) { document.adminForm.message.value = document.adminForm.message.value + $e; document.adminForm.message.focus(); } function submitForm() { submitme = 1; formname = document.adminForm.fb_authorname.value; if ((formname.length
|
|
NateM (User)
Fresh Boarder
Posts: 17
|
|
|
|
|
The administrator has disabled public write access.
|
|
|