• Welcome to Simple Machines Community Forum. Please login or sign up.
December 04, 2021, 08:53:43 AM

News:

SMF 2.0.18 has been released! Please update. Read more.


[SMF Converter] IPB 2.2.x

Started by JayBachatero, January 24, 2007, 07:30:01 PM

Previous topic - Next topic

JayBachatero

Quote from: daveb47 on February 22, 2008, 10:00:37 AM
Tryingto convert ipb 2.2.2  to smf1 .1.4 bot getting following error

Converting members... Unsuccessful!
This query:

    SELECT
    id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
    joined AS dateRegistered, posts,
    IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
    last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
    msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
    SUBSTRING(email, 1, 255) AS emailAddress,
    SUBSTRING(website, 1, 255) AS websiteTitle,
    SUBSTRING(website, 1, 255) AS websiteUrl,
    SUBSTRING(location, 1, 255) AS location,
    SUBSTRING(icq_number, 1, 255) AS ICQ, signature,
    IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
    SUBSTRING(aim_name, 1, 16) AS AIM, SUBSTRING(yahoo, 1, 32) AS YIM,
    SUBSTRING(msnname, 1, 255) AS MSN, hide_email AS hideEmail,
    SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
    email_pm AS pm_email_notify, '' 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 memberIP
    FROM `arnoldvo_org`.ibf_members
    WHERE id != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'password' in 'field list'

That's weird.  Check in your IPB members table and see if there is a field for password there.

Quote from: Ali Imran on February 27, 2008, 06:08:41 AM
Hello again.

At some post within this topic, you suggest a member to drop index of posts table.
I have same error with users table 'Duplicate key...'

My question is:

1. Is it safe to drop index of topics table of the ipb 2.2.2?
2. HOW to drop index using mysql query?


regards
What section are you getting duplicate index errors?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Ali Imran

Am getting 'Duplicate key' error at USERS Table sir.

JayBachatero

Edit the .sql file.

Code (find) Select

---* {$to_prefix}members
---{


Add after.

$ignore = true;
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Ali Imran

Quote from: JayBachatero on February 27, 2008, 12:56:21 PM
Edit the .sql file.

Code (find) Select

---* {$to_prefix}members
---{


Add after.

$ignore = true;


Should I add $ignore = true; for every table under same position that reports same error? because now I have sme thing for TOPICS table.

Converting topics... Duplicate entry '13328' for key 1

regards

JayBachatero

Yes.  If no ---{ ---} exists you must add them.  So
---* {$to_prefix}topics

becomes

--- {$to_prefix}topics
---{
$ignore = true;
---}
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Ali Imran

Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...Duplicate entry '30' for key 1


Now error raised at 'permissions'.

Suggest me please.

regards

Mudassar Ahmed

I am getting this error, Please Help Me !

Mudassar Ahmed


Ali Imran

My last post was on "February 29, 2008, 03:02:42 PM" am (too) still waiting for your response guys.

JayBachatero

Quote from: Mudassar Ahmed on March 06, 2008, 01:27:59 PM
I am getting this error, Please Help Me !
That is a bug with MySQL.  Open the convert.php file.
Code (find) Select

LENGTH(code) DESC;

Code (replace) Select

code DESC;


Quote from: Ali Imran on February 29, 2008, 03:02:42 PM
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions...Duplicate entry '30' for key 1


Now error raised at 'permissions'.

Suggest me please.

regards
Open the .sql file.
Code (find) Select

INSERT INTO {$to_prefix}membergroups

Code (replace) Select

INSERT IGNORE INTO {$to_prefix}membergroups
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

edwardx

March 21, 2008, 06:50:06 PM #130 Last Edit: March 21, 2008, 06:54:04 PM by edwardx
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(910) : eval()'d code:41) in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(913) : eval()'d code on line 61

How should I proceed? I am using Invision 2.3.3

Nordoelum

As you might have read, this is for IP.Board 2.2.x.

Birger :)

Ali Imran

Exactly, no matter what version he is using I get same error while converting

2.2.2   >   SMF


QuoteFatal error: Cannot redeclare magicmask() (previously declared in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(910) : eval()'d code:41) in C:\Arquivos de programas\VertrigoServ\www\ragnanews\forum\convert.php(913) : eval()'d code on line 61

regards

JayBachatero

Ok try this.  Open the .sql file.

Code (find) Select

function magicMask(&$group)
{

Code (replace) Select

if (!function_exists('magicMask'))
{
function magicMask(&$group)
{


Code (find) Select

}

function smfGroup(&$group)
{

Code (replace) Select

}
}

if (!function_exists('smfGroup'))
{
function smfGroup(&$group)
{


Code (find) Select

}

while (true)
{
pastTime($substep);

$result = convert_query("
SELECT id AS ID_BOARD, permission_array

Code (replace) Select

}
}

while (true)
{
pastTime($substep);

$result = convert_query("
SELECT id AS ID_BOARD, permission_array

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Mudassar Ahmed

QuoteThat is a bug with MySQL.  Open the convert.php file.
Code: (find) [Select]
LENGTH(code) DESC;
Code: (replace) [Select]
code DESC;

I am now getting this error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\smf\convert.php on line 1372

JayBachatero

Seems like part of the file got corrupted when you made the change.  Download it again and make the changes.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Scruffyman

May 03, 2008, 02:01:33 PM #136 Last Edit: May 03, 2008, 05:38:43 PM by Scruffyman
Hi

Nevermind I fixed it:S

scimmiotto

May 04, 2008, 03:25:43 PM #137 Last Edit: May 04, 2008, 04:24:36 PM by scimmiotto
hi guys, there's a problem. i tried to convert ipb 2.2.1 to smf 1.1.5 and after using your tips (i had problem and used ignore in poll logs, permissions and magic)...but now the old posts that were good in ipb (using the wysywyg editor) now are not shown properly in smf. Plz see this for example

http://www.laforgia.medusaworks.it/smf/index.php?topic=2417.msg11711#new

and this is my forum
http://www.laforgia.medusaworks.it/smf/index.php

is there anything i can do to adjust the posts?
Loop code example:
The following statement is FALSE
The previous statement is TRUE.

JohnH

Gah, Im probably doing it all wrong but I get the following error:

SELECT command denied to user 'user'@'localhost' for table 'ibf_members'

I take it this means I need to do something with the databases but being a noob I have no idea what :(

SleePy

Quote from: scimmiotto on May 04, 2008, 03:25:43 PM
hi guys, there's a problem. i tried to convert ipb 2.2.1 to smf 1.1.5 and after using your tips (i had problem and used ignore in poll logs, permissions and magic)...but now the old posts that were good in ipb (using the wysywyg editor) now are not shown properly in smf. Plz see this for example

http://www.laforgia.medusaworks.it/smf/index.php?topic=2417.msg11711#new

and this is my forum
http://www.laforgia.medusaworks.it/smf/index.php

is there anything i can do to adjust the posts?

Is there something I am not seeing? They look fine, I see the signatures need to be repaired a little but adding/editing the regex that fixes it shouldn't be to hard to accomplish this.

JohnH,
Common conversion errors.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Advertisement: