Site Info Open forum for the discussion of the S2K International site and organization. If you like what we're doing, post it here. If you don't, post it here too. Get answers to site related questions.

mySQL error doing "Find all posts by this member"

Thread Tools
 
Old 06-15-2005, 09:23 AM
  #1  
Registered User

Thread Starter
 
WhiteS2k's Avatar
 
Join Date: Oct 2000
Location: Bay Area
Posts: 3,827
Likes: 0
Received 0 Likes on 0 Posts
Default mySQL error doing "Find all posts by this member"

I hope this is not a repost, but since search is not working, it is hard to tell if someone reported this before.

I clicked on "Find all posts by this member" and I got the following error. Since it is a "syntax error", I doubt it has anything to do with time-outs. Please take a look and fix it if it is a real problem. Thanks.

[QUOTE]mySQL query error: SELECT t.*, f.id as forum_id, f.name as forum_name
Old 06-15-2005, 12:42 PM
  #2  
Administrator


 
AquilaEagle's Avatar
 
Join Date: Jan 2002
Location: Heath & Reach, Beds, UK
Posts: 95,156
Received 60 Likes on 51 Posts
Default

Probably the time on the server, at the server's location, vs what time zone you are in

e.g. you posted at 06.23pm my time
Old 06-15-2005, 02:02 PM
  #3  
Registered User

Thread Starter
 
WhiteS2k's Avatar
 
Join Date: Oct 2000
Location: Bay Area
Posts: 3,827
Likes: 0
Received 0 Likes on 0 Posts
Default

Possible. But that means the server is one hour behind where I am located, and I am already in the PDT (Pacific Daylight Time) time zone. I don't know of any land-mass that is one hour behind us except possibly way up in Alaska.

What about the mySQL syntax error? Anyone working on fixing that? Thanks.
Old 06-15-2005, 03:02 PM
  #4  
Administrator


 
AquilaEagle's Avatar
 
Join Date: Jan 2002
Location: Heath & Reach, Beds, UK
Posts: 95,156
Received 60 Likes on 51 Posts
Default

ok maybe DST is in effect on the server it's no biggie.

The SQL error will be part of the search issues. Search is on the operating table right now having a transplant and some plastic surgery.
Old 06-15-2005, 05:23 PM
  #5  
Registered User

Thread Starter
 
WhiteS2k's Avatar
 
Join Date: Oct 2000
Location: Bay Area
Posts: 3,827
Likes: 0
Received 0 Likes on 0 Posts
Default

Thanks. Sounds serious. I hope the patient lives.
Old 06-16-2005, 09:00 AM
  #6  
Administrator


 
cthree's Avatar
 
Join Date: Oct 2000
Location: Toronto, Canada
Posts: 20,274
Likes: 0
Received 4 Likes on 4 Posts
Default

More like we hope the patient can be revived, it's already dead
Old 06-17-2005, 09:51 AM
  #7  
Registered User

 
thetz99's Avatar
 
Join Date: Aug 2004
Location: Davis, CA
Posts: 2,536
Likes: 0
Received 1 Like on 1 Post
Default

I'm getting a sql error when I search my own alias with all posts by this member, but I don't get the error when I search other aliases.

Also I can't see my thumbnails in mY own photo album, but I can see other's galleries fine.

Sounds like I have a glitch in my account db.
Old 06-17-2005, 04:18 PM
  #8  
dut
Registered User
 
dut's Avatar
 
Join Date: Dec 2003
Location: Murrieta, CA
Posts: 4,369
Likes: 0
Received 0 Likes on 0 Posts
Default

I always get errors just searching. Not sure what happened to this search engine on this site.
Old 06-20-2005, 07:49 AM
  #9  
Registered User

Thread Starter
 
WhiteS2k's Avatar
 
Join Date: Oct 2000
Location: Bay Area
Posts: 3,827
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by thetz99,Jun 17 2005, 09:51 AM
I'm getting a sql error when I search my own alias with all posts by this member, but I don't get the error when I search other aliases.
To help all the people who put in many hours to maintain this site and keep things going, it would help if you give some details of what kind of "sql error" you were getting. Some sql errors are known and there is already an explanation for them (such as time-outs). But others, such as the recent syntax error, may be real problems that they can do something about. So to help them out, give them more detailed info, as much as you can provide. Thanks.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
lovegroova
Site Info
5
01-16-2013 11:14 AM
Moddiction
Site Info
20
10-27-2010 07:25 AM
mtmetzger
Site Info
5
06-28-2005 05:20 PM
HydnHood
Site Info
5
03-29-2005 10:09 AM
ttah
Site Info
7
03-20-2005 06:33 PM



Quick Reply: mySQL error doing "Find all posts by this member"



All times are GMT -8. The time now is 02:07 PM.