phpnuke

[Silver-SAF]

Hey Guys,

What should I change in the code, I really do not know php that well, but I can understand, sorta, what it means.

Hope that bit makes sense.

[w1x]

argh.. I shouldve saved the file which I altered.. sorry.. erm just post the error messages on here and I'll tell you what to alter..

[[Unknown]]

For a quick fix, find:

INSERT INTO

Replace:

INSERT IGNORE INTO

-[Unknown]

[SpikeyKlitske]

I thought i post my success story on porting php-nuke to mambo-smf.

I used the tool as attached in one of the earlier posts didnt worked and got stuck as mentioned. changed the wrong email thingy and got stuck again. Lots of trials and errors eventually decided to try it  on a solo clean smf install . With solo i mean not integrated with mambo but just plain smf. I still got the initial erros, changed email again, corrected a few other ones and managed to get everything ported beit that indeed permissions are screwed. Since i wanted to change the existing structure i didnt bother much about it. Went straight into the database and changed all permissions aka removed the admin priviledges and manualy adjusted groups and boards etc into its new place. Bottom line i got all 150 users and 10000 messages ported pffffff. Once this install was done and ported i imported the database into mambo changed the settings files to its proper location and i was done.

So crucial thing learned, dont even try it on a combined mambo-smf install but on a clean stand alone smf

[sobrelacolina]

hi,

first, sorry (my english is poor/bad)

I try to convert my phpbb2 forums (integrated in phpnuke) to SMF, but have some problems...

I prove to convert this with the "nuke_to_smf.php" and "nuke_to_smf_103.php", but in both ocurred this:

Code Select Expand

