| Author |
Message |
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
 Posted:
Thu Mar 04, 2004 7:41 pm |
 
|
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 |
Last edited by Bamafan on Fri Mar 05, 2004 12:18 pm; edited 1 time in total |
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Thu Mar 04, 2004 9:52 pm |
|
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? |
|
|
  
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| Posted:
Thu Mar 04, 2004 10:08 pm |
|
not sure where can I find line 53? php... myphpadmin or where? |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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 |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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? |
Last edited by Bamafan on Fri Mar 05, 2004 1:31 am; edited 2 times in total |
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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? |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Fri Mar 05, 2004 4:49 am |
|
Are you using a pop-up blocker? |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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... |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Fri Mar 05, 2004 11:34 am |
|
Still sounds like the popup blocker. Disable it completely and try the chat. |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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> |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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? |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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. |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Fri Mar 05, 2004 1:03 pm |
|
You have JS enabled or nuke wouldn't be working  . Just to convince yourself, save this script to test.html and run it in your browser | Code: | | <script>alert('Hello World');</script> |
|
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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? |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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. |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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... |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| 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. |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| Posted:
Fri Mar 05, 2004 2:57 pm |
|
no, unfortunately that seems to be more than I could handle with my inexperience... |
|
|
|
|
|
Bamafan
Regular
Joined: Feb 07, 2004
Posts: 59
|
| 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... |
|
|
|
|
|
gator
Hangin' Around
Joined: Jul 24, 2003
Posts: 36
Location: Canada
|
| 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 |
|
|
|
|
|
gator
Hangin' Around
Joined: Jul 24, 2003
Posts: 36
Location: Canada
|
| Posted:
Mon Mar 08, 2004 3:30 pm |
|
|
|
|
|
aram
New Member
Joined: Mar 26, 2004
Posts: 1
|
| Posted:
Fri Mar 26, 2004 8:32 pm |
|
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...  |
|
|
|
|
|
|
|
|
|
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::