News:

Join the Facebook Fan Page.

Main Menu

[SMF Converter] IPB 1.3.x

Started by JayBachatero, January 28, 2007, 02:56:33 PM

Previous topic - Next topic

SleePy

DJ Omnimaga,

That error is saying that there is two permission sets in IPB that have the id of 9. You will need to use phpMyAdmin and go to the permissions table and find this duplicate id and remove one of them.

vwchris,
Are you using the convert.php and sql attached to the first post of this topic?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vwchris


vwchris

It fails trying to build topics and convert posts

SleePy

ok, well I seen another post by jay so its known
What error do you get on the conversion process itself (ignoring that charset one)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vwchris

first this

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Incomplete.

Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.


then

Notice: Undefined index: charsets in /home/airspee/public_html/online-community/convert.php on line 378

combined with this

Converting...
Converting topics... Successful.
Converting posts (this may take some time)... Incomplete.

then this

Notice: Undefined index: charsets in /home/airspee/public_html/online-community/convert.php on line 378

combined with this

Converting...
Converting posts (this may take some time)... Incomplete.

it keeps cycling there until you hit continue then I get

Converting...
Converting posts (this may take some time)... Duplicate entry '66640' for key 1

and thats all I can do.

SleePy

Don't hit continue. It is working on the conversion and you may have double submitted the data which resulted in the duplicate key.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vwchris

figured that out, thanks for the help.

Dream of Omnimaga

#67
Quote from: SleePy on April 17, 2008, 07:25:56 PM
DJ Omnimaga,

That error is saying that there is two permission sets in IPB that have the id of 9. You will need to use phpMyAdmin and go to the permissions table and find this duplicate id and remove one of them.

vwchris,
Are you using the convert.php and sql attached to the first post of this topic?
could you explain more into details how I could do this? I am in phpMyAdmin now and selected the appropriate database and I checked the documentation of phpMyAdmin on table permissions and I couldn't find what I need. Could you post a step by step (preferably with screenshots) on how to find the duplicate table in my database so I don't delete something I shouldn't?

EDIT: I found something called Perm_id in the database,

   perm_id    perm_name
           1   Validating Forum Mask
           3   Member Forum Mask
           2   Guest Forum Mask
           4   Admin Forum Mask
           5   Banned Forum Mask

However it doesn't seems to be what I want because I see no permission with a ID of 9 there, just 1 through 5

SleePy

For IPB you are looking for pid in the posts table that has an id of 66640
There should be two of them. It would be a hard guess, but one of them needs to be removed.

If you do the wrong one, find and repair errors in SMF should help you resolve these by fixing them.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dream of Omnimaga

#69
sorry, still no luck figuring out what you mean. Ok let me make this clear: I am a real n00b at MySQL administration, all I wanted is to run a forum, but found out that IPB 1.3.1 was insecure so I want to convert now. However it is the first time I am messing with PHPMYadmin for real (altough I looked at it before). I went into ibf_posts, and i seeno posts with the id of 66640. In fact it doesn't even go higher than 2183 right now.

I even tried doing a query to check if pid 66640 existed and no results were found

SleePy

phpmyadmin comes with a search feature.
Just search the "posts" table by "pid" of "66640"

There should be two of them, remove one.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dream of Omnimaga

as I said in my previous post. I did used the search feature, and i found no results:

QuoteMySQL returned an empty result set (i.e. zero rows). (Query took 0.0007 sec)
SQL query:
SELECT `pid`
FROM `ibf_posts`
WHERE `pid` =66640
LIMIT 0 , 30

SleePy

Are you clicking the continue button as the converter is converting?
If you got javascript enabled it will automatically continue after a selected time. This is to prevent it from overloading your server.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dream of Omnimaga

When I click convert after selecting what I want to convert and entering my db password i get that page i posted as screenshot on the previous page. There is no continue button there. Unless you were replying to someone else's post.

Oh well so far I am sorry but I couldn't figure out anything that was told to me in that thread, I guess I am not ready to do board conversions unless I become PhpMyAdmin expert I guess I will just stick to IPB 1.3.1 until I finished learning it in 2-3 months and get my website hosting space shut down for spam sent from hacker php files they uploaded using exploits.

Sorry for taking all your time.

Does anyone know where I could maybe get SMF conversion help and support in french?

SleePy

We do have language specific boards below the general english ones.

I am sad we can't get this or figure out why its occuring, but all indicators of why it would occur are by you being said they don't exist or you are not doing it.

Are you sure that duplicate key error didn't change now?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dream of Omnimaga

i think part of the problem is that I am a beginner at MySQL, phpMyAdmin and board conversion, and you try to help me as if I used those for 8 years x.x

SleePy

I am sorry if its appearing to come to you to advanced.

Can you pm me your admin and site details and such so I can attempt the conversion myself? I just need things that will help me get the conversion done and be able to look at phpmyadmin myself.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dream of Omnimaga

hold on...

re-reading the previous page of the topic including vwchris posts, it seems you confused myself as him x.x, since the post ID 66640 thing seems to be related to his problem.

I still haven't found any forum permission that had the ID of 9 though. According to the error it is entry 9, but there is only 5 entries and searching for entry 9 seems to return no results.

I feel a bit relunctant to give my website acct password and login to someone I hardly know online though to be honest, especially when my credit card info and all that stuff is stored there x.x, atm I try to ask everywhere for help but not much luck yet, as no one I know ever used IPB or knows nothing about MySQL. I will try giving away my pass as last resort

SleePy

Doh,

That might help :P Thats what happens when you try to help to many people in one topic.

Ok, Go to your IPB database and look for the "groups" table.
In there (it hopefully shouldn't be that big that you need to search), you will find two groups with the ID of 9.

I do understand the need to not want to give out information. It is totaly up to you to give it out, whether it is temporarily information or not. But before you do, please read A reminder about admin / ftp passwords etc.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Dream of Omnimaga

#79
Ok I went there, but it didn't went up to 9 either. Highest group ID is 6:


Sorry for the large image

EDIT: I also attached a screenshot of permissions

Advertisement: