MySQL错误＃1064，我不认为：该怎么办？

Question

MySQL error in file: /engine/modules/files/newfiles.php at line 14
Error Number: 1064
The Error returned was:
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 '' at line 5

SQL query:

SELECT `id`, `title`, `version`, `alt_name` FROM `dle_` WHERE `approve` = '0' AND `date` < '2014-08-28 12:57:32' ORDER BY `date` DESC LIMIT 0,

code fragment:

 $db->query ( "SELECT `id`,
 `title`,
 `version`, 
 `alt_name`
 FROM `".PREFIX ."_".$modul_dbtitle ."` WHERE `approve` = '0' AND `date` < '{$thisdate}'  ORDER BY `date` DESC LIMIT 0,".$filesConfig ['numbernewfiles'] ."");

Answer 1

$modul_dbtitle apparently does not have a value as your tablename is incomplete in your query.

SELECT `id`, `title`, `version`, `alt_name` FROM `dle_` WHERE `approve` = '
                                                  ^^^^^^
                                                   HERE

You need to figure out why. My guess is you are missing an e in the variable name:

$modul_dbtitle

should be

$module_dbtitle

Additionally, $filesConfig ['numbernewfiles'] also contains no value and will break your query.

You should ensure error reporting is turned on as I suspect PHP would be warning you about these errors.