Создала, пытаюсь создать товар (нажимию создать страницу), забиваю данные, все ок. Но когда нажимаю "опубликовать", почему-то выдаются ошибки. И выводит даже мои пароли и данные.
Fatal error
2014-07-01 09:17
SQL error 42S22: Column not found: 1054 Unknown column 'c_pages.page_prod_manufacturer_id' in 'on clause'
#0 cot_diefatal(SQL error 42S22: Column not found: 1054 Unknown column 'c_pages.page_prod_manufacturer_id' in 'on clause') called at [/www/system/database.php:576]
#1 CotDB->query(SELECT `c_pages`.*, m.page_id as _manufacturer_id, m.page_title as _mf_title, m.page_desc as _mf_desc,
m.page_cat as _mf_cat, m.page_alias as _mf_alias,
pp.price_id as _price_id, pp.price_price as _price, pp.price_override as _price_override,
pp.price_override_price as _price_override_price, pp.price_tax_id as _price_tax_id,
pp.price_discount_id as _price_discount_id, pp.price_currency as _price_currency
FROM c_pages
LEFT JOIN c_pages as m ON m.page_id=`c_pages`.page_prod_manufacturer_id
LEFT JOIN c_shop_product_prices as pp ON pp.product_id=`c_pages`.page_id AND price_primary=1
LEFT JOIN c_structure as cat ON cat.structure_code=`c_pages`.page_cat AND cat.structure_area='page'
WHERE (`c_pages`.`page_id` = :page_id) AND (`c_pages`.page_state=0 OR (`c_pages`.page_state=2 AND 1)) AND (`c_pages`.page_cat IN ('shop')) ORDER BY `c_pages`.`page_id` ASC LIMIT 0, 1, Array ([page_id] => 6)) called at [/www/modules/shop/models/Product.php:511]
#2 Product::fetch(page_id = '6', 1) called at [/www//modules/shop/models/ShopModelAbstract.php(245) : eval()'d code:1]
#3 eval() called at [/www/modules/shop/models/ShopModelAbstract.php:245]
#4 ShopModelAbstract::getById(6) called at [/www/modules/shop/models/Product.php:249]
#5 Product::loadInfoByPag(Array ([page_id] => 6,[page_alias] => ,[page_state] => 0,[page_cat] => shop,[page_title] => Кран,[page_desc] => ,[page_keywords] => Кран,[page_metatitle] => Кран,[page_metadesc] => Кран,[page_text] =>
Кран
моя почта
,[page_parser] => html,[page_author] => ,[page_ownerid] => 1,[page_date] => 1404206220,[page_begin] => 1404205800,[page_expire] => 0,[page_updated] => 1404206220,[page_file] => 0,[page_url] => ,[page_size] => 0,[page_count] => 0,[page_rating] => 0.00,[page_filecount] => 0,[user_id] => 1,[user_banexpire] => 0,[user_name] => ВЫВОДИТ МОЙ ЛОГИН,[user_password] => ВЫВОДИТ МОЙ ПАРОЛЬ,[user_passfunc] => МОИ ДАННЫЕ,[user_passsalt] => МОИ ДАННЫЕ,[user_maingrp] => 5,[user_country] => ,[user_timezone] => GMT,[user_text] => ,[user_birthdate] => 0000-00-00,[user_gender] => U,[user_email] => МОЯ ПОЧТА,[user_hideemail] => 1,[user_theme] => bootlance,[user_scheme] => default,[user_lang] => ru,[user_regdate] => 1395344838,[user_lastlog] => 1404206221,[user_lastvisit] => 1404166279,[user_lastip] => МОИ ДАННЫЕ,[user_logcount] => МОИ ДАННЫЕ,[user_sid] => МОИ ДАННЫЕ,[user_sidtime] => МОИ ДАННЫЕ,[user_lostpass] => ,[user_auth] => a:17:{s:5:"admin";a:1:{s:1:"a";i:255;}s:5:"folio";a:7:{s:1:"a";i:255;s:6:"design";i:255;s:2:"hm";i:255;s:5:"logos";i:255;s:5:"photo";i:255;s:5:"sites";i:255;s:4:"soft";i:255;}s:6:"forums";a:4:{s:1:"a";i:255;s:7:"general";i:255;s:8:"offtopic";i:255;s:3:"pub";i:255;}s:5:"index";a:1:{s:1:"a";i:255;}s:6:"market";a:7:{s:1:"a";i:255;s:6:"design";i:255;s:2:"hm";i:255;s:5:"logos";i:255;s:5:"photo";i:255;s:5:"sites";i:255;s:4:"soft";i:255;}s:7:"message";a:1:{s:1:"a";i:255;}s:4:"page";a:6:{s:1:"a";i:255;s:8:"articles";i:255;s:6:"events";i:255;s:4:"news";i:255;s:4:"shop";i:255;s:6:"system";i:255;}s:8:"payments";a:1:{s:1:"a";i:255;}s:3:"pfs";a:1:{s:1:"a";i:255;}s:4:"plug";a:46:{s:12:"autocomplete";i:255;s:7:"banlist";i:255;s:6:"bbcode";i:255;s:8:"ckeditor";i:255;s:7:"cleaner";i:255;s:8:"comments";i:255;s:7:"contact";i:255;s:12:"hiddengroups";i:255;s:4:"hits";i:255;s:4:"html";i:255;s:12:"htmlpurifier";i:255;s:4:"i18n";i:255;s:13:"ikassabilling";i:255;s:8:"ipsearch";i:255;s:16:"locationselector";i:255;s:8:"mavatars";i:255;s:13:"mavatarslance";i:255;s:8:"mcaptcha";i:255;s:4:"news";i:255;s:11:"nullbilling";i:255;s:10:"payprjbold";i:255;s:9:"payprjtop";i:255;s:6:"paypro";i:255;s:6:"paytop";i:255;s:9:"phpmailer";i:255;s:7:"ratings";i:255;s:11:"recentitems";i:255;s:8:"referers";i:255;s:7:"reviews";i:255;s:12:"roboxbilling";i:255;s:6:"search";i:255;s:7:"sitemap";i:255;s:11:"sp_standart";i:255;s:19:"ss_weight_countries";i:255;s:10:"statistics";i:255;s:4:"tags";i:255;s:9:"tagslance";i:255;s:8:"trashcan";i:255;s:9:"urleditor";i:255;s:13:"useragreement";i:255;s:14:"usercategories";i:255;s:17:"usergroupselector";i:255;s:10:"userimages";i:255;s:10:"userpoints";i:255;s:10:"whosonline";i:255;s:9:"wmbilling";i:255;}s:2:"pm";a:1:{s:1:"a";i:255;}s:5:"polls";a:1:{s:1:"a";i:255;}s:8:"projects";a:11:{s:1:"a";i:255;s:12:"construction";i:255;s:10:"consulting";i:255;s:6:"design";i:255;s:7:"gamedev";i:255;s:10:"management";i:255;s:9:"marketing";i:255;s:5:"photo";i:255;s:11:"programming";i:255;s:3:"seo";i:255;s:5:"texts";i:255;}s:3:"rss";a:1:{s:1:"a";i:255;}s:4:"shop";a:1:{s:1:"a";i:255;}s:9:"structure";a:1:{s:1:"a";i:255;}s:5:"users";a:1:{s:1:"a";i:255;}},[user_token] => e3815140697bcea1,[user_postcount] => 0,[user_pmnotify] => 0,[user_newpm] => 0,[user_pro] => 0,[user_region] => 0,[user_city] => 0,[user_userpoints] => 14,[user_avatar] => ,[user_photo] => ,[user_usergroup] => 0,[user_agreed] => ,[user_company] => ,[user_firstname] => ,[user_middlename] => ,[user_lastname] => ,[user_address] => ,[user_zip] => 0,[user_city_name] => ,[user_region_name] => ,[user_phone] => ,[page_begin_noformat] => 1404205800,[page_tab] => 0,[page_pageurl] => shop/6,[page_fulltitle] => Title of your site / Shop / Кран,[page_fileicon] => ,[page_status] => published)) called at [/www/modules/shop/models/Product.php:858]
#6 Product::generateTags(Array ([page_id] => 6,[page_alias] => ,[page_state] => 0,[page_cat] => shop,[page_title] => Кран,[page_desc] => ,[page_keywords] => Кран,[page_metatitle] => Кран,[page_metadesc] => Кран,[page_text] =>
Кран
МОЯ ПОЧТА
,[page_parser] => html,[page_author] => ,[page_ownerid] => 1,[page_date] => 1404206220,[page_begin] => 1404205800,[page_expire] => 0,[page_updated] => 1404206220,[page_file] => 0,[page_url] => ,[page_size] => 0,[page_count] => 0,[page_rating] => 0.00,[page_filecount] => 0,[user_id] => 1,[user_banexpire] => 0,[user_name] => ВЫВОДИТ МОЙ ЛОГИН,[user_password] => ВЫВОДИТ МОЙ ПАРОЛЬ,[user_passfunc] => МОИ ДАННЫЕ,[user_passsalt] => МОИ ДАННЫЕ,[user_maingrp] => 5,[user_country] => ,[user_timezone] => GMT,[user_text] => ,[user_birthdate] => 0000-00-00,[user_gender] => U,[user_email] => МОЯ ПОЧТА,[user_hideemail] => 1,[user_theme] => bootlance,[user_scheme] => default,[user_lang] => ru,[user_regdate] => 1395344838,[user_lastlog] => 1404206221,[user_lastvisit] => 1404166279,[user_lastip] => МОИ ДАННЫЕ,[user_logcount] => МОИ ДАННЫЕ,[user_sid] => МОИ ДАННЫЕ,[user_sidtime] => МОИ ДАННЫЕ,[user_lostpass] => ,[user_auth] => a:17:{s:5:"admin";a:1:{s:1:"a";i:255;}s:5:"folio";a:7:{s:1:"a";i:255;s:6:"design";i:255;s:2:"hm";i:255;s:5:"logos";i:255;s:5:"photo";i:255;s:5:"sites";i:255;s:4:"soft";i:255;}s:6:"forums";a:4:{s:1:"a";i:255;s:7:"general";i:255;s:8:"offtopic";i:255;s:3:"pub";i:255;}s:5:"index";a:1:{s:1:"a";i:255;}s:6:"market";a:7:{s:1:"a";i:255;s:6:"design";i:255;s:2:"hm";i:255;s:5:"logos";i:255;s:5:"photo";i:255;s:5:"sites";i:255;s:4:"soft";i:255;}s:7:"message";a:1:{s:1:"a";i:255;}s:4:"page";a:6:{s:1:"a";i:255;s:8:"articles";i:255;s:6:"events";i:255;s:4:"news";i:255;s:4:"shop";i:255;s:6:"system";i:255;}s:8:"payments";a:1:{s:1:"a";i:255;}s:3:"pfs";a:1:{s:1:"a";i:255;}s:4:"plug";a:46:{s:12:"autocomplete";i:255;s:7:"banlist";i:255;s:6:"bbcode";i:255;s:8:"ckeditor";i:255;s:7:"cleaner";i:255;s:8:"comments";i:255;s:7:"contact";i:255;s:12:"hiddengroups";i:255;s:4:"hits";i:255;s:4:"html";i:255;s:12:"htmlpurifier";i:255;s:4:"i18n";i:255;s:13:"ikassabilling";i:255;s:8:"ipsearch";i:255;s:16:"locationselector";i:255;s:8:"mavatars";i:255;s:13:"mavatarslance";i:255;s:8:"mcaptcha";i:255;s:4:"news";i:255;s:11:"nullbilling";i:255;s:10:"payprjbold";i:255;s:9:"payprjtop";i:255;s:6:"paypro";i:255;s:6:"paytop";i:255;s:9:"phpmailer";i:255;s:7:"ratings";i:255;s:11:"recentitems";i:255;s:8:"referers";i:255;s:7:"reviews";i:255;s:12:"roboxbilling";i:255;s:6:"search";i:255;s:7:"sitemap";i:255;s:11:"sp_standart";i:255;s:19:"ss_weight_countries";i:255;s:10:"statistics";i:255;s:4:"tags";i:255;s:9:"tagslance";i:255;s:8:"trashcan";i:255;s:9:"urleditor";i:255;s:13:"useragreement";i:255;s:14:"usercategories";i:255;s:17:"usergroupselector";i:255;s:10:"userimages";i:255;s:10:"userpoints";i:255;s:10:"whosonline";i:255;s:9:"wmbilling";i:255;}s:2:"pm";a:1:{s:1:"a";i:255;}s:5:"polls";a:1:{s:1:"a";i:255;}s:8:"projects";a:11:{s:1:"a";i:255;s:12:"construction";i:255;s:10:"consulting";i:255;s:6:"design";i:255;s:7:"gamedev";i:255;s:10:"management";i:255;s:9:"marketing";i:255;s:5:"photo";i:255;s:11:"programming";i:255;s:3:"seo";i:255;s:5:"texts";i:255;}s:3:"rss";a:1:{s:1:"a";i:255;}s:4:"shop";a:1:{s:1:"a";i:255;}s:9:"structure";a:1:{s:1:"a";i:255;}s:5:"users";a:1:{s:1:"a";i:255;}},[user_token] => e3815140697bcea1,[user_postcount] => 0,[user_pmnotify] => 0,[user_newpm] => 0,[user_pro] => 0,[user_region] => 0,[user_city] => 0,[user_userpoints] => 14,[user_avatar] => ,[user_photo] => ,[user_usergroup] => 0,[user_agreed] => ,[user_company] => ,[user_firstname] => ,[user_middlename] => ,[user_lastname] => ,[user_address] => ,[user_zip] => 0,[user_city_name] => ,[user_region_name] => ,[user_phone] => ,[page_begin_noformat] => 1404205800,[page_tab] => 0,[page_pageurl] => shop/6,[page_fulltitle] => Title of your site / Shop / Кран,[page_fileicon] => ,[page_status] => published)) called at [/www/modules/shop/shop.pagetags.main.php:32]
#7 include(/www/modules/shop/shop.pagetags.main.php) called at [/www/modules/page/inc/page.functions.php:265]
#8 cot_generate_pagetags(Array ([page_id] => 6,[page_alias] => ,[page_state] => 0,[page_cat] => shop,[page_title] => Кран,[page_desc] => ,[page_keywords] => Кран,[page_metatitle] => Кран,[page_metadesc] => Кран,[page_text] =>
Кран
,[page_parser] => html,[page_author] => ,[page_ownerid] => 1,[page_date] => 1404206220,[page_begin] => 1404205800,[page_expire] => 0,[page_updated] => 1404206220,[page_file] => 0,[page_url] => ,[page_size] => 0,[page_count] => 0,[page_rating] => 0.00,[page_filecount] => 0,[user_id] => 1,[user_banexpire] => 0,[user_name] => ВЫВОДИТ МОЙ ЛОГИН,[user_password] => ВЫВОДИТ МОЙ ПАРОЛЬ,[user_passfunc] => МОИ ДАННЫЕ,[user_passsalt] => МОИ ДАННЫЕ,[user_maingrp] => 5,[user_country] => ,[user_timezone] => GMT,[user_text] => ,[user_birthdate] => 0000-00-00,[user_gender] => U,[user_email] => МОЯ ПОЧТА,[user_hideemail] => 1,[user_theme] => bootlance,[user_scheme] => default,[user_lang] => ru,[user_regdate] => 1395344838,[user_lastlog] => 1404206221,[user_lastvisit] => 1404166279,[user_lastip] => МОИ ДАННЫЕ,[user_logcount] => МОИ ДАННЫЕ,[user_sid] => МОИ ДАННЫЕ,[user_sidtime] => МОИ ДАННЫЕ,[user_lostpass] => ,[user_auth] => a:17:{s:5:"admin";a:1:{s:1:"a";i:255;}s:5:"folio";a:7:{s:1:"a";i:255;s:6:"design";i:255;s:2:"hm";i:255;s:5:"logos";i:255;s:5:"photo";i:255;s:5:"sites";i:255;s:4:"soft";i:255;}s:6:"forums";a:4:{s:1:"a";i:255;s:7:"general";i:255;s:8:"offtopic";i:255;s:3:"pub";i:255;}s:5:"index";a:1:{s:1:"a";i:255;}s:6:"market";a:7:{s:1:"a";i:255;s:6:"design";i:255;s:2:"hm";i:255;s:5:"logos";i:255;s:5:"photo";i:255;s:5:"sites";i:255;s:4:"soft";i:255;}s:7:"message";a:1:{s:1:"a";i:255;}s:4:"page";a:6:{s:1:"a";i:255;s:8:"articles";i:255;s:6:"events";i:255;s:4:"news";i:255;s:4:"shop";i:255;s:6:"system";i:255;}s:8:"payments";a:1:{s:1:"a";i:255;}s:3:"pfs";a:1:{s:1:"a";i:255;}s:4:"plug";a:46:{s:12:"autocomplete";i:255;s:7:"banlist";i:255;s:6:"bbcode";i:255;s:8:"ckeditor";i:255;s:7:"cleaner";i:255;s:8:"comments";i:255;s:7:"contact";i:255;s:12:"hiddengroups";i:255;s:4:"hits";i:255;s:4:"html";i:255;s:12:"htmlpurifier";i:255;s:4:"i18n";i:255;s:13:"ikassabilling";i:255;s:8:"ipsearch";i:255;s:16:"locationselector";i:255;s:8:"mavatars";i:255;s:13:"mavatarslance";i:255;s:8:"mcaptcha";i:255;s:4:"news";i:255;s:11:"nullbilling";i:255;s:10:"payprjbold";i:255;s:9:"payprjtop";i:255;s:6:"paypro";i:255;s:6:"paytop";i:255;s:9:"phpmailer";i:255;s:7:"ratings";i:255;s:11:"recentitems";i:255;s:8:"referers";i:255;s:7:"reviews";i:255;s:12:"roboxbilling";i:255;s:6:"search";i:255;s:7:"sitemap";i:255;s:11:"sp_standart";i:255;s:19:"ss_weight_countries";i:255;s:10:"statistics";i:255;s:4:"tags";i:255;s:9:"tagslance";i:255;s:8:"trashcan";i:255;s:9:"urleditor";i:255;s:13:"useragreement";i:255;s:14:"usercategories";i:255;s:17:"usergroupselector";i:255;s:10:"userimages";i:255;s:10:"userpoints";i:255;s:10:"whosonline";i:255;s:9:"wmbilling";i:255;}s:2:"pm";a:1:{s:1:"a";i:255;}s:5:"polls";a:1:{s:1:"a";i:255;}s:8:"projects";a:11:{s:1:"a";i:255;s:12:"construction";i:255;s:10:"consulting";i:255;s:6:"design";i:255;s:7:"gamedev";i:255;s:10:"management";i:255;s:9:"marketing";i:255;s:5:"photo";i:255;s:11:"programming";i:255;s:3:"seo";i:255;s:5:"texts";i:255;}s:3:"rss";a:1:{s:1:"a";i:255;}s:4:"shop";a:1:{s:1:"a";i:255;}s:9:"structure";a:1:{s:1:"a";i:255;}s:5:"users";a:1:{s:1:"a";i:255;}},[user_token] => e3815140697bcea1,[user_postcount] => 0,[user_pmnotify] => 0,[user_newpm] => 0,[user_pro] => 0,[user_region] => 0,[user_city] => 0,[user_userpoints] => 14,[user_avatar] => ,[user_photo] => ,[user_usergroup] => 0,[user_agreed] => ,[user_company] => ,[user_firstname] => ,[user_middlename] => ,[user_lastname] => ,[user_address] => ,[user_zip] => 0,[user_city_name] => ,[user_region_name] => ,[user_phone] => ,[page_begin_noformat] => 1404205800,[page_tab] => 0,[page_pageurl] => shop/6), PAGE_, 0, 1, 1) called at [/www/modules/page/inc/page.main.php:159]
#9 require_once(/www/modules/page/inc/page.main.php) called at [/www/modules/page/page.php:43]
#10 require_once(/www/modules/page/page.php) called at [/www/index.php:126]
Добавлено 4 минуты спустя:
И страница mydomen.ru/shop теперь тоже не открывается, до того, как попыталась опубликовать товар, открывалась. А сейчас выдает ошибки
Fatal error
2014-07-01 09:29
SQL error 42S22: Column not found: 1054 Unknown column 'c_pages.page_prod_manufacturer_id' in 'on clause'
#0 cot_diefatal(SQL error 42S22: Column not found: 1054 Unknown column 'c_pages.page_prod_manufacturer_id' in 'on clause') called at [/www/system/database.php:576]
#1 CotDB->query(SELECT `c_pages`.*, m.page_id as _manufacturer_id, m.page_title as _mf_title, m.page_desc as _mf_desc,
m.page_cat as _mf_cat, m.page_alias as _mf_alias,
pp.price_id as _price_id, pp.price_price as _price, pp.price_override as _price_override,
pp.price_override_price as _price_override_price, pp.price_tax_id as _price_tax_id,
pp.price_discount_id as _price_discount_id, pp.price_currency as _price_currency
FROM c_pages
LEFT JOIN c_pages as m ON m.page_id=`c_pages`.page_prod_manufacturer_id
LEFT JOIN c_shop_product_prices as pp ON pp.product_id=`c_pages`.page_id AND price_primary=1
LEFT JOIN c_structure as cat ON cat.structure_code=`c_pages`.page_cat AND cat.structure_area='page'
WHERE (`c_pages`.`page_id` IN ('3','4','5','6')) AND (`c_pages`.page_state=0 OR (`c_pages`.page_state=2 AND 1)) AND (`c_pages`.page_cat IN ('shop')) ORDER BY `c_pages`.`page_id` ASC , Array ()) called at [/www/modules/shop/models/Product.php:511]
#2 Product::fetch(Array ([0] => Array ([0] => page_id,[1] => Array ([0] => 3,[1] => 4,[2] => 5,[3] => 6))), 0, 0, ) called at [/www/modules/shop/models/ShopModelAbstract.php(219) : eval()'d code:1]
#3 eval() called at [/www/modules/shop/models/ShopModelAbstract.php:219]
#4 ShopModelAbstract::find(Array ([0] => Array ([0] => page_id,[1] => Array ([0] => 3,[1] => 4,[2] => 5,[3] => 6)))) called at [/www/modules/shop/shop.page.list.before_loop.php:38]
#5 include(/www/modules/shop/shop.page.list.before_loop.php) called at [/www/modules/page/inc/page.list.php:386]
#6 require_once(/www/modules/page/inc/page.list.php) called at [/www/modules/page/page.php:43]
#7 require_once(/www/modules/page/page.php) called at [/www/index.php:126]