I know there is a request under the "requests" thread, but it has remained unanswered and after hours of research it seems to be inconclusive whether phpnuke + SMF are reasonably possible. Does anyone have any experience, importers, etc. for conversion?
My webhost is banning phpbb and I have a nonprofit phpNuke site with a very active phpbb forum... and few if any choices :(
Your help would be greatly appreciated!
I've quickly hacked this together from the phpBB converter, but it worked on my test phpNuke install so it may well work. The one ending "103" is for SMF 1.0.3, the other for 1.1 Beta 2. I have only tested it on 1.1 but I believe both may work - let me know how you get on - and follow the instructions on the converter :)
yowza! I will happily try this and let you know how it goes! :) THANKS!
Nope.
Didnt work on my install.
Error Messages
QuoteNotice: Undefined variable: dbname in e:\domains\g\gtacomplex.co.uk\user\htdocs\forum\nuke.php on line 122
Warning: loadsettings(e:\domains\g\gtacomplex.co.uk\user\htdocs\modules\forums/includes/constants.php): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forum\nuke.php on line 124
Fatal error: loadsettings(): Failed opening required 'e:\domains\g\gtacomplex.co.uk\user\htdocs\modules\forums/includes/constants.php' (include_path='.;c:\php4\pear') in e:\domains\g\gtacomplex.co.uk\user\htdocs\forum\nuke.php on line 124
What version of phpnuke?
-[Unknown]
phpnuke version is 7.2.x
Oh and SMF was 1.3
Anyone any ideas?
Sorry Silver-SAF, was away for the weekend.
I wrote the converter for Nuke 7.7, which I tested it on. Could you post the contents of your config.php file from phpNuke - maybe they've changed a few things. Obviously when you post them make sure you REMOVE your password from it!
Quote from: Silver-SAF on June 03, 2005, 12:31:43 PM
Nope.
Didnt work on my install.
Error Messages
QuoteNotice: Undefined variable: dbname in e:\domains\g\gtacomplex.co.uk\user\htdocs\forum\nuke.php on line 122
Warning: loadsettings(e:\domains\g\gtacomplex.co.uk\user\htdocs\modules\forums/includes/constants.php): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forum\nuke.php on line 124
Fatal error: loadsettings(): Failed opening required 'e:\domains\g\gtacomplex.co.uk\user\htdocs\modules\forums/includes/constants.php' (include_path='.;c:\php4\pear') in e:\domains\g\gtacomplex.co.uk\user\htdocs\forum\nuke.php on line 124
Had same error turned out that i had the wrong path for phpnuke. make sure to enter tha path to phpnuke and not the forums underneath the phpnuke directory.
Hey,
Sorry about the lateness of the reply, I had some difficulties in life to sort out.
<?php
######################################################################
# PHP-NUKE: Advanced Content Management System
# ============================================
#
# Copyright (c) 2002 by Francisco Burzi ([email protected])
# http://phpnuke.org
#
# This module is to configure the main options for your site
#
# This program is free software. You can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License.
######################################################################
######################################################################
# Database & System Config
#
# dbhost: SQL Database Hostname
# dbuname: SQL Username
# dbpass: SQL Password
# dbname: SQL Database Name
# $prefix: Your Database table's prefix
# $user_prefix: Your Users' Database table's prefix (To share it)
# $dbtype: Your Database Server type. Supported servers are:
# MySQL, mysql4, postgres, mssql, oracle, msaccess,
# db2 and mssql-odbc
# Be sure to write it exactly as above, case SeNsItIvE!
# $sitekey: Security Key. CHANGE it to whatever you want, as long
# as you want. Just don't use quotes.
# $gfx_chk: Set the graphic security code on every login screen,
# You need to have GD extension installed:
# 0: No check
# 1: Administrators login only
# 2: Users login only
# 3: New users registration only
# 4: Both, users login and new users registration only
# 5: Administrators and users login only
# 6: Administrators and new users registration only
# 7: Everywhere on all login options (Admins and Users)
# NOTE: If you aren't sure set this value to 0
# $subscription_url : If you manage subscriptions on your site, you
# must write here the url of the subscription
# information/renewal page. This will send by
# email if set.
######################################################################
$dbhost = "mysql4.streamline.net";
$dbuname = "gtacomplex";
$dbpass = "xxxxxxxxxxxx";
$dbname = "gtacomplex";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "7408";
$gfx_chk = 7;
$subscription_url = "";
/*********************************************************************/
/* You finished to configure the Database. Now you can change all */
/* you want in the Administration Section. To enter just launch */
/* you web browser pointing to http://yourdomain.com/admin.php */
/* */
/* Remeber to go to Settings section where you can configure your */
/* new site. In that menu you can change all you need to change. */
/* */
/* Congratulations! now you have an automated news portal! */
/* Thanks for choose PHP-Nuke: The Future of the Web */
/*********************************************************************/
// DO NOT TOUCH ANYTHING BELOW THIS LINE UNTIL YOU KNOW WHAT YOU'RE DOING
$reasons = array("As Is",
"Offtopic",
"Flamebait",
"Troll",
"Redundant",
"Insighful",
"Interesting",
"Informative",
"Funny",
"Overrated",
"Underrated");
$badreasons = 4;
$AllowableHTML = array("b"=>1,
"strong"=>1,
"em"=>1,
"i"=>1,
"u"=>1,
"("=>1,
")"=>1,
"()"=>1,
"br"=>1,
"p"=>2,
"a"=>2,
"h1"=>1,
"h2"=>1,
"h3"=>1,
"h4"=>1,
"h5"=>1,
"h6"=>1,
"center"=>1,
"img"=>2,
"alt"=>1,
"table"=>2,
"tr"=>2,
"td"=>2,
"div"=>2,
"font"=>2,
"style"=>2,
"blockquote"=>1,
"tt"=>1,
"li"=>1,
"ol"=>1,
"ul"=>1);
$CensorList = array("******",
"******",
"******er",
"******ing",
"pussy",
"cock",
"c0ck",
"cum",
"twat",
"clit",
"******",
"fuk",
"fuking",
"mother******er");
$tipath = "images/topics/";
if (eregi("config.php",$_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}
?>
Thats direct from the config.php file, with no password.
Quote from: SpikeyKlitske on June 21, 2005, 07:38:14 PM
Had same error turned out that i had the wrong path for phpnuke. make sure to enter tha path to phpnuke and not the forums underneath the phpnuke directory.
Sorry mate didn't see that there, nice one, will definitely try that and post any errors.
Hi,
I get as far as this:
QuoteConverting ranks... successful.
Converting groups... successful.
Converting members... Unsuccessful!
This query:
Then it gives me mebers names etc. then it says at the end:
QuoteCaused the error:
Unknown column 'pm_email_notify' in 'field list'
Please help
EDIT
Also, there are some fields which have been incorrectly named. ANDDD it doesnt import all members and it also makes the wrong person the administrator of the board... I got as far as group access and then gave up because I couldnt find solution to the next problem.. I solved the above problem its actually meant to be email_notify I think.. something like that. anyway, please fix these bugs :-[
+ everyone is being made admin.. the ID_Groups dont come out right either...
+ Member list does not show all the members
+ It says only 1 registered member when theres like 500+
any update on this?
i tried to run the converter but failed like indicated. the conversion stopped with errors that it couldnt find a great number of avatars and then produced the same error as mentioned before about the pm_email_notify
btw im using php-nuke 7.7 and smf 1.05
thx spikey
Inside the file, replace "pm_email_notify" with "im_email_notify".
-[Unknown]
Hey Guys,
Just attempted the convert to some test forums, first time unsuccesful and then remembered toi change the email_notify thingy.
Did that, members were all succesful. Although,
Converting ranks... successful.
Converting groups... successful.
Converting members...
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/167207054111960940b96.jpg): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/56765290541920a93e3ad0.jpg): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/6322351104103db318bbf3.gif): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/103468932541059f7e3efd7.jpg): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/138351167541019cc66f1b2.jpg): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/52986046841a0ca6d0597d.gif): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/1216985245413b9fb64418d.gif): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/4377581274156d806d9b7b.jpg): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
Warning: copy(e:\domains\g\gtacomplex.co.uk\user\htdocs\/modules/Forums/images/avatars/1571437862418fc6c2f2c4a.jpg): failed to open stream: No such file or directory in e:\domains\g\gtacomplex.co.uk\user\htdocs\forums\change.php on line 1011
successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... successful.
Converting messages... (this may take some time) successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (step 2)... successful.
Converting topic notifications... successful.
Converting board access... successful.
Converting group access permissions... Unsuccessful!
This query:
INSERT INTO `gtacomplex`.smft_board_permissions
(ID_GROUP, ID_BOARD, permission)
VALUES
(22, 1, 'post_new'),
(22, 1, 'mark_notify'),
(22, 1, 'mark_any_notify'),
(22, 1, 'post_reply_any'),
(22, 1, 'modify_own'),
(22, 1, 'remove_own'),
(22, 1, 'delete_own'),
(22, 1, 'make_sticky'),
(22, 1, 'announce_topic'),
(22, 1, 'poll_post'),
(22, 1, 'poll_add_own'),
(22, 1, 'poll_vote'),
(22, 1, 'poll_view'),
(22, 1, 'moderate_board'),
(22, 1, 'remove_any'),
(22, 1, 'lock_any'),
(22, 1, 'lock_own'),
(22, 1, 'merge_any'),
(22, 1, 'modify_any'),
(22, 1, 'modify_own'),
(22, 1, 'move_any'),
(22, 1, 'poll_add_any'),
(22, 1, 'poll_edit_any'),
(22, 1, 'poll_remove_any'),
(22, 1, 'post_reply_own'),
(22, 1, 'delete_any'),
(22, 1, 'report_any'),
(22, 1, 'send_topic'),
(22, 1, 'split_any');
Caused the error:
Duplicate entry '22-1-modify_own' for key 1
That was the report given.
Any help would be great fellas
that's exactly where i got stuck on!
Strange. It sounds like it's trying to do the same board permissions twice....
-[Unknown]
actually, I just deleted step16.. Thats not risky is it? I can add the moderators etc again.. will that be ok?
Yeah, that should be okay.
-[Unknown]
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.
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.. :)
For a quick fix, find:
INSERT INTO
Replace:
INSERT IGNORE INTO
-[Unknown]
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
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:
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 :)
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]
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:
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
...
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)
;)
I'm very sorry, but the current converters only support 7.7 as far as I understand.
-[Unknown]
mmm...
ok... thnx for the help [Unknown] ;) ;)
bye
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 ;D
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..
Try this one.
-[Unknown]
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
What is the user_level column set to for you, and for most users, in the PHP-Nuke database?
-[Unknown]
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.. :D
Quote from: [Unknown] on July 13, 2005, 04:05:08 AM
For a quick fix, find:
INSERT INTO
Replace:
INSERT IGNORE INTO
ALL of the INSERT INTO or just a specific one??
All is fine.
-[Unknown]
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.
Oh and, in the administration center i see a huge list of administrators, there should only be two.
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]
Ahh right, sorry I missed that.
Anyway, did that, all is good.
Except when I try to go on the Manage Boards option in the Admin panel i get this error
QuoteUnknown column 'b.topicSolved' in 'field list'
File: e:\domains\g\gtacomplex.co.uk\user\htdocs\smf\Sources\ManageBoards.php
Line: 852
I upgraded and it works fine now.
Currently running V 1.0.5
I need some help with a statement. I figured my reg dates wouldn't convert over, so I wasn't too concerned. I figured I could just run a statement like I did with the user groups, but I'm afraid I only know of MySQL what i've picked up over the years. I get stuck on the part to update my _members table.
SELECT user_id, user_regdate AS dateRegistered FROM prefix_users LIMIT 0 , 30
UPDATE smfPrefix_members SET dateRegistered = user_regdate WHERE ID_MEMBER=user_id
It's a syntax error. Annoying cause I know what pieces of info I need selected, I just can't figure out how to tell it what I want to do with it.
In case it's not obvious from the obvious, wanted it to take the user_id and user_regdate and then seek the same user_id as it occurs in ID_MEMBER and update the dateRegistered with the data from user_regdate.
Any suggestions for other things to try since there's prolly other ways to tackle this? I'm trying it on a smaller board with test data before I use it on a bigger board, so no worries about things getting botched.
UPDATE smf_members AS mem, phpbb_users AS u
SET mem.dateRegistered = u.user_regdate
WHERE mem.ID_MEMBER = u.user_id;
This will only work in MySQL 4 and above. But, why wasn't this converted properly automatically?
-[Unknown]
I don't know, but I suspect a difference in how the data is stored..it doesn't convert properly. user_regdate is a varchar(20) versus a int(10) unsigned for the smf table. After running the convert.php tt will have a value of 0 in the database and when you look at the members list, all of them are 1969-12-31 as the reg date and the same result occurs when running the corrected statement you provided.
My Reg Dates didnt get carried over but I am not to bothered about that.
I just hope all the users who register in nuke get added to the DB.
Then try:
UPDATE smf_members AS mem, phpbb_users AS u
SET mem.dateRegistered = UNIX_TIMESTAMP(u.user_regdate)
WHERE mem.ID_MEMBER = u.user_id;
-[Unknown]
Do you mean as a SQL Query in phpMyadmin ??
Yes. What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
-[Unknown]
Okie dokie, just checking so I didn't screw things up .
I guess that was to update my members registration dates?
If so, i must have done something wrong as it did not work.
QuoteSQL-query:
UPDATE smf_members AS mem,
nuke_users AS u SET mem.dateRegistered = UNIX_TIMESTAMP( u.user_regdate ) WHERE mem.ID_MEMBER = u.user_id
Did it give an error message or just do nothing?
-[Unknown]
No error given, it didn't change anything; the date is still 0 in the smf_members table in the database.
Quote from: Chelle on August 21, 2005, 07:17:39 PM
No error given, it didn't change anything; the date is still 0 in the smf_members table in the database.
Then what's stored in the varchar? Can you give a specific example of a date?
Date registered is stored as seconds since 1969, in SMF.
-[Unknown]
Well if you mean what format it is.
May 28, 2004
Is that what you mean, also I had no error.
Just wanted to elaborate on the result given..I just realized this today, when running that statement, the result yeilds this:
Affected rows: 0 (Query took 0.0263 sec)
SQL-query:
UPDATE smf_members AS mem,
phpbb_users AS u SET mem.dateRegistered = UNIX_TIMESTAMP( u.user_regdate ) WHERE mem.ID_MEMBER = u.user_id
Also, I asked over at nukecops how the user's regdate gets stored, cause I figure that'd be helpful too:
QuoteIn modules/Your_Account/index.php in the finishNewUser function
$user_regdate = date("M d, Y");
Then it is inserted into nuke_users_temp by the following query:
$result = $db->sql_query("INSERT INTO ".$user_prefix."_users_temp (user_id, username, user_email, user_password, user_regdate, check_num, time) VALUES (NULL, '$username', '$user_email', '$new_password', '$user_regdate', '$check_num', '$time')");
Sorry I can't be more helpful..MySQL has a big learning curve for me still
Bleh. That's no fun.
Change this:
UNIX_TIMESTAMP(u.user_regdate) AS dateRegistered
Back to this:
u.user_regdate AS dateRegistered
Then change this:
unset($row['signature_uid']);
---}
To this:
unset($row['signature_uid']);
$row['dateRegistered'] = strtotime($row['dateRegistered']);
---}
Or in other words, the attached file.
-[Unknown]
w00t! That did it. Thanks [Unknown], you rock. This is not news.
Ok, next question, can strtotime be used in a statement? Because I can't run the converter on the other board I have without loosing info. So would I need to select dateRegistered, do the equivalent of $row['dateRegistered'] = strtotime($row['dateRegistered']); then run
UPDATE smf_members AS mem,
phpbb_users AS u
SET mem.dateRegistered = u.user_regdate
WHERE mem.ID_MEMBER = u.user_id
umm, right? And if yes, I've tried some things, but my syntax isn't right in trying to get the equivalent of he equivalent of $row['dateRegistered'] = strtotime($row['dateRegistered']);
What about something like: (As a php file)
<?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdata AS dateRegistered FROM phpbb_users");
while ($row = mysql_fetch_assoc($request))
db_query("UPDATE smf_members SET dateRegistered = " . strtotime($row['dataRegistered']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1");
?>
That, or something similar, should work.
I'm all confused now sorry.
I thought you wanted to update the date registered field on your SMF members after a conversion? If so you copy and paste the contents of my code into a PHP file in your SMF directory and run it, and it should work.
Grudge: Yeah, something like was what I was thinking...didn't have the SSI.php include in there...I'll give it a go after my backup's done and see what happens.
Silver-SAF: I can't run convert.php again without loosing all the posts made since my board was converted, so I'm looking for a method to convert my date registered without affecting the rest of my board...that's what the code Grudge offered up is supposed to help with..does that help your confusion?
I get this when trying to run that php file:
Warning: Missing argument 2 for db_query() in /home/donnie6/public_html/dymb/Sources/Subs.php on line 234
Warning: Missing argument 3 for db_query() in /home/donnie6/public_html/dymb/Sources/Subs.php on line 234
Then further:
Database Error
No Database Selected
File:
Line:
The contents of that file are: <?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdate AS dateRegistered FROM chronicle_users");
while ($row = mysql_fetch_assoc($request))
db_query("UPDATE chronMB_members SET dateRegistered = " . strtotime($row['user_regdate']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1");
?>
I looked at subs.php to see what was missing. And I'm clueless about this string __FILE__, int __LINE__ it's expecting to try and fix something. What are these?
BTW, I get the same thing with running the code you offered Grudge, changing the prefixes to match what's in my database..
Apologies, I forgot you need to use:
<?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdate AS dateRegistered FROM chronicle_users", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
db_query("UPDATE {$db_prefix}members SET dateRegistered = " . strtotime($row['user_regdate']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1", __FILE__, __LINE__);
?>
I think the actual error may be involve specifying the phpBB database better. I've added {$db_prefix} into the SMF bit - if that doesn't stop the error you may need to edit the "chronicle_users" bit to explicitly say the phpBB database name (i.e. phpBBdatabase.chronicle_users)
No worries. I appreciate the help and you lot learnin me :D
Alright, here's what's up so far:
The code will change the date reg field in the smf_members table. So no one's no longer registered in 1969 -chuckles- but it changes the date to the day's date you run the php file. In my case, I named it convertDate.php. It's contents are:
<?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdate AS dateRegistered FROM phpBBdatabase.prefix_users", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
db_query("UPDATE {$db_prefix}members SET dateRegistered = " . strtotime($row['user_regdate']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1", __FILE__, __LINE__);
?>
So yeah, you need to specify the db name as you thought Grudge. I'm perplexed. I checked all the field names, just in case and to rule that out [they're correct] but it doesn't look like it's even looking at the data in the nuke user table.
What does this reveal:
<?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdate AS dateRegistered FROM phpBBdatabase.prefix_users", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
{
echo "<br />User Number $row[user_id], original date: $row[user_regdate], new date: " . strtotime($row['user_regdate']);
db_query("UPDATE {$db_prefix}members SET dateRegistered = " . strtotime($row['user_regdate']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1", __FILE__, __LINE__);
}
?>
Here's a snippet, but you get the idea:
QuoteUser Number 1, original date: , new date: 1125039600
User Number 3, original date: , new date: 1125039600
User Number 5, original date: , new date: 1125039600
User Number 6, original date: , new date: 1125039600
User Number 7, original date: , new date: 1125039600
User Number 8, original date: , new date: 1125039600
User Number 9, original date: , new date: 1125039600
User Number 10, original date: , new date: 1125039600
User Number 11, original date: , new date: 1125039600
User Number 12, original date: , new date: 1125039600
User Number 13, original date: , new date: 1125039600
User Number 14, original date: , new date: 1125039600
User Number 15, original date: , new date: 1125039600
User Number 16, original date: , new date: 1125039600
User Number 17, original date: , new date: 1125039600
User Number 18, original date: , new date: 1125039600
User Number 19, original date: , new date: 1125039600
User Number 20, original date: , new date: 1125039600
User Number 22, original date: , new date: 1125039600
That's interesting..I checked the first query, just to make sure I got the right info in there for db name and table. It's correct, it pulls the user_id and user_regdate just fine. Question, I just thought of this...though I don't know why it would affect anything- the nuke user table automatically inserts a user when you install [whose id =1 btw], it's not brought over to the SMF conversion [which is perfectly fine]...that shouldn't screw anything up, should it?
Got it, stupid typo:
<?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdate AS dateRegistered FROM phpBBdatabase.prefix_users", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
db_query("UPDATE {$db_prefix}members SET dateRegistered = " . strtotime($row['dateRegistered']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1", __FILE__, __LINE__);
?>
That did it! w00t! Thanks for all your help with this. VERY MUCHLY Appreciated. -insert dancing smiliey here-
[Unknown] that is what I was trying to do, but I wasn't following along very well, sorry.
Plus, I didnt know you had to save that as a PHP file. Will do all that now and let you know.
problem :(
Converting previous poll votes... Unsuccessful!
This query:
INSERT INTO `onweeronline`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('1', '6'),
Caused the error:
Duplicate entry '9-1489-0' for key 1
]oeps other probs :)
got 2100 members see them in the membes but not in the statistics :(
fixed :D
Quote from: Grudge on August 26, 2005, 10:03:59 AM
Got it, stupid typo:
<?php
require('SSI.php');
$request = db_query("SELECT user_id, user_regdate AS dateRegistered FROM phpBBdatabase.prefix_users", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
db_query("UPDATE {$db_prefix}members SET dateRegistered = " . strtotime($row['dateRegistered']) . " WHERE ID_MEMBER = $row[user_id] LIMIT 1", __FILE__, __LINE__);
?>
/me stupid :( but i realy don't know how to do this :(
do i have to do this in the convert script ???
Soulmaster, if you downloaded the .sql file a fews posts back attached by [Unknown] you should be good to go. The other .php code Grudge posted was for people that had run the convert.php already and had their board active after they converted [meaning new posts, setting changes and new users, etc]. If you run the convert.php script AFTER your SMF boards been running and had new activity since the conversion, you'll lose everything new after you converted.
I wanted to prevent that, so I was seeking help with some code that would just focus on the date registered.
Soo, winded way of saying if you downloaded the latest convert.php and the .sql file [Unknown] attached a few posts back, you shouldn't have to worry about that bit of code.
But for anyone else wondering, that bit you would need to save as a .php file, upload it to the directory SMF is located in and run it:
http://www.yourdomain/smf_directory_name/name_of_file.php
Okay, after a long search for a tool like this I've finally found it! However, there is one small problem, it doesn't import hte topics. can anyone give me a hint where I should look in the PHPNuke/phpBB2-database to correct this?
Converting...
Converting ranks... successful.
Converting groups... successful.
Converting members... successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... Unsuccessful!
This query:
ALTER TABLE `database_smf`.smf_topics
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD);
Caused the error:
Duplicate entry '290-16' for key 3
Thanks in advance! :)
Andreas
This error is caused by a corrupted (phpbb) topics table. The message ID '290' appears to be the first or last message of two topics. The easiest to get around this problem is to remove (phpbb2_to_smf.php):
// Put the index's back into the table.
mysql_query("
ALTER TABLE {$to_prefix}topics
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD)");
run the conversion, use SMF's repair feature ('admin' -> 'Forum Maintenance' -> 'Find and repair any errors.') and after that run the query you removed from the converter:
ALTER TABLE smf_topics
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD)
Quote from: Compuart on October 12, 2005, 01:55:07 PM
This error is caused by a corrupted (phpbb) topics table. The message ID '290' appears to be the first or last message of two topics. The easiest to get around this problem is to remove (phpbb2_to_smf.php):
// Put the index's back into the table.
mysql_query("
ALTER TABLE {$to_prefix}topics
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD)");
run the conversion, use SMF's repair feature ('admin' -> 'Forum Maintenance' -> 'Find and repair any errors.') and after that run the query you removed from the converter:
ALTER TABLE smf_topics
ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD),
ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD)
Thank you very much, it worked like a charm! :)
im getting this error, and i know it says something about line 9 but can someone be more specific? thank you....
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
SUBSTRING(u.username, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages,
SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessages,
SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
SUBSTRING(u.user_aim AS AIM, 1, 16) AS AIM,
SUBSTRING(u.user_icq, 1, 255) AS ICQ,
SUBSTRING(u.user_yim, 1, 32) AS YIM,
SUBSTRING(u.user_website, 1, 255) AS websiteTitle,
SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
'' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
'' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
'' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
'' AS memberIP2
FROM `hackphre_diego`.nuke_users AS u
LEFT JOIN `hackphre_diego`.nuke_bbranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `hackphre_smf`.smf_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != 1
GROUP BY u.user_id
LIMIT 0, 500;
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 'AS emailAddress, 1, 255) AS emailAddress,
u.user_unread_privmsg AS unreadMessag' at line 9
the same problem i had
read this http://www.simplemachines.org/community/index.php?topic=107868.0
rejetto what line did u changed exactly in phpbb2_to_smf.sql ?
i try to get working phpnuke converter but no luck :(
http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-rc3_phpnuke_converter.zip