I'm not at a computer where I can access the files, but I just noticed that all the posts written before I converted have "Last edited by <blank> on <1969-... >" which is why even silent edits are just being updated with blank (or real values if the mark is removed from the Silent Edit option.

So the error isn't in the silent editing but in the fact that posts that weren't edited (but simply posted one time only) got the last edited by value set during the conversion. I'm thinking the fix would then be to update the database somehow. Does this make sense?

As far as I know, I haven't. I've added some mods, followed instructions carefully, etc. All I (think) I did was move to a new web host, who had version 5 of PHP/mySQL instead of the version 4 the old host had. Now that has caused a number of problems that are all fixed now.

Silent Edit used to not write anything at all to the post. If there was an edit before, it would leave the line alone, if there was no edited by before it would not add one.

As far as I know, I haven't. It shows an empty timestamp and editor name because the checkmark for Silent Edit is on, if I uncheck it, it is stamped "Last edited by <myuserid> at <current timestamp>"

When the Silent edit box is ticked, it suddenly shows:

Last edited by (1969-12-31 17:00:00)

instead of showing nothing, as before. Any ideas?

Email sent to smartys@punBB.org. Thank you!

Let me know if you didn't receive it... thx

As the forum is password protected, I've sent the link to Smartys by email. Thanks

thanks! that plug-in was exactly what I was looking for. Now I have a new problem. I've run the cleanup and now all my topics have the correct counts, last poster, etc. But they don't display on the viewforum.php page. I can see the correct fields in the db, and when I run in debug mode, cut and paste the query into, say, phpMyAdmin and run the query manually, the fields are returned. But suddenly they don't display. There are just blank table cells where the totals are supposed to be. Any ideas?

Thanks. Where do I access the Update Forum function?

After a restore, I have lost the information for several forums and topics - the number of topics, last posted, etc. and for topics, the number of replies, etc. Is there a way to recreate this easily? thanks in advance

Thanks Smartys. Weirdly, the database property was exactly like that. But still the code didn't work. I found that I actually needed to test for both 0 and NULL because all new topics were being assigned the NULL. I even performed a manual update on all rows to FORCE the 0 to NULL but it still didn't work. I find that very bizarre. So now, I have code saying "where = 0 OR IS NULL" and now it all works. I don't like it, but I couldn't think of anything else to do!

Answering my own post:

A global change in viewtopic.php from " t.moved_to IS NULL " to " t.moved_to = 0 " solved the problem

I am currently battling with this exact problem. Does anyone have the solution? My new db (after host change) does indeed show 0 instead of NULL.

Solved the problem. Somehow, I had deleted the Guest user. Restoring that solved the problem. :-)

I have the same problem, tried the solution but it didn't help. I cleared cache, cookies, etc. Strangely, this worked fine until all of a sudden it didn't. All I did was play with the css files. Troubleshooting, I restored the changed files to the originals. But I still can't get in. My login is accepted, but after redirect it says "you are not logged in". I was just about to go live with the forum, so I am in pretty urgent need of some good advice! Thanks in advance.

PS: On Mac OSX, using Safari, Firefox and Flock