Database error

[SloppyGoat]

What does this mean? Any idea?


Database error in vBulletin 2.3.0:

Invalid SQL: SELECT template,title
FROM template
WHERE (title IN
('showthread_ratingdisplay','postbit_search','postbit_buddy','postbit_ignore','postbit_use remail','icq','aim','yahoo','postbit_homepage','postbit_profile','postbit_ip_show','postbi t_ip_hidden','postbit','postbit_sendpm','postbit_avatar','postbit_offline','postbit_online ','postbit_editedby','postbit_signature','postbit_attachment','postbit_attachmentimage','s howthread_adminoptions','showthread_threadrate','showthread_pollresults_voted','showthread _pollresults_closed','showthread_pollresults_cantvote','showthread_firstunread','showthrea d_nextnewestthread','showthread_nextoldestthread','forumrules','showthreadhead_sound','gob utton','timezone','username_loggedout','username_loggedin','phpinclude','headinclude','hea der','footer','forumjumpbit','forumjump','nav_linkoff','nav_linkon','navbar','nav_joiner', 'pagenav','pagenav_curpage','pagenav_firstlink','pagenav_lastlink','pagenav_nextlink','pag enav_pagelink','pagenav_prevlink')
AND (templatese|id=-1 OR templatesetid=1))


ORDER BY templatesetid
mysql error: Unknown column 'templatese' in 'where clause'

mysql error number: 1054

[Steve Machol]

There is no 'templatese' field in any version of vB. If that's really the error, then it's from a hack you've installed. Reupload the original vB files to fix this.

[SloppyGoat]

Nope, no hacks installed recently. Could it just be from someone entering an invalid address or characters? It only happened once. I mean, can you tell from that mess what was done to cause it?

[Steve Machol]

I didn't ask if you have any hacks installed 'recently'.

As far as I can tell this error is from a modified file.

[SloppyGoat]

How can you tell? This is the rest or the error. It appears it was just showthread.php, which I haven't messed with for years, if at all. I don't believe I've ever modified that file, actually.

Script:
http://tga.dynu.com/showthread.php?goto=lastpost&threadid=10024

It also appears that it should've been 'templatesetid', if you look above that it says "ORDER BY templatesetid." Apparently, it threw a bad character in there for some reason.

(templatese|id=-1 OR templatesetid=1))

What file would that be in, just so I can check the syntax and make sure it doesn't really have an error? I don't see any 'templatesetid' in showthread.php anyway.

[Steve Machol]

You do realize that we cannot provide support for forums running modified code, ight?

At any rate, reupload the original showthread.php file to fix this. Most likely your modified file has a hard return where it shouldn't.

[SloppyGoat]

I just told you it's not modified. Geez! Look, the board has been running without a glitch for practically years now. Nothing has been done to that file. Understand? There's nothing wrong with that file, IMO. This only happened once, and hasn't happened since. I was just wondering what it means, or what caused it. Apparently, you don't really know. Thanks.

[Steve Machol]

You would not get this error with unmodified files. Since you have hacks instlled and choose not to follow my advice, you can try asking for help over at vbulletin.org.

[SloppyGoat]

How do you figure? I've never had the error before, and may never have it again. There is indeed a 'templatesetid', is there not? Are you failing to realize that 'templatese' is merely a truncated version of 'templatesetid'? It looks more to me like the entire command (or whatever you call it) was not received for some reason.

[Steve Machol]

What is it you want me to tell you? Maybe you could just tell me the answer thast is acceptable to you and this will save us both some time.

[SloppyGoat]

Something helpful, maybe. Nevermind. If it was modified code causing the problem, it would do it every single time, and it would definitely be something I could duplicate. You should know that. In this instance, I was really wondering what this person or bot was doing when this happened. If it was just accessing that link, then that sure doesn't explain why there was an error. When a board runs perfect with no errors for so long, then you have one out of the blue like that, it's definitely not a hack. Nice cop out, though. Thanks.

[Scott MacVicar]

This is a server error and has been seen before.

Its memory corruption though I can't remember what part is causing it, if you look at the query you posted it says

templatese|id=-1

But if you search all the PHP code you'll notice that there is no templatese|id but templatesetid.

Usual suspects are Op Code Caches like Zend Optimizer, Zend Accelerator, APC, eAccelerator, Turck MM Cache etc.

I've informed Steve of these situtations now for his future reference.

[SloppyGoat]

Thanks Scott. I was guessing it was something like that, since it seems to be a fluke, as far as I can tell. I am running Zend Opt. Maybe I have a questionable RAM module then? It's possible, since it is a pretty old server. So, memory probably flaked out and caused an invalid character to be inserted in place of the "t"? I suppose it's time to test my RAM, eh? I did search for 'templatesetid' in showthread.php, but didn't find that in it either.

[Scott MacVicar]

Its within functions.php and is called from global.php on every page to fetch the templates.

Are you running the latest versions of PHP / MySQL / Zend Optimizer, try giving them an upgrade if you can.

[SloppyGoat]

No, not the latest versions. I ran into a problem with updating php, so I've only done manual security updates. I'm going to leave it as is, if I can. The plan is to build a new server and go to v3.5 soon. So, in the meantime, I just want to keep this version running until that happens. The old board still screams. It's quite amazing, considering the low bandwidth and server specs I'm working with.