Uutiset:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu
Advertisement:

Split error

Aloittaja AlenNS, lokakuu 28, 2008, 05:37:05 IP

« edellinen - seuraava »

AlenNS

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.

greyknight17

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?

AlenNS

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.

AlenNS

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.

greyknight17

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?

AlenNS

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.

H

Hi AlenNS, I'm going through some old topics.
Did you manage to fix this problem?
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

AlenNS


AlenNS


H

Which version of MySQL are you using? (You should be able to get this through cpanel)
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

AlenNS

Apache version   1.3.41 (Unix)
PHP version   5.2.5
MySQL version   5.0.51a-community
Architecture   i686
Operating system   Linux

AlenNS


greyknight17

Is this issue resolved now?

If not, please attach your /Sources/SplitTopics.php file here. What mods do you have installed?

AlenNS

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

Here's the Sources file.

Advertisement: