|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
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. 
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
hmmmm... I'll take a look around and see what I can figure out. 
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Sent ya a PM. 
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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. 
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Thanks! 
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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. 
|
|
|
|
Joined: Oct 2000
Posts: 53
Junior Member
|
Junior Member
Joined: Oct 2000
Posts: 53 |
It works fine. Thank for your great job.... Junhyok
Last edited by junhyok; 01/18/2003 1:59 AM.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
You da man Dave! 
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
Addict
Joined: Aug 2000
Posts: 1,609 |
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
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
Addict
Joined: Aug 2000
Posts: 1,609 |
I fixed it. I CHMODED the pals directory to 777. Did I miss this in the directions somewhere? And should I keep it 777?
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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. 
|
|
|
|
Joined: Aug 2002
Posts: 109
Journeyman
|
Journeyman
Joined: Aug 2002
Posts: 109 |
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
|
|
|
|
Joined: Oct 2002
Posts: 165
Member
|
Member
Joined: Oct 2002
Posts: 165 |
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.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
I haven't done this so I don't know off hand. I believe canvey has done something like this though.
|
|
|
|
Joined: Oct 2002
Posts: 108
Journeyman
|
Journeyman
Joined: Oct 2002
Posts: 108 |
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.
|
|
|
|
Joined: Sep 2000
Posts: 49
Power User
|
Power User
Joined: Sep 2000
Posts: 49 |
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.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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. 
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
*bump*
Updated IIP's zip to include the new profilepal.php script to fix the hard coded "w3t_" table extentions being used.
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
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)
Last edited by ChAoS; 01/19/2003 9:24 PM.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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?
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
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
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
What version are you upgrading from?
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
Are you on a IIS server by chance?
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
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
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
Member
Joined: Apr 2001
Posts: 3,266 |
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.
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
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
Last edited by ChAoS; 01/19/2003 10:10 PM.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
Are you hosted on a windows server?
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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...
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
I actually just downloaded IIP about 30 minutes ago.I assume the link at the beginning of the thread is the most current?
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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.
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
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?
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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. 
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
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?
Last edited by ChAoS; 01/19/2003 10:38 PM.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
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. 
|
|
|
|
Joined: Nov 2002
Posts: 554
Code Monkey
|
Code Monkey
Joined: Nov 2002
Posts: 554 |
Sorry you will have to tell me how to delete it.I dont know a whole hoot about SQL management
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
|
Most Online6,139 Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|