| Author |
Message |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sat Nov 22, 2003 8:32 pm |
|
I apoolgize if this in the wrong area. I just installed this messenger software called Buddy Block and was wondering if anyone else is using it. I put all the files in the right area according to the instruction. However, i am getting a error. The error can be seen on my site Messenger is on the bottom right.
Id appreciate any help
Thanks
Joe |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sat Nov 22, 2003 10:22 pm |
|
What is the file that it can't locate on line 32? That's what's missing. |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sat Nov 22, 2003 10:32 pm |
|
The file, i believe is:
functions.php
Dont see it any where in the directory
Joe |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sat Nov 22, 2003 10:35 pm |
|
That is in the includes directory so it seems as if that file that is calling functions.php either needs to be prefaced with includes/funtions.php or the file that is calling it needs to be in the includes directory. |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sat Nov 22, 2003 10:40 pm |
|
well i copied a copy of function from the includes directory /httpdocs/forums/modules/Private_Messages and that error seems to have cleared up. There were 2 others to do with sql:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/forums/BlockMessenger.php on line 196
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/forums/BlockMessenger.php on line 198
Joe |
|
|
 |
 |
CodyG Life Cycles Becoming CPU Cycles

Joined: Jan 02, 2003 Posts: 668 Location: Vancouver Island
|
Posted:
Sun Nov 23, 2003 12:10 am |
|
Did you install the db tables for this block? Did you deactivate the block? Did you ever get it working? I can't find errors... btw, your site is looking way better. |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 6:33 am |
|
i found no database tables for this program to import. All there is is a couple .php files and a couple images
Joe |
|
|
 |
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 7:10 am |
|
I viewedBlockMessenger.php and looked for line 196. Its the 6th line below. There is a mysql error that appears in messenger on my site.
Joe
echo "<body onload=setInterval('self.location.reload()',$refreshtime) bgcolor=$bgcolor1 text=$textcolor1 link=$textcolor1 alink=\"$textcolor1\" vlink=$textcolor1 topmargin=\"0\" marginheight=\"0\">";
echo "<font size=\"1\" face=\"Arial, Helvetica, sans-serif\">"._ENLIGNE.":</font><br>";
$sql = mysql_query("SELECT username FROM $prefix"._session." where guest=0");
$member_online_num = mysql_num_rows($sql);
$i = 1;
while ($session = mysql_fetch_array($sql)) {
Also, when you click on "members" in the Messenger screen, you get the following errors:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/forums/BlockMessenger.php on line 283
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/forums/BlockMessenger.php on line 285 |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sun Nov 23, 2003 11:09 am |
|
Need to see lines 283 and 285. |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 11:28 am |
|
Hi Raven:
I managed to find a updated version of this thats installed on my sustem now. (Messenger)
Theres only one error on this version that pops up when you click on your name:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/forums/includes/sql_layer.php on line 342
I believe this is line 342: $row = mysql_fetch_array($res);
Joe |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sun Nov 23, 2003 11:34 am |
|
You need to turn sql_debug on to see the offending sql. That line just references the logic, not the sql. |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 11:35 am |
|
how do you turn sql_debug on ?
Joe |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sun Nov 23, 2003 11:42 am |
|
includes/sql_layer - search for sql_debug and set it to 1 |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 11:46 am |
|
OK i found the sql_debug and it's now set to 1
When i go to my mainpage, the following appreared at the very top of the screen:
SQL query: select topicid, topictext from nuke_topics order by topictext
Also, where the Messenger block was, the following shows:
SQL query: CREATE TABLE IF NOT EXISTS nuke_lastseen (id INT (15) not null AUTO_INCREMENT, username TEXT not null, date INT(15) not null, ip CHAR(50), PRIMARY KEY (id), UNIQUE (id))
SQL query: SELECT * FROM nuke_lastseen WHERE username = "joerobertson"
SQL query: UPDATE nuke_lastseen SET date = 1069609702 WHERE username = "joerobertson"
SQL query: SELECT username, date FROM nuke_lastseen ORDER BY date DESC limit 11
SQL query: select user_id from nuke_users where (username='Othic')
Joe |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sun Nov 23, 2003 11:50 am |
|
Which text is right above the Warning text? |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 11:51 am |
|
if you visit my site you'll se various error. One on the right, left and top of the web page
Joe |
|
|
 |
 |
Raven Site Admin/Owner

Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
|
Posted:
Sun Nov 23, 2003 12:16 pm |
|
But where is the Warning message? |
|
|
|
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 12:19 pm |
|
| Raven wrote: | | Which text is right above the Warning text? |
Which warning text? I see 3 areas which seem to have bugs. |
|
|
 |
 |
porcupinepc Involved


Joined: Sep 20, 2003 Posts: 261 Location: Schumacher, Ontario CANADA
|
Posted:
Sun Nov 23, 2003 2:19 pm |
|
Raven:
I found a better Messenger with no bugs.
AE Buddy Block v0.4 by Johua "Shadowhunter" Segatto
I'm posting it in my downloads also. Im just waiting for one of my users to test it online with me.
Regards
Joe Robertson
Porcupine PC / Great White North Trading Post
|
|
|
 |
 |
|
|
|
|