Previous Thread
Next Thread
Print Thread
SQL Search Error & Sig Limit #190267
09/27/06 02:53 PM
09/27/06 02:53 PM
Joined: Sep 2006
Posts: 264
San Diego, CA
Chaos_Sedated Offline OP
CoS Priest
Chaos_Sedated  Offline OP
CoS Priest

Joined: Sep 2006
Posts: 264
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
Re: SQL Search Error & Sig Limit [Re: Chaos_Sedated] #190268
09/27/06 03:00 PM
09/27/06 03:00 PM
Joined: Oct 2004
Posts: 357
Freudenabteilung
Soleil Noir Offline
CoS Member
Soleil Noir  Offline
CoS Member

Joined: Oct 2004
Posts: 357
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.

Re: SQL Search Error & Sig Limit [Re: Soleil Noir] #190269
09/27/06 03:47 PM
09/27/06 03:47 PM
Joined: Sep 2006
Posts: 264
San Diego, CA
Chaos_Sedated Offline OP
CoS Priest
Chaos_Sedated  Offline OP
CoS Priest

Joined: Sep 2006
Posts: 264
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

Forum Statistics
Forums73
Topics44,555
Posts407,984
Members13,371
Most Online227
Sep 17th, 2018
Advertisements

hold
Page Time: 0.013s Queries: 14 (0.006s) Memory: 3.7699 MB (Peak: 4.2381 MB) Zlib enabled. Server Time: 2018-10-21 21:51:56 UTC