Error:

Error code: 0
Source file: /var/www/vhosts/archiveadme.com/httpdocs/system/classes/database.php (34):
Error message: Invalid query: Unknown column '2023' in 'field list'
SQL Query:
 
            SELECT `2023`, `2022`, `2021`, `2020`, `2019`, `2018`, `2017`, `2016`, `2015`, `2014`, `2013`, `2012`, `2011`, `2010`, `2009`, `2008`, `2007`, `2006`, `2005`, `2004`, `2003`, `2002`, `2001`, `2000`, `1999`, `1998`, `1997`, `1996`, `1995`, `1994`, `1993`, `1992`, `1991`
            FROM `festivals_years`  
            WHERE `festival_id` = '81' 
 
  1. }
  2. /**
  3.  *
  4.  */
  5. public static function query($query){
  6. self::$last_query = $query;
  7. //fb::log($query);
  8. $result = mysql_query($query, self::$link);
  9. if (!$result) {
  10. throw new Exception ('Invalid query: ' . mysql_error());
  11. }
  12. self::$query_result = $result;
  13. // $log = logs::factory('mysql_query');
  14. // $log->setDir('/logs/');
  15. // $log->write($query);
  16. return $result;
  17. }
  18. /**
  19.  * TODO
  20.  * нужно переделать если один результат, то елемент массива 0 только возвращать в сокращенном виде
  21.  
Stack trace:
#0 /var/www/vhosts/archiveadme.com/httpdocs/application/classes/festivals.php(224): Database::query('\n            SE...')
#1 /var/www/vhosts/archiveadme.com/httpdocs/application/modules/festivals/frontend/festival.php(367): festivals::getYears('81')
#2 /var/www/vhosts/archiveadme.com/httpdocs/application/modules/festivals/ini.php(20): include_once('/var/www/vhosts...')
#3 /var/www/vhosts/archiveadme.com/httpdocs/system/classes/core.php(59): require_once('/var/www/vhosts...')
#4 /var/www/vhosts/archiveadme.com/httpdocs/index.php(12): core::loadModule('festivals')
#5 {main}

Dumps:

$_GET:
array (
  'festivals/golden-hammer/2013/' => '',
)
$_POST:
array (
)
$_SESSION:
$_SERVER:
array (
  'PATH' => '/sbin:/usr/sbin:/bin:/usr/bin',
  'PP_CUSTOM_PHP_INI' => '/var/www/vhosts/system/archiveadme.com/etc/php.ini',
  'PP_CUSTOM_PHP_CGI_INDEX' => 'fastcgi',
  'SCRIPT_NAME' => '/index.php',
  'REQUEST_URI' => '/festivals/golden-hammer/2013/',
  'QUERY_STRING' => 'festivals/golden-hammer/2013/',
  'REQUEST_METHOD' => 'GET',
  'SERVER_PROTOCOL' => 'HTTP/1.0',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'REDIRECT_URL' => '/festivals/golden-hammer/2013/',
  'REDIRECT_QUERY_STRING' => 'festivals/golden-hammer/2013/',
  'REMOTE_PORT' => '35291',
  'SCRIPT_FILENAME' => '/var/www/vhosts/archiveadme.com/httpdocs/index.php',
  'SERVER_ADMIN' => 'root@localhost',
  'DOCUMENT_ROOT' => '/var/www/vhosts/archiveadme.com/httpdocs',
  'REMOTE_ADDR' => '18.206.92.240',
  'SERVER_PORT' => '443',
  'SERVER_ADDR' => '176.9.138.202',
  'SERVER_NAME' => 'archiveadme.com',
  'SERVER_SOFTWARE' => 'Apache',
  'SERVER_SIGNATURE' => '
Apache Server at archiveadme.com Port 443
', 'HTTP_ACCEPT_ENCODING' => 'br,gzip', 'HTTP_IF_MODIFIED_SINCE' => 'Mon, 04 Jul 2022 09:13:42 GMT', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'HTTP_CONNECTION' => 'close', 'HTTP_X_ACCEL_INTERNAL' => '/internal-nginx-static-location', 'HTTP_X_FORWARDED_FOR' => '18.206.92.240', 'HTTP_X_REAL_IP' => '18.206.92.240', 'HTTP_HOST' => 'archiveadme.com', 'HTTPS' => 'on', 'SCRIPT_URI' => 'https://archiveadme.com/festivals/golden-hammer/2013/', 'SCRIPT_URL' => '/festivals/golden-hammer/2013/', 'REDIRECT_STATUS' => '200', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SCRIPT_URI' => 'https://archiveadme.com/festivals/golden-hammer/2013/', 'REDIRECT_SCRIPT_URL' => '/festivals/golden-hammer/2013/', 'FCGI_ROLE' => 'RESPONDER', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1680358156.74098110198974609375, 'REQUEST_TIME' => 1680358156, )