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 www.porcupinepc.com/forums Messenger is on the bottom right.
Id appreciate any help
Thanks
Joe |
|
|
 |
 |
Raven
Site Admin/Owner

Joined: Aug 27, 2002
Posts: 17088
|
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

|
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

|
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

|
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: 714
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

|
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

|
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

|
Posted:
Sun Nov 23, 2003 11:09 am |
|
Need to see lines 283 and 285. |
|
|
|
 |
porcupinepc

|
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

|
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

|
Posted:
Sun Nov 23, 2003 11:35 am |
|
how do you turn sql_debug on ?
Joe |
|
|
|
 |
Raven

|
Posted:
Sun Nov 23, 2003 11:42 am |
|
includes/sql_layer - search for sql_debug and set it to 1 |
|
|
|
 |
porcupinepc

|
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

|
Posted:
Sun Nov 23, 2003 11:50 am |
|
Which text is right above the Warning text? |
|
|
|
 |
porcupinepc

|
Posted:
Sun Nov 23, 2003 11:51 am |
|
|
|
 |
Raven

|
Posted:
Sun Nov 23, 2003 12:16 pm |
|
But where is the Warning message? |
|
|
|
 |
porcupinepc

|
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

|
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 shadow@in-my-world.com
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
www.porcupinepc.com/forums |
|
|
|
 |
|