Split topic error

[AlenNS]

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 ')' at line 4
Datoteka: /home/baklja/public_html/forum/Sources/SplitTopics.php
Linija: 711

I've tried to split post from one topic and got this error.
Now when I check users' last posts it shows that message but it is gone from that topic and from board and from forum at all.

What happened?

[AlenNS]

==>711:     WHERE id_msg IN ($postList)");

[AlenNS]

Please bump.

[AlenNS]

Noone interested in this bug???

[Kermit]

I don't think,that is a bug,did you already try to renew your Sources/SplitTopics.php file ?

[AlenNS]

Yes, I did.
It happens every time I try to split some topic.
To many posts gone nowhere with this problem.

Here's my SplitTopic.php. I didn't change anything.

[AlenNS]

I'm sorry. I've copied SplitTopic.php from my backup.
Now I've copied from installation package and it works fine.

But, can you tell me, does any mod could change something to splittopic.php because I didn't even touch it?

[Kermit]

But, can you tell me, does any mod could change something to splittopic.php because I didn't even touch it?

I can't tell you exactly which mod did that,but it's quite possible,that can be changed during installation of a new mod...


and if your problem is fixed,please mark your topic as solved

[AlenNS]

It's not solved.

I've tried to split topic and got this error:

Database error:

Duplicate entry '0-1' for key 2
File: /home/baklja/public_html/forum/Sources/SplitTopics.php
Line: 680

[AlenNS]

Please. It's realy important to me to solve this.
I need to split one topic urgently but I cann't.

Please help...

[Kermit]

It's a database related problem,it's probably sth. wrong with smf_topics table

the error from above should show sth. more about the problem...

[AlenNS]

How can I check that?
I lost too many posts and topics because of this problem.
And now I have one big topic to split and I can't.

[Kermit]

did you try to fix it through

AdminCP -> Forum Maintenance -> Find and repair any errors. ?

[AlenNS]

I'm doing it every day.
But it only fix post errors.

I did it now and still get this.

Duplicate entry '0-1' for key 2
Datoteka: /home/baklja/public_html/forum/Sources/SplitTopics.php
Linija: 680

[Kermit]

Duplicate entry '0-1' for key 2
Datoteka: /home/baklja/public_html/forum/Sources/SplitTopics.php
Linija: 680

As i said,this error should have sth. more than this,also the error should say,which topics are effected...

[metallica48423]

moving to support.  this doesn't occur in the default install.

[AlenNS]

Is there any wav to fix this?

[metallica48423]

try running a check and repair on your database from phpmyadmin.  there might be an issue with the autoincrement value causing it to insert a duplicate id for a topic.

[AlenNS]

Done.
Checked and repaired all the tables in my database.

And again:

Database error:
Duplicate entry '0-1' for key 2
File: /home/baklja/public_html/forum/Sources/SplitTopics.php
Linija: 680


But when I try to split topic in special board for admins it splits with no errors. I don't understand.

Maybe is the problem because there is more then one page...

damn...

[AlenNS]

Any solution?