Jestem w trakcie instalacji skryptu do zarządzania kontami w grze. I skończyłem po instalacji gdy ujrzałem następujący błąd:
Kod
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1' in /var/www/latestnews.php:6 Stack trace: #0 /var/www/latestnews.php(6): PDO->query('SELECT * FROM `...') #1 /var/www/index.php(73): include('/var/www/latest...') #2 {main} thrown in /var/www/latestnews.php on line 6
Załączam linijki od 1 - 15 :
Kod
<?PHP
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
if($action == "") {
//show tickers if any in database or not blocked (tickers limit = 0)
$tickers = $SQL->query('SELECT * FROM '.$SQL->tableName('z_news_tickers').' WHERE hide_ticker != 1 ORDER BY date DESC LIMIT '.$config['site']['news_ticks_limit'].';');
$number_of_tickers = 0;
if(is_object($tickers)) {
foreach($tickers as $ticker) {
if(is_int($number_of_tickers / 2))
$color = "Odd";
else
$color = "Even";
$tickers_to_add .= '<div id="TickerEntry-'.$number_of_tickers.'" class="Row" onclick=\'TickerAction("TickerEntry-'.$number_of_tickers.'")\'>
<div class="'.$color.'">
//######################## SHOW TICKERS AND NEWS #######################
$time = time();
if($action == "") {
//show tickers if any in database or not blocked (tickers limit = 0)
$tickers = $SQL->query('SELECT * FROM '.$SQL->tableName('z_news_tickers').' WHERE hide_ticker != 1 ORDER BY date DESC LIMIT '.$config['site']['news_ticks_limit'].';');
$number_of_tickers = 0;
if(is_object($tickers)) {
foreach($tickers as $ticker) {
if(is_int($number_of_tickers / 2))
$color = "Odd";
else
$color = "Even";
$tickers_to_add .= '<div id="TickerEntry-'.$number_of_tickers.'" class="Row" onclick=\'TickerAction("TickerEntry-'.$number_of_tickers.'")\'>
<div class="'.$color.'">
Domyślam się że jest coś nie tak z zapytaniem, niestety nie wiem co dokładnie. Proszę o pomoc!
Pozdrawiam,
Ligo.