Topic Options
#190267 - 09/27/06 09:53 AM SQL Search Error & Sig Limit
Chaos_Sedated Offline
CoS Priest

Registered: 09/26/06
Posts: 255
Loc: San Diego, CA
While trying to update my password in my profile settings, the form noted my signature is too long (100 character limit). I thought that was rather interesting since it allowed the signature when I first registered, and I noticed members with much longer signatures.

So I went to this forum and attempted to do a search on "long signatures" using the "Search forum" tool, and received this error:

We cannot proceed.
Script: /home/httpd/vhosts/vireweb.com/httpdocs/lttd/dosearch.php
Line#: 572
SQL Error: You have an error in your SQL syntax near '' at line 14
SQL Error #: 1064
Query: SELECT B_Number FROM w3t_Posts WHERE B_Approved = 'yes' AND B_Status <> 'M' AND B_Board IN ('bugs') AND ( (B_Subject LIKE '%long%' OR B_Body LIKE '%long%') OR (B_Subject LIKE '%signature%' OR B_Body LIKE '%signature%')) ORDER BY B_Posted DESC LIMIT

Please use your back button to return to the previous page.

Could this be because I'm using the http://www.vireweb.com/lttd address to access this forum, as opposed to satannet (which may be banned at my office, but rather not test). I registered and initially entered my signature from my home office, using the satannet address.

Thanks
_________________________
This is our purpose: to make as meaningful as possible this life that has been bestowed upon us; to live in such a way that we may be proud of ourselves; to act in such a way that some part of us lives on.
- Oswald Spengler

Top
#190268 - 09/27/06 10:00 AM Re: SQL Search Error & Sig Limit [Re: Chaos_Sedated]
Soleil Noir Offline
CoS Member

Registered: 10/03/04
Posts: 357
Loc: Freudenabteilung
Quote:

Could this be because I'm using the http://www.vireweb.com/lttd address to access this forum




Yes, that's why. I had the same problems when updating information in safe mode. You'll have to update your signature when you're not in safe mode.

Top
#190269 - 09/27/06 10:47 AM Re: SQL Search Error & Sig Limit [Re: Soleil Noir]
Chaos_Sedated Offline
CoS Priest

Registered: 09/26/06
Posts: 255
Loc: San Diego, CA
Excellent, thanks for the quick response.

I had a feeling it was related to that.
_________________________
This is our purpose: to make as meaningful as possible this life that has been bestowed upon us; to live in such a way that we may be proud of ourselves; to act in such a way that some part of us lives on.
- Oswald Spengler

Top


Forum Stats
12218 Members
73 Forums
43998 Topics
406136 Posts

Max Online: 197 @ 10/04/11 06:49 AM
Advertisements