UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration Integrated Index Page (IIP) 5.3.1

Install tip for 5.3 - make sure your Pals directory is writable or else the config file won't be created.

Also, question.

I set this up here:
http://199.231.148.190/ubbthreads/index.php?Cat=

The shoutbox doesn't work. The board is created and an entry gets made in the Posts table..... but the body and subject is blank.

Are you using "force public"? Perhaps removing a box or two that are not that important to you for your index or just increasing their cache times so they are not updated as often would help. You may also want to exclude some public boards if you are using "force public" to limit the amount of data that's accessed to speed things up as well.

hmmmm... I'll take a look around and see what I can figure out.

Josh is there a way I can see the configure panel for that? I think I know what the problem is but need to see the settings for shoutbox. Thanks.

Sent ya a PM.

I must have missed shoutboxadd/shoutboxdel.php when adding the work-around for register globals being off. I'll update them and upload the zip in the morn.

This should fix that problem.

Thanks!

I may sleep in late... lol

So I updated the IIP 5.3 zip in the main post of this thread to include the modified shoutdisplaypal/shoutaddpal/shoutdelpal.php scripts.

Just download the zip and upload those 3 files and you should be good to go. I also switched off anonymous shoutbox use while testing at your site. You may want to turn that back on.

It works fine.
Thank for your great job....

Junhyok

You da man Dave!

I'm confuzzled about this one.

When I'm at editconfigpal.php and I click on the Update button at the bottom, I get the following SQL errors:

Warning: fopen("/home/drumlin/public_html/threads/pals/configpal.php", "w") - Permission denied in /drumlin/public_html/threads/pals/doeditconfigpal.php on line 750

Warning: fwrite(): supplied argument is not a valid File-Handle resource in /drumlin/public_html/threads/pals/doeditconfigpal.php on line 751

Warning: fclose(): supplied argument is not a valid File-Handle resource in /drumlin/public_html/threads/pals/doeditconfigpal.php on line 752

Warning: Cannot add header information - headers already sent by (output started at /drumlin/public_html/threads/pals/doeditconfigpal.php:750) in /drumlin/public_html/threads/pals/doeditconfigpal.php on line 755

I don't have a file called configpal.php

I fixed it. I CHMODED the pals directory to 777. Did I miss this in the directions somewhere? And should I keep it 777?

It used to be in the instructions. I took it out when I had it automatically check to see if it was writable. But now that there is no configpal.php script in the package I can't check it to see if it's writable untill it's created or something. Perhaps chmod'n the pals directory during setup would suffice. Do keep it set to world readable/writable so it can be edited when needed.

Just went from 5.2 -> 5.3
Everything seemingly works fine...except IE reports an error:

Line: 73
Char: 48
Error: Unterminated string constant
Code: 0

Is there a way to have 2 occurances of the IIP? I would like to use one as the Home page with News pulled from the fourms and general information, then another copy as a Forum index with all the Birthdays, Top... and other options.

If IE is reporting an error it's probably javascript related. There was nothing done to the javascript in this update so check and see if there are other javascripts or other html that may be causing a problem.

I haven't done this so I don't know off hand. I believe canvey has done something like this though.

Thanks for the update, had to do a bit of changing in my pal boxes, to display my images, but I like much better. Thanks for the work.

I figured out what was happening to my ENTRANCE link and linking problems in MENUPAL.PHP. I can't help thinking that others must have had or will have the same problem....

The ENTRANCE link code that has to be added to ubbt_registered.tmpl ( <a href = "{$config['homeurl']}/index.php?Cat=$Cat">Entance</a> ) is grabbing the homeurl from the $config['homeurl'] of Threads' config.inc.php (as you pointed out to me before, Dave). The trouble with that is that (in my case, anyway), I placed the URL of my site rather than the specific Threads installation URL in that field. So when the "Entrance" is clicked, it goes to a non-existent index.php. Another subsequent problem arises in the MENUPAL.PHP in that a few links (like the Profile Index) use that same $config['homeurl'], so they also didn't work in my case.


ALSO (unrelated):

in profilepal.php, lines 320 and 435 say:

FROM w3t_Users

...but I use a different table prefix, so it can't find that table and produces an error.

Should it include $config['tbprefix'] = "XXX"; in there somewhere??



Anyway I'm all fixed-up and going now! Thanks for all your hard work Dave. I appreciate it.

Oops... that w3t_ should have been replaced with {$config['tbprefix']} to work with .threads 6.0 and newer. Not sure how I missed that. I did a global replace on them at one time...

I'll update the zip after this post. Thanks.

*bump*

Updated IIP's zip to include the new profilepal.php script to fix the hard coded "w3t_" table extentions being used.

Help.I tried upgrading and this is what I am getting.I have no admin acces now either


Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\wwwroot\ubbthreads\mysql.inc.php on line 38
SQL ERROR: Database error only visible to forum administrators

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 45

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 104
SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 130

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 104
SQL ERROR: Database error only visible to forum administrators

I followed the directions (pretty simple)

IIP shouldn't have affected your forums in that manor. I upgraded from 5.2 to 5.3 here at threadsdev in a few minutes with no problems. What version did you upgrade from? Did you run the modify database script? What did it say?

OK I have restored my data base and tried again and this is what I get when I use "Modify MY Database"

Creating IIP 5.3 cache table.
SQL ERROR: Unable to do_query: CREATE TABLE w3t_IIPcache( Ca_Number INT(4) UNSIGNED DEFAULT '0' AUTO_INCREMENT PRIMARY KEY, Ca_TimeStamp INT(9) UNSIGNED, Ca_Version varchar(9) NULL, Ca_TopPosters text, Ca_TopThreads text, Ca_CurrentThreads text, Ca_ShortStats text, Ca_HotTopic text, Ca_LastSeen text, Ca_LastSeen2 text, Ca_TopRatedPosts text, Ca_News text, Ca_PastThreads text, Ca_RandomProfile text, Ca_CurrentPollName text, Ca_CurrentPollVote text, Ca_CurrentPollResult text, Ca_CustomB1 text, Ca_CustomB2 text, Ca_CustomB3 text )
Table 'w3t_iipcache' already existsCache table created

Any help will be greatly appreciated.I am panicking here

What version are you upgrading from?

Are you on a IIS server by chance?

sorry for the Spamination..I was panicking. I have it up and working now but I am seeing this error

SQL ERROR: Unable to do_query: SELECT Ca_TimeStamp,Ca_ShortStats,Ca_TopPosters,Ca_LastSeen,Ca_LastSeen2,Ca_RandomProfile,Ca_TopThreads,Ca_CurrentThreads,Ca_HotTopic,Ca_TopRatedPosts,Ca_News,Ca_PastThreads,Ca_CustomB1,Ca_CustomB2,Ca_CustomB3,Ca_CurrentPollName,Ca_CurrentPollVote,Ca_CurrentPollResult FROM w3t_IIPcache WHERE Ca_Number = 1
Unknown column 'Ca_LastSeen2' in 'field list'
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 130

IIS server by chance?

Warning: Can't connect to MySQL server on 'localhost' (10061) in c:\wwwroot\ubbthreads\mysql.inc.php on line 38
SQL ERROR: Database error only visible to forum administrators

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 45

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 104
SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 130

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\wwwroot\ubbthreads\mysql.inc.php on line 104
SQL ERROR: Database error only visible to forum administrators

With that error sounds like you need to clear your cookies and relog into Threads.

I upgraded UBBThreads from 6.1.2 to 6.2.It looked ok after the upgrade. I then upgraded IIP from 5.1 to 5.3

I am using Apache

And Chuck you were right about the first errors

Are you hosted on a windows server?

Yes Dave Win XP Pro

Why I asked was that this line:

Table 'w3t_iipcache' already existsCache table created


has w3t_IIPcache in all lower case. I thought that perhaps that was why it didn't see that the cache table was already installed.


Strange...

I actually just downloaded IIP about 30 minutes ago.I assume the link at the beginning of the thread is the most current?

Yes it is.

What I don't understand is that IIP failed to see that the cache table was already installed so it tried to install it again but of course failed because it already existed. I will be adding the check for lower case letters as well. Usually the lower case letters come from MySQL on a IIS server during backup/dumps of the database. When moved to a unix server the lower case table names don't match the upper case ones.

should I restore the DB and try again? Im a bit of a novice.I didnt run the "Initial Setup" the first time around when I first clicked "Update IIP 5.3 Settings" Could that have done it?

In the initial setup is the link to modify your database. I can't seem to see how it didn't recognize that you already had a cache table and that it should have upgraded 5.1 cache to 5.3 cache. It instead tried to install the cache table as if the old one didn't exist.

what about deleting the cache table and trying to install again? Also if you scroll down to the bottom of my index page you will see a big mess.Shoul I leave my forums opened or closed at this time?

That should work but I still would like to know why it didn't see that the table already existed so I can keep it from happening again.

Sorry you will have to tell me how to delete it.I dont know a whole hoot about SQL management