Urgent Help [PHP]

[Shadows]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: 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 'WHERE `player_id` = 11484 AND `skillid` = 0' at line 1' in C:\xampp\htdocs\pot\OTS_Player.php:195 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(195): PDO->query('UPDATE `player_...') #1 C:\xampp\htdocs\accountmanagement.php(710): OTS_Player->save() #2 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 195

On that line is

             $this->db->query('UPDATE ' . $this->db->tableName('player_skills') . ' SET ' . $this->db->fieldName('value') . ' = ' . $skill['value'] . ', ' . $this->db->fieldName('count') . ' = ' . $skill['tries'] . ' WHERE ' . $this->db->fieldName('player_id') . ' = ' . $this->data['id'] . ' AND ' . $this->db->fieldName('skillid') . ' = ' . $id);

The character is still created but without EQ and the skills do not save.

 

[Shadows]

Bump

 

[Shadows]

Bump

 

[Shadows]

Bump

 

[Jesper_Kladden]

It has to do with the MySQL Syntax it says (At least what I read).
I don't know MySQL, but PM someone who is professional 'bout this if none answers <.<

 

[zerghel]

use xampp 1.6.5 instead of newer versions

 

[Shadows]

Nah I figured it out already Triggers Were Improperly Setup. Just reloaded them simple.

Close Topic