| User | Post |
|
11:43 am
21 Aug 2008
|
ovizii
Member
| | | |
|
| posts 114 |
|
|
I, as an admin, tried to move a topic. the javascript popup said: successfully moved, but below it was giving this error:
WordPress database 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 1]
DELETE FROM
And when I go to the forum where the topic was, I see: meaning its a topic, with no content, no author, no publishing date and -1 as comments  I fear I just lsot this topic.
|
|
|
11:45 am
21 Aug 2008
|
ovizii
Member
| | | |
|
| posts 114 |
|
|
ok, its not that bad. the topic got moved without its title, after editing the title of the new topic, the copy works fine, its just that Inow have this left over so I have to manually delete the old topic.is there any debugging I could do? I'd have to move some other topics as well..
|
|
|
|
|
(Please do not copy and paste from the browser - it never works and just screws up the display as it brings the underlying formatting with it).
I do not have a clue what this is about. The 'Move Topic' function RUNS absolutly no SQL DELETE queries. It does not make a copy. It simply changes the forum ID in the topic record. So… there is no 'old' topic to delete and if you went into the database and manually removed this 'topic' then you have left the forum index in a corrupted state. You should NEVER delete anything from the database (well unless we have discussed it first and advised you to!)
|
|
|
12:53 pm
21 Aug 2008
|
ovizii
Member
| | | |
|
| posts 114 |
|
|
well, all I did was click: move topic and in teh new popup I selected the new forum, clicked move, the page refreshed, saying topic moved, but on top of the page I saw the error I posted above.
I did no deleting in the DB but insted had a look into the old forum, and there the topic was still showing with its title but no info for author and posting date. if I clicked on its title it opened a totally empty topic, so I deleted it via the delete topic button of SF. I went into the forum where I had moved that topic to and there it was but missing the title. After I had reentered its title, all was well.
I will do a test topic now, then try and move it to see if I can duplicate the error.
|
|
|
1:19 pm
21 Aug 2008
|
ovizii
Member
| | | |
|
| posts 114 |
|
|
|
|
|
Ah this helped a lot.
The error is a different one to expected. You were NOT performing a 'Move Topic' operation. You WERE performing a 'Move POST' operation. Hence my statements above. I can already see that it is a two fold problem.
- You specified the forum but did NOT give it a new topic name. You can only, currently, move a post to a new topic. Now it should have stopped and told you that it needed a topic name and can't see immediately why it did not but that is something I can investigate and fix. But tis explains the unamed topic.
- There is a piece of malformed SQL I can see that is ONLY called if the post being moved is the only post in a topic. Which your was. Under thos circumstances (single post only) the old topic is, of course, deleted. That failure caused the error message and was also the reason the old topic dd not actually vanish.
All is now clear and will be fixed. And apoliogies for that. And the screencast was a great idea.
|
|
|
7:42 am
22 Aug 2008
|
ovizii
Member
| | | |
|
| posts 114 |
|
|
 thx, you are very helpful as always. I just thought it might be really hard for me to explain my problem in words, so I downloaded a screencast software and uploaded the screencast to that free service.
I am glad you now “saw” the problem for yourself. I understand my error, as I was trying to move a post, but what I actually wanted to do was move the whole topic into another forum as the one it was posted in was a private one and the topic was actually for public.
I guess I have to go look for another button called “move topic” 
|
|
|
|
|
Same tool but on the topic listing (i.e., forum view). 'Move Topic'!
|
|
This forum is currently locked - access is read only
Forums
