UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Problem after server move

UBB Error
There was a problem looking up this post in our database.

---

The topics are there but when clicked on the above message appears.

I can create new topics, reply to new topics and post in the shout box.

Any ideas please?

Well, we need the error... If you enable sql error logging in the control panel and can recreate the error then it'll be copied to the file you specify (in the cp).

You could also disable the generic error message by editing /libs/mysql.inc.php and looking for the $show_error line and setting it to a 0, but I'd recommend changing it back to a 1 when done as it can have security implications when left on.

I will report back Giz, thanks.

The only error displayed is the one I posted above. I have gone to View SQL errors and it just says log underneath with no errors displayed.

Where do I enable logging please? I will keep looking incase I find it before someone answers

Found it, do I just create a directory and add to that path/destination option?

What should the chmod of the directory be?

It's set at 777?

Test says it's writable.

Have browsed the site and get the error message the same as in my first post above but nothing is listing under the SQL errors log

Edited the file you suggested and it was already set to 0 so I have changed to 1.

If I click on a profile that works.

I can browse all forums.

But when I click on a subject, the error is displayed

That error is basically saying it just can't find the post. What you need to do is look at your ubbt_POSTS table and make sure that it's populated. You can go into the control panel and then the DB Info link and it will show how many rows are in that table.

Which option is it Rick, can't find it?

Sorry, Database Tools. Lower portion of the left menu in the control panel. You'll see all tables listed, and one of the columns shows the total # of rows in each table.

Everything is working now, kind of. We uploaded the database again. However there is one topic that when clicked gives the same error. Is there any way I remove the title of the topic from the forum?

You'll need either the topic id or the post id that is being linked to. Depending on which you have, you can use one of the queries below, replacing 'topic_id' or 'post_id' with the number you have.


or


If you want to verify it's the right topic before deleting, you can change the query to:


or