UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration Finished-[6.5.1] Integrated Index Page (IIP) 6.5

ehm throw this into your sql query zone either in the control panel or is you use phpMyAdmin in that and see what it goves you

SELECT U_Username,U_LastSeen,U_Number,U_Visible
FROM w3t_Users
WHERE U_LastSeen <> U_Registered
AND U_LastSeen IS NOT NULL
AND U_Number > 1
ORDER BY U_LastSeen DESC
LIMIT 10

and

SELECT U_Username,U_Laston,U_Number,U_Visible
FROM w3t_Users
WHERE U_Laston <> U_Registered
AND U_Laston IS NOT NULL
AND U_Number > 1
ORDER BY U_Laston DESC
LIMIT 10

also in your configpal.inc.php tell me what value is in

$configpal[moreSeen]
$configpal[lastonDisplayNum]
$configpal[modifiedlastseen]

I finally found out where the problem was coming from.
The problem is with [:"red"]newspal.php[/].
When I set-up IIP to pull news from more than 1 board on my forum, I get "Internal Server Error" error on the entrance page (index.php). If it is set-up to pull new from only 1 board the entrance page works fine.

really? works fine for me.. wonder what it could be

I've identified the real source of the problem with newspal.php. It can only read from the first board on my forum (to be specific, the first board in w3t_Boards). Any attempt to pull articles from the remaining boards (2 to 11) leads to "Internal Server Error".

Just to remember:

#120884 - 10/05/04 10:39 AM
Minor Bug:

IIP control panel, index file options, at the bottom:

Should we cache the Short Status information to decrease page generation times?
If so, how many minutes should lapse before updating? (0 disables)

if you enter a numeric value in the box and save it the value is disapered next time enter this page.


scroungr
Re: Finished-[6.5] Integrated Index Page (IIP) 6.5 [Re: Zarzal]
#120893 - 10/05/04 02:42 PM

okay will check when I get some time

Sorry took so long to repond. I had some problems with my server...
Ok. for the 2 queries:

The first query returns nothing. Blank
The second query returns the last then users.

$configpal[moreSeen] = "";
$configpal[lastonDisplayNum] = "10";
$configpal[modifiedlastseen] = "";

Hope it will help.

Hmm on the IIP User Management Tab did you


Use enhanced who's online tracking?
Before using this option you must follow THESE setup instructions or this WILL NOT WORK CORRECTLY!

and click on the the word THESE?

No. I'm not using Enhaced who's online tracking.
Should I?
I clicked on the "THESE" link and received a message "You need to run the "Modify My Database" link in initial setup before using this step."

well I would

OK. I changed modes and still doing the very same thing...
It's not moving to the next 10 users...
Any other ideas to try?

Thank you

rerun the query

SELECT U_Username,U_LastSeen,U_Number,U_Visible
FROM w3t_Users
WHERE U_LastSeen <> U_Registered
AND U_LastSeen IS NOT NULL
AND U_Number > 1
ORDER BY U_LastSeen DESC
LIMIT 10

then wait a bit and run it again and see if that query changes the values that you see. that is the key query

I run that query 3 times in 15 minutes.
It always return blank.
And if you have a minute, check my page at Entrance:
http://www.imigrar.com/forum/index.php?Cat=0
the Last 10 now are complete empty (since I changed the mode).
It's in Portugues, but please look for the words "Passaram por aqui", in the central column, just below a "Sponsored by" banner.

Do you want me to change back the mode?

I see

Online 1 member (Threadsdev) and 10 guests have been online with in the last 10 minutes.

ok send me a PM

okay think I found the isue with Last seen I have updated the main zip but

find in lastseenpal.php

$thisinstant = $html -> get_date();
$lastonlimit;
$lastonstart = $configpal[moreSeen] + 0;
$lastonend = $configpal[lastonDisplayNum];
$moreSeen = $configpal[moreSeen] + $configpal[lastonDisplayNum];
$date = $thisinstant;


change to

$thisinstant = $html -> get_date();
$lastonlimit;
$lastonstart = $moreSeen + 0;
$lastonend = $configpal[lastonDisplayNum];
$moreSeen = $moreSeen + $configpal[lastonDisplayNum];
$date = $thisinstant;

there must be another bug.
The initial setup told me while trying to modify the database:

IIP 6.5 modifications already exists. Nothing more to be done here...

If I try to run .../ubbthreads/pals/lastseensetup.php I get :

You need to run the "Modify My Database" link in initial setup before using this step.

Set Use enhanced who's online tracking? to yes give me a empty pal box.

I use IIP very long time so my database modification is from a old version. What should I do ?

yeah looking into why the U_LastSeen field doesn't populate. For now set enhanced to no and should be okay.

Problem with exploitfix:

There is an inofficial exploitfix on www.infopop.com for the file ubb.inc.php



If you apply this, the newspal.php have a malfunction. You are no longer able to click links. the $cat seems to bee empty and this result in a broken link with ...//... and a missing cat number.

have you tried the non spider friendly newspal?

no, but thats a good tip I go and will try it.

/edit: ok, this help. I try it. But if Infopop include this exploitfix you should watch it for spiderfrindly. So I use unfriendly and the fix works. Thanks again for the tip.

np. I will take a look at the spider friendly

I have been testing my "Recommend Us!" at its all working fine.

How would I be able to BCC me on every mail that is sent? I only want this to be noisey

guess you could write something up for that.

I had a go, but it stopped working altogether

After banging my head against the wall trying to get just PHP, MySQL, and Threads installed, I finally got it.

I attempted to install IIP, but I ended up with this mess:

http://aow.rpg.st

Now, you can see, my threads install works...

http://aow.rpg.st/ubbthreads/ubbthreads.php

Can anyone guide me here? I feel so stupid at this point. There has to be an easier way...

~Eric C.

check your path settings

Failed opening '/ubbthreads/includes/main.inc.php' for inclusion (include_path='.;c:\php4\pear')

means its looking in c:\php4\pear for the /ubbthreads/includes/main.inc.php

Thanks for the reply.

I checked my include_path in my php.ini, and it's commented out. I tried to change it to:

include_path = ".;c:\php\includes;c:\inetpub\wwwroot\aowroot"

But that just changes the error message to:

'/ubbthreads/includes/main.inc.php' for inclusion (include_path='.;c:\php\includes;c:\inetpub\wwwroot\aowroot')

Now, the root of that website is c:\inetpub\wwwroot\aowroot

Threads is in c:\inetpub\wwwroot\aowroot\ubbthreads

The IIP index.php is in the aowroot folder.

What should my include_path be?

~Eric C.

c:\inetpub\wwwroot\aowroot\ubbthreads\includes\main.inc.php

Thank you again for your reply, scroungr.

Well, I gave that a try, and that didn't work either. Now the error looks like this:

[:"purple"]PHP Notice: Undefined variable: Cat in C:\Inetpub\wwwroot\aowroot\index.php on line 66 PHP Warning: main(/ubbthreads/includes/main.inc.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\aowroot\index.php on line 70 PHP Warning: main(): Failed opening '/ubbthreads/includes/main.inc.php' for inclusion (include_path='.;c:\php\includes;c:\inetpub\wwwroot\aowroot;c:\inetpub\wwwroot\aowroot\ubbthreads\includes\main.inc.php') in C:\Inetpub\wwwroot\aowroot\index.php on line 70 PHP Notice: Undefined variable: myprefs in C:\Inetpub\wwwroot\aowroot\index.php on line 71 PHP Warning: main(/ubbthreads/pals/languages//genericpal.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\aowroot\index.php on line 71 PHP Warning: main(): Failed opening '/ubbthreads/pals/languages//genericpal.php' for inclusion (include_path='.;c:\php\includes;c:\inetpub\wwwroot\aowroot;c:\inetpub\wwwroot\aowroot\ubbthreads\includes\main.inc.php') in C:\Inetpub\wwwroot\aowroot\index.php on line 71 PHP Fatal error: Cannot instantiate non-existent class: user in C:\Inetpub\wwwroot\aowroot\index.php on line 75[/]

I'm no expert at this by any means, but I see a couple of potential things in this error. I looked at the index.php, and it's referring to the variable $thispath from the main.inc.php

Here are the contents of my main.inc.php:

[:"purple"]<?

// THIS NEEDS TO BE SET, OTHERWISE ADMIN SCRIPTS WILL NOT WORK
// THIS IS THE ACTUAL PATH TO YOUR PHP INSTALLATION
$thispath = "c:\inetpub\wwwroot\aowroot\ubbthreads";

// PATH TO YOUR config.inc.php file. BY DEFAULT THIS IS THE
// SAME AS , BUT IF YOU MOVE config.inc.php TO ANY
// OTHER LOCATION YOU MUST SPECIFY IT HERE.
$configdir = "c:\inetpub\wwwroot\aowroot\ubbthreads\includes";

// DO NOT EDIT ANYTHING BELOW THIS LINE!
include("$thispath/ubbt.inc.php");

// Page load times
$timea = getmicrotime();

?> [/]

The other thing that I'm wondering about is this: If something is wrong with the include_path, why does threads work? After all, it's only the IIP that I can't use...

Thanks again for your help.

~Eric

I dont have a windows server for testing but I rember that I read someting about / and \ in the config files. You use c:\... whats about using unix like /wwwroot/aowroot/... and not filesystem like windows paths.

in the index php you need to set

// WHAT IS THE FULL PATH TO YOUR UBB.threads INSTALLATION (do not include the trailing slash)
$palspath = "";

to

// WHAT IS THE FULL PATH TO YOUR UBB.threads INSTALLATION (do not include the trailing slash)
$palspath = "c:/inetpub/wwwroot/aowroot/ubbthreads";


now create some forums... and good luck

Thank you. Thank you. Thank you!

~Eric

Is this confirmed to work under UBB.Threads 6.5.1 final yet?

works for me at www.cccbmt.org

oops, I'm still running iip 5.5

nope and since I haven't upgraded to 6.5.1 I will need input from others...

I run it on www.dragon-clan.de without bigger problem. I use everywhere non-spider url's. There are some litte problems allready described here in this thread but nothing real big.

I have 2 major problems, but this is not based on UBBt 6.5.1 (I noticed this before).

1) The cache timer doesnt work well. I set it to cache news for 10 minutes but it took time between 30 and 60 minutes, so I disable caching.

2) Setup 4 different newspals with 5 news each. Enable HTML, Names, Avatars and Date will sometimes crash the page generation by mysql (timed out or something else) I get an 503 error from my server. I change the newssetup as follows: Box 1 with name, avatar, date and HTML. All other boxes set to no pictures, no name, date and HTML. If I try to strip html too I get 503 again. Seems to much queries or so.

General I say, you can use it with 6.5.1

Remeber to fix the little bugs in the control panel

Ok just updated a 6.5 instalation to 6.5.1.
I'm using the IIP 6.5.1 from this thread

now threads that show up in "current threads" report
"We cannot proceed.
There was a problem looking up the post in our database.
Please use your back button to return to the previous page."
when they are selected.

also in "top posters" when I click on any name (including the one I'm logged in with) I get "We cannot proceed.
This user is no longer in our database.

Please use your back button to return to the previous page."

also now when a user chooses to select the Entrance as a starting point it throws up reporting:

[] We cannot proceed.

Script: /var/www/html/ubbthreads/pals/pollpal.php
Line#: 85
SQL Error: You have an error in your SQL syntax near ') AND B_Poll != '' AND (B_Sticky = 0 OR B_Sticky IS NULL) ORDER ' at line 6
SQL Error #: 1064
Query: SELECT B_Poll,B_Replies,B_Number,B_Board,B_Posted, B_Subject FROM w3t_Posts WHERE B_Number = B_Main AND B_Approved = 'yes' AND () AND B_Poll != '' AND (B_Sticky = 0 OR B_Sticky IS NULL) ORDER BY B_Posted DESC LIMIT 0,1



[/]

Owen93, be sure to take the files from the spiderUNfriendly directrory. If you take a closer look to your URL's you see that something behind cat is missing and you have two following // in it.

Using the files from this directory should solve it.

ETA -

Ok I found the "Unspiderfriendly" dir
I'll poke around and see if I can deduce where these file might go ?