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'] ."");
$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.
There is missing the number of line in your statement:
LIMIT 0,".$filesConfig ['numbernewfiles']
DESC LIMIT 0,
^^^^^
Looks like $filesConfig ['numbernewfiles']
is blank