Собственно вдруг перестали сохраняться настройки, начал лазить искать - поставил новую галеру - работает, после того, как перенес таблицу jos_joomgallery_config на новой галере стало то же самое - настройки не сохраняются. REPAIR TABLE не помогает.
JDatabaseMySQL::query: 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 'gd2', jg_fastgd2thumbcreation = '0', ......бла-бла-бла...... jg_favouritesshownotauth = '1', jg_maxfavourites = '0', jg_zipdownload = '0', jg_usefavouritesforpubliczip = '0', jg_usefavouritesforzip = '0', id = '0' WHERE id = 0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Структура таблицы `jos_joomgallery_config`
--
CREATE TABLE IF NOT EXISTS `jos_joomgallery_config` (
`id` int(1) NOT NULL default '0',
`jg_pathimages` varchar(50) NOT NULL,
`jg_pathoriginalimages` varchar(50) NOT NULL,
`jg_paththumbs` varchar(50) NOT NULL,
`jg_pathftpupload` varchar(50) NOT NULL,
`jg_pathtemp` varchar(50) NOT NULL,
`jg_wmpath` varchar(50) NOT NULL,
`jg_wmfile` varchar(50) NOT NULL,
`jg_dateformat` varchar(50) NOT NULL,
`jg_checkupdate` int(1) NOT NULL,
`jg_filenamewithjs` int(1) NOT NULL,
`jg_filenamesearch` varchar(50) NOT NULL,
`jg_filenamereplace` varchar(50) NOT NULL,
`jg_thumbcreation` varchar(5) NOT NULL,
`jg_fastgd2thumbcreation` int(1) NOT NULL,
`jg_impath` varchar(50) NOT NULL,
`jg_resizetomaxwidth` int(1) NOT NULL,
`jg_maxwidth` int(5) NOT NULL,
`jg_picturequality` int(3) NOT NULL,
`jg_useforresizedirection` int(1) NOT NULL,
`jg_thumbwidth` int(5) NOT NULL,
`jg_thumbheight` int(5) NOT NULL,
`jg_thumbquality` int(3) NOT NULL,
`jg_uploadorder` int(1) NOT NULL,
`jg_useorigfilename` int(1) NOT NULL,
`jg_filenamenumber` int(1) NOT NULL,
`jg_delete_original` int(1) NOT NULL,
`jg_wrongvaluecolor` varchar(10) NOT NULL,
`jg_combuild` int(1) NOT NULL,
`jg_realname` int(1) NOT NULL,
`jg_bridge` int(1) NOT NULL,
`jg_cooliris` int(1) NOT NULL,
`jg_coolirislink` int(1) NOT NULL,
`jg_userspace` int(1) NOT NULL,
`jg_approve` int(1) NOT NULL,
`jg_usercat` int(1) NOT NULL,
`jg_maxusercat` int(5) NOT NULL,
`jg_userowncatsupload` int(1) NOT NULL,
`jg_maxuserimage` int(9) NOT NULL,
`jg_maxfilesize` int(9) NOT NULL,
`jg_category` text NOT NULL,
`jg_usercategory` text NOT NULL,
`jg_usercatacc` int(1) NOT NULL,
`jg_maxuploadfields` int(3) NOT NULL,
`jg_useruploadnumber` int(1) NOT NULL,
`jg_special_gif_upload` int(1) NOT NULL,
`jg_delete_original_user` int(1) NOT NULL,
`jg_newpiccopyright` int(1) NOT NULL,
`jg_newpicnote` int(1) NOT NULL,
`jg_showrating` int(1) NOT NULL,
`jg_maxvoting` int(1) NOT NULL,
`jg_onlyreguservotes` int(1) NOT NULL,
`jg_showcomment` int(1) NOT NULL,
`jg_anoncomment` int(1) NOT NULL,
`jg_namedanoncomment` int(1) NOT NULL,
`jg_approvecom` int(1) NOT NULL,
`jg_secimages` int(1) NOT NULL,
`jg_bbcodesupport` int(1) NOT NULL,
`jg_smiliesupport` int(1) NOT NULL,
`jg_anismilie` int(1) NOT NULL,
`jg_smiliescolor` varchar(10) NOT NULL,
`jg_firstorder` varchar(20) NOT NULL,
`jg_secondorder` varchar(20) NOT NULL,
`jg_thirdorder` varchar(20) NOT NULL,
`jg_pagetitle_cat` varchar(50) NOT NULL,
`jg_pagetitle_detail` varchar(50) NOT NULL,
`jg_showgalleryhead` int(1) NOT NULL,
`jg_showpathway` int(1) NOT NULL,
`jg_completebreadcrumbs` int(1) NOT NULL,
`jg_search` int(1) NOT NULL,
`jg_showallpics` int(1) NOT NULL,
`jg_showallhits` int(1) NOT NULL,
`jg_showbacklink` int(1) NOT NULL,
`jg_suppresscredits` int(1) NOT NULL,
`jg_showuserpanel` int(1) NOT NULL,
`jg_showallpicstoadmin` int(1) NOT NULL,
`jg_showminithumbs` int(1) NOT NULL,
`jg_openjs_padding` int(3) NOT NULL,
`jg_openjs_background` varchar(10) NOT NULL,
`jg_dhtml_border` varchar(10) NOT NULL,
`jg_show_title_in_dhtml` int(1) NOT NULL,
`jg_show_description_in_dhtml` int(1) NOT NULL,
`jg_lightbox_speed` int(3) NOT NULL,
`jg_lightbox_slide_all` int(1) NOT NULL,
`jg_resize_js_image` int(1) NOT NULL,
`jg_disable_rightclick_original` int(1) NOT NULL,
`jg_showgallerysubhead` int(1) NOT NULL,
`jg_showallcathead` int(1) NOT NULL,
`jg_colcat` int(1) NOT NULL,
`jg_catperpage` int(1) NOT NULL,
`jg_ordercatbyalpha` int(1) NOT NULL,
`jg_showgallerypagenav` int(1) NOT NULL,
`jg_showcatcount` int(1) NOT NULL,
`jg_showcatthumb` int(1) NOT NULL,
`jg_showrandomcatthumb` int(1) NOT NULL,
`jg_ctalign` int(1) NOT NULL,
`jg_showtotalcathits` int(1) NOT NULL,
`jg_showcatasnew` int(1) NOT NULL,
`jg_catdaysnew` int(3) NOT NULL,
`jg_rmsm` int(1) NOT NULL,
`jg_showrmsmcats` int(1) NOT NULL,
`jg_showsubsingalleryview` int(1) NOT NULL,
`jg_showcathead` int(1) NOT NULL,
`jg_usercatorder` int(1) NOT NULL,
`jg_usercatorderlist` varchar(50) NOT NULL,
`jg_showcatdescriptionincat` int(1) NOT NULL,
`jg_showpagenav` int(1) NOT NULL,
`jg_showpiccount` int(1) NOT NULL,
`jg_perpage` int(3) NOT NULL,
`jg_catthumbalign` int(1) NOT NULL,
`jg_colnumb` int(3) NOT NULL,
`jg_detailpic_open` int(1) NOT NULL,
`jg_lightboxbigpic` int(1) NOT NULL,
`jg_showtitle` int(1) NOT NULL,
`jg_showpicasnew` int(1) NOT NULL,
`jg_daysnew` int(3) NOT NULL,
`jg_showhits` int(1) NOT NULL,
`jg_showauthor` int(1) NOT NULL,
`jg_showowner` int(1) NOT NULL,
`jg_showcatcom` int(1) NOT NULL,
`jg_showcatrate` int(1) NOT NULL,
`jg_showcatdescription` int(1) NOT NULL,
`jg_showcategorydownload` int(1) NOT NULL,
`jg_showcategoryfavourite` int(1) NOT NULL,
`jg_showsubcathead` int(1) NOT NULL,
`jg_showsubcatcount` int(1) NOT NULL,
`jg_colsubcat` int(3) NOT NULL,
`jg_subperpage` int(3) NOT NULL,
`jg_showpagenavsubs` int(1) NOT NULL,
`jg_subcatthumbalign` int(1) NOT NULL,
`jg_showsubthumbs` int(1) NOT NULL,
`jg_showrandomsubthumb` int(1) NOT NULL,
`jg_ordersubcatbyalpha` int(1) NOT NULL,
`jg_showtotalsubcathits` int(1) NOT NULL,
`jg_showdetailpage` int(1) NOT NULL,
`jg_showdetailnumberofpics` int(1) NOT NULL,
`jg_cursor_navigation` int(1) NOT NULL,
`jg_disable_rightclick_detail` int(1) NOT NULL,
`jg_showdetailtitle` int(1) NOT NULL,
`jg_showdetail` int(1) NOT NULL,
`jg_showdetailaccordion` int(1) NOT NULL,
`jg_showdetaildescription` int(1) NOT NULL,
`jg_showdetaildatum` int(1) NOT NULL,
`jg_showdetailhits` int(1) NOT NULL,
`jg_showdetailrating` int(1) NOT NULL,
`jg_showdetailfilesize` int(1) NOT NULL,
`jg_showdetailauthor` int(1) NOT NULL,
`jg_showoriginalfilesize` int(1) NOT NULL,
`jg_showdetaildownload` int(1) NOT NULL,
`jg_downloadfile` int(1) NOT NULL,
`jg_downloadwithwatermark` int(1) NOT NULL,
`jg_watermark` int(1) NOT NULL,
`jg_watermarkpos` int(1) NOT NULL,
`jg_bigpic` int(1) NOT NULL,
`jg_bigpic_open` int(1) NOT NULL,
`jg_bbcodelink` int(1) NOT NULL,
`jg_showcommentsunreg` int(1) NOT NULL,
`jg_showcommentsarea` int(1) NOT NULL,
`jg_send2friend` int(1) NOT NULL,
`jg_minis` int(1) NOT NULL,
`jg_motionminis` int(1) NOT NULL,
`jg_motionminiWidth` int(3) NOT NULL,
`jg_motionminiHeight` int(3) NOT NULL,
`jg_miniWidth` int(3) NOT NULL,
`jg_miniHeight` int(3) NOT NULL,
`jg_minisprop` int(1) NOT NULL,
`jg_nameshields` int(1) NOT NULL,
`jg_nameshields_unreg` int(1) NOT NULL,
`jg_show_nameshields_unreg` int(1) NOT NULL,
`jg_nameshields_height` int(3) NOT NULL,
`jg_nameshields_width` int(3) NOT NULL,
`jg_slideshow` int(1) NOT NULL,
`jg_slideshow_timer` int(3) NOT NULL,
`jg_slideshow_usefilter` int(1) NOT NULL,
`jg_slideshow_filterbychance` int(1) NOT NULL,
`jg_slideshow_filtertimer` int(3) NOT NULL,
`jg_showsliderepeater` int(1) NOT NULL,
`jg_showexifdata` int(1) NOT NULL,
`jg_subifdtags` text NOT NULL,
`jg_ifdotags` text NOT NULL,
`jg_gpstags` text NOT NULL,
`jg_showiptcdata` int(1) NOT NULL,
`jg_iptctags` text NOT NULL,
`jg_showtoplist` int(1) NOT NULL,
`jg_toplist` int(3) NOT NULL,
`jg_topthumbalign` int(1) NOT NULL,
`jg_toptextalign` int(1) NOT NULL,
`jg_toplistcols` int(3) NOT NULL,
`jg_whereshowtoplist` int(1) NOT NULL,
`jg_showrate` int(1) NOT NULL,
`jg_showlatest` int(1) NOT NULL,
`jg_showcom` int(1) NOT NULL,
`jg_showthiscomment` int(1) NOT NULL,
`jg_showmostviewed` int(1) NOT NULL,
`jg_favourites` int(1) NOT NULL,
`jg_showdetailfavourite` int(1) NOT NULL,
`jg_favouritesshownotauth` int(1) NOT NULL,
`jg_maxfavourites` int(5) NOT NULL,
`jg_zipdownload` int(1) NOT NULL,
`jg_usefavouritesforpubliczip` int(1) NOT NULL,
`jg_usefavouritesforzip` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `jos_joomgallery_config`
--
UPDATE `jos_joomgallery_config` SET `id` = 0,`jg_pathimages` = 'components/com_joomgallery/img_pictures/',`jg_pathoriginalimages` = 'components/com_joomgallery/img_originals/',`jg_paththumbs` = 'components/com_joomgallery/img_thumbnails/',`jg_pathftpupload` = 'components/com_joomgallery/ftp_upload/',`jg_pathtemp` = 'administrator/components/com_joomgallery/temp/',`jg_wmpath` = 'components/com_joomgallery/assets/images/',`jg_wmfile` = 'watermark.png',`jg_dateformat` = '%d.%m.%Y %H:%M:%S',`jg_checkupdate` = 1,`jg_filenamewithjs` = 1,`jg_filenamesearch` = 'a|o|u|?|"',`jg_filenamereplace` = 'ae|oe|ue|ss|''',`jg_thumbcreation` = 'gd2',`jg_fastgd2thumbcreation` = 0,`jg_impath` = '',`jg_resizetomaxwidth` = 1,`jg_maxwidth` = 300,`jg_picturequality` = 70,`jg_useforresizedirection` = 0,`jg_thumbwidth` = 180,`jg_thumbheight` = 80,`jg_thumbquality` = 70,`jg_uploadorder` = 2,`jg_useorigfilename` = 0,`jg_filenamenumber` = 0,`jg_delete_original` = 0,`jg_wrongvaluecolor` = '#f00',`jg_combuild` = 0,`jg_realname` = 0,`jg_bridge` = 0,`jg_cooliris` = 0,`jg_coolirislink` = 0,`jg_userspace` = 1,`jg_approve` = 0,`jg_usercat` = 0,`jg_maxusercat` = 10,`jg_userowncatsupload` = 0,`jg_maxuserimage` = 100,`jg_maxfilesize` = 174080,`jg_category` = '4,26,25,11,12,9,7,13,10,8,23,22,21,24,14,16,6,36,15,20,19,18,17,35,30,28,29,32,34,31,33',`jg_usercategory` = '',`jg_usercatacc` = 0,`jg_maxuploadfields` = 1,`jg_useruploadnumber` = 0,`jg_special_gif_upload` = 0,`jg_delete_original_user` = 0,`jg_newpiccopyright` = 1,`jg_newpicnote` = 1,`jg_showrating` = 1,`jg_maxvoting` = 5,`jg_onlyreguservotes` = 0,`jg_showcomment` = 0,`jg_anoncomment` = 0,`jg_namedanoncomment` = 0,`jg_approvecom` = 0,`jg_secimages` = 0,`jg_bbcodesupport` = 0,`jg_smiliesupport` = 0,`jg_anismilie` = 0,`jg_smiliescolor` = 'grey',`jg_firstorder` = 'imgdate DESC',`jg_secondorder` = 'imgtitle ASC',`jg_thirdorder` = 'ordering DESC',`jg_pagetitle_cat` = '[! JGS_CATEGORY!]: #cat',`jg_pagetitle_detail` = '[! JGS_CATEGORY!]: #cat - [! JGS_PICTURE!]: #img',`jg_showgalleryhead` = 1,`jg_showpathway` = 1,`jg_completebreadcrumbs` = 1,`jg_search` = 1,`jg_showallpics` = 1,`jg_showallhits` = 1,`jg_showbacklink` = 2,`jg_suppresscredits` = 0,`jg_showuserpanel` = 3,`jg_showallpicstoadmin` = 1,`jg_showminithumbs` = 1,`jg_openjs_padding` = 10,`jg_openjs_background` = '#fff',`jg_dhtml_border` = '#808080',`jg_show_title_in_dhtml` = 1,`jg_show_description_in_dhtml` = 1,`jg_lightbox_speed` = 5,`jg_lightbox_slide_all` = 1,`jg_resize_js_image` = 0,`jg_disable_rightclick_original` = 0,`jg_showgallerysubhead` = 1,`jg_showallcathead` = 1,`jg_colcat` = 2,`jg_catperpage` = 10,`jg_ordercatbyalpha` = 0,`jg_showgallerypagenav` = 3,`jg_showcatcount` = 1,`jg_showcatthumb` = 0,`jg_showrandomcatthumb` = 1,`jg_ctalign` = 1,`jg_showtotalcathits` = 1,`jg_showcatasnew` = 0,`jg_catdaysnew` = 7,`jg_rmsm` = 0,`jg_showrmsmcats` = 0,`jg_showsubsingalleryview` = 1,`jg_showcathead` = 1,`jg_usercatorder` = 0,`jg_usercatorderlist` = 'date,user,hits,rating',`jg_showcatdescriptionincat` = 1,`jg_showpagenav` = 3,`jg_showpiccount` = 1,`jg_perpage` = 12,`jg_catthumbalign` = 1,`jg_colnumb` = 3,`jg_detailpic_open` = 0,`jg_lightboxbigpic` = 1,`jg_showtitle` = 1,`jg_showpicasnew` = 1,`jg_daysnew` = 7,`jg_showhits` = 1,`jg_showauthor` = 0,`jg_showowner` = 0,`jg_showcatcom` = 0,`jg_showcatrate` = 0,`jg_showcatdescription` = 0,`jg_showcategorydownload` = 0,`jg_showcategoryfavourite` = 1,`jg_showsubcathead` = 1,`jg_showsubcatcount` = 1,`jg_colsubcat` = 2,`jg_subperpage` = 8,`jg_showpagenavsubs` = 1,`jg_subcatthumbalign` = 1,`jg_showsubthumbs` = 1,`jg_showrandomsubthumb` = 3,`jg_ordersubcatbyalpha` = 0,`jg_showtotalsubcathits` = 1,`jg_showdetailpage` = 1,`jg_showdetailnumberofpics` = 1,`jg_cursor_navigation` = 0,`jg_disable_rightclick_detail` = 0,`jg_showdetailtitle` = 1,`jg_showdetail` = 1,`jg_showdetailaccordion` = 0,`jg_showdetaildescription` = 1,`jg_showdetaildatum` = 1,`jg_showdetailhits` = 1,`jg_showdetailrating` = 1,`jg_showdetailfilesize` = 0,`jg_showdetailauthor` = 1,`jg_showoriginalfilesize` = 1,`jg_showdetaildownload` = 0,`jg_downloadfile` = 2,`jg_downloadwithwatermark` = 1,`jg_watermark` = 0,`jg_watermarkpos` = 9,`jg_bigpic` = 1,`jg_bigpic_open` = 1,`jg_bbcodelink` = 3,`jg_showcommentsunreg` = 0,`jg_showcommentsarea` = 2,`jg_send2friend` = 0,`jg_minis` = 1,`jg_motionminis` = 2,`jg_motionminiWidth` = 600,`jg_motionminiHeight` = 50,`jg_miniWidth` = 50,`jg_miniHeight` = 50,`jg_minisprop` = 2,`jg_nameshields` = 0,`jg_nameshields_unreg` = 0,`jg_show_nameshields_unreg` = 0,`jg_nameshields_height` = 10,`jg_nameshields_width` = 6,`jg_slideshow` = 0,`jg_slideshow_timer` = 3,`jg_slideshow_usefilter` = 0,`jg_slideshow_filterbychance` = 0,`jg_slideshow_filtertimer` = 1,`jg_showsliderepeater` = 0,`jg_showexifdata` = 0,`jg_subifdtags` = '',`jg_ifdotags` = '',`jg_gpstags` = '',`jg_showiptcdata` = 0,`jg_iptctags` = '',`jg_showtoplist` = 1,`jg_toplist` = 15,`jg_topthumbalign` = 1,`jg_toptextalign` = 1,`jg_toplistcols` = 3,`jg_whereshowtoplist` = 0,`jg_showrate` = 1,`jg_showlatest` = 1,`jg_showcom` = 0,`jg_showthiscomment` = 1,`jg_showmostviewed` = 1,`jg_favourites` = 1,`jg_showdetailfavourite` = 0,`jg_favouritesshownotauth` = 1,`jg_maxfavourites` = 0,`jg_zipdownload` = 0,`jg_usefavouritesforpubliczip` = 0,`jg_usefavouritesforzip` = 0 WHERE `jos_joomgallery_config`.`id` = 0;
12.01.2017, 22:36:16