• 03-04-2015, 23:26:02
    #1
    Merhaba arkadaşlar, wordpress e bir sql yedeği yüklemek istiyorum sadece sqlde takıldım. tüm yedekleri ftp ye attım(dosyalar) fakat burada takıldım nerede hata yapıyorum ?




    SQL sorgusu:
    -- -- Tablo döküm verisi `wp_layerslider` -- INSERT INTO `wp_layerslider` (`id`, `author`, `name`, `slug`, `data`, `date_c`, `date_m`, `flag_hidden`, `flag_deleted`) VALUES (1, 1, 'Avada Full Width', '', '{"properties":{"title":"Avada Full Width","width":"100%","height":"400px","forceresponsive":"on","responsiveunder":"960","sublayercontainer":"960","autostart":"on","pauseonhover":"on","firstlayer":"1","animatefirstlayer":"on","twowayslideshow":"on","loops":"0","forceloopnum":"on","autopauseslideshow":"auto","youtubepreview":"maxresdefault.jpg","keybnav":"on","touchnav":"on","skin":"avada","backgroundcolor":"#f6f6f6","backgroundimage":"","sliderstyle":"","navprevnext":"on","navstartstop":"on","navbuttons":"on","circletimer":"on","thumb_nav":"hover","thumb_width":"100","thumb_height":"60","thumb_container_width":"60%","thumb_active_opacity":"35","thumb_inactive_opacity":"100","imgpreload":"on","bodyinclude":"on","yourlogo":"","yourlogostyle":"","yourlogolink":"","yourlogotarget":"_[...]
    
    MySQL çıktısı: Belgeler
    
    #1062 - Duplicate entry '1' for key 'PRIMARY'


    yüklemek istediğim sql

    (1, 1, 'Avada Full Width', '', '{"properties":{"title":"Avada Full Width","width":"100%","height":"400px","forceresponsive":"on","responsiveunder":"960","sublayercontainer":"960","autostart":"on","pauseonhover":"on","firstlayer":"1","animatefirstlayer":"on","twowayslideshow":"on","loops":"0","forceloopnum":"on","autopauseslideshow":"auto","youtubepreview":"maxresdefault.jpg","keybnav":"on","touchnav":"on","skin":"avada","backgroundcolor":"#f6f6f6","backgroundimage":"","sliderstyle":"","navprevnext":"on","navstartstop":"on","navbuttons":"on","circletimer":"on","thumb_nav":"hover","thumb_width":"100","thumb_height":"60","thumb_container_width":"60%","thumb_active_opacity":"35","thumb_inactive_opacity":"100","imgpreload":"on","bodyinclude":"on","yourlogo":"","yourlogostyle":"","yourlogolink":"","yourlogotarget":"_self","cbinit":"function(element) { }","cbstart":"function(data) { }","cbstop":"function(data) { }","cbpause":"function(data) { }","cbanimstart":"function(data) { }","cbanimstop":"function(data) { }","cbprev":"function(data) { }","cbnext":"function(data) { }"},"layers":[{"properties":{"3d_transitions":"","2d_transitions":"","custom_3d_transitions":"","custom_2d_transitions":"","background":"","thumbnail":"","slidedelay":"6000","new_transitions":"on","slidedirection":"right","timeshift":"0","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","durationout":"1500","easingout":"easeInOutQuint","delayout":"0","layer_link":"","layer_link_target":"_self","id":"","deeplink":""},"sublayers":[{"subtitle":"Clouds","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/slide_4.jpg","html":"","slidedirection":"fade","durationin":"1000","easingin":"easeInOutQuint","delayin":"0","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"0px","left":"0px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"Mac","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/mac.png","html":"","slidedirection":"left","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"34px","left":"506px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"iPad","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/ipad2.png","html":"","slidedirection":"top","durationin":"1500","easingin":"easeInOutQuint","delayin":"400","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"157px","left":"457px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"iPhone","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/iphone.png","html":"","slidedirection":"right","durationin":"1500","easingin":"easeInOutQuint","delayin":"800","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"209px","left":"403px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"Avada Wordpress Theme","type":"h1","image":"","html":"Avada Wordpress Theme","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"1400","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"font-family\\\\\\":\\\\\\"serif\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"40\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\"}","top":"83px","left":"1px","style":"","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Made With Care...","type":"h1","image":"","html":"Made With Care For Our Users","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1800","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"357\\\\\\",\\\\\\"height\\\\\\":\\\\\\"38\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"24\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"38\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#a0ce4e\\\\\\"}","top":"135px","left":"1px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Lid est laborum ...","type":"p","image":"","html":"Lid est laborum dolo rumes fugats untras. Et harums ser quidem<br \\/> \\r\\nrerum facilisdolores nemis omnis fugiats vitaes nemo minima<br \\/> \\r\\nrerums unsers sadips amets sadips ipsums","slidedirection":"fade","durationin":"1000","easingin":"easeInOutQuint","delayin":"2200","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\"}","top":"195px","left":"2px","style":"","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Purchase Now","type":"p","image":"","html":"<a href=\\\\\\"http:\\/\\/themeforest.net\\/user\\/ThemeFusion\\\\\\" class=\\\\\\"button large green\\\\\\">Purchase Now<\\/a>","slidedirection":"bottom","durationin":"2000","easingin":"easeInOutQuint","delayin":"2400","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"279px","left":"1px","style":"","id":"","class":"","title":"","alt":"","rel":""}]},{"properties":{"3d_transitions":"","2d_transitions":"","custom_3d_transitions":"","custom_2d_transitions":"","background":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/slide_5.jpg","thumbnail":"","slidedelay":"4000","new_transitions":"on","slidedirection":"right","timeshift":"0","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","durationout":"1500","easingout":"easeInOutQuint","delayout":"0","layer_link":"","layer_link_target":"_self","id":"","deeplink":"","backgroundId":""},"sublayers":[{"subtitle":"iPad","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/ipad.png","html":"","slidedirection":"right","durationin":"2000","easingin":"easeInOutQuint","delayin":"0","rotatein":"0","scalein":".2","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"54px","left":"-1px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"Avada Is Better ...","type":"h1","image":"","html":"Avada Is Better Than Ever","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"700","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"295\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#a0ce4e\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#333333\\\\\\"}","top":"67px","left":"666px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"100% Fully Responsive","type":"h1","image":"","html":"100% Fully Responsive","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1100","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"250\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#a0ce4e\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#333333\\\\\\"}","top":"106px","left":"711px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"With Numerous","type":"h1","image":"","html":"With Numerous","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"1500","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"190\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#a0ce4e\\\\\\"}","top":"175px","left":"770px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Additions & Optimizations","type":"h1","image":"","html":"Additions & Optimizations","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1800","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"285\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#a0ce4e\\\\\\"}","top":"215px","left":"675px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"It Doesn\\\\''t Get Better","type":"h1","image":"","html":"It Doesn\\\\''t Get Better Than This","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"2100","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"342\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#a0ce4e\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#333333\\\\\\"}","top":"289px","left":"617px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""}]},{"properties":{"3d_transitions":"","2d_transitions":"","custom_3d_transitions":"","custom_2d_transitions":"","background":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/slide_3.jpg","thumbnail":"","slidedelay":"4000","new_transitions":"on","slidedirection":"right","timeshift":"0","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","durationout":"1500","easingout":"easeInOutQuint","delayout":"0","layer_link":"","layer_link_target":"_self","id":"","deeplink":"","backgroundId":""},"sublayers":[{"subtitle":"Create Fantastic...","type":"h1","image":"","html":"Create Fantastic Sliders With Animations","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"200","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"430\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"21px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#000000\\\\\\"}","top":"82px","left":"270px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Be Creative","type":"h1","image":"","html":"BE CREATIVE","slidedirection":"right","durationin":"1000","easingin":"easeInOutQuint","delayin":"700","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"font-size\\\\\\":\\\\\\"150px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\"}","top":"178px","left":"81px","style":"text-align: center; font-weight: normal; text-shadow: 0px 2px 5px rgba(0, 0, 0, 1);","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"The Possibilities Are...","type":"h1","image":"","html":"The Possibilities Are Endless And Results Stunning","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1000","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"515\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"21px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#000000\\\\\\"}","top":"275px","left":"232px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""}]}]}', 1400170289, 1400170289, 0, 0),
  • 04-04-2015, 03:55:06
    #2
    veritabanına eklemeye calıstıgınız (1, 1, 'Avada Full Width' id = 1 varmış daha önce farklı id ile deneyin isterseniz hocam.
  • 04-04-2015, 10:11:56
    #3
    tayfaturk adlı üyeden alıntı: mesajı görüntüle
    Merhaba arkadaşlar, wordpress e bir sql yedeği yüklemek istiyorum sadece sqlde takıldım. tüm yedekleri ftp ye attım(dosyalar) fakat burada takıldım nerede hata yapıyorum ?




    SQL sorgusu:
    -- -- Tablo döküm verisi `wp_layerslider` -- INSERT INTO `wp_layerslider` (`id`, `author`, `name`, `slug`, `data`, `date_c`, `date_m`, `flag_hidden`, `flag_deleted`) VALUES (1, 1, 'Avada Full Width', '', '{"properties":{"title":"Avada Full Width","width":"100%","height":"400px","forceresponsive":"on","responsiveunder":"960","sublayercontainer":"960","autostart":"on","pauseonhover":"on","firstlayer":"1","animatefirstlayer":"on","twowayslideshow":"on","loops":"0","forceloopnum":"on","autopauseslideshow":"auto","youtubepreview":"maxresdefault.jpg","keybnav":"on","touchnav":"on","skin":"avada","backgroundcolor":"#f6f6f6","backgroundimage":"","sliderstyle":"","navprevnext":"on","navstartstop":"on","navbuttons":"on","circletimer":"on","thumb_nav":"hover","thumb_width":"100","thumb_height":"60","thumb_container_width":"60%","thumb_active_opacity":"35","thumb_inactive_opacity":"100","imgpreload":"on","bodyinclude":"on","yourlogo":"","yourlogostyle":"","yourlogolink":"","yourlogotarget":"_[...]
    
    MySQL çıktısı: Belgeler
    
    #1062 - Duplicate entry '1' for key 'PRIMARY'


    yüklemek istediğim sql

    (1, 1, 'Avada Full Width', '', '{"properties":{"title":"Avada Full Width","width":"100%","height":"400px","forceresponsive":"on","responsiveunder":"960","sublayercontainer":"960","autostart":"on","pauseonhover":"on","firstlayer":"1","animatefirstlayer":"on","twowayslideshow":"on","loops":"0","forceloopnum":"on","autopauseslideshow":"auto","youtubepreview":"maxresdefault.jpg","keybnav":"on","touchnav":"on","skin":"avada","backgroundcolor":"#f6f6f6","backgroundimage":"","sliderstyle":"","navprevnext":"on","navstartstop":"on","navbuttons":"on","circletimer":"on","thumb_nav":"hover","thumb_width":"100","thumb_height":"60","thumb_container_width":"60%","thumb_active_opacity":"35","thumb_inactive_opacity":"100","imgpreload":"on","bodyinclude":"on","yourlogo":"","yourlogostyle":"","yourlogolink":"","yourlogotarget":"_self","cbinit":"function(element) { }","cbstart":"function(data) { }","cbstop":"function(data) { }","cbpause":"function(data) { }","cbanimstart":"function(data) { }","cbanimstop":"function(data) { }","cbprev":"function(data) { }","cbnext":"function(data) { }"},"layers":[{"properties":{"3d_transitions":"","2d_transitions":"","custom_3d_transitions":"","custom_2d_transitions":"","background":"","thumbnail":"","slidedelay":"6000","new_transitions":"on","slidedirection":"right","timeshift":"0","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","durationout":"1500","easingout":"easeInOutQuint","delayout":"0","layer_link":"","layer_link_target":"_self","id":"","deeplink":""},"sublayers":[{"subtitle":"Clouds","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/slide_4.jpg","html":"","slidedirection":"fade","durationin":"1000","easingin":"easeInOutQuint","delayin":"0","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"0px","left":"0px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"Mac","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/mac.png","html":"","slidedirection":"left","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"34px","left":"506px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"iPad","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/ipad2.png","html":"","slidedirection":"top","durationin":"1500","easingin":"easeInOutQuint","delayin":"400","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"157px","left":"457px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"iPhone","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/iphone.png","html":"","slidedirection":"right","durationin":"1500","easingin":"easeInOutQuint","delayin":"800","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"209px","left":"403px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"Avada Wordpress Theme","type":"h1","image":"","html":"Avada Wordpress Theme","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"1400","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"font-family\\\\\\":\\\\\\"serif\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"40\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\"}","top":"83px","left":"1px","style":"","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Made With Care...","type":"h1","image":"","html":"Made With Care For Our Users","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1800","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"357\\\\\\",\\\\\\"height\\\\\\":\\\\\\"38\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"24\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"38\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#a0ce4e\\\\\\"}","top":"135px","left":"1px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Lid est laborum ...","type":"p","image":"","html":"Lid est laborum dolo rumes fugats untras. Et harums ser quidem<br \\/> \\r\\nrerum facilisdolores nemis omnis fugiats vitaes nemo minima<br \\/> \\r\\nrerums unsers sadips amets sadips ipsums","slidedirection":"fade","durationin":"1000","easingin":"easeInOutQuint","delayin":"2200","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\"}","top":"195px","left":"2px","style":"","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Purchase Now","type":"p","image":"","html":"<a href=\\\\\\"http:\\/\\/themeforest.net\\/user\\/ThemeFusion\\\\\\" class=\\\\\\"button large green\\\\\\">Purchase Now<\\/a>","slidedirection":"bottom","durationin":"2000","easingin":"easeInOutQuint","delayin":"2400","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"279px","left":"1px","style":"","id":"","class":"","title":"","alt":"","rel":""}]},{"properties":{"3d_transitions":"","2d_transitions":"","custom_3d_transitions":"","custom_2d_transitions":"","background":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/slide_5.jpg","thumbnail":"","slidedelay":"4000","new_transitions":"on","slidedirection":"right","timeshift":"0","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","durationout":"1500","easingout":"easeInOutQuint","delayout":"0","layer_link":"","layer_link_target":"_self","id":"","deeplink":"","backgroundId":""},"sublayers":[{"subtitle":"iPad","type":"img","image":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/ipad.png","html":"","slidedirection":"right","durationin":"2000","easingin":"easeInOutQuint","delayin":"0","rotatein":"0","scalein":".2","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{}","top":"54px","left":"-1px","style":"","id":"","class":"","title":"","alt":"","rel":"","imageId":""},{"subtitle":"Avada Is Better ...","type":"h1","image":"","html":"Avada Is Better Than Ever","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"700","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"295\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#a0ce4e\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#333333\\\\\\"}","top":"67px","left":"666px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"100% Fully Responsive","type":"h1","image":"","html":"100% Fully Responsive","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1100","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"250\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#a0ce4e\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#333333\\\\\\"}","top":"106px","left":"711px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"With Numerous","type":"h1","image":"","html":"With Numerous","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"1500","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"190\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#a0ce4e\\\\\\"}","top":"175px","left":"770px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Additions & Optimizations","type":"h1","image":"","html":"Additions & Optimizations","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1800","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"285\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#333333\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#a0ce4e\\\\\\"}","top":"215px","left":"675px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"It Doesn\\\\''t Get Better","type":"h1","image":"","html":"It Doesn\\\\''t Get Better Than This","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"2100","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"342\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"22px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#a0ce4e\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#333333\\\\\\"}","top":"289px","left":"617px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""}]},{"properties":{"3d_transitions":"","2d_transitions":"","custom_3d_transitions":"","custom_2d_transitions":"","background":"http:\\/\\/theme-fusion.com\\/avadaxml\\/wp-content\\/uploads\\/2013\\/10\\/slide_3.jpg","thumbnail":"","slidedelay":"4000","new_transitions":"on","slidedirection":"right","timeshift":"0","durationin":"1500","easingin":"easeInOutQuint","delayin":"0","durationout":"1500","easingout":"easeInOutQuint","delayout":"0","layer_link":"","layer_link_target":"_self","id":"","deeplink":"","backgroundId":""},"sublayers":[{"subtitle":"Create Fantastic...","type":"h1","image":"","html":"Create Fantastic Sliders With Animations","slidedirection":"top","durationin":"1000","easingin":"easeInOutQuint","delayin":"200","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"430\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"21px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#000000\\\\\\"}","top":"82px","left":"270px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"Be Creative","type":"h1","image":"","html":"BE CREATIVE","slidedirection":"right","durationin":"1000","easingin":"easeInOutQuint","delayin":"700","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"font-size\\\\\\":\\\\\\"150px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\"}","top":"178px","left":"81px","style":"text-align: center; font-weight: normal; text-shadow: 0px 2px 5px rgba(0, 0, 0, 1);","id":"","class":"","title":"","alt":"","rel":""},{"subtitle":"The Possibilities Are...","type":"h1","image":"","html":"The Possibilities Are Endless And Results Stunning","slidedirection":"bottom","durationin":"1000","easingin":"easeInOutQuint","delayin":"1000","rotatein":"0","scalein":"1.0","slideoutdirection":"auto","durationout":"1000","easingout":"easeInOutQuint","delayout":"0","rotateout":"0","scaleout":"1.0","level":"-1","showuntil":"0","url":"","target":"_self","styles":"{\\\\\\"width\\\\\\":\\\\\\"515\\\\\\",\\\\\\"height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"font-size\\\\\\":\\\\\\"21px\\\\\\",\\\\\\"line-height\\\\\\":\\\\\\"35\\\\\\",\\\\\\"color\\\\\\":\\\\\\"#ffffff\\\\\\",\\\\\\"background\\\\\\":\\\\\\"#000000\\\\\\"}","top":"275px","left":"232px","style":"text-align: center; font-weight: normal;","id":"","class":"","title":"","alt":"","rel":""}]}]}', 1400170289, 1400170289, 0, 0),
    Yuklemek istediginiz sql deki ilk (1' olan yeri (NULL, olarak degistirip denerseniz olacaktir.

    Sent from my GT-I9200 using Tapatalk
  • 04-04-2015, 10:19:27
    #4
    mtl adlı üyeden alıntı: mesajı görüntüle
    Yuklemek istediginiz sql deki ilk (1' olan yeri (NULL, olarak degistirip denerseniz olacaktir.

    Sent from my GT-I9200 using Tapatalk
    Şimdi NULL olarak değiştirdim tekrardan olmadı hocam.
  • 04-04-2015, 10:22:07
    #5
    tayfaturk adlı üyeden alıntı: mesajı görüntüle
    Şimdi NULL olarak değiştirdim tekrardan olmadı hocam.
    Ayni hatayi mi veriyor baska hata mi?

    Sent from my GT-I9200 using Tapatalk
  • 04-04-2015, 10:25:28
    #6
    mtl adlı üyeden alıntı: mesajı görüntüle
    Ayni hatayi mi veriyor baska hata mi?

    Sent from my GT-I9200 using Tapatalk
    hocam id 1 i null yaptım yüklemeye çalıştım sonra duplicate "2" hatasını aldım sonra aynı işlemi 2. id'e de yaptım tekrar yükledim sonrasında şu hatayı verdi

    #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 ' 'Avada Full Width', '', '{"properties":{"title":"Avada Full Width","width":"100' at line 6
  • 04-04-2015, 10:37:31
    #7
    tayfaturk adlı üyeden alıntı: mesajı görüntüle
    hocam id 1 i null yaptım yüklemeye çalıştım sonra duplicate "2" hatasını aldım sonra aynı işlemi 2. id'e de yaptım tekrar yükledim sonrasında şu hatayı verdi

    #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 ' 'Avada Full Width', '', '{"properties":{"title":"Avada Full Width","width":"100' at line 6
    Null verince duplicate 2 hatasi vermesi ilginc. Tablodaki id ve author yapisi nedir. Su durumda ID mutlaka auto increment olmali. Eger 1 yerine tabloda kayitli olmayan bir sayi yazdiginizda da hata veriyorsa...

    Sent from my GT-I9200 using Tapatalk
  • 04-04-2015, 10:43:46
    #8
    mtl adlı üyeden alıntı: mesajı görüntüle
    Null verince duplicate 2 hatasi vermesi ilginc. Tablodaki id ve author yapisi nedir. Su durumda ID mutlaka auto increment olmali. Eger 1 yerine tabloda kayitli olmayan bir sayi yazdiginizda da hata veriyorsa...

    Sent from my GT-I9200 using Tapatalk
    hocam ben sıfırdan oluşturulmuş bir veritabanın üzerine yüklemeye çalışıyorum bu sql i acaba ondan kaynaklı olabilir mi ?
  • 04-04-2015, 14:04:12
    #9
    id yi direk bos bırakın null de yazmanıza da gerek yok. Inser Into (`author`, `name`, ...
    şeklinde deneyin id ile işlem yapmayın otomatik atıyor