Cannot open the topic

Yes, if you can not delete topic by admin interface - delete topic from DB.
if unsure - make backup.

So we didn't create double topics but we are unable to get into any of our forum's (http://tymkrs.com/forum) topics.  We get the same error as what antonio did:

"Sorry! The page cannot be loaded" etcetc.

What can we do to get rid of this problem?  I'd forever thank whoever helped me rescue our forums.

Same problem on my forum:
a migration from 1.2 to 1.4.2

I cannot open a topic when logged in, BUT i can open and see the messages when logged out.

I can open the 'topic list' page but not the 'post page'.
When logged out BOTH can be opened.

The error message is
'Sorry! The page could not be loaded.

This is probably a temporary error. Just refresh the page and retry. If problem continues, please check back in 5-10 minutes.
'

DB is up to date.
/cache 777
/extensions 777

Any help appreciated.
Thx.

Sorry!!

Now it talks a little bit more!

Sorry! The page could not be loaded.

This is probably a temporary error. Just refresh the page and retry. If problem continues, please check back in 5-10 minutes.

Database reported: Unknown column 'post_approval' in 'field list' (Errno: 1054).

Failed query: SELECT post_approval FROM calc_topics as t, forums as f WHERE t.id=161 AND f.id=t.forum_id

The error occurred on line 16 in /xxxxx/yyyyy/www/forum/viewtopic.php(668) : eval()'d code

I re installed the extension.

Post and registration approval 1.5.1

Same behavior : can't open post when logged in BUT it works IF Extension disabled !!

The problem will be (I hope) easier to solve tomorrow morning ....

Yes MySQL Standard 5.0.90.

I have made progresses.

Problem @ line 668 in viewtopic.php

ONLY when logged in!!!

That's a clue.
Line 668 is where the 'quickpost'  option is evaluated (only to users not guests).
If I disable the option in
Setting/Features/'Topic and post features and information' all seem to work correctly (user or guest).

Any help to correct this (with quickposts enabled) appreciated.

Thx in advance.

Hi all,

The same problem exists on my 2 installations (on line and local).
Here are more data for developers, maybe they can help.

It seems that column post_approval is missing in table 'topics' in both installations.
But this column does exist in table 'forums'.

That explains why deleting the 2 lines

<?php ($hook = get_hook('vt_quickpost_pre_fieldset_end')) ? eval($hook) : null; ?>
        </fieldset>

in file viewtopic.php line 668, corrected the problem.

Now searching in pun_approval's manifest.xml file, I found this in the installation part:
around line 292

.../...
if (!$forum_db->field_exists('forums', 'post_approval'))
            $forum_db->add_field('forums', 'post_approval', 'INT(3)', false, '1');

        if (!$forum_db->field_exists('groups', 'g_without_approval'))
            $forum_db->add_field('groups', 'g_without_approval', 'INT(3)', false, '0');

        if (!$forum_db->field_exists('groups','g_allow_post_approval'))
            $forum_db->add_field('groups','g_allow_post_approval','INT(3)', false, '0');

        if(!$forum_db->field_exists('groups','g_allow_reg_approval'))
            $forum_db->add_field('groups','g_allow_reg_approval','INT(3)',false,'0');

.../...

So it appears the field 'post_approval' is added to forums but never to 'topics'.
This field is in fact missing in my 2 databases in table 'topics'.

Could any one in the development team be kind to confirm or infirm this diagnosis.

Cheers.