Hi,
Data to access the site:
Hidden text
I tried to submit my categories (190 of them) directly via MySQL - via a query like this:
INSERT INTO c8rx4_js_res_categories (id , asset_id , parent_id , lft , rgt , level , path , section_id , title , alias , note , description , image , published , checked_out , checked_out_time, access , params , metadesc , metakey , metadata , created_user_id , created_time , modified_user_id , modified_time , hits , language , num_current , num_all , relative_cats) VALUES ('187','0','1','187','188','1','f-a-fricosmos--1-100c','1', 'F A Fricosmos -1.100c','f-a-fricosmos--1-100c','','description','','1','{"submission":"1","category_itemid":"","category_item_itemid":"","orderby":"","records_mode":"","featured_first":"","tmpl_markup":"","tmpl_list":[""],"tmpl_filters":"","tmpl_category":"","tmpl_menu":"","tmpl_compare":""}','','4','','','','','','','','','','','','','');
I then corrected the params field which hadn't inserted correctly, but I can't get the categories to show. What did I do wrong this time, Sergey?
A sample MySQL entry looks like this in the actual database:
INSERT INTO c8rx4_js_res_categories VALUES (54, 0, 1, 54, 55, 1, 'f-a-coldline-1-103b', 1, 'F A Coldline 1.103b', 'f-a-coldline-1-103b', '', '
Manufacturer: Coldline
Serial Code:
Handover Date:
Warranty Expiry Date:
Шкаф холодильный. A120/3M, габариты: 1480 x 715 x 2085 мм, потребл.мощность: 0.48 kW - 230/1/50, вместимость 1200л, GN 2/1 сокращен. - GN 1/1, температурный режим -2/+8 град.С, электронное управление, 2 двери с планкой для руч.запирания,противокап. устройство, работа при температуре окруж.среды до +43град.С, вентиляц.охлаждение, с автоматич. отаиванием и испарением талой воды, дополнительные принадлежности - 3 решетки GN 2/1, 3 комплекта направляющих, исполнение внутри и снаружи из хромоникел.стали
DOCUMENTS
{easyfolderlistingpro method=''list''|folder=''documents/Machine1''}
SERVICE HISTORY
', '', 1, 0, '0000-00-00 00:00:00', 4, '{"submission":"1","category_itemid":"","category_item_itemid":"","orderby":"","records_mode":"","featured_first":"","tmpl_markup":"","tmpl_list":[""],"tmpl_filters":"","tmpl_category":"","tmpl_menu":"","tmpl_compare":""}', '', '', '', 114, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '', 0, 0, '');
Question
Announcement
Conversation
Idea
Praise
Problem
Open
Hi,
Data to access the site:
I tried to submit my categories (190 of them) directly via MySQL - via a query like this:
INSERT INTO
c8rx4_js_res_categories(id,asset_id,parent_id,lft,rgt,level,path,section_id,title,alias,note,description,image,published,checked_out,checked_out_time,access,params,metadesc,metakey,metadata,created_user_id,created_time,modified_user_id,modified_time,hits,language,num_current,num_all,relative_cats) VALUES ('187','0','1','187','188','1','f-a-fricosmos--1-100c','1', 'F A Fricosmos -1.100c','f-a-fricosmos--1-100c','','description','','1','{"submission":"1","category_itemid":"","category_item_itemid":"","orderby":"","records_mode":"","featured_first":"","tmpl_markup":"","tmpl_list":[""],"tmpl_filters":"","tmpl_category":"","tmpl_menu":"","tmpl_compare":""}','','4','','','','','','','','','','','','','');I then corrected the params field which hadn't inserted correctly, but I can't get the categories to show. What did I do wrong this time, Sergey?
A sample MySQL entry looks like this in the actual database:
INSERT INTO
c8rx4_js_res_categoriesVALUES (54, 0, 1, 54, 55, 1, 'f-a-coldline-1-103b', 1, 'F A Coldline 1.103b', 'f-a-coldline-1-103b', '', 'Serial Code:
Handover Date:
Warranty Expiry Date:
Шкаф холодильный. A120/3M, габариты: 1480 x 715 x 2085 мм, потребл.мощность: 0.48 kW - 230/1/50, вместимость 1200л, GN 2/1 сокращен. - GN 1/1, температурный режим -2/+8 град.С, электронное управление, 2 двери с планкой для руч.запирания,противокап. устройство, работа при температуре окруж.среды до +43град.С, вентиляц.охлаждение, с автоматич. отаиванием и испарением талой воды, дополнительные принадлежности - 3 решетки GN 2/1, 3 комплекта направляющих, исполнение внутри и снаружи из хромоникел.стали
DOCUMENTS
{easyfolderlistingpro method=''list''|folder=''documents/Machine1''}
SERVICE HISTORY
', '', 1, 0, '0000-00-00 00:00:00', 4, '{"submission":"1","category_itemid":"","category_item_itemid":"","orderby":"","records_mode":"","featured_first":"","tmpl_markup":"","tmpl_list":[""],"tmpl_filters":"","tmpl_category":"","tmpl_menu":"","tmpl_compare":""}', '', '', '', 114, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '', 0, 0, '');