Error in event countdown and sp chat

Regular Joined: Feb 07, 2004 Posts: 59

I am getting the following error for an event countdown timer any ideas will be appreciated... Here's the error... Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/ps2onlin/public_html/blocks/block-Event_Countdown.php on line 53

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

This error indicates that either a table is missing or the SQL clause accessing the table is calling for an incorrect number of columns. What is line 53?

Posted: Thu Mar 04, 2004 10:08 pm

not sure where can I find line 53? php... myphpadmin or where?

Posted: Thu Mar 04, 2004 10:13 pm

Per your post: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/ps2onlin/public_html/blocks/block-Event_Countdown.php on line 53

Posted: Fri Mar 05, 2004 12:15 am

Ok I have it working but I have one small problem... when I decide to change or add something I have to delete the exsisiting countdown block or deactivate it... Is this just the way it is with the countdown?

Posted: Fri Mar 05, 2004 12:34 am

Oh my!! I have another issue... we are using sp chat at our site and when I hit "let's go" it says I am in the chat but the chat room doesnt pop up... any ideas?

Posted: Fri Mar 05, 2004 4:49 am

Are you using a pop-up blocker?

Posted: Fri Mar 05, 2004 11:32 am

Yeah I have a pop up blocker but I have it disabled for my site... and have been to ther sites that allow me to use their sp chat... that is why I am kinda lost...

Posted: Fri Mar 05, 2004 11:34 am

Still sounds like the popup blocker. Disable it completely and try the chat.

Posted: Fri Mar 05, 2004 12:23 pm

Yeah I have tried totally disabling my pop up blocker and have also installed a newer version of the chat, as the older one was doing same thing... it is doing this with other users at my site as well... when someone selects "Let's go" it will show them in the chat room but no chat window opens... please feel free to take a look> http://www.ps2onlineleagues.com/modules.php?name=SPChat

Posted: Fri Mar 05, 2004 12:37 pm

If you do a right mouse click on the Let's Go link and select open in new window, does that work?

Posted: Fri Mar 05, 2004 12:45 pm

Yeah it just does the same thing I have found a FAQ about it maybe you can help me Raven or anyone else... does enabling the java script going to be in my browser or at my site server? Here is the FAQ....> Make shure to have switched off popup blockers and activated JavaScripting. Most modern browser have the ability to block popus. This should prevent from unwanted adverts. Also there exists more programs to block advertisments by blocking popups. Some antiviral software does it too. How to deactivate the blocker, please read the docu of the depending blocking software.

Posted: Fri Mar 05, 2004 1:03 pm

You have JS enabled or nuke wouldn't be working Smile

. Just to convince yourself, save this script to test.html and run it in your browser

Code:

<script>alert('Hello World');</script>

Posted: Fri Mar 05, 2004 1:11 pm

Yep its working... the support forums for this chat aren't up... ... I guess i'll try my server for some assistance... does anyone know of a good user friendly chat for nuke?

Posted: Fri Mar 05, 2004 1:13 pm

I have installed SP Chat on several sites and it works really well so I don't believe it's SP Chat. Although I haven't gotten the most recent build, so maybe there is a bug.

Posted: Fri Mar 05, 2004 1:22 pm

This is driving me crazy...lol.. I am able to access other SP Chat rooms at other sites... I'm gonna post at nuke cops and see if anyone else has had this type issue.... I also sent my server an e-mail stating the problem... I appreciate your time and effort Raven... this site is the first place I come when I have a problem, keep up the great work...

Posted: Fri Mar 05, 2004 2:46 pm

Have you tried removing the database tables and files and reinstalling from scratch? Also, make sure that there is not an entry in your popup blocker's file that is blocking it, just in case.

Posted: Fri Mar 05, 2004 2:57 pm

no, unfortunately that seems to be more than I could handle with my inexperience...

Posted: Mon Mar 08, 2004 8:54 am

I found out the problem was from an additional "Live Score" block I use... by moving the block from the left to the right it eliminated the issue with my SP Chat...

Posted: Mon Mar 08, 2004 3:28 pm

I would also try to change the preset spchat admin settings to:

Message refresh time (milliseconds) = 5000
Time to delete idle chatter/messages (secs) =180
Number of messages shown on first join =10

Posted: Mon Mar 08, 2004 3:30 pm

http://nukecops.com/postlite17287-.html

New Member Joined: Mar 26, 2004 Posts: 1

If you have a Sports Block running, and it's on the left side,
move it to the right side.
I did that and it fixed my similar problem... Laughing