Forum posting

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

My forum has some how not leting anyone post past .say page 11

it lets me post on my test site , but when i click on the return to forum topic
it says "NO NEW POSTS FOR THIS TOPIC"

So i reinstalled on 4 test sites and i cannot seem to fix this.

if you want to take a look at my test site to see my point let me know

montego · Posted: Thu Aug 30, 2007 5:45 am

<bump>

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

for more clarification on this problem which i think is a DateBase thingy

on one of our topics has 129 replies then no matter what you type it says
after the brief page you get
"no new replies for this topic" but if you refresh the topic page its there so why that unusual error ?

as said above i did it 4 times trying different methods with each still no dice. and yet nothing was changed in the database to cause the error none of the files either, i have another topic which has 200+ replies.
i got screens below so you can see better what i mean.

fkelly · Posted: Thu Aug 30, 2007 3:33 pm

You could be getting a database error. It's hard to tell because there is no built in error tracking or logging in Nuke. I'd start by taking a look at your server error logs for the time right when you post or try to. If nothing there then, if you have some facility with code you can try this. First create a file called dblog.txt in your root directory. Make it 777 permissions.

Now make a backup copy of /db/mysql.php.

Then edit /db/mysql.php to include the following:

Code:

   if($this->query_result)
   {
      unset($this->row[$this->query_result]);
      unset($this->rowset[$this->query_result]);
      return $this->query_result;
   }
   else
      {
$error = $this->sql_error($query);
   $fplog = fopen('dblog.txt','a');
            $logvar = date("F j, Y, g:i a") . ' ' ;
            $logvar .= $error['code'] . ' : ' . $error['message'] . "\n";
            $logvar .= 'SQL was: ' . $query . "\n";
            $logvar .= ' remote addr: ' . $_SERVER['REMOTE_ADDR'];
            fwrite($fplog, "$logvar" . "\n");
            fclose($fplog);

This goes in the sql_query function and I included the first few lines (starting with "if($this->query_result)" to show where. Save it and try the query again. Have your cpanel or whatever you need to look at files running on another window. Look at the dblog.txt and see if there are any SQL errors captured ... it may indicate something about what is going on with the Forums update.

When you are done, get rid of the dblog.txt file and put back the official version of mysql.php.

evaders99 · Posted: Thu Aug 30, 2007 4:30 pm

You may want to try a Resync on the forum, it could redo some of the numbers that phpBB uses for its topics tracking.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

tried the Resync already evaders99

fkelly did what you said my testing site goes to..white page

fkelly · Posted: Fri Aug 31, 2007 7:05 pm

Did you look at what's in dblog.txt afterwards? The problem is that in NUKE a SQL error can result in a blank page like you see but you have no record of what caused it. IF it is a SQL error the cause should be in dblog.txt.

You might also want to crank up error reporting in case there are any PHP type errors.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

thx ill try again ,

where would i crank the error reporting up which file ?

fkelly · Posted: Sat Sep 01, 2007 9:57 am

Look in rnconfig.php ... it is pretty well documented there. You also need to set $display_errors to TRUE in config.php, but that's documented also in the file. If this is your production environment you will want to reset the error settings when you are done.

If there have been any SQL errors they should be in your dblog.txt file already. Sometimes Nuke will generate other errors that aren't related to your Forum problem. So you may need to look at the file carefully.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

theres no errors showing with config set to true

did the edits with mysql.php and the dblog.txt nothing showing up about anything
no errors

maybe raven and the guys did too gooder job lol.

fkelly · Posted: Sat Sep 01, 2007 7:23 pm

I don't know. You could deliberately create a SQL error to make sure the dblog.txt and associated code is working properly and something is showing in the file. If the topic is not that important to you you could just get rid of it. You could dig into the database structure and try to trace what goes on between the Forums tables when a posting is done. You could dig into the Forums code and find the section that is used when you update your topic and you could put some echoes in there to trace down exactly what is going on. Or you could hire someone to do it for you. Those are the options I can think of but maybe someone else will have more.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

ill try and make some errors and see where i get digging through the forum tables
im in no rush as our other forum admins just make a new topic when they meet this error.
i`ll report back here when i find it.

thx for your help fkelly

montego · Posted: Sun Sep 02, 2007 8:54 am

bugsTHoR, just want you to double-check that you physically created the file that fkelly suggested and gave it permissions of at least 666 (read / write). Without those permissions it won't write anything... however, I would have expected PHP to throw an error if it could not write to the file, when you have display errors turned on in config.php.

fkelly · Posted: Sun Sep 02, 2007 12:30 pm

Yeah, M. that's what I was trying to say Smile

. I think the surest way to make sure you have dblog working is to create an error ... just bugger up one of the statements in mainfile, for instance, after saving the original so you can put it back. Then you should see the SQL error reported in dblog.txt.

Let's be more specific Fkelly. In mainfile go down to line 221 where it says:

Code:

$result = $db->sql_query('SELECT * FROM '.$prefix.'_config');

Now just copy this line and paste it back in on the preceding line to say:

Code:

$result = $db->sql_query('SELECT abcdefg FROM '.$prefix.'_config');

Leave the original in too so the reading your config values in doesn't get screwed up.

When the SELECT abcdefg gets executed you should get something like:

Quote:

September 2, 2007, 2:25 pm 1054 : Unknown column 'abcdefg' in 'field list'
SQL was: SELECT abcdefg FROM nuke_config

in your dblog.txt file. If you don't you have not followed the setup instructions properly.

When you are done remove that statement from mainfile.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

still nothing coming up i upload the the altered

/db/myslq.php
dblog.txt in the root directory, i have set it to 777

and made the edits in mainfile.php
config.php is set to show errors

here is my test site i`m trying these edits on
[edited]/index.php

trying the query again , is what you mean by this refresh the page ?

fkelly · Posted: Mon Sep 03, 2007 12:59 pm

I am seeing all sorts of errors on that page. Starting with:

Quote:

Notice: Undefined index: 1 in /xxx/xxxx/xxxx/xxxx-FLNN/test/bugstesting/themes/fisubice/theme.php on line 125

Notice: Undefined variable: showbanners in /xxx/xxxx/xxxx/xxxx-FLNN/test/bugstesting/themes/fisubice/theme.php(155) : eval()'d code on line 7

And going on and on. These would seem to me to indicate that something is not uploaded to the site correctly ... like the theme directory but I am seeing other errors as well that indicate that other files may not be where they should be.

After you do mainfile edit I suggested, whenever a page loads it will call on mainfile and repeat SQL you have created. So that should put an additional few lines into dblog.txt.

I am going to see if I can edit out the path you put in your post. It's not a good idea to post those here.

edit: no, I'm not seeing an option to edit your post. You might want to take that path out even though it's just a test site. Caution is always a good idea.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

i did it for you , i also reuploaded all the theme files

fkelly · Posted: Mon Sep 03, 2007 2:07 pm

The theme file upload seems to have gotten rid of most of the errors. Now all I get is "There is a problem right now on the Homepage. Please check back later.". Are you seeing anything in dblog.txt yet?

And researching that message a bit, that happens in index.php when your module path is not set correctly. There is still something wrong with the way your distribution is loaded I believe. Probably something else in FTP did not complete.

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

i deleted folders and re uploaded a new set thats all

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

is there any reason why your script would`nt show the error i followed them to the letter.

if that didnt work for what ever reason other than that, how much we talking about cost wise for one of you code wizards to fix it.

montego · Posted: Fri Sep 14, 2007 7:46 am

Any update on this issue?

Anyone else able to report the same?

It might be worth checking the phpBB forums too, but just don't tell them you are using Nuke... Wink

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

not sorted yet, was thinking the same.

going to check the database tables against a new install tables see if its something there. failing that i`ll delete a mountain of old post that none replied to maybe the problem is there somewhere when i`ve back up wrongly.
either way i`ll get back if i find a cure.

montego · Posted: Fri Sep 14, 2007 7:56 am

Yes, if you find something soon, please get back to us. It would be a great help. We are preparing a 2.2.0 release for RavenNuke and are pretty swamped. Would like to fix this too, but need your help to see if you can find the cause.

Thanks!

bugsTHoR · Involved Joined: Apr 05, 2006 Posts: 252

ok i think i found something ,

my
topic>topic-id>forum-id
bbposts- >post-id>topic-id > forum-id
bbpost-txt > post-id
bbforum > topic-id >cat-id

the numbers under the headers and sub headers dont match up, what appears in one is missing in another , what i mean is.

bbpost> post -id might have 1 -10000 where post or forum >topic-id is miss some numbers inbetween giving me 1-97890 and vice versa in all of them.

so what would help me , is a sql query that could find all tha same bbtopic` s > bbforum >bpost > bbposts-txt and make sure i have exactly the same in the subs >bbpost> bbpost-txt if that is possible , then i can delete the all posts-txt or what ever that has no topic coresponding to it. so they all match up again , it probably happend the last time i did a back up...me-bad.

i hope that all makes sense. taken me 4 days to get to this lol.

**i luv DB ..............not Embarassed

montego · Posted: Wed Sep 19, 2007 6:13 am

Evaders, you are probably the most experienced here with phpBB, are you able to decipher the above and help with resolution? I am lost... Sad