| View previous topic :: View next topic |
| Author |
Message |
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
 Posted: Sat Sep 23, 2006 2:47 pm Post subject: |
 |
|
Ah sorry, I don't know why I missed those fields.
It should work fine now.
No avatar files were moved over. So you will have to do that yourself. And none of the avatar paths in your forums config were changed. You will also have to fix that
_________________
Evaders99
 Webmaster
 Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
 |
ShotoKan
Newbie
Joined: Sep 20, 2006
Posts: 13
|
| Posted: Sat Sep 23, 2006 3:02 pm Post subject: |
|
|
| Besides AVATAR is there any other thing that is not converted and i will need to fix manually? |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
| Posted: Sat Sep 23, 2006 4:13 pm Post subject: |
|
|
If you have any custom smilies, you would have to move them over and reinstall them. Custom themes, etc. This conversion does not move any files over
_________________
Evaders99
Webmaster
Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
|
ShotoKan
Newbie
Joined: Sep 20, 2006
Posts: 13
|
| Posted: Sat Sep 23, 2006 4:21 pm Post subject: |
|
|
Ok. I will check these thing and start an overall test in my new php-nuke forums. If anything else come-up I will post it here.
By the way the conversion issue with those fields I had to delete from phpBB_privmsgs tables are particular to my installation or is something you will add to you script later? |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
| Posted: Sat Sep 23, 2006 4:32 pm Post subject: |
|
|
Must be your installation, default phpBB does not use those
_________________
Evaders99
Webmaster
Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
|
skullshot
Newbie
Joined: Sep 27, 2006
Posts: 2
|
| Posted: Wed Sep 27, 2006 11:05 am Post subject: |
|
|
i have same problem - its because we have attach mod installed, is there a way to attach mod the nuke phpbb?
if not i can easily drop the attach fields from the db.. |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
| Posted: Wed Sep 27, 2006 5:07 pm Post subject: |
|
|
There is a version of the attachment mod for an older version of phpNuke. I don't know how it will work with the newer forums though
_________________
Evaders99
Webmaster
Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
|
skullshot
Newbie
Joined: Sep 27, 2006
Posts: 2
|
| Posted: Wed Sep 27, 2006 9:32 pm Post subject: |
|
|
thanks - for now i am testing a conversion so i have successfully done it by dropping all the additional (mod) fields from my db
i did run into one other issue that i shouldn't mention here (  ) and that is the user id values clash - ie. my account was userid 1 in my phpbb install, but in nuke, it leaves 1 set to anonymous and works from there up - so for an extra step i had to delete the anonymous and my own accounts from phpbb before i converted - then i updated all the places where userid 1 was mentioned and set it to my new nuke userid!! alot of work but it gets there in the end |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
| Posted: Wed Sep 27, 2006 10:49 pm Post subject: |
|
|
Hmm I had thought I got that done in the conversion script. But if not, let me know
_________________
Evaders99
Webmaster
Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
|
Napsterbater
Newbie
Joined: Oct 07, 2006
Posts: 1
|
| Posted: Sat Oct 07, 2006 12:56 am Post subject: Unable to connect to the Database |
|
|
IIS6 + PHP 5 + MYSQL 5 and im getting (Cannot connect to database server) i know my settings are correct any suggestions.
Also i have PHPNuke 7.9 and bbtonuke up to 2.0.21 and phpbb 2.0.21
| Code: |
http://evaders.swrebellion.com)
"; $dbcheck = mysql_connect($dbhost, $dbuname, $dbpass); if (!$dbcheck) { echo "
Cannot connect to database server. Please check your database settings in phpbb2phpnuke_config.php
"; echo "
"; die(); } $dbcheck2 = mysql_select_db($dbname); if (!$dbcheck2) { echo "
Cannot connect to database. Please check your database settings in phpbb2phpnuke_config.php
"; echo "
"; die(); } $result = mysql_query("SELECT config_value FROM " . $nuke_prefix . "_bbconfig WHERE config_name = 'version'"); if(!$result) { echo "
Cannot connect to phpNuke's bbconfig table. Please check your phpNuke prefix settings in phpbb2phpnuke_config.php
"; echo "
"; die(); } else { list($phpnuke_version) = mysql_fetch_row($result); } if(!mysql_query("SELECT * FROM " . $user_prefix . "_users WHERE 1;")) { echo "
Cannot connect to phpNuke's users table. Please check your phpNuke user_prefix settings in phpbb2phpnuke_config.php
"; echo "
"; die(); } $result = mysql_query("SELECT config_value FROM " . $phpbb_prefix . "_config WHERE config_name = 'version'"); if(!$result) { echo " |
|
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
| Posted: Mon Oct 09, 2006 9:42 am Post subject: |
|
|
Seems your file maybe corrupted.
The only thing you should edit is phpbb2phpnuke_config.php
| Code: |
$dbhost = "localhost";
$dbuname = "";
$dbpass = "";
$dbname = "";
$nuke_prefix = "nuke";
$user_prefix = "nuke";
$phpbb_prefix = "phpbb";
|
Those settings need to be verified for proper use
_________________
Evaders99
Webmaster
Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
|
jakobahman
Newbie
Joined: Oct 13, 2006
Posts: 5
|
| Posted: Fri Oct 13, 2006 4:38 am Post subject: |
|
|
Hi!
First of all I would like to thank you for the effort you put in this script, I am truly grateful.
Although I do have a few issues I cant solve. When I run the script I get 2 errors:
| Quote: |
Inserting phpBB users data into phpNuke
Error inserting data from nuke_users to phpbb_users - Field 'bio' doesn't have a default value |
(Should it really be from nuke_users to phpbb_users? Shouldnt it be the other way around?)
and
| Quote: |
Inserting phpBB forums data into phpNuke
Error inserting data from phpbb_search_results to nuke_bbsearch_results - Out of range value adjusted for column 'search_time' at row 1 |
This all results in me having a working forum but without my previous users and posts.
My problem is I dont know what to do, since im a complete noob. 
You think you could point me in the right direction somehow?
Cheers,
Jakob |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3063
Location: USA
|
| Posted: Fri Oct 13, 2006 10:17 am Post subject: |
|
|
Sorry there was just a typo in the first version of the script. It has already been fixed
I am guessing you are using MySQL 5 - I haven't tested it on there yet.
Using phpMyAdmin, run this in your phpNuke tables
| Code: |
ALTER TABLE nuke_users CHANGE bio bio TINYTEXT NULL;
ALTER TABLE nuke_users CHANGE ublock ublock TINYTEXT NULL;
|
That should fix the users problem.
For the second, I'll need to see the structure of those two tables. Please use phpMyAdmin to export the structure of both tables and post them here
_________________
Evaders99
Webmaster
Administrator
Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie. |
|
| Back to top |
|
|
jakobahman
Newbie
Joined: Oct 13, 2006
Posts: 5
|
| Posted: Fri Oct 13, 2006 10:55 am Post subject: |
|
|
Thanks for the fast reply!
Hmm... the first trick made the script move the users sucessfully, but something must have gone wrong with nuke_bbsearch_results since phpmyadmin says:
| Quote: |
| #144 - Table '.\nuke\nuke_bbsearch_results' is marked as crashed and last (automatic?) repair failed |
and it lists it as 'in use'. It wasnt like that earlier today. I ran your script again, maybe that screwed things up?
Anyway. If ive done this right the table structure for table phpbb_search_results is:
Field Type Null Default
search_id int(11) Yes 0
session_id char(32) Yes
search_time int(11) Yes 0
search_array text Yes
Is that what you mean? |
|
| Back to top |
|
|
jakobahman
Newbie
Joined: Oct 13, 2006
Posts: 5
|
| Posted: Fri Oct 13, 2006 11:13 am Post subject: |
|
|
Hmm. But on the other hand. It seems like everything is in place. All the posts have been sucessfully moved as well...
Maybe I dont need no help. 
I will do some more testing and see if something isnt working. |
|
| Back to top |
|
|
|
![Welcome to Evaders Squadron Coding [ESC]](themes/Onset/images/esc_reflect.png)
