1 (edited by antonio 2012-07-05 17:47)

Topic: Cannot open the topic

A user on my webpage has created two same topics, the second one a 3 seconds later. The first one cannot be opened, when I click on the link, the following text is displayed:

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.

In database in topics table, fields first_post_id and last_post_id have set "0".


I assume the only way how to delete the topic from forum is via mysql database? But is it safe?

Re: Cannot open the topic

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

Re: Cannot open the topic

Thanks, I did it. Incidentally, I noticed that number of topics at right-bottom on index remained same.

Re: Cannot open the topic

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.

5

Re: Cannot open the topic

Enable debug mode for more details (see config.php)

6 (edited by jlap 2012-07-05 16:17)

Re: Cannot open the topic

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.

7

Re: Cannot open the topic

Enable debug mode in config.php:

define('FORUM_DEBUG', 1);
define('FORUM_SHOW_QUERIES', 1);

8 (edited by jlap 2012-07-06 17:14)

Re: Cannot open the topic

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

9

Re: Cannot open the topic

Try to reinstall pun_approval :-)

If any of my dropbox link fails with 404 error, change dl.dropbox.com/u/56038890/punbb/*.zip in address to 82283017.

Currently working on rPlus - responsive theme for developers to create their own themes basing on this one.

10 (edited by jlap 2012-07-05 20:35)

Re: Cannot open the topic

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 .... smile

11

Re: Cannot open the topic

DB MySql ?

12 (edited by jlap 2012-07-06 09:09)

Re: Cannot open the topic

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.

13 (edited by jlap 2012-07-06 12:48)

Re: Cannot open the topic

In viewtopic.php line 668

I simply deleted the following 2 lines

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

Now the code works.
Can open post, quick posts enabled.
I just don't know exactly what this hook is supposed to do.
And if there is a side effect (if my deleting is safe ??) ....

If anyone knows ??

ps: in the extension's XML file, I found
this for this hook:
    <!--Adds a warning to quickpost form which says that a post should be approved/moderated -->
Can someone confirm, it is only a warning ??

14 (edited by jlap 2012-07-06 16:49)

Re: Cannot open the topic

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.

Re: Cannot open the topic

No one ever answers here - I am dumping this BB - so annoyed already