• Welcome to Simple Machines Community Forum. Please login or sign up.
September 27, 2021, 09:20:01 AM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


Problem with PHPbb -> SMF

Started by Kroesss, January 08, 2007, 01:58:52 PM

Previous topic - Next topic

Kroesss

January 08, 2007, 01:58:52 PM Last Edit: January 16, 2007, 11:37:40 AM by Kroesss
SMF Version: SMF 1.1.1
Hi all,

I thought I'd give SMF a try because I'm getting rather fed up of PHPbb. I downloaded the installation package and dutch langue files and unzipped it onto my local machine to test it (I have Xampp from apachefriends installed). The installation went flawless.

Then I unzipped the converter into the same folder and started the converter. I get a few creens of succesfull-messages, but then it comes up with a Caused the error:

Duplicate entry '63948' for key 1
error with a lot of sql-statements above it.

I searched this forum and it was implied that this would be caused by either:
- duplicate entry's in phpbb_topics_watch
- entries in phpbb_topics with a value in topic_moved_id
I checked and double-checked, but neither of this cases exist in my database.

I also ran the query select topic_id, user_id, count(*) as n
from phpbb_topics_watch
group by topic_id, user_id
having  n > 1;
in phpmyadmin, but it didn't return any rows.

Can anybody think of something wrong with my db/the converter/anything?

Kroesss


margarett

Well, that error IS related with duplicate entries somewhere... Usually on "phpbb_topics_watch "

My converter also had that error, and I also had to find the cause... My advise is to search again. That is the problem, for shure...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

JayBachatero

I'll be looking into updating the converter tonight. 
Follow me on Twitter

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

Kroesss

Is there some easy way of knowing where in the PHP-script the converter actually is encountering the error? That way I could look at the SQL and see from whitch phpbb-table the data is retrieved.

I'm kinda confused about where the error occurs because of all the screen refreshes in the converting process...

JayBachatero

the sql statement tells you where the error is at.  The name of the table.  if you give me FTP info I can look into this for you.
Follow me on Twitter

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

Kroesss

Actually, the SQL on the error-screen tells me in whitch table it is trying to put the data, not where the data is coming from. I think I should correct the problems in the phpbb-tables, shouldn't I?

FTP access is not available since I'm running it local on my computer. I'd have to sitting behind my computer if you wanted to log in.

JayBachatero

Just look at the .sql file.  It should tell you there.  If you want send me a database dump then and I can work on it locally.
Follow me on Twitter

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

Kroesss

I've send you the database through e-mail, I hope you can do something about the errors.

JayBachatero

January 12, 2007, 12:07:27 PM #9 Last Edit: January 12, 2007, 12:10:25 PM by JayBachatero
Ok thanks.  I just got the email.

EDIT:  What version of phpBB are you using?
Follow me on Twitter

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


fandel

January 12, 2007, 05:49:24 PM #11 Last Edit: January 12, 2007, 05:51:50 PM by fandel
Hi I got the same problem with the error message:


Converting topics... Unsuccessful!
This query:

Caused the error:

Duplicate entry '655' for key 1


Ofcourse this is only the top portion and the end.  Is there any fix yet?

Thank you again for everyone who has been working on this.

Thanks,

-Jose

I'm running phpbb v. 2.0.21

JayBachatero

I am looking for a way yo prevent the dup keys error.  I'll see how it goes.
Follow me on Twitter

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

prodigal

This worked for me , if you cant wait :) dropg smf_topics and recreate it with the following syntax

CREATE TABLE smf_topics(
ID_TOPIC mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
isSticky tinyint( 4 ) NOT NULL default '0',
ID_BOARD smallint( 5 ) unsigned NOT NULL default '0',
ID_FIRST_MSG int( 10 ) unsigned NOT NULL default '0',
ID_LAST_MSG int( 10 ) unsigned NOT NULL default '0',
ID_MEMBER_STARTED mediumint( 8 ) unsigned NOT NULL default '0',
ID_MEMBER_UPDATED mediumint( 8 ) unsigned NOT NULL default '0',
ID_POLL mediumint( 8 ) unsigned NOT NULL default '0',
numReplies int( 10 ) unsigned NOT NULL default '0',
numViews int( 10 ) unsigned NOT NULL default '0',
locked tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( ID_TOPIC )
);


It's the unique value constaraints that the table has on it by default that causes those errors

JayBachatero

But you have to create the indexes again or it can hurt the forum.  Indexes increase queries speed.
Follow me on Twitter

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

prodigal

yep done that :) , just abit of a ductape job to get the conversion script to work heh

Kroesss

Any luck on the conversion-problem yet?

prodigal

the one in this topic worked fine for me , with some minor coaxing ;)

Kroesss

That one worked like a charm!

Thanks!

Advertisement: