Webpage Registration error

[atulhom]

string(69) "SELECT `created` FROM `znote_accounts` WHERE `account_id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

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 'LIMIT 1' at line 1

i got this error but i dident understand why becouse this DB its imported from yesterday and server runs. i cant regist, its appear this error

bump

Bump

 

[Raggaer]

Your query is wrong you are missing the account_id attribute?

SELECT `created` FROM `znote_accounts` WHERE `account_id` = 10 LIMIT 1;

For example. Also select_single only gets a single result so there is no need for LIMIT 1 plus there is only one account for your given ID (usually)

 

[atulhom]

thx bro, its solved