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?

[metallica48423]

I'm no good with debugging database errors.  I apoligize but I will have to gracefully bow out of this one.

What mods do you actually have installed.

[AlenNS]

I have a lot of mods installed...

1.     Grouped Who's Online      1.0       [ Deinstaliraj ]  [ Spisak datoteka ]  [ Obriši ]
2.    Reg Bar    1.0.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
3.    Order Stickied Topics    1.01    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
4.    Birthday on Profile Summary    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
5.    Auto Email Inactive Users    1.7    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
6.    Google Member Map    1.0 beta 3    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
7.    Ad Managment    2.3.4    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
8.    Show Local Url Titles    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
9.    SimplePortal    2.1    [ Spisak datoteka ] [ Obriši ]
10.    [user] BBC Tag    1.0.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
11.    User Control Panel By Alan S    2.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
12.    Custom Action Mod    3.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
13.    Auto Embed Video/Audio Clips    4.0.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
14.    Super Admin    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
15.    Profil Moderator Managment    1.0.0    [ Spisak datoteka ] [ Obriši ]
16.    Thank-O-Matic    2.0 Beta 6    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
17.    Missing Breadcrumbs Fix    0.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
18.    Custom Form Mod    1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
19.    RSS Feed Icon    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
20.    Remove MySQL, PHP & W3C images to minimize footer size    1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
21.    Generic Avatars    1.02    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
22.    Posting_Announcement    1.1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
23.    Frustrate Your Guests    0.2.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
24.    Pm_Informer    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
25.    Enhance Recent Post    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
26.    Member Color Link    3.0.5a    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
27.    Custom Copyright    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
28.    cbi, 1.0    1.5    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
29.    Users Online Today    1.5.4    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
30.    Internal_Links_Use_Same_Window    1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
31.    New Style Message Icon    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
32.    Remove SMF Logo    1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
33.    Highslide Image Viewer    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
34.    Reflection Avatar    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
35.    Recount Posts Maintenance    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
36.    More Spiders    1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
37.    Load Standard Language    1.0.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
38.    Welcome Back    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
39.    Custom_Greeting_Depending_on_Time    0.8    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
40.    Remove Post Modified Time    1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
41.    Topic Recent Moderation History    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
42.    Look But No Read    1.2    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
43.    SimplePortal    2.1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
44.    No More Ugly Avatar Scrollbars    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
45.    Wysiwyg Quick Reply    1.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
46.    JPG Thumbnails    2.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
47.    MCLegendII.2    3.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
48.    New Topic Button    1.0    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]
49.    Bookmarks    2.2.1    [ Deinstaliraj ] [ Spisak datoteka ] [ Obriši ]

[AlenNS]

Bump

[AlenNS]

I see that I have been posted this topic in SMF 1.X Support and I'm running SMF 2.0 Beta 4.

Could moderators move this to that board please, so I can get some help for this serious problem?

[metallica48423]

Sorry about that.  I'll move it to 2.0 support.

[AlenNS]

Thanks. I hope that someone will try to help.

[metallica48423]

Bumping topics less than 24 hours old is frowned upon.

You have now done so twice within 6 hours.  you also bump yourself to the bottom of the support queue by bumping your topic.

i've posted a link to this topic in the team boards in hopes that someone knows about the database error.

Can you please attach a copy of your SplitTopics.php?

[AlenNS]

Yes, I can. I'm sorry for bumping, but I asked for help long time ago and nothing.
In that time, I've lost too many posts.

[metallica48423]

Can you check the autoincrement value on id_topic in the topics table?  Check it, and make sure that it is higher than your highest topic ID. 

You'll need to use php -- What is phpMyAdmin? -- to find that out,.

[AlenNS]

My highest topic ID is 10090 and this is value.

[SleePy]

Are you selecting valid posts to split? That would explain the previous error and possibly this error.

[AlenNS]

Hm, what do you mean "valid" posts?
I am checking posts I want to split and either I want to split a single post or want to split multiple post I am getting same error.

But, on my trash board and admin board I am splitting topics with no errors. It is strange.

[AlenNS]

Bump

[greyknight17]

Sorry for the late reply. Do you still need help with this?

Are you familiar with using phpMyAdmin? Go to cPanel->phpMyAdmin and choose your SMF database. Then click on smf_messages and look at the table at the bottom (Row Statistics) to see what value Next Autoindex is set to. Then go to Browse tab at the top and see what the last ID_MSG number is. That number should be one value less than Next Autoindex. If not, it may be causing the problem.

Do the same thing for smf_topics to make sure it's not off there.

[AlenNS]

Sorry for the late reply. Do you still need help with this?

Are you familiar with using phpMyAdmin? Go to cPanel->phpMyAdmin and choose your SMF database. Then click on smf_messages and look at the table at the bottom (Row Statistics) to see what value Next Autoindex is set to. Then go to Browse tab at the top and see what the last ID_MSG number is. That number should be one value less than Next Autoindex. If not, it may be causing the problem.

Do the same thing for smf_topics to make sure it's not off there.

greyknight17 Thanks for the answer.
Yes, I still have this problem.

But, I couldn't find this:

Then click on smf_messages and look at the table at the bottom (Row Statistics) to see what value Next Autoindex is set to. Then go to Browse tab at the top and see what the last ID_MSG number is. That number should be one value less than Next Autoindex. If not, it may be causing the problem.

Here how it looks like...



and...

[greyknight17]

On your first image, next to smf_messages, you will see the six icons to the right. Click on the second one for the structure. Then scroll down to view the details (may require you to click on the Details link to expand it if it's not already expanded to show the row statistics data). Give me the next autoindex number there....I forgot exactly why I asked for this instead of the topic ID count (asked earlier by the others).

How about if you move that topic to that special board you have and then try to do the split? Will it actually allow you to do it then?

[AlenNS]

Sorry for the late reply. Do you still need help with this?

Are you familiar with using phpMyAdmin? Go to cPanel->phpMyAdmin and choose your SMF database. Then click on smf_messages and look at the table at the bottom (Row Statistics) to see what value Next Autoindex is set to. Then go to Browse tab at the top and see what the last ID_MSG number is. That number should be one value less than Next Autoindex. If not, it may be causing the problem.

Do the same thing for smf_topics to make sure it's not off there.

Next Autoindex     198,956
id_msg                     198,955

------------------------------------

Next Autoindex     11,157
id_topic                   11,156

--------------------------------------

On your first image, next to smf_messages, you will see the six icons to the right. Click on the second one for the structure. Then scroll down to view the details (may require you to click on the Details link to expand it if it's not already expanded to show the row statistics data). Give me the next autoindex number there....I forgot exactly why I asked for this instead of the topic ID count (asked earlier by the others).

How about if you move that topic to that special board you have and then try to do the split? Will it actually allow you to do it then?

You mean in admin room I told earlier?
Nice idea, I'll try.

[greyknight17]

Yes, if that admin board is that special board you were referring to earlier.

Any updates on this? Does it work in that board?

[AlenNS]

Yes, if that admin board is that special board you were referring to earlier.

Any updates on this? Does it work in that board?

It works in admin board. I've just splited one big theme in it.
But in other it doesn't split.

[Rumbaar]

Are you still encountering this after the upgrade to RC1?

So it works in admin board, but not in others?  What mods do you have installed that affect posts and thread permissions?

[AlenNS]

After upgrading to RC1 problem gone.