[Paul M]

Sorry but that sql [for newposts] is simply not this hack - I would guess it's a hack to show a member the number of new posts since they last visited. It might help if you posted the whole message - since it should show has the script that called it.

As for dateline - that's a column in a table, not a table. You could probably recreate it with

ALTER TABLE post ADD dateline INT UNSIGNED NOT NULL DEFAULT '0'

But that won't recover the data it - all you posts would have a date of Jan1st 1970, and I doubt threads would show correctly. Don't you have a BACKUP ?

Oh, I have to go to bed now so I won't see any reply for a few hours.