Принимаем вопросы от населения
Nik Samokhvalov |
|
---|---|
Таблица объявлена, колонка существует. Пробовал сделать простой запрос: <?php /* ==================== [BEGIN_COT_EXT] Hooks=page.edit.update.done [END_COT_EXT] ==================== */ defined('COT_CODE') or die('Wrong URL'); require_once cot_langfile('pagethumbs', 'plug', 'config'); require_once 'system/uploads.php'; $pagethumbs['paget_pageid'] = $id; $pagethumbs['paget_alt'] = cot_import('rpagethumbs_alt', 'P', 'TXT'); $pagethumbs['paget_url'] = ''; $paget_url = ''; if (isset($_POST['rpagethumbs_delete'])) { $oldthumbs = $db->query("SELECT paget_url FROM $db_pages_thumbs WHERE paget_pageid='$id'")->fetch(); if ($oldthumbs['paget_url'] != '') unlink($oldthumbs['paget_url']); $db->query("DELETE $db_pages_thumbs WHERE paget_pageid='$id'"); } if ($_FILES['rpagethumbs_file']['name'] != '') { if ($_FILES['rpagethumbs_file']['error'] == 0) { $oldthumbs = $db->query("SELECT paget_url FROM $db_pages_thumbs WHERE paget_pageid='$id'")->fetch(); if ($oldthumbs['paget_url'] != '') unlink($oldthumbs['paget_url']); $pagethumbs['paget_url'] = $item_id.rand(10, 99).".".end(explode('.', $_FILES['rpagethumbs_file']['name'])); $paget_path = $pagethumbs_catalog."/".$pagethumbs['paget_url']; move_uploaded_file($_FILES['rpagethumbs_file']['tmp_name'], $page_thumbs['path']); cot_imageresize($paget_path, $paget_path, $cfg['plugin']['pagethumbs']['paget_width'], $cfg['plugin']['pagethumbs']['paget_height'], 'fit', '#000', 100, true); $paget_url = " , paget_url='".$pagethumbs['paget_url']."'"; } else cot_error($L['Error_pagethumbs_load']); } $db->query("SELECT * FROM $db_pages_thumbs"); ?> Всё равно получаю ошибку: Fatal error 2012-05-01 19:30 SQL error 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 #0 cot_diefatal(SQL error 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) called at [X:\home\cot-max.ru\www\system\database.php:449] #1 CotDB->query(SELECT * FROM ) called at [X:\home\cot-max.ru\www\plugins\pagethumbs\pagethumbs.page.edit.php:47] #2 include(X:\home\cot-max.ru\www\plugins\pagethumbs\pagethumbs.page.edit.php) called at [X:\home\cot-max.ru\www\modules\page\inc\page.edit.php:193] #3 require_once(X:\home\cot-max.ru\www\modules\page\inc\page.edit.php) called at [X:\home\cot-max.ru\www\modules\page\page.php:43] #4 require_once(X:\home\cot-max.ru\www\modules\page\page.php) called at [X:\home\cot-max.ru\www\index.php:96] Sorry for my English.
|