Menu

fatal error

Help
eric
2009-10-12
2013-05-30
  • eric

    eric - 2009-10-12

    tried to add a favorite, got this error when i clicked add:
    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access violation: 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 '?AND fv_file=? AND fv_username=?' at line 1' in /storage/mijndomein/users/058363/public/sites/www.ruytenbeek.nl/phpgedview/includes/classes/class_pgv_db.php:709 Stack trace: #0 /storage/mijndomein/users/058363/public/sites/www.ruytenbeek.nl/phpgedview/includes/classes/class_pgv_db.php(709): PDO->prepare('SELECT 1 FROM p…') #1 /storage/mijndomein/users/058363/public/sites/www.ruytenbeek.nl/phpgedview/includes/authentication.php(649): PGV_DB::prepare('SELECT 1 FROM p…') #2 /storage/mijndomein/users/058363/public/sites/www.ruytenbeek.nl/phpgedview/index.php(145): addFavorite(Array) #3 {main} thrown in /storage/mijndomein/users/058363/public/sites/www.ruytenbeek.nl/phpgedview/includes/classes/class_pgv_db.php on line 709

    hope someone can help me getting this sorted.
    greetz Crazyh

     
  • Greg Roach

    Greg Roach - 2009-10-12

    Works OK on my system.  Just for an experiement, can you add a space to line 595 of includes/authentication.php.  Change

    $sql.="AND fv_file=? AND fv_username=?";

    to

    $sql.=" AND fv_file=? AND fv_username=?";

     
  • eric

    eric - 2009-10-12

    would love to but my includes/authentication.php line 595 isnt like that at all, this is in my line 595 :function deleteMessage($message_id) {
    if you want can send a copy to mail address.
    greetz Crazyh

     
  • Greg Roach

    Greg Roach - 2009-10-12

    Try 645

     
  • eric

    eric - 2009-10-12

    great thnx for your replies. all working now.
    and btw superfast and great help using forum, thnx for your help

    greetz Crazyh

     

Log in to post a comment.