Warning: [mysql error 1062] Duplicate entry '7' for key 'PRIMARY'

INSERT  INTO piwigo_categories
  (id,dir,name,site_id,id_uppercat,uppercats,commentable,visible,status,rank,global_rank)
  VALUES('7','ftp_up_free','ftp up free','1','3','3,7','true','false','public','3','3.3')
  , ('8','giptv','giptv','1','7','3,7,8','true','false','public','1','3.3.1')
  , ('9','video','video','1','7','3,7,9','true','false','public','2','3.3.2')
  , ('10','iptv_list','iptv list','1','3','3,10','true','false','public','4','3.4')
  , ('11','ftp_up_lock2','ftp up lock2','1','3','3,11','true','false','public','5','3.5')
  , ('12','photo_data_mount','photo data mount','1','11','3,11,12','true','false','public','1','3.5.1')
  , ('13','piwigo_photo_all_mount','piwigo photo all mount','1','11','3,11,13','true','false','public','2','3.5.2')
  , ('14','photo_lock','photo lock','1','13','3,11,13,14','true','false','public','1','3.5.2.1')
  , ('15','1_photo_사진첩','1 photo 사진첩','1','14','3,11,13,14,15','true','false','public','1','3.5. in /volume1/web/piw/include/dblayer/functions_mysqli.inc.php on line 845

Call Stack:
    0.0000     245328   1. {main}() /volume1/web/piw/admin.php:0
    0.0105     874824   2. include('/volume1/web/piw/admin/site_update.php') /volume1/web/piw/admin.php:312
   13.4292    2828504   3. mass_inserts() /volume1/web/piw/admin/site_update.php:317
   13.4324    2893392   4. pwg_query() /volume1/web/piw/include/dblayer/functions_mysqli.inc.php:565
   13.4357    2893616   5. my_error() /volume1/web/piw/include/dblayer/functions_mysqli.inc.php:147
   13.4357    2958328   6. trigger_error() /volume1/web/piw/include/dblayer/functions_mysqli.inc.php:845

Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 4

SELECT id
  FROM piwigo_images
  WHERE storage_category_id IN (
)
; in /volume1/web/piw/include/dblayer/functions_mysqli.inc.php on line 845

Call Stack:
    0.0000     245328   1. {main}() /volume1/web/piw/admin.php:0
    0.0105     874824   2. include('/volume1/web/piw/admin/site_update.php') /volume1/web/piw/admin.php:312
   13.4767    2878968   3. delete_categories() /volume1/web/piw/admin/site_update.php:459
   13.4787    2879448   4. query2array() /volume1/web/piw/admin/include/functions.php:86
   13.4787    2879448   5. pwg_query() /volume1/web/piw/include/dblayer/functions_mysqli.inc.php:886
   13.4789    2879608   6. my_error() /volume1/web/piw/include/dblayer/functions_mysqli.inc.php:147
   13.4789    2880016   7. trigger_error() /volume1/web/piw/include/dblayer/functions_mysqli.inc.php:845

Fatal error: Call to a member function fetch_assoc() on boolean in /volume1/web/piw/include/dblayer/functions_mysqli.inc.php on line 906 Call Stack: 0.0000 245328 1. {main}() /volume1/web/piw/admin.php:0 0.0105 874824 2. include('/volume1/web/piw/admin/site_update.php') /volume1/web/piw/admin.php:312 13.4767 2878968 3. delete_categories() /volume1/web/piw/admin/site_update.php:459 13.4787 2879448 4. query2array() /volume1/web/piw/admin/include/functions.php:86

piwigo error 빠른 동기화 다시한번 사례

◎ ■ ▶ ☞ ♠ 정보찾아 공유 드리며 출처는 링크 참조 바랍니다. https://11q.kr ♠