vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Ultimate Now Playing Hack - WA3 plugin / data stored in database (https://vborg.vbsupport.ru/showthread.php?t=45604)

Jitway 11-23-2002 09:22 PM

Ok everytime I try to post a newthread I get this error and it has to do with this hack that I installed. Posting a reply to thread is no problem but starting a newthread I get the same erro everytime........

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT * FROM nowplaying WHERE userid = '1' AND dateline > ORDER BY dateline DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY dateline DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Saturday 23rd of November 2002 11:15:55 PM
Script: http://www.jitway.com/forums/forums/newthread.php
Referer: http://www.jitway.com/forums/newthre...read&forumid=5
......and this would be that line of code in the newthread.php....

$npdateline=time()-600;
$currentsong=$DB_site->query_first("SELECT * FROM nowplaying WHERE userid = '".$bbuserinfo[userid]."' AND dateline > $npdateline ORDER BY dateline DESC LIMIT 1");

Any suggestions?

SlaPPiE 11-23-2002 09:37 PM

I recieved this error when I tried to view "All History":

Quote:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1565905 bytes) in /home/btrend/www/forums/admin/functions.php on line 591

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 40 bytes) in Unknown on line 0
Forgive me if this has been solved somewhere earlier in this thread.

I'm not exactly sure how to clear out that list, and then lessen the length of days it keeps the history there, so if anyone could help me out, it'd be appreciated. Thanks in advance. :)

GoTTi 11-29-2002 06:58 AM

need some support here, i want this hack to work

Jitway 11-29-2002 11:00 AM

Same here how about some support for post #51

Oblivion Knight 12-07-2002 01:26 AM

I'm recieving the same error as Da_GoTTi.
It's really weird, I've tried re-downloading the zip several times and i get the same error..

Any ideas..? This sounds like a really good hack..

RudeDog 12-18-2002 01:30 PM

Whatever happened to working on the winamp 2 support?

If a board is still needed for test, I'll help....

Issy_X 12-20-2002 11:56 AM

Ok, I don't have a clue about what I'm doing wrong. I applied the hack but it's not working. The only thing that works is that the nowplaying stuff is showing up on the profile page. The postbit is not working and I also can't access the howto and stats pages. What do I have to do?

Keta 12-21-2002 12:57 AM

Quote:

Originally posted by Da_GoTTi
When I follow the instructions on where to unzip the file to...then I goto the winamp preferences and install the skin or whatever...

the .xml file

I get this error after I click Open on the .xml file (file attached)

What is this and how do i get it fixed?

yup i get the same thing

TheComputerGuy 12-22-2002 11:27 AM

I get this error....

PHP Code:

<!-- Database error in vBulletin 2.2.9:

Invalid SQLINSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visibleVALUES (NULL,'271','','TheComputerGuy','1','1040530296','0','I agree

Who are you?'
,'1','1','67.30.234.131','0','1,'','')
mysql error: You have an error in your SQL syntax near ''1,'','')' 
at line 1

mysql error number
1064

Date
Saturday 21st of December 2002 08:11:36 PM
Script
: [url]http://www.runaked.com/forums/forums/newreply.php[/url]
Referer: [url]http://www.runaked.com/forums/showthread.php?postid=3078#post3078[/url]
 
--> 


Xelation 02-05-2003 02:26 AM

anyone get this to work? not working for me...


All times are GMT. The time now is 07:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01220 seconds
  • Memory Usage 1,744KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete