Abend,
Ich vertsehe das Problem nicht
Code
1 -> 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 'WHERE `username` = 'wolf' SET `lastseen` = '2014-05-20 21:33:16'' at line 1 -- Code : 42000 -- in localhost /var/www/UMAG/classes/class.usermag.helper.php on line 206. Query: REPLACE `useractions` WHERE `username` = :username SET `lastseen` = :time
Hier Der Code dazu
PHP
function setLastSeen(){
$SQL['setLastSeen']['query'] = "REPLACE `useractions` WHERE `username` = :username SET `lastseen` = :time";
$SQL['setLastSeen']['stmt'] = $this->SYS['conf']['db']['conect']->prepare($SQL['setLastSeen']['query']);
if (
!$SQL['setLastSeen']['stmt']->execute(
array(
':username' => $this->username,
':time' => date("Y-m-d H:i:s")
)
)
){#wenn fehler beim ausführen
generate_query_ErrorMessage($SQL['setLastSeen']['stmt']->errorInfo(),__LINE__,__FILE__,$SQL['setLastSeen']['query']);
}
}
Alles anzeigen
EDIT:
Tabellen Spalte: `username` VARCHAR(50) UNIQUE NOT NULL