Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Aiheen aloitti: AlenNS - lokakuu 28, 2008, 05:37:05 IP

Otsikko: Split error
Kirjoitti: AlenNS - lokakuu 28, 2008, 05:37:05 IP
I've tried to split one topic and got this error.

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


Now all the messages from the splited part gone, but they are still in the users last post in profile.
Otsikko: Re: Split error
Kirjoitti: greyknight17 - lokakuu 28, 2008, 06:45:00 IP
Did you try going into those missing posts (from the user's profile) to see where it ended up in?

Give the following a try...

Go into Admin->Forum Maintenance and run the following:

Optimize all tables to improve performance.
Find and repair any errors.
Recount all forum totals and statistics.

Did you make any changes recently before you noticed this problem with splitting up topics? Anything in your forum error log?
Otsikko: Re: Split error
Kirjoitti: AlenNS - lokakuu 28, 2008, 07:12:13 IP
Lainaus käyttäjältä: greyknight17 - lokakuu 28, 2008, 06:45:00 IP
Did you try going into those missing posts (from the user's profile) to see where it ended up in?
I did after that happened. But it says there's no topic you try to enter or something like that.

Now I'm running maintenance you told me to do.
Otsikko: Re: Split error
Kirjoitti: AlenNS - lokakuu 28, 2008, 07:26:58 IP
It found that topic I splited has error:
Topic #8690 has wrong messages, 15.

I have repaired and still can find those messages in users profiles but there is no splited topic.
Otsikko: Re: Split error
Kirjoitti: greyknight17 - lokakuu 28, 2008, 07:29:05 IP
Lainaus käyttäjältä: greyknight17 - lokakuu 28, 2008, 06:45:00 IP
Did you make any changes recently before you noticed this problem with splitting up topics? Anything in your forum error log?
Otsikko: Re: Split error
Kirjoitti: AlenNS - lokakuu 28, 2008, 07:32:39 IP
Sorry.
I recently moved from Beta 3 to Beta 4 with certain problems. Here is details about that.

http://www.simplemachines.org/community/index.php?topic=268836.0

I have some errors in my error log mostly in common with languafe files missing.
I'm using serbianl-utf8.
Otsikko: Re: Split error
Kirjoitti: H - joulukuu 02, 2008, 02:05:11 IP
Hi AlenNS, I'm going through some old topics.
Did you manage to fix this problem?
Otsikko: Re: Split error
Kirjoitti: AlenNS - joulukuu 02, 2008, 03:52:05 IP
No, I didn't. :(
Otsikko: Re: Split error
Kirjoitti: AlenNS - joulukuu 03, 2008, 07:05:39 IP
Bump
Otsikko: Re: Split error
Kirjoitti: H - joulukuu 04, 2008, 03:48:57 IP
Which version of MySQL are you using? (You should be able to get this through cpanel)
Otsikko: Re: Split error
Kirjoitti: AlenNS - joulukuu 04, 2008, 04:52:23 IP
Apache version   1.3.41 (Unix)
PHP version   5.2.5
MySQL version   5.0.51a-community
Architecture   i686
Operating system   Linux
Otsikko: Re: Split error
Kirjoitti: AlenNS - joulukuu 11, 2008, 11:25:54 AP
Bump
Otsikko: Re: Split error
Kirjoitti: greyknight17 - helmikuu 03, 2009, 09:24:46 IP
Is this issue resolved now?

If not, please attach your /Sources/SplitTopics.php file here. What mods do you have installed?
Otsikko: Re: Split error
Kirjoitti: AlenNS - helmikuu 03, 2009, 09:59:43 IP
No, it is not resovled. I can split topics in admin board I have, but not on other.

http://www.simplemachines.org/community/index.php?topic=276575.msg1820316#msg1820316 (http://www.simplemachines.org/community/index.php?topic=276575.msg1820316#msg1820316)

Here's the Sources file.