BUG:

Error Number: 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 ”4” at line 1

SELECT a.*,b.user_nickname, b.user_head_url from qk_user_album a, qk_user b where a.album_user_id = b.user_id ORDER BY a.album_create_date desc LIMIT 0, ‘4’;

Filename: D:\DEV_PHP\WAMP\www\qk\system\database\DB_driver.php

Line Number: 330

Problem solved.

Here the limit syntax is used, the two parameters should be numbers, should not appear string

The reason is that when PHP pass the parameters, the second parameter is not converted, add an intval function, string to number can be

Similar Posts:

• [Solved] java.lang.Exception: java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to ‘SP_ ACT_ DAYACCOUNTAMOUNT’
• Error: ENOSPC: System limit for number of file watchers reached…
• IDEA Connect MYSQL Error: You have an error in your SQL syntax : ‘OPTION SQL_SELECT_LIMIT=1000’ （or…
• Logstash output jdbc Error: java.lang.IllegalAccessError: tried to access class com.mysql.jdbc.EscapeProcessor from class com.mysql.jdbc.ConnectionImpl
• [Solved] MYSQL Error: [Warning] Changed limits: max_open_files: 1024
• Gradle Could not find method leftShift() for arguments
• MySQL from_ Unixtime() and UNIX_ The difference of timestamp() function
• [Solved] Java Call Error: java.lang.IllegalArgumentException: wrong number of arguments
• Spark2.x Error: Queue’s AM resource limit exceeded.
• [Solved] Shell Script [: -ge/-le/=/… : unary operator expected (standard_in) 1: syntax error