| View previous topic :: View next topic |
| Author |
Message |
fade2gray
Newbie
Joined: Mar 27, 2006
Posts: 6
|
 Posted: Thu Apr 06, 2006 9:15 pm Post subject: |
 |
|
| Evaders99 wrote: |
| Yes, you'd need to go to the Forums Configuration and change it. It won't detect it automatically, because it doesn't actually know where you put your files |
Re-reading it, I think your previous comment covers it.
| Evaders99 wrote: |
| However, as stated in the script - it does delete all existing user and forums data in phpNuke |
Sorry about that.  |
|
| Back to top |
|
 |
ShotoKan
Newbie
Joined: Sep 20, 2006
Posts: 13
|
| Posted: Wed Sep 20, 2006 10:38 pm Post subject: |
|
|
Evaders, i am quoting your answer on hukefoorum to let you know i am continue it here since i am not going to talk about your script OK.
I have 2 questions:
1-Does your script will import ALL phpBB data into the PHP-Nuke databases? Including forums, users, everything?
2 -Does the script delete or modify anything in the phpBB database during this process? Or it just reads the data from there and that's it? I really can't delete or touch the phpBB data.
Please let me know what to do OK.
Thanks,
Here is my phpbb2phpnuke-config:
$dbhost = "localhost";
$dbuname = "database";
$dbpass = "password";
$dbname = "phpBBtest"; (I wasn't sure if here goes the phpBB or Nuke DB)
$nuke_prefix = "nuke";
$user_prefix = "nuke";
$phpbb_prefix = "phpbb";
The problem is that when I run phpbb2phpnuke.php i got the below message:
"Cannot connect to phpNuke's bbconfig table. Please check your phpNuke prefix settings in phpbb2phpnuke_config.php"
I have o say that my php-nuke databse is not NUKE soi don't know if you script is expecting this as the name. |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3064
Location: USA
|
| Posted: Wed Sep 20, 2006 10:54 pm Post subject: |
|
|
1) It imports all relevant data except themes and smilies
2) It does not delete any phpBB data
As stated in the readme
| Code: |
TO USE:
1) You must have your phpBB and phpNuke tables in the same database
If not, use phpMyAdmin to export your tables into one database
|
_________________
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: Wed Sep 20, 2006 11:01 pm Post subject: |
|
|
Well i think I do have them both in the same database. I mean the same MySql database. Or you mean that the phpBB and PHP-Nuke tables must all be together in one database?
If you look into my phpbb2phpnuke config i setup the $dbname = my phpbb database is that correct it should have been the php-buke database?
Just one more question: Should i make all the changes you asked on the first posts concerning the use of the underscore on the phpBB and php-nuke prefix? Or that was especific for the other person? |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3064
Location: USA
|
| Posted: Thu Sep 21, 2006 8:13 am Post subject: |
|
|
"phpBB and PHP-Nuke tables must all be together in one database"
Correct
You don't need to make the changes to the underscore if you are using the default values from the phpBB and phpNuke installations.
_________________
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: Thu Sep 21, 2006 1:58 pm Post subject: |
|
|
Mr. Evaders
I just run the script after your last post and now i could run... GREAT... there was just two issues as you can see below.
Please let me know how can i fix them.
Inserting phpBB forums data into phpNuke
Error inserting data from phpbb_privmsgs to nuke_bbprivmsgs - Column count doesn't match value count at row 1
I notice the private messages text is all there but the other table private messages only is tottaly empt because this error above.
I also notice some users did not had theirs signature and avatar uploaded. It seems there is a size limit maybe different from the original phpBB. |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3064
Location: USA
|
| Posted: Thu Sep 21, 2006 6:34 pm Post subject: |
|
|
Did you make sure your phpNuke forums version was the same as your phpBB?
It would not have converted your private messages over. It does not copy any files over, you would have to do that yourself.
_________________
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: Thu Sep 21, 2006 6:57 pm Post subject: |
|
|
Yes they're both 2.0.20. I used BBtoNuke before to get it from 0.17 to 0.20 base on your recommendation from other post.
So the script does not move the private messages over? But it did move the private_messages_text table and only the private_messages got the error and the data did not went through.
How would i get the private messages converted then? |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3064
Location: USA
|
| Posted: Thu Sep 21, 2006 8:45 pm Post subject: |
|
|
Maybe an update did not work correctly. Use phpMyAdmin and post the structure of both privmsgs tables
_________________
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: Fri Sep 22, 2006 5:41 am Post subject: |
|
|
OK
Here is the nuke_bbprivmsgs
| Code: |
Field Type Collation Attributes Null Default Extra Action
privmsgs_id mediumint(8) UNSIGNED No auto_increment
privmsgs_type tinyint(4) No 0
privmsgs_subject varchar(255) latin1_swedish_ci No 0
privmsgs_from_userid mediumint(8) No 0
privmsgs_to_userid mediumint(8) No 0
privmsgs_date int(11) No 0
privmsgs_ip varchar(8) latin1_swedish_ci No
privmsgs_enable_bbcode tinyint(1) No 1
privmsgs_enable_html tinyint(1) No 0
privmsgs_enable_smilies tinyint(1) No 1
privmsgs_attach_sig tinyint(1) No 1
Check All / Uncheck All With selected:
--------------------------------------------------------------------------------
Print view Propose table structure
Add field(s)At End of Table At Beginning of Table After privmsgs_id privmsgs_type privmsgs_subject privmsgs_from_userid privmsgs_to_userid privmsgs_date privmsgs_ip privmsgs_enable_bbcode privmsgs_enable_html privmsgs_enable_smilies privmsgs_attach_sig
--------------------------------------------------------------------------------
Indexes: Keyname Type Cardinality Action Field
PRIMARY PRIMARY 0 privmsgs_id
privmsgs_from_userid INDEX None privmsgs_from_userid
privmsgs_to_userid INDEX None privmsgs_to_userid
Create an index on columns
Space usage Type Usage
Data 0 Bytes
Index 1,024 Bytes
Total 1,024 Bytes
Row Statistics Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Sep 21, 2006 at 02:58 PM
Last update Sep 21, 2006 at 02:58 PM
|
Here is the phpBB_privmsgs
| Code: |
Field Type Collation Attributes Null Default Extra Action
privmsgs_id mediumint(8) UNSIGNED No auto_increment
privmsgs_type tinyint(4) No 0
privmsgs_subject varchar(255) latin1_swedish_ci No 0
privmsgs_from_userid mediumint(8) No 0
privmsgs_to_userid mediumint(8) No 0
privmsgs_date int(11) No 0
privmsgs_ip varchar(8) latin1_swedish_ci No
privmsgs_enable_bbcode tinyint(1) No 1
privmsgs_enable_html tinyint(1) No 0
privmsgs_enable_smilies tinyint(1) No 1
privmsgs_attach_sig tinyint(1) No 1
privmsgs_from_username varchar(25) latin1_swedish_ci No
privmsgs_to_username varchar(25) latin1_swedish_ci No
site_id mediumint(8) No 0
room_id mediumint(8) No 0
Check All / Uncheck All With selected:
--------------------------------------------------------------------------------
Print view Propose table structure
Add field(s)At End of Table At Beginning of Table After privmsgs_id privmsgs_type privmsgs_subject privmsgs_from_userid privmsgs_to_userid privmsgs_date privmsgs_ip privmsgs_enable_bbcode privmsgs_enable_html privmsgs_enable_smilies privmsgs_attach_sig privmsgs_from_username privmsgs_to_username site_id room_id
--------------------------------------------------------------------------------
Indexes: Keyname Type Cardinality Action Field
PRIMARY PRIMARY 13216 privmsgs_id
privmsgs_from_userid INDEX None privmsgs_from_userid
privmsgs_to_userid INDEX None privmsgs_to_userid
room_id INDEX None room_id
site_id INDEX None site_id
Create an index on columns
Space usage Type Usage
Data 608,380 Bytes
Index 530,432 Bytes
Total 1,112 KB
Row Statistics Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 13,216
Row length ø 46
Row size ø 86 Bytes
Next Autoindex 29,666
Creation Sep 21, 2006 at 03:18 PM
Last update Sep 21, 2006 at 03:19 PM
|
|
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3064
Location: USA
|
| Posted: Fri Sep 22, 2006 9:03 am Post subject: |
|
|
Use phpMyAdmin to delete these fields from nuke_bbprivmsgs
privmsgs_from_username
privmsgs_to_username
Run the conversion script again and it should work
_________________
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: Fri Sep 22, 2006 11:13 am Post subject: |
|
|
Mr. Evaders
You asked me to delete the fields privmsgs_from_username and privmsgs_to_username from nuke_bbprivmsgs but these fields only exist in the phpBB_privmsgs.
Should I delete them from phpBB_privmsgs?
Thanks, |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3064
Location: USA
|
| Posted: Fri Sep 22, 2006 7:51 pm Post subject: |
|
|
Sorry, right phpBB_privmsgs
_________________
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 8:41 am Post subject: |
|
|
Mr. Evaders
I did delete the fields and re-run the script but still the same error. See below.
Inserting phpBB forums data into phpNuke
Error inserting data from phpbb_privmsgs to nuke_bbprivmsgs - Column count doesn't match value count at row 1 |
|
| Back to top |
|
|
ShotoKan
Newbie
Joined: Sep 20, 2006
Posts: 13
|
| Posted: Sat Sep 23, 2006 9:30 am Post subject: |
|
|
Ok. After i got the same error again i thoug why does he asked me to elete those fields... maybe because they does not exist in Nuke structure then i realize there was two more in phpBB that wasn't in Nuke either.
site_id mediumint
room_id mediumint
Well idelete them too and run the script again. Guess what got NO ERROR.
Now my question is: Did i screw up anything by doing that? I got no error but maybe it wasn't the right thing to do?
The only thing i realized so far is that majority of the AVATARs did not get imported and i don't know why. It seems that all avatars using URL is ok but the ones pointing to a picture did not went through.
Please let me know |
|
| Back to top |
|
|
|
![Welcome to Evaders Squadron Coding [ESC]](themes/Onset/images/esc_reflect.png)