Converting ranks... successful.
Converting groups... successful.
Converting members... Unsuccessful!
This query:

    INSERT INTO `sentimental_es_db`.smf_members
    (ID_MEMBER, memberName, dateRegistered, posts, ID_GROUP, lastLogin, realName, instantMessages, unreadMessages, passwd, emailAddress, websiteTitle, websiteUrl, location, ICQ, AIM, YIM, MSN, hideEmail, showOnline, signature, timeOffset, avatar, pm_email_notify, is_activated)
    VALUES ('1', 'Anonymous', 'Nov 10, 2000', '12', '1', '0', 'Anonymous', '0', '0', '', '', '', '', '', '', '', '', '', '1', '1', '', '0', 'blank.gif', '1', '1'),
    ('2', 'Porsupueston', 'Dec 11, 2004', '220', '0', '1121135395', 'Porsupueston', '0', '0', '02bfd5107194dcfda3faf7d89cb0a297', '[email protected]', 'http://sentimental.3a2.com', 'http://sentimental.3a2.com', '', '', '', '', '', '1', '1', '[img]http://galeon.com/musikate/Fotos/tortura.gif[/img]
    <br />La tortura no me sienta bien.', '0', 'gallery/010.gif', '0', '1'),
    ('3', 'garbanzo', 'Dec 11, 2004', '0', '1', '1115973053', 'garbanzo', '0', '0', 'e10adc3949ba59abbe56e057f20f883e', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('4', 'carolsita', 'Dec 28, 2004', '1', '1', '1111442768', 'carolsita', '0', '0', '50152560ed2f9bd3f194c90c891d2dd8', '[email protected]', 'http://www.photoblog.be/Carolsita', 'http://www.photoblog.be/Carolsita', 'Italia', '', '', '', 'carolsitag_1', '0', '1', '', '0', 'gallery/blank.gif', '1', '1'),
    ('6', 'NAHUEL', 'Jan 12, 2005', '0', '1', '0', 'NAHUEL', '2', '0', '68e6957707c840aca0f4af970b25ac3c', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('7', 'grimb', 'Jan 14, 2005', '0', '1', '0', 'grimb', '2', '0', '2710d99328d940f6a8681297f207d018', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('8', 'MAINGOLEM', 'Jan 17, 2005', '0', '1', '0', 'MAINGOLEM', '2', '0', '7213d3ea5f60763caa484e848f032732', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('9', 'gitano', 'Jan 17, 2005', '0', '1', '1105967974', 'gitano', '1', '0', '5b1b68a9abf4d2cd155c81a9225fd158', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('10', 'reggaesusplantas', 'Jan 21, 2005', '0', '1', '0', 'reggaesusplantas', '1', '0', '586cc2653ed22ca6f4f09c931785814e', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('11', 'tomyjerry', 'Jan 22, 2005', '0', '1', '1106433373', 'tomyjerry', '1', '0', 'd32e7ecebb92a9a772e1b7e9d95faaf8', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('12', 'pknot', 'Jan 30, 2005', '0', '1', '1107121968', 'pknot', '1', '0', '2f9867d99792a54c18d9d073e144cda2', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('13', 'sindolares', 'Jan 31, 2005', '0', '1', '1108285246', 'sindolares', '1', '0', '4fed6a15e52a7e2af52f4d6e54aefbb1', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('14', 'meloso', 'Jan 31, 2005', '0', '1', '0', 'meloso', '1', '0', 'a530879719b35dbcd6914c01666f5cf7', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('15', 'maquinote', 'Feb 04, 2005', '0', '1', '1107552220', 'maquinote', '1', '0', '5e92f78a10a659bc54ffbb3d1d655ae2', '[email protected]', '', '', '', '', '', '', '', '1', '1', '...y al despertar se acabó la primavera, y al dia siguiente la cabeza no deja de girar....', '0', '', '0', '1'),
    ('16', 'jumana', 'Feb 06, 2005', '0', '1', '0', 'jumana', '1', '0', '65a368f66ad6b9ee45263577713d8a95', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('17', 'DULINA', 'Feb 08, 2005', '0', '1', '0', 'DULINA', '1', '0', 'd0bb5b09082a7afd98326abeec419814', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('18', 'marduk23', 'Feb 08, 2005', '0', '1', '1107843057', 'marduk23', '1', '0', 'be422409d08749e03541019d919d995b', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('19', 'deus', 'Feb 12, 2005', '0', '1', '0', 'deus', '1', '0', 'd8819774196edb09869cb3f36c27d7b5', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('20', 'Juanmi_gr_1', 'Feb 14, 2005', '0', '1', '0', 'Juanmi_gr_1', '0', '0', '446866c68b50f78abf24dee8d1867ac3', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('21', 'NIPPUR', 'Feb 14, 2005', '0', '1', '0', 'NIPPUR', '0', '0', '0e727ae0732b0bb55d0006c0bedb4604', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('22', 'turbbo', 'Feb 16, 2005', '0', '1', '0', 'turbbo', '0', '0', '73fdc6f400d480f4354d84f88820d7c9', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('23', 'Argento', 'Feb 19, 2005', '0', '1', '0', 'Argento', '0', '0', '95deda99a12913341d745ecda2541e2f', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('24', 'mike_doe', 'Feb 20, 2005', '0', '1', '0', 'mike_doe', '0', '0', '1f7254694408508be3dde29c3105bdbe', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('25', 'cris', 'Feb 21, 2005', '0', '1', '0', 'cris', '0', '0', '9f0e8b547286604c0b8ee17545266c46', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('26', 'skaliwal', 'Feb 21, 2005', '0', '1', '0', 'skaliwal', '0', '0', 'af07e46299656b47b88f1164e50eacb5', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('27', 'naiya', 'Feb 21, 2005', '0', '1', '0', 'naiya', '0', '0', '784c48992e9fd4adc2744ffc8fbad900', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('28', 'p', 'Feb 22, 2005', '0', '1', '0', 'p', '0', '0', 'e0f352008c0d93aca9c2580d92c30a23', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('29', 'Atnamara', 'Mar 02, 2005', '0', '1', '1109764816', 'Atnamara', '0', '0', 'ea98c9a238aaa2abe1a2fb26b2ba2886', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('30', 'agroman', 'Mar 03, 2005', '0', '1', '0', 'agroman', '0', '0', '827ccb0eea8a706c4c34a16891f84e7b', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('31', 'alxtspro', 'Mar 10, 2005', '0', '1', '0', 'alxtspro', '1', '0', '34f765e519c08c3baae4ad41041cb639', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('32', 'pabroten', 'Mar 18, 2005', '0', '1', '0', 'pabroten', '0', '0', 'b3c623381ab8ca770e26349433111cba', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('33', 'sirsam', 'May 02, 2005', '0', '1', '0', 'sirsam', '1', '0', '6855e8c50ef360355fab94c8418ecbc9', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('34', 'anarkito', 'May 03, 2005', '0', '1', '1116697662', 'anarkito', '0', '0', '1b6d47df5dd084b34acb0421254c3559', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', '', '1', '1'),
    ('35', 'LuiS4', 'May 03, 2005', '0', '1', '1115231125', 'LuiS4', '1', '0', 'da89cc27b25ee42fcc43c60d97aecd02', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '-10', '', '1', '1'),
    ('36', 'oiuio', 'May 05, 2005', '0', '1', '1115438980', 'oiuio', '1', '0', '4297f44b13955235245b2497399d7a93', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('37', 'Larita', 'May 10, 2005', '0', '1', '0', 'Larita', '1', '0', 'd037405771c07a81934461bfa8061d37', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('38', 'doctorsuave', 'May 11, 2005', '0', '1', '0', 'doctorsuave', '1', '0', '1a100d2c0dab19c4430e7d73762b3423', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('39', 'jazz', 'May 14, 2005', '0', '1', '1116031221', 'jazz', '1', '0', 'a1bc43a235ed260f9af624b51eda5ecd', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('40', 'Mahillo', 'May 19, 2005', '13', '1', '1120927656', 'Mahillo', '0', '0', '21b72c0b7adc5c7b4a50ffcb90d92dd6', '[email protected]', '', '', '', '', '', '', '', '1', '1', 'No se donde vivo, no se ke ora es,
    <br />no se si es mañana o todavia ayer....', '0', 'gallery/034.gif', '0', '1'),
    ('41', 'punko', 'May 19, 2005', '0', '1', '1116534499', 'punko', '1', '0', 'bf006b8323735a1e5ef1f91ccba123da', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('43', 'name', 'May 24, 2005', '0', '1', '0', 'name', '0', '0', '39bec0c82248dbd9b1e4470305964d2d', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('42', 'Natxoill97', 'May 22, 2005', '0', '1', '0', 'Natxoill97', '0', '0', '8f2989a9844948992d0ffe5e3980e012', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('44', 'pachekin', 'May 27, 2005', '0', '1', '0', 'pachekin', '0', '0', 'ada8d22c80fb8feb03e73a1a317b4c49', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('45', 'klaudiapaulina', 'May 29, 2005', '1', '1', '1117392324', 'klaudiapaulina', '0', '0', '5b248d73af0b06452ed6bc6aa52f3174', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('46', 'jojolo03', 'Jun 28, 2005', '0', '1', '0', 'jojolo03', '1', '0', 'e8c75500494871cbba274b21279c17b0', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('47', 'Marcosxfx', 'Jul 03, 2005', '0', '1', '0', 'Marcosxfx', '1', '0', 'd0d98c3f4526aaf3fbfcd4c7be841b57', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1'),
    ('48', 'Predator_15', 'Jul 03, 2005', '0', '1', '0', 'Predator_15', '1', '0', '21ec6379d30e841a77ab321787a4ee0e', '[email protected]', '', '', '', '', '', '', '', '1', '1', '', '0', 'gallery/blank.gif', '0', '1');

Caused the error:

    Unknown column 'pm_email_notify' in 'field list'

this problem... have a solutin??

sorry for the languaje

thnx

[[Unknown]]

Looks to me like you're trying to convert to SMF 1.0 with a 1.1 converter, which ain't going to work.

-[Unknown]

[sobrelacolina]

i'm lost... sorry

i try to convert with this files:

--------------------------
convert.php
phpbb2_to_smf.sql
phpnuke_to_smf.sql
--------------------------
and with: (in different times)
--------------------------
phpbb2_to_smf.php
--------------------------

in all, the result is:

Code Select Expand

Notice: Undefined variable: dbname in /data/members/free/tripod/es/s/e/n/sentimental/htdocs/foro/convert.php(299) : eval()'d code on line 1

Notice: Undefined variable: table_prefix in /data/members/free/tripod/es/s/e/n/sentimental/htdocs/foro/convert.php(299) : eval()'d code on line 1

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. 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: Access denied for user: 'sentimental_es@%.lyceu.net' to database ''
__________________________
and try with:

nuke_to_smf.php
nuke_to_smf_103.php

and te result with the two last files, you can see in the othe message...

only have an advance when I try with the last two files... but not suficient

I don't know so much, sorry

thnx for the help

[sobrelacolina]

...

you say me that I try to convert to SMF 1.0 with a 1.1 converter file (bad/incorrect)...

but, what is the correct converter file??... i dont see any more

can you link me that??

EDIT-------------------------------------------

i have:

SMF 1.0.5
phpnuke 7.5 (phpBB 2.0.10)

[[Unknown]]

I'm very sorry, but the current converters only support 7.7 as far as I understand.

-[Unknown]

[sobrelacolina]

mmm...

ok... thnx for the help [Unknown] 

bye

[Chelle]

Alright, I'm carrying on my woes here for my conversion from bbtonuke to SMF.  I can't rememeber if I had altered it after reading about the phpbb pm_email_notify...if it's im_email_notify in the sql file, it'll give an error.  Now if it's not and that was just me...nevermind

It get's stuck on group access, giving a MySQL syntax error:

    INSERT IGNORE INTO `donnie6_cms1`.dyusmb_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (, 1, 'post_new'),
    (, 1, 'mark_notify'),
    (, 1, 'mark_any_notify'),
    (, 1, 'post_reply_any'),
    (, 1, 'modify_own'),
    (, 1, 'remove_own'),
    (, 1, 'delete_own'),
    (, 1, 'make_sticky'),
    (, 1, 'announce_topic'),
    (, 1, 'poll_post'),
    (, 1, 'poll_add_own'),
    (, 1, 'poll_vote'),
    (, 1, 'poll_view'),
    (, 1, 'moderate_board'),
    (, 1, 'remove_any'),
    (, 1, 'lock_any'),
    (, 1, 'lock_own'),
    (, 1, 'merge_any'),
    (, 1, 'modify_any'),
    (, 1, 'modify_own'),
    (, 1, 'move_any'),
    (, 1, 'poll_add_any'),
    (, 1, 'poll_edit_any'),
    (, 1, 'poll_remove_any'),
    (, 1, 'post_reply_own'),
    (, 1, 'delete_any'),
    (, 1, 'report_any'),
    (, 1, 'send_topic'),
    (, 1, 'split_any');

Caused the error:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'post_new'),
    (, 1, 'mark_notify'),
    (, 1, 'mark_any_



I skipped that just tp push forward to see if there were any other issues and there were:

Converting settings... Unsuccessful!
This query:

    REPLACE INTO `donnie6_cms1`.dyusmb_settings
    (variable, value)
    VALUES ('site_desc', '-we're UN, baby!');

Caused the error:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 're UN, baby!')' at line 3


After skipping those two steps..everything else went fine.


UPDATE: Ok, after poking around a bit and this might be due to skipping the above...every one that was given mod or admin right at my board were converted to reg user permissions and reg users have admin rights..

[[Unknown]]

Try this one.

-[Unknown]

[Chelle]

Works great getting everything over.  Still swaps all reg users setting them as admin yet admin/mods stay in their phpbb group, but no admin button for me.

No biggie for me, I just run a SQL statement to change all the users to ID_GROUP=0 and then change my to 1 and go from there, but FYI.


for any needing, that statement is:

UPDATE prefix_members SET ID_GROUP = 0 WHERE ID_GROUP =1

change prefix to whatever prefix you're using for smf.  Then go back and change your ID_GROUP to 1 to get into the admin area of smf..via phpMyAmin

[[Unknown]]

What is the user_level column set to for you, and for most users, in the PHP-Nuke database?

-[Unknown]

[Chelle]

reg users: user lvl = 1
mods: user lvl = 3
superuser[admin]: user lvl=2

I think I see why all my reg users were getting admin rights now..

[Silver-SAF]

For a quick fix, find:

INSERT INTO

Replace:

INSERT IGNORE INTO

ALL of the INSERT INTO or just a specific one??

[[Unknown]]

All is fine.

-[Unknown]

[Silver-SAF]

Right, everything worked ok except for on the new SMF forums.

1926 Posts in 327 Topics by 1 Members

So i check the Member list, and I have one page of members, instead of 1300 odd members, what happened there.

[Silver-SAF]

Oh and, in the administration center i see a huge list of administrators, there should only be two.

[[Unknown]]

Look at Chelle's posts.  You'll need to run:

UPDATE smf_members
SET ID_GROUP = IF(memberName = 'yourname', 1, 0);

And then go to Admin -> Recount all forum totals and statistics.

-[Unknown]