Home   |  Message Board   |  Information   |  Classifieds   |  Features   |  Video
Server Issues - Page 2 - Walleye Message Central
Walleye Message Central

Go Back   Walleye Message Central > Walleye Message Central > General Discussion

Reply
 
Thread Tools Display Modes
  #11  
Old 03-10-2012, 12:35 PM
BeFishin BeFishin is offline
Charter Member
 
Join Date: Mar 2002
Location: Green Bay, WI.
Posts: 111
Default Classified Ads Filter Does Not Work

If I try to filter by 620 or Ranger I get a SQL error.

Any filtering does not work.

Last edited by BeFishin; 03-10-2012 at 12:38 PM.
Reply With Quote
Sponsored Links
Advertisement
 
  #12  
Old 03-10-2012, 02:16 PM
NEBRASKA JOHN NEBRASKA JOHN is online now
Slot Fish
 
Join Date: Sep 2010
Location: Lake Oahe Pierre,SD
Posts: 82
Default New format on photos

Just curious as to why my 21 foot lund photo looks more like an 8 foot bathtub. . . . (on the classified ad).
Reply With Quote
  #13  
Old 03-11-2012, 10:09 AM
Golden's Avatar
Golden Golden is offline
Charter Member
 
Join Date: Feb 1995
Location: Bull Shoals Lake - USA.
Posts: 1,951
Default

I'm not getting any errors when I search.

@ Nebraska John - your photo is your photo.
Nothing is changing the way it looks.
Reply With Quote
  #14  
Old 03-11-2012, 10:37 AM
NEBRASKA JOHN NEBRASKA JOHN is online now
Slot Fish
 
Join Date: Sep 2010
Location: Lake Oahe Pierre,SD
Posts: 82
Default Boat Photos

That's what I thought too until I looked at some of the new photo listings. They look like they've been shortened and fattened up too.
Reply With Quote
  #15  
Old 03-11-2012, 10:48 AM
Golden's Avatar
Golden Golden is offline
Charter Member
 
Join Date: Feb 1995
Location: Bull Shoals Lake - USA.
Posts: 1,951
Default

They don't look that way to me.

Photos are resized when uploaded but they are sized proportionately.

Do they look weird to anyone else?
Reply With Quote
  #16  
Old 03-11-2012, 10:56 AM
wrg668 wrg668 is offline
Minnow
 
Join Date: Jan 2003
Location: Burbank, IL, cook.
Posts: 44
Default server issuse

some photos look weird and some look normal.
Reply With Quote
  #17  
Old 03-11-2012, 11:04 AM
Rich B Rich B is offline
Charter Member
 
Join Date: Dec 2002
Location: Dover, OH
Posts: 813
Default Classifieds

Scott - when I try to go into the Classifieds I can get to that "page" and then when I try and
open up the page for the boats, etc, here is what pops up as of a minute ago:

404 Page Not Found
The page you requested was not found.

Now when I go into the Classifieds off your main page, that page will open OK.

Speed overall is great.....thanks for all you do to keep Walleye Central "# 1".

Rich
Reply With Quote
  #18  
Old 03-11-2012, 05:56 PM
JBlanck JBlanck is offline
Minnow
 
Join Date: Aug 2011
Location: Northern Illinois
Posts: 28
Default

I am also having the photos on the classified section show up distorted.
Reply With Quote
  #19  
Old 03-11-2012, 06:36 PM
Juls's Avatar
Juls Juls is offline
Super Moderator
 
Join Date: Nov 1999
Location: Port Clinton Ohio
Posts: 10,194
Default

Quote:
Originally Posted by Golden View Post
They don't look that way to me.

Photos are resized when uploaded but they are sized proportionately.

Do they look weird to anyone else?
Here's a screen shot of a 621 that is listed...it's definitely distorted as are most of the pics I looked at.

Juls
Attached Thumbnails
Click image for larger version

Name:	Classifieds 621 Pic.jpg
Views:	89
Size:	41.7 KB
ID:	14294  
__________________
Juls
NPAA#89

Find me in Walleye Central's Business Directory HERE

http://www.walleyecentral.com/pros/?proID=8

2014 Ranger 620
250 ETEC
15 ETEC Kicker
112 Terrova w/iPilot LINK
Humminbird 1199 SI, 1159c DI on Dash & 1159 Bow
Reply With Quote
  #20  
Old 03-11-2012, 07:56 PM
BeFishin BeFishin is offline
Charter Member
 
Join Date: Mar 2002
Location: Green Bay, WI.
Posts: 111
Default SQL Error on Filter

Here is the error I get when I enter 620 into the Keyword text box and click the filter button. The Category drop down was left at ALL, the State drop down was left at ALL and the Sorted by drop down was left at Most Recent Ad First. I did not check the Only Show New or Updated Ads in the past 30 Days. Also I did not check the show Ad Detail Checkbox:

A Database Error Occurred
Error Number: 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 '') Order By am.Last_PaymentDate DESC' at line 1

SELECT wcu.phone AS Phone, wcu.emailaddr, am.Ad_ID, am.Title, am.Item_Desc, am.SellersName, am.LocationCity, am.LocationState, am.Ad_Category, am.listcount, am.viewcount, am.brand, am.boat_year, am.boat_price, (SELECT count(*) FROM adphotos WHERE adphotos.Ad_ID = am.Ad_ID) AS PCount FROM wcu , admaster AS am WHERE ( wcu.UserKey = am.UserKey ) AND (am.Current_Status = 'Approved' OR Current_Status = 'Sold') AND ( am.active_end_date > DATE_ADD(CURDATE(),INTERVAL -1 DAY) ) AND ( am.StartDate < DATE_ADD(CURDATE(),INTERVAL +1 DAY) ) AND 0620%') Order By am.Last_PaymentDate DESC

Needs at least another quote and the keyword LIKE or CONTAINS

Last edited by BeFishin; 03-11-2012 at 07:59 PM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 12:07 PM.