Results 1 to 3 of 3

Thread: SQL Error

  1. #1
    Scott
    Guest

    Default SQL Error

    Hey,
    I keep getting this error from time to time on some php pages.
    " Query failed: 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 '' at line 1 "

    I can not find anything wrong with the code, and it happens everynow and
    then to a page. The page was working correctly then it stops. The only way I
    have found to fix the problem is to recreate the page from scratch. I tried
    just deleting the connector and adding it back in. But the same error
    happens.

    I have some pages that have about 20 if then else combinations so im
    dreading if this happens to one of these pages because it took me hours to
    create them let alone recreate it all.

    Any ideas?

    Thanks
    Scotty



  2. #2

    Default

    I have the same problem. It doesn't seem like Netobjects want to connect to my database.

    It come up with the same error: Query failed: 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 "" FROM "" WHERE "" ORDER BY "" DESC' at line 1

    With my connector even if I delete and remake the page with new connectors it still doesn't work.
    I've tried 3 different hosts, 1and1, hostgator, and a 3rd party host and none of them want to work.

    Does Netobjects work with old and new MySQL and PHP versions? I am using the most updated software right now.

    I never used to have this problem a couple years ago. I'm looking forward to another Netobjects Fusion release!

    Thanks,
    Brandon

  3. #3
    Junior Member
    Join Date
    May 2015
    Posts
    13

    Default

    Hi Scott, have you Fusion yet? Link below.

    http://forums.netobjects.com/showthr...h-DB-connector

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •