
Пожалуйста, сообщите об этом разработчику
Ошибка
Ошибка в SQL запросе!
Запрос:
Ответ сервера:
/var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/sql.inc.php (line 237)
Показать системную информацию
Ошибка в SQL запросе!
Запрос:
Select `building` From wc_fdata_pageFloor WHERE `id` = '218' LIMIT 1
Ответ сервера:
Unknown column 'building' in 'field list'
/var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/sql.inc.php (line 237)
}
private static function error($q) {
$error = "<br><b>Ошибка в SQL запросе!</b><br>Запрос:<div style=\"border:1px solid red;\"><pre>$q</pre></div>";
$error .= "<br> Ответ сервера: <div style='border:1px solid red;padding:2px;margin:3px;'><pre>".mysql_error()."</pre></div>";
if(class_exists('CMS') && is_object(CMS::$self)) {
CMS::$self->FatalError($error);
} else if(class_exists('Site') && is_object(Site::getSelf())){
Site::getSelf()->fatalError(new Exception($error, mysql_errno()));
} else {
echo $error;
echo '<b>backtrace:</b><pre>';
debug_print_backtrace();
echo '</pre>';
}
}
public static function lastId() {
return mysql_insert_id();
}
backtrace:
[0]: Site::__construct /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/index.php (line 24)
[1]: Site::launchPlugins /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/Site.inc.php (line 89)
[2]: PluginLauncher::doit /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/Site.inc.php (line 274)
[3]: PluginLauncher::launchPlugin /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/core/PluginLauncher.inc.php (line 32)
[4]: call_user_func_array /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/core/PluginLauncher.inc.php (line 133)
[5]: Flat::index (line )
[6]: Flat::show /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/plugins/Flat/classess/Flat.inc.php (line 1378)
[7]: DocumentList::getDocuments /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/plugins/Flat/classess/Flat.inc.php (line 1200)
[8]: DocumentList::_proccessList /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/Library/DocumentList.inc.php (line 236)
[9]: Flat::prepareFlat /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/Library/DocumentList.inc.php (line 473)
[10]: DataUtils::getDataField /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/plugins/Flat/classess/Flat.inc.php (line 440)
[11]: SimpleSQL::getCell /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/Library/DataUtils.inc.php (line 79)
[12]: sql::result /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/SimpleSql.inc.php (line 74)
[13]: sql::query /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/sql.inc.php (line 68)
[14]: sql::error /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/sql.inc.php (line 121)
} catch (CacheExceptionNotActual $e) {
define('CACHE_THIS_PAGE', true);
} catch (CacheExceptionActual $e) {
die;
} catch (Exception $e) {
die($e->getMessage());
}
}
new Site;
?>
[1]: Site::launchPlugins /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/Site.inc.php (line 89)
if(!$fullInit)
{
return ;
}
try
{
$this->components('start');
$this->launchPlugins();//can throws Exception404
$this->components('end');
if($this->getOption('wrapper'))
{
$this->dump();
}
}
catch (Exception404 $e)
{
[2]: PluginLauncher::doit /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/Site.inc.php (line 274)
$this->plugins = new PluginLauncher;
if($this->urlParser->isHavePluginAction())
{
$plugin_key = $this->urlParser->getPluginKeyByAction();
if(!$this->plugins->isPluginExists($plugin_key))
{
throw new Exception404;
}
}
$this->plugins->doit();
}
private function dump()
{
if($this->id == -1)//Error 404
{
$this->error404();
}
if($this->did && $this->options['check_document_id'])
{
[3]: PluginLauncher::launchPlugin /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/core/PluginLauncher.inc.php (line 32)
$command = '';
if (isset($plugin['launch_type']) && ($plugin['launch_type'] == 'text')) {
$command = 'inline';
}
if(isset($plugin['plugin_method']) && ($plugin['plugin_method'])) {
$command = $plugin['plugin_method'];
}
$pluginObject = $this->launchPlugin($plugin, $command, false);
// если запуск по тексту - надо сохранить объект для отложенного запуска
if ((isset($plugin['launch_type'])) && ($plugin['launch_type'] == 'text'))
{
$this->pluginsStorage[$plugin['key']] = array(
'object' => $pluginObject,
'data' => $plugin
);
}
}
}
[4]: call_user_func_array /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/core/PluginLauncher.inc.php (line 133)
if(!is_callable(array($plugin['key'], $action))) {
$this->fatalError('Action "' . $action . '" in plugin "' .$plugin['key'] . '"' .
' <b>must be public</b> (not private)', false);
}
$loaderUrl = SITE_PLUGINS_PATH . $plugin['key'] . DIRECTORY_SEPARATOR . 'classess' . DIRECTORY_SEPARATOR;
$loaderKey = 'Plugin_' . $plugin['key'];
Loader::get()->addDirectory($loaderUrl, $loaderKey);
$result = call_user_func_array(array($pluginObject, $action), $parameters);
Loader::get()->removeDirectory($loaderKey);
}
}
} catch (ExceptionStop $e) {
die;
}
}
$this->_processAfterLaunch();
[5]: Flat::index (line )
[6]: Flat::show /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/plugins/Flat/classess/Flat.inc.php (line 1378)
View::get()->stack('mortgageForm',View::get()->parseTemplateUnit('mortgageForm_pda.tpl', array('cost' => intval($flat['cost']))));
View::get()->stack('flatId',$flat['id']);
View::get()->stack('cartForm',$this->forceLaunchPlugin('Cart','generateCartForm'));
}
View::get()->stack('content', View::get()->parseTemplateUnit($template,array('planning'=>true,'flat'=>$flat, 'filtersAbsent' => $filtersAbsent)));
}
else
{
View::get()->stack('flatFilters',$this->flatFilters());
$this->show();
}
View::get()->stack('mortgageForm',$this->generateMortgageForm());
}
}
?>
[7]: DocumentList::getDocuments /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/plugins/Flat/classess/Flat.inc.php (line 1200)
$documents = new DocumentList('flat',$this->parent,false,$conditions,$this->orderParametr." ".$this->orderType.",data.reduction asc",true);
$count = $documents->count();
$paging = new ArrowsUtils($this->limit, $documents->count(),null,null,null,null,null);
$documents->setLimit($paging);
$list = $documents->getDocuments(array($this,'prepareFlat'));
}
else
{
$parent=false;
if(is_array($this->parent) && count($this->parent)>0)
{
$parent='';
foreach($this->parent as $p)
[8]: DocumentList::_proccessList /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/Library/DocumentList.inc.php (line 236)
$this->setPositions( $data );
}
if($this->cacheEnabled) {
$this->saveToCache($data);
}
}
if($callback) {
$this->_proccessList($data, $callback);
}
if (!is_array($data)) {
$data = array();
}
return $data;
}
public function count()
{
[9]: Flat::prepareFlat /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/Library/DocumentList.inc.php (line 473)
private function _proccessList( & $list, $callback) {
if(is_array($list)) {
$listCount = count($list);
foreach ($list as $position => $item) {
if(is_array($callback)) {
if(!method_exists($callback[0], $callback[1])) {
throw new Exception('Callback method '.$callback[1].' not defined');
} else {
$result = $callback[0]->$callback[1]($item, $position, $listCount);
}
} else {
if(!function_exists($callback)) {
throw new Exception('Callback '.$callback.' not defined');
} else {
$result = $callback($item);
}
}
if($result == 'delete') {
unset($list[$position]);
} else {
[10]: DataUtils::getDataField /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/site/plugins/Flat/classess/Flat.inc.php (line 440)
//Ищем папку-этаж
$floorFolderId = CacheFolders::getParent($sectionFolder['id']);
$floorFolder = CacheFolders::get($floorFolderId);
$item['floor'] = $floorFolder['name'];
//Ищем папку-комплекс
$complexFolderId = CacheFolders::getParent($floorFolderId);
if ($complexFolderId == 103) $this->flatsToFloor = 10;
$complexFolderBuilding = DataUtils::getDataField($complexFolderId,'building',FOLDER);
$item['complexName'] = CacheFolders::getName($complexFolderId);
$item['complexUrl'] = CacheFolders::getUrl($complexFolderId);
$flatNumber = $item['flatNumber'];
if (!intval($complexFolderBuilding)) $item['flatNumber'].=$complexFolderBuilding;
$item['floorId'] = $floorFolderId;
$filtersAbsent = DataUtils::getDataField($complexFolderId,'filtersAbsent',FOLDER);
if($filtersAbsent) View::get()->stack('searchTheSameAbsent',true);
[11]: SimpleSQL::getCell /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/Library/DataUtils.inc.php (line 79)
if(!$elementId)
{
throw new Exception('$elementId is empty');
}
if(!$fields) {
throw new Exception('$fields is empty');
}
$tableName = self::getTableNameById($elementId, $type);
if(SimpleSQL::is_table_exsits($tableName)) {
$data = SimpleSQL::getCell($tableName, $fields, $elementId);
}
return $data;
}
/**
* Взять все данные по одному элементу (за исключением мета-данных)
*
* @param int $id
* @param type $type
* @param mixed $template может быть id или key шаблона
* @version 2.0
[12]: sql::result /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/SimpleSql.inc.php (line 74)
}
$method = 'fetch';
}
$Query = "Select $field From ".self::tableName($fromTable) . self::parseCondition($condition, true);
self::orderBy($Query);
$Query .= ' LIMIT 1';
#echo '<b>'.$Query.'</b><br><br>';
return sql :: $method ($Query);
}
public static function getQuery($fromTable, $condition) {
$Query = "Select * From " . self::tableName($fromTable) . self::parseCondition($condition, true);
self::orderBy($Query);
return $Query;
}
public static function countRows($fromTable, $condition = null) {
$Query = "Select count(*) From " . self::tableName($fromTable) . self::parseCondition($condition, true);
[13]: sql::query /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/sql.inc.php (line 68)
$charset = $GLOBALS['sql_config']['charset'];
if(!$this->lastError && $charset) {
self::query('SET CHARACTER SET "' . $charset .'"');
self::query('SET NAMES "' . $charset .'"');
}
}
public static function result($q, $row = 0, $cell = 0, $echo = false, $mute = false, $noCache = false) {
if(!is_resource($q)) {
$q = self ::query($q, $echo, $mute, $noCache);
}
if (mysql_num_rows($q)) {
$res = mysql_result($q, $row, $cell);
} else {
$res = false;
}
return $res;
}
[14]: sql::error /var/www/bm/data/www/xn----9sbmlcaqln9b9csxi.xn--p1ai/engine/core/Database/sql.inc.php (line 121)
}
}
}
$q = str_replace("prname_", $GLOBALS['sql_config']['prefix'].'_', $q);
$query = $q;
$q = mysql_query($q) or self::error($query);
if($cache && $is_selectQuery) {
self::$SQL_CACHE[$queryId] = $q;
}
self::$countQueries++;
$queryTime = Timer::get($timeId);
self::$timeOfQueries += $queryTime;
Попробуйте обновить страницу, или перейти на главную страницу сайта
Система управления сайтом dinamique