maternal
Welcome, Guest. Please login or register.
Did you miss your activation email?

 
Advanced search

22744 Posts in 6702 Topics- by 17593 Members - Latest Member: permsk

18-09-2019 07:55:25
JOOM::GALLERY::FORUMArchiveJoomGallery 2.x ACLMigrationAn error has occured
Pages: [1]
Print
Author Topic: An error has occured  (Read 2300 times)
0 Members and 1 Guest are viewing this topic.
erickpaulino
Newbie
*
Offline Offline

Posts: 2


View Profile
« on: 10-10-2014 21:15:09 »

Hello,

I am trying to migrate from J15 to J30, but I'm having some issues. The Joomgallery version on j15 is 1.5.7.5 (it was automatically updated). I am doing all steps described in the migration walkthrough, except putting tables in the same DB, since this new migration plugin has an option for remote database. When I click on Start Migration, it takes a few seconds and then give me this error:


Code:
An error has occurred.
 0 SQL=SELECT jg_use_real_paths,jg_dateformat,jg_checkupdate,jg_thumbcreation,jg_fastgd2thumbcreation,jg_impath,jg_resizetomaxwidth,jg_maxwidth,jg_picturequality,jg_useforresizedirection,jg_cropposition,jg_thumbwidth,jg_thumbheight,jg_thumbquality,jg_uploadorder,jg_useorigfilename,jg_filenamenumber,jg_delete_original,jg_wrongvaluecolor,jg_msg_upload_type,jg_msg_upload_recipients,jg_msg_download_type,jg_msg_zipdownload,jg_msg_download_recipients,jg_msg_comment_type,jg_msg_comment_recipients,jg_msg_comment_toowner,jg_msg_nametag_type,jg_msg_nametag_recipients,jg_msg_nametag_totaggeduser,jg_msg_nametag_toowner,jg_msg_report_type,jg_msg_report_recipients,jg_msg_report_toowner,jg_realname,jg_cooliris,jg_coolirislink,jg_contentpluginsenabled,jg_itemid,jg_userspace,jg_approve,jg_maxusercat,jg_maxuserimage,jg_maxfilesize,jg_usercatacc,jg_maxuploadfields,jg_useruploadsingle,jg_useruploadbatch,jg_useruploadjava,jg_useruseorigfilename,jg_useruploadnumber,jg_special_gif_upload,jg_delete_original_user,jg_newpiccopyright,jg_newpicnote,jg_redirect_after_upload,jg_downloadfile,jg_downloadwithwatermark,jg_showrating,jg_maxvoting,jg_ratingcalctype,jg_ratingdisplaytype,jg_ajaxrating,jg_onlyreguservotes AS jg_votingonlyonce,jg_showcomment,jg_anoncomment,jg_namedanoncomment,jg_approvecom,jg_bbcodesupport,jg_smiliesupport,jg_anismilie,jg_smiliescolor,jg_anchors,jg_tooltips,jg_dyncrop,jg_dyncropposition,jg_dyncropwidth,jg_dyncropheight,jg_dyncropbgcol,jg_hideemptycats,jg_imgalign,jg_firstorder,jg_secondorder,jg_thirdorder,jg_showgalleryhead,jg_showpathway,jg_completebreadcrumbs,jg_showallpics,jg_showallhits,jg_showbacklink,jg_suppresscredits,jg_showrmsmcats AS jg_showrestrictedcats,jg_rmsm AS jg_showrestrictedhint,jg_showallpicstoadmin,jg_showminithumbs,jg_openjs_padding,jg_openjs_background,jg_dhtml_border,jg_show_title_in_dhtml AS jg_show_title_in_popup,jg_show_description_in_dhtml AS jg_show_description_in_popup,jg_lightbox_speed,jg_lightbox_slide_all,jg_resize_js_image,jg_disable_rightclick_original,jg_showgallerysubhead,jg_showallcathead,jg_colcat,jg_catperpage,jg_ordercatbyalpha,jg_showgallerypagenav,jg_showcatcount,jg_showcatthumb,jg_showrandomcatthumb,jg_ctalign,jg_showtotalcatimages,jg_showtotalcathits,jg_showcatasnew,jg_catdaysnew,jg_showdescriptioningalleryview,jg_showsubsingalleryview,jg_category_rss,jg_showcathead,jg_usercatorder,jg_usercatorderlist,jg_showcatdescriptionincat,jg_showpagenav,jg_showpiccount,jg_perpage,jg_catthumbalign,jg_colnumb,jg_detailpic_open,jg_lightboxbigpic,jg_showtitle,jg_showpicasnew,jg_daysnew,jg_showhits,jg_showauthor,jg_showowner,jg_showcatcom,jg_showcatrate,jg_showcatdescription,jg_showcategoryfavourite,jg_showcategoryeditorlinks,jg_showsubcathead,jg_showsubcatcount,jg_colsubcat,jg_subperpage,jg_showpagenavsubs,jg_subcatthumbalign,jg_showsubthumbs,jg_showrandomsubthumb,jg_showdescriptionincategoryview,jg_ordersubcatbyalpha,jg_showtotalsubcatimages,jg_showtotalsubcathits,jg_showdetailpage,jg_disabledetailpage,jg_showdetailnumberofpics,jg_cursor_navigation,jg_disable_rightclick_detail,jg_showdetaileditorlinks,jg_showdetailtitle,jg_showdetail,jg_showdetailaccordion,jg_showdetaildescription,jg_showdetaildatum,jg_showdetailhits,jg_showdetailrating,jg_showdetailfilesize,jg_showdetailauthor,jg_showoriginalfilesize,jg_watermark,jg_watermarkpos,jg_bigpic,jg_bigpic_open,jg_bbcodelink,jg_showcommentsunreg,jg_showcommentsarea,jg_send2friend,jg_minis,jg_motionminis,jg_motionminiWidth,jg_motionminiHeight,jg_miniWidth,jg_miniHeight,jg_minisprop,jg_nameshields,jg_nameshields_others,jg_nameshields_unreg,jg_show_nameshields_unreg,jg_nameshields_height,jg_nameshields_width,jg_slideshow,jg_slideshow_timer,jg_slideshow_transition,jg_slideshow_transtime,jg_slideshow_maxdimauto,jg_slideshow_width,jg_slideshow_heigth,jg_slideshow_infopane,jg_slideshow_carousel,jg_slideshow_arrows,jg_slideshow_repeat,jg_showexifdata,jg_geotagging,jg_subifdtags,jg_ifdotags,jg_gpstags,jg_showiptcdata,jg_iptctags,jg_showtoplist,jg_toplist,jg_topthumbalign,jg_toptextalign,jg_toplistcols,jg_whereshowtoplist,jg_showrate,jg_showlatest,jg_showcom,jg_showthiscomment,jg_showmostviewed,jg_showtoplistfavourite,jg_showtoplisteditorlinks,jg_favourites,jg_favouritesshownotauth,jg_maxfavourites,jg_zipdownload,jg_usefavouritesforpubliczip,jg_usefavouritesforzip,jg_showfavouriteseditorlinks,jg_search,jg_searchcols,jg_searchthumbalign,jg_searchtextalign,jg_showsearchfavourite,jg_showsearcheditorlinks FROM jos_joomgallery_config WHERE id = 1

Any help?

Thank you
Logged
erickpaulino
Newbie
*
Offline Offline

Posts: 2


View Profile
« Reply #1 on: 10-10-2014 21:31:54 »

Update:

I have tried to manually import the j15 database tables to the new j3 (actually is Joomla 3.2.2) so I could perform the migration exactly as recommended in the tutorial, i.e., all tables in the same database. I got a new error message:

Code:
An error has occurred.
 1054 Unknown column 'jg_use_real_paths' in 'field list' SQL=SELECT jg_use_real_paths,jg_dateformat,jg_checkupdate,jg_thumbcreation,jg_fastgd2thumbcreation,jg_impath,jg_resizetomaxwidth,jg_maxwidth,jg_picturequality,jg_useforresizedirection,jg_cropposition,jg_thumbwidth,jg_thumbheight,jg_thumbquality,jg_uploadorder,jg_useorigfilename,jg_filenamenumber,jg_delete_original,jg_wrongvaluecolor,jg_msg_upload_type,jg_msg_upload_recipients,jg_msg_download_type,jg_msg_zipdownload,jg_msg_download_recipients,jg_msg_comment_type,jg_msg_comment_recipients,jg_msg_comment_toowner,jg_msg_nametag_type,jg_msg_nametag_recipients,jg_msg_nametag_totaggeduser,jg_msg_nametag_toowner,jg_msg_report_type,jg_msg_report_recipients,jg_msg_report_toowner,jg_realname,jg_cooliris,jg_coolirislink,jg_contentpluginsenabled,jg_itemid,jg_userspace,jg_approve,jg_maxusercat,jg_maxuserimage,jg_maxfilesize,jg_usercatacc,jg_maxuploadfields,jg_useruploadsingle,jg_useruploadbatch,jg_useruploadjava,jg_useruseorigfilename,jg_useruploadnumber,jg_special_gif_upload,jg_delete_original_user,jg_newpiccopyright,jg_newpicnote,jg_redirect_after_upload,jg_downloadfile,jg_downloadwithwatermark,jg_showrating,jg_maxvoting,jg_ratingcalctype,jg_ratingdisplaytype,jg_ajaxrating,jg_onlyreguservotes AS jg_votingonlyonce,jg_showcomment,jg_anoncomment,jg_namedanoncomment,jg_approvecom,jg_bbcodesupport,jg_smiliesupport,jg_anismilie,jg_smiliescolor,jg_anchors,jg_tooltips,jg_dyncrop,jg_dyncropposition,jg_dyncropwidth,jg_dyncropheight,jg_dyncropbgcol,jg_hideemptycats,jg_imgalign,jg_firstorder,jg_secondorder,jg_thirdorder,jg_showgalleryhead,jg_showpathway,jg_completebreadcrumbs,jg_showallpics,jg_showallhits,jg_showbacklink,jg_suppresscredits,jg_showrmsmcats AS jg_showrestrictedcats,jg_rmsm AS jg_showrestrictedhint,jg_showallpicstoadmin,jg_showminithumbs,jg_openjs_padding,jg_openjs_background,jg_dhtml_border,jg_show_title_in_dhtml AS jg_show_title_in_popup,jg_show_description_in_dhtml AS jg_show_description_in_popup,jg_lightbox_speed,jg_lightbox_slide_all,jg_resize_js_image,jg_disable_rightclick_original,jg_showgallerysubhead,jg_showallcathead,jg_colcat,jg_catperpage,jg_ordercatbyalpha,jg_showgallerypagenav,jg_showcatcount,jg_showcatthumb,jg_showrandomcatthumb,jg_ctalign,jg_showtotalcatimages,jg_showtotalcathits,jg_showcatasnew,jg_catdaysnew,jg_showdescriptioningalleryview,jg_showsubsingalleryview,jg_category_rss,jg_showcathead,jg_usercatorder,jg_usercatorderlist,jg_showcatdescriptionincat,jg_showpagenav,jg_showpiccount,jg_perpage,jg_catthumbalign,jg_colnumb,jg_detailpic_open,jg_lightboxbigpic,jg_showtitle,jg_showpicasnew,jg_daysnew,jg_showhits,jg_showauthor,jg_showowner,jg_showcatcom,jg_showcatrate,jg_showcatdescription,jg_showcategoryfavourite,jg_showcategoryeditorlinks,jg_showsubcathead,jg_showsubcatcount,jg_colsubcat,jg_subperpage,jg_showpagenavsubs,jg_subcatthumbalign,jg_showsubthumbs,jg_showrandomsubthumb,jg_showdescriptionincategoryview,jg_ordersubcatbyalpha,jg_showtotalsubcatimages,jg_showtotalsubcathits,jg_showdetailpage,jg_disabledetailpage,jg_showdetailnumberofpics,jg_cursor_navigation,jg_disable_rightclick_detail,jg_showdetaileditorlinks,jg_showdetailtitle,jg_showdetail,jg_showdetailaccordion,jg_showdetaildescription,jg_showdetaildatum,jg_showdetailhits,jg_showdetailrating,jg_showdetailfilesize,jg_showdetailauthor,jg_showoriginalfilesize,jg_watermark,jg_watermarkpos,jg_bigpic,jg_bigpic_open,jg_bbcodelink,jg_showcommentsunreg,jg_showcommentsarea,jg_send2friend,jg_minis,jg_motionminis,jg_motionminiWidth,jg_motionminiHeight,jg_miniWidth,jg_miniHeight,jg_minisprop,jg_nameshields,jg_nameshields_others,jg_nameshields_unreg,jg_show_nameshields_unreg,jg_nameshields_height,jg_nameshields_width,jg_slideshow,jg_slideshow_timer,jg_slideshow_transition,jg_slideshow_transtime,jg_slideshow_maxdimauto,jg_slideshow_width,jg_slideshow_heigth,jg_slideshow_infopane,jg_slideshow_carousel,jg_slideshow_arrows,jg_slideshow_repeat,jg_showexifdata,jg_geotagging,jg_subifdtags,jg_ifdotags,jg_gpstags,jg_showiptcdata,jg_iptctags,jg_showtoplist,jg_toplist,jg_topthumbalign,jg_toptextalign,jg_toplistcols,jg_whereshowtoplist,jg_showrate,jg_showlatest,jg_showcom,jg_showthiscomment,jg_showmostviewed,jg_showtoplistfavourite,jg_showtoplisteditorlinks,jg_favourites,jg_favouritesshownotauth,jg_maxfavourites,jg_zipdownload,jg_usefavouritesforpubliczip,jg_usefavouritesforzip,jg_showfavouriteseditorlinks,jg_search,jg_searchcols,jg_searchthumbalign,jg_searchtextalign,jg_showsearchfavourite,jg_showsearcheditorlinks FROM jos_joomgallery_config WHERE id = 1

Please, any help?

Thank you...
Logged
MrMusic
Administrator
Hero Member
*****
Offline Offline

Posts: 1084



View Profile
« Reply #2 on: 10-12-2014 16:06:34 »

Hi,

does the error occur when you click at "Check" or later?
There are entries in the table jos_joomgallery_config when you open it by using phpmyadmin?
Logged

From now on there is the support for the JoomGallery here: forum.en.joomgalleryfriends.net
Pages: [1]
Print
Jump to:  

HOSTED BY SCHWARZKÜNSTLER ®

PROTECTED BY  ZB BLOCK  AND Project Honey Pot
Theme orange-lt created by panic

Bad Behavior has blocked 12453 access attempts in the last 7 days.

maternal