Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Classifieds Not Fully Working Since The Server MOve

  1. #1

    Classifieds Not Fully Working Since The Server MOve

    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'

  2. #2
    Orbiting Earth Orbiting Earth ThomSmith's Avatar
    Join Date
    Nov 2005
    Location
    In the Blue Mountains of North East Oregon
    Posts
    769
    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.
    Thom Smith
    N3688Q
    67 Super III
    KLGD

  3. #3
    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

  4. #4
    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

  5. #5
    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

  6. #6
    Orbiting Earth Orbiting Earth sjcote's Avatar
    Join Date
    Jul 2004
    Location
    Springfield, Massachusetts
    Posts
    1,178
    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!


    Steve Cote
    BAC Founding Member
    Sundowner N-1958L

  7. #7
    Orbiting Earth Orbiting Earth ThomSmith's Avatar
    Join Date
    Nov 2005
    Location
    In the Blue Mountains of North East Oregon
    Posts
    769
    But as a volunteer there will be a few times that the time in the middle is longer than some folks would like.
    Oooooooohhh! You just think you are a volunteer! Sorry,, I just couldn't resist!
    Thom Smith
    N3688Q
    67 Super III
    KLGD

  8. #8
    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

  9. #9
    Orbiting Earth Orbiting Earth ThomSmith's Avatar
    Join Date
    Nov 2005
    Location
    In the Blue Mountains of North East Oregon
    Posts
    769
    I could not find any with the validation errors - please email me directly with a link to any broken ad and I'll investigate.
    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"
    Thom Smith
    N3688Q
    67 Super III
    KLGD

  10. #10

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Single Sign On provided by vBSSO