Classifieds Not Fully Working Since The Server MOve

Rellihan

Rellihan

Touring the Galaxy
I am putting this under Fly-Ins as opposed to General, so that it can show up on the Home Page.

I have been unable to create new Classifieds since the server change (and have reported it previously). I saw that at least one other member has reported the same thing. Viewing the ads still seems to work. Here is the error message.
___________________________
Error: 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 'condition, add_date, exp_date, country_id, state_id, valid, mother_id ) VALUES (' at line 1 back

Thank you ! Your ad has been saved! Click here to see your ad
___________________________
If I click on the ‘See your ad’ link, I get this error message:

Invalid page 'details.php'
 
And for what its worth, when trying to view some classified ads, you get "This ad has not been validated" . In two of the cases on the home page, I have previously been able to view them, but no longer am able to. Probably pretty dissapointing to someone needing to sell.
 
I have been actively working to try to find the problem on this area as time has allowed for the past week, which unfortunately time hasn't allowed much as it caught me in the middle of lots of hours in the air and crisis at that pesky job that pays for my AvGas ;-).

The note on the validation error is new and this is the first time I have heard of it - please as you find issues email the webmaster through the site and we'll run them down as best we can.

I responded promptly to the original trouble report and I always send out post-resolution updates so that the interested parties can verify things are fixed to their satisfaction. But as a volunteer there will be a few times that the time in the middle is longer than some folks would like.

I would just ask that you be patient - I don't always take the time to send out intermediate updates as this can take away from the finite pool of time available to work on fixing and improving the site.

We're also working on getting a group of people so the pool of available folks to investigate and fix is greater than "1" but this takes time and we're just not there yet.

Thanks all,

Your (interim but busy nonetheless) Webmaster,

Mark
 
Mark,

Also when you get a chance, under the download section I get "Object not found!" error 404 when I try to look at the shop manual. I checked the rest of the downloads in that section and they appear to to be OK. Just for Info thanks.

Jack
 
Thanks. These have been a variety of errors - this particular one appears to be the old server was case in-sensitive and the new one most definitely is.

I have been fixing these as they are found and implemented some compatibility hacks to make the old ones work. I thought I had all of them but it's a bit of a WIP (and as much as I would like I don't have time to click every one and there hasn't been a common thread to the breakage to search automatically in all cases - there have been in some and those were fixed).

Anyway, this one should be fixed in the next few minutes.
-=-
Mark
 
Mark,

I/We thank you. Just don't burn yourself out. We do this for heart, not as a job.

Besides, let something "git" ya and just think of those EMS gorillas who may come to "help" your! :shock:
 
But as a volunteer there will be a few times that the time in the middle is longer than some folks would like.
Click to expand...

Oooooooohhh! You just think you are a volunteer! :shock: Sorry,, I just couldn't resist!
 
Classifieds are fixed. Yet another case of old code. The Classifieds module has a table with a field name "condition" - this is a reserved word in SQL which MySQL 4.x tolerated "bare" but MySQL 5.0/5.1 does not. There's been a few of these. So changed "<blah>, condition, <blah>" to "<blah>, `condition`, <blah>,". In classic computer consitency though table.condition is fine - the "." provides unambiguous indication that it is a field name.

I could not find any with the validation errors - please email me directly with a link to any broken ad and I'll investigate.

Given code found and fixed a few paths to update an ad might have been broken as well.

G'luck and sell away,
--
Mark
 
I could not find any with the validation errors - please email me directly with a link to any broken ad and I'll investigate.
Click to expand...

These classifieds give the "not validated " error. These are in the main window on the Front page of BAC


"Bitchin, Beechcraft in Bakersfield!!!"

"LOOKING TO BUY A SIERRA"
 
Classified still misfiring

Mark: Just nit-picking here, and BTW you are doing a good job. but...classifidies show 14 in the counter when there are only 4 airplanes listed. Not a big deal, I read all the available for sale items 2-3 times a week anyway.

Rap
 
Okay...sigh.

Thom's issue is bad error reporting by the site code. The code for the ad detail checks that the ad is validated and that the ad is not expired but then reports just the validated error. I've fixed the error reporting to report the specific (validated or expiration) error code.

The secondary issue is that the user who posts the ad selects the expiration time (and they can renew the ads) - but some of the code that displays lists of ads or counts of ads does not filter on all the details it should. So there are 14 valid airplane ads in the database but all but 4 are expired.

Now I realize that due to the recently fixed problem most folks have not been able to update their ads - you can easily add time to your adds just by going to your ads and editing the add - then do the add time option. If there is a consensus I can manually add ~30 days (the time on the new server) to all the ads but that is a bit of a broad stroke and risks "waking up" old/dead ads.

As time allows we'll try to fix the other queries to properly filter - but that takes time and testing, all in finite supply ;-).

Thanks,
--
Mark
 
One last update. Photo uploads on new classifieds were still broken until today. If you added classifieds yesterday or today with photos will not show up - although the links will be there.

The fix is pretty simple - go into your ad and click the delete link on each photo - then re-add them and all should be well.

Good luck and thanks for your patience,
--
Mark
 
Found another little glitch...

The front page of the classifieds displays this:

Aircraft (15)

That there's 15 aircraft for sale, but there's only 5 items in the section.

..Joe
 
Another bug that's probably been there a while is the link to the PT points.

If you click on the link on the home page Presidents Trophy under Member Info, you get the 2006 PT points page. If you go to Member info in the title bar and click on Presidents Trophy, you get the 2009 page.
 
You must log in or register to reply here.
Back
Top