jareczekjsp
Member
Hello guys I make char bazzar in myacc and when I add char to auction is error
createcharacterauction.php(1704)
Can you help me?
Lua:
Exception class: PDOException()
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `id` = 9' at line 1
File: C:\xampik\htdocs\system\pages\createcharacterauction.php
Line: 1704
Backtrace:
#0 C:\xampik\htdocs\system\pages\createcharacterauction.php(1704): PDO->exec('UPDATE `players...')
#1 C:\xampik\htdocs\index.php(362): require('C:\\xampik\\htdoc...')
#2 {main}
createcharacterauction.php(1704)
Code:
$update_character = $db->exec('UPDATE `players` SET `account_id` = '.$account_new.' WHERE `id` = '.$getCharacter['id'].'');
Can you help me?