new posts

[PranK]

Jimbo - up the top in the middle of the nav bar - theres a 'new posts' button... it shows all posts since your last visit.

[PranK]

Have you tried running the SQL it doesn't like on the server directly (not via PHP)?

yah - fails there too.

[ferni]

Jimbo - up the top in the middle of the nav bar - theres a 'new posts' button... it shows all posts since your last visit.

Well its suppose to

what error does SQL spit back at you when you do it manually?

[Jimbo2000]

stop whinging then ladies

its not like you cant search manually

/get ready for a flaming by those who dont know me

[PranK]

this...

[b]Error[/b]

SQL-query :  

SELECT threadid
FROM thread AS thread
LEFT JOIN deletionlog AS delthread ON ( delthread.primaryid = thread.threadid AND delthread.type = 'thread' ) 
WHERE forumid
IN ( 3, 7, 8, 44, 53, 59, 10, 9, 11, 17, 66, 63, 64, 57, 4, 49, 50, 19, 14, 67, 18, 16, 32, 30, 42, 62, 15, 43, 47, 48, 65, 6, 21, 46, 51, 33, 54, 22, 31, 35, 55, 23, 34, 28, 37, 58, 24, 39, 25, 36, 26, 40, 27, 38, 5, 29, 60, 61, 41, 56, 12, 13 ) AND thread.lastpost >=1078366975 AND visible =1 AND delthread.primaryid IS NULL 
ORDER BY lastpost DESC 
LIMIT 

MySQL said: 


#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7 

I put it in the PHP tags cause its easier to read..

Christian

[PranK]

its starting to drive me mad, and i dont even use the damn thing!

[ferni]

can you run it on a fresh install / different install of VB?

[ferni]

hah Disable the email to you on error, or direct them to /dev/null or something until you get it fixed

[PranK]

bah, it doesn't really bother me.

hang on, i have a local install.

[Jimbo2000]

haha.. oh shit thats a nuisance

[PranK]

same error... its bizarre.

[ferni]

Same error on a fresh install running that SQL command? what SQL does the "new posts" link run in the fresh install?

[PranK]

i am trying to find it - hang on a tic.

[ferni]

any luck?

[PranK]

nah - there are so many included files...

[ferni]

grep / text search for "new posts" ?

[B-Man]

It used to work - something must have changed - I'd be looking at that ..... then working backwards

[Duncan]

Hey christian, I had a look at the thread over at the vbulletin forum, looks like they pointed out the SQL syntax problem, the keyword LIMIT wasn't followed by a number.

I know *nothing* about php but I assume that $vboptions[maxresults] bind variable should be set somewhere, is it some sort of application wide setting in a config file that you need to add?

[B-Man]

Compare the code to the "user cp" button code - it displays the last active 'subscribed' posts - maybe the code is similar to the 'new posts' code ??

The 'user cp' code seems to work - so maybe there is a clue there ??

[EnricoPalazzo]

or compare it to someone else running same version of vbulliten.