wallabag.el icon indicating copy to clipboard operation
wallabag.el copied to clipboard

Error in process sentinel: EmacsSQL had an unhandled condition

Open karthink opened this issue 4 years ago • 8 comments

Thanks for writing this package! I've been looking for something like it for months now.

wallabag-request-entries is failing with the following messages:

Retriving articles from wallabag host https://read.karthinks.com ...
error in process sentinel: cons: Symbol’s function definition is void: map
error in process sentinel: Symbol’s function definition is void: map

After some debugging it looks like the problem is wallabag-db-insert:

(defun wallabag-db-insert (entries)
  (let ((entries
         (cl-loop for entry in entries collect
                  (map 'array #'identity (mapcar 'cdr entry)))))
    (wallabag-db-sql `[:insert :or :ignore :into items
                    :values ,entries])))

I'm not very familiar with cl-loop syntax but it looks like map is not a valid function on Emacs 27.2.

EDIT: I think you meant to use cl-map here? I changed it to cl-map and it ran, but now I get the following error:

error in process sentinel: EmacSQL had an unhandled condition: "table items has 32 columns but 28 values were supplied"

karthink avatar Apr 14 '21 17:04 karthink

Thanks for reporting. It maybe the your version of wallabag produces a different json structure than me. Would you like to share one of the entries to me (you may retrive only one entry by wallabag-request-entries)? (Json or the result generated at https://github.com/chenyanming/wallabag.el/blob/master/wallabag.el#L185)

chenyanming avatar Apr 15 '21 00:04 chenyanming

map was changed to cl-map 8da206cf5dee5b1e4ce4133d43ea6d917d76435c. @karthink

chenyanming avatar Apr 15 '21 01:04 chenyanming

Also have this same issue with the miss-match in the number of columns. I self-host wallabag through what should be an up-to-date Docker container. One of my "entries" looks like this:

(tag . "webapp") (is_archived . 1) (is_starred . 0) (user_name . "name goes here") (user_email . "email goes here") (user_id . 2) (tags . [((id . 1) (label . "webapp") (slug . "webapp"))]) (is_public . :json-false) (id . 1) (uid) (title . "TITLE GOES HERE") (url . "https://wallabag.org/en/news/wallabagger-howto") (content . "<HTML IS HERE>") (created_at . "2021-04-14T03:06:03+0000") (updated_at . "2021-04-14T03:08:00+0000") (published_at) (published_by . [#2#]) (starred_at) (annotations . #1#) (mimetype . "text/html") (language . "en") (reading_time . 3) (domain_name . "wallabag.org") (preview_picture) (http_status . "200") (headers) (origin_url) (_links (self (href . "/api/entries/1")))

HardRockMartian avatar Apr 15 '21 03:04 HardRockMartian

Apprentally, it is not the format expected in wallabag.el. My content is of wallabag (2.4.1):

((tag . "")
  (is_archived . 0)
  (is_starred . 0)
  (user_name . "admin")
  (user_email . "[email protected]")
  (user_id . 3)
  (tags .
        [])
  (is_public . :json-false)
  (id . 547)
  (uid)
  (title . "MAN WITH A MISSION Seven Deadly Sins 歌詞&動画視聴")
  (url . "https://www.uta-net.com/movie/179761/")
  (hashed_url . "4596dde59d32fb440961930c1ffe89a65422b2f8")
  (origin_url . "https://sp.uta-net.com/movie/179761/")
  (given_url . "https://sp.uta-net.com/movie/179761/")
  (hashed_given_url . "ea354670d3dadb44e479d48997e3f8eda9065c7b")
  (archived_at)
  (content . "<noscript><div class=\"container-xl\"><div class=\"row pt-lg-5 justify-content-center\" id=\"movie-page\"><iframe width=\"100%\" height=\"332\" src=\"https://www.youtube.com/embed/rh517TMtVbo?hd=1&amp;rel=0&amp;autoplay=0&amp;iv_load_policy=3&amp;wmode=transparent\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" id=\"movieFrame\"> </iframe><div class=\"main col-sm-12 col-lg-8\"><iframe width=\"320\" height=\"240\" src=\"https://www.youtube.com/embed/rh517TMtVbo?rel=0&amp;playsinline=1\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"> </iframe><div class=\"row kashi col-12 px-0 px-lg-3 c8\"><div>Wow oh oh oh oh oh<br />The pain and the pleasure All come together<br />There is no reason why<br />The pain and the pleasure All come together<br />There's no reason why<p>I got my demons They don't know<br />I'm fierce enough to let them go<br />It's like a fire A stranglehold<br />I wish I was invincible</p><p>Hello desire Your my old friend<br />But I don't need you here again<br />Just take a walk Go back inside<br />I'll see you on the other side</p><p>彷徨い問う者も 戸惑い請う者も<br />全ての罪を越え</p><p>Wow oh oh oh oh oh<br />The pain and the pleasure All come together<br />There is no reason why<br />The pain and the pleasure All come together<br />There's no reason why</p><p>I get the feeling down below<br />It's coming back to take control<br />It's like a fire A stranglehold<br />I feel like I'm a criminal</p><p>One criminal<br />Two animal<br />Three typical<br />Four breakable<br />Five I can't fight it<br />Six I can't fight it<br />Seven I can't fight it</p><p>So I hide it</p><p>People falling into the seven deadly sins<br />彷徨い続け 辿り着いた<br />光を求め 願いよ叶え<br />あらゆる罪を越えて</p><p>Wow oh oh oh oh oh<br />The pain and the pleasure All come together</p><p>Wow oh oh oh oh oh<br />There's no reason There's no reason<br />That's the reason why<br />Wow oh oh ohoh oh<br />The pain and the pleasure All come together<br />There's no reason why</p></div><p><a href=\"https://www.uta-net.com/renew/myutanet/movie.php?mode=add&amp;TID=179761&amp;URL=https%3A%2F%2Fwww.youtube.com%2Fembed%2Frh517TMtVbo\" class=\"c6\">この動画をマイ歌ネットに登録 &gt;</a></p><p><a class=\"btn btn-outline-dark rounded-pill more-btn c7\" href=\"https://sp.uta-net.com/myuta/add.php?type=mov&amp;id=179761&amp;prm=rh517TMtVbo\">マイ歌ネットに登録</a></p></div><div class=\"row artist-ranking pt-0 pb-4\"><ul class=\"row list bg_white m-0\"><li class=\"ranktop arrow col-12 col-lg-3 pb-2 mb-2 c9\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/266964/bCt-jPWd4QE/\"><img src=\"https://i.ytimg.com/vi/bCt-jPWd4QE/default.jpg\" alt=\"Remember Me\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/266964/bCt-jPWd4QE/\">\n<p class=\"title text-truncate\">Remember Me</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 col-lg-3 pb-2 mb-2\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/247418/b-Ma_fd1aXg/\"><img src=\"https://i.ytimg.com/vi/b-Ma_fd1aXg/default.jpg\" alt=\"Winding Road\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/247418/b-Ma_fd1aXg/\">\n<p class=\"title text-truncate\">Winding Road</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 col-lg-3 pb-2 mb-2\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/297592/0vWZne52W8U/\"><img src=\"https://i.ytimg.com/vi/0vWZne52W8U/default.jpg\" alt=\"ONE WISH\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/297592/0vWZne52W8U/\">\n<p class=\"title text-truncate\">ONE WISH</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 col-lg-3 pb-2 mb-2\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/293100/qvSN7meZwi8/\"><img src=\"https://i.ytimg.com/vi/qvSN7meZwi8/default.jpg\" alt=\"Telescope\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/293100/qvSN7meZwi8/\">\n<p class=\"title text-truncate\">Telescope</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 col-lg-2 pb-2 mb-2\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/141982/HIRfc3ybbPg/\"><img src=\"https://i.ytimg.com/vi/HIRfc3ybbPg/default.jpg\" alt=\"Emotions\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/141982/HIRfc3ybbPg/\">\n<p class=\"title text-truncate\">Emotions</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-2 pb-2 mb-2 d-none d-lg-block\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/195395/PiQpGzYMVos/\"><img src=\"https://i.ytimg.com/vi/PiQpGzYMVos/default.jpg\" alt=\"Raise your flag\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/195395/PiQpGzYMVos/\">\n<p class=\"title text-truncate\">Raise your flag</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-2 pb-2 mb-2 d-none d-lg-block\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/296034/euRGMlfYiLk/\"><img src=\"https://i.ytimg.com/vi/euRGMlfYiLk/default.jpg\" alt=\"evergreen\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/296034/euRGMlfYiLk/\">\n<p class=\"title text-truncate\">evergreen</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-2 pb-2 mb-2 d-none d-lg-block\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/114162/bCt-jPWd4QE/\"><img src=\"https://i.ytimg.com/vi/bCt-jPWd4QE/default.jpg\" alt=\"FLY AGAIN -Hero’s Anthem-\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/114162/bCt-jPWd4QE/\">\n<p class=\"title text-truncate\">FLY AGAIN -Hero’s Anthem-</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-2 pb-2 mb-2 d-none d-lg-block\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/287360/EjtN-eVB0ew/\"><img src=\"https://i.ytimg.com/vi/EjtN-eVB0ew/default.jpg\" alt=\"Change the World\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/287360/EjtN-eVB0ew/\">\n<p class=\"title text-truncate\">Change the World</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-2 pb-2 mb-2 d-none d-lg-block\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/198427/P2T2BJwkjL8/\"><img src=\"https://i.ytimg.com/vi/P2T2BJwkjL8/default.jpg\" alt=\"Memories\" class=\"h-100 w-100\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2 pb-0 ps-lg-0 pe-lg-4\"><a href=\"https://www.uta-net.com/movie/198427/P2T2BJwkjL8/\">\n<p class=\"title text-truncate\">Memories</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2 d-lg-none\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/195395/PiQpGzYMVos/\"><img src=\"https://i.ytimg.com/vi/PiQpGzYMVos/default.jpg\" alt=\"Raise your flag\" class=\"h-100 w-100\" width=\"120\" height=\"66\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2\"><a href=\"https://www.uta-net.com/movie/195395/PiQpGzYMVos/\">\n<p class=\"title text-truncate\">Raise your flag</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2 d-lg-none\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/296034/euRGMlfYiLk/\"><img src=\"https://i.ytimg.com/vi/euRGMlfYiLk/default.jpg\" alt=\"evergreen\" class=\"h-100 w-100\" width=\"120\" height=\"66\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2\"><a href=\"https://www.uta-net.com/movie/296034/euRGMlfYiLk/\">\n<p class=\"title text-truncate\">evergreen</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2 d-lg-none\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/114162/bCt-jPWd4QE/\"><img src=\"https://i.ytimg.com/vi/bCt-jPWd4QE/default.jpg\" alt=\"FLY AGAIN -Hero’s Anthem-\" class=\"h-100 w-100\" width=\"120\" height=\"66\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2\"><a href=\"https://www.uta-net.com/movie/114162/bCt-jPWd4QE/\">\n<p class=\"title text-truncate\">FLY AGAIN -Hero’s Anthem-</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2 d-lg-none\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/287360/EjtN-eVB0ew/\"><img src=\"https://i.ytimg.com/vi/EjtN-eVB0ew/default.jpg\" alt=\"Change the World\" class=\"h-100 w-100\" width=\"120\" height=\"66\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2\"><a href=\"https://www.uta-net.com/movie/287360/EjtN-eVB0ew/\">\n<p class=\"title text-truncate\">Change the World</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2 d-lg-none\">\n<div class=\"mvthumb rounded\"><a href=\"https://www.uta-net.com/movie/198427/P2T2BJwkjL8/\"><img src=\"https://i.ytimg.com/vi/P2T2BJwkjL8/default.jpg\" alt=\"Memories\" class=\"h-100 w-100\" width=\"120\" height=\"66\" referrerpolicy=\"no-referrer\" /></a></div>\n<div class=\"songdata p-2\"><a href=\"https://www.uta-net.com/movie/198427/P2T2BJwkjL8/\">\n<p class=\"title text-truncate\">Memories</p>\n<p class=\"artist text-truncate\">MAN WITH A MISSION</p>\n</a></div>\n</li>\n</ul></div></div></div><div class=\"col-md-12 col-lg-auto pc-right-column\"><div class=\"row pc-right-column-block ms-lg-1 ms-x2 side-ranking-box movie-ranking pt-3 pb-4\"><p></p><h4>デイリー動画歌詞ランキング</h4><ol class=\"row list bg_white p-0 m-0 pb-2\">\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/x8VYWazR5mE/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"夜に駆ける\" referrerpolicy=\"no-referrer\" /></div>\n<p>YOASOBI<br />夜に駆ける</p>\n<a href=\"https://www.uta-net.com/movie/292534/Qp3b-RXtz4w/\">\n<ul><li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/Qp3b-RXtz4w/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"うっせぇわ\" referrerpolicy=\"no-referrer\" /></div>\n<p>Ado<br />うっせぇわ</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/mgYnKfgx6tI/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"Poppin' Shakin'\" referrerpolicy=\"no-referrer\" /></div>\n<p>NiziU<br />Poppin' Shakin'</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/dy90tA3TT1c/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"怪物\" referrerpolicy=\"no-referrer\" /></div>\n<p>YOASOBI<br />怪物</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/N2u7gdbPieU/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"こいのぼり\" referrerpolicy=\"no-referrer\" /></div>\n<p>童謡・唱歌<br />こいのぼり</p>\n</li>\n</ul></a></li>\n</ol><p><a class=\"btn btn-outline-dark rounded-pill more-btn\" href=\"https://www.uta-net.com/movie/daily_ranking.php\">もっと見る</a></p></div><div class=\"row pc-right-column-block ms-lg-1 ms-x2 side-ranking-box movie-ranking pt-3 pb-4 d-none d-lg-block\"><p></p><h4>注目度ランキング動画</h4><ol class=\"row list bg_white p-0 m-0 pb-2\">\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/-_P_cD0yimw/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"Born To Be Wild\" referrerpolicy=\"no-referrer\" /></div>\n<p>JO1<br />Born To Be Wild</p>\n<a href=\"https://www.uta-net.com/movie/300817/ha-1dNqH5xA/\">\n<ul><li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/ha-1dNqH5xA/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"虹の橋のたもとから\" referrerpolicy=\"no-referrer\" /></div>\n<p>TANEBI<br />虹の橋のたもとから</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/VKQxOuA-OoA/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"はしりがき\" referrerpolicy=\"no-referrer\" /></div>\n<p>マカロニえんぴつ<br />はしりがき</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/3FNcPJsOxc0/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"ハミングバード\" referrerpolicy=\"no-referrer\" /></div>\n<p>Novelbright<br />ハミングバード</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/L6Vg09Jgalg/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"遠距離恋愛\" referrerpolicy=\"no-referrer\" /></div>\n<p>THE BEAT GARDEN<br />遠距離恋愛</p>\n</li>\n</ul></a></li>\n</ol><p><a class=\"btn btn-outline-dark rounded-pill more-btn\" href=\"https://www.uta-net.com/movie/attention_ranking.php\">もっと見る</a></p></div><div class=\"row pc-right-column-block ms-lg-1 ms-x2 side-ranking-box movie-ranking pt-3 pb-4\"><p></p><h4>アーティスト別ランキング動画</h4><ol class=\"row list bg_white p-0 m-0 pb-2\">\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/x8VYWazR5mE/default.jpg\" class=\"play_thumb rounded\" alt=\"YOASOBI 人気動画一覧リスト\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></div>\n<p>YOASOBI<br />人気動画一覧リスト</p>\n<a href=\"https://www.uta-net.com/movie/artist/3891/\">\n<ul><li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/EDu47zD-DgI/default.jpg\" class=\"play_thumb rounded\" alt=\"嵐 人気動画一覧リスト\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></div>\n<p>嵐<br />人気動画一覧リスト</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/8220ZMtdd8E/default.jpg\" class=\"play_thumb rounded\" alt=\"童謡・唱歌 人気動画一覧リスト\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></div>\n<p>童謡・唱歌<br />人気動画一覧リスト</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/Eze6-eHmtJg/default.jpg\" class=\"play_thumb rounded\" alt=\"スピッツ 人気動画一覧リスト\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></div>\n<p>スピッツ<br />人気動画一覧リスト</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/VVY_lGLUnC0/default.jpg\" class=\"play_thumb rounded\" alt=\"Hey! Say! JUMP 人気動画一覧リスト\" width=\"120\" height=\"90\" referrerpolicy=\"no-referrer\" /></div>\n<p>Hey! Say! JUMP<br />人気動画一覧リスト</p>\n</li>\n</ul></a></li>\n</ol><p><a class=\"btn btn-outline-dark rounded-pill more-btn\" href=\"https://www.uta-net.com/movie/artist_ranking.php\">もっと見る</a></p></div><div class=\"row pc-right-column-block ms-lg-1 ms-x2 side-ranking-box movie-ranking pt-3 pb-4\"><p></p><h4>演歌歌謡ランキング動画</h4><ol class=\"row list bg_white p-0 m-0 pb-2\">\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/4kavnmW3EqA/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"木綿のハンカチーフ\" referrerpolicy=\"no-referrer\" /></div>\n<p>太田裕美<br />木綿のハンカチーフ</p>\n<a href=\"https://www.uta-net.com/movie/6220/zNinU6GCLzk/\">\n<ul><li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/zNinU6GCLzk/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"VOYAGER ~日付のない墓標~\" referrerpolicy=\"no-referrer\" /></div>\n<p>松任谷由実<br />VOYAGER ~日付のない墓標~</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/jOegTv3a2h4/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"糸\" referrerpolicy=\"no-referrer\" /></div>\n<p>中島みゆき<br />糸</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/qX7pFYH9O04/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"春よ、来い\" referrerpolicy=\"no-referrer\" /></div>\n<p>松任谷由実<br />春よ、来い</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/_0qC22tZHRA/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"はたらくくるま1\" referrerpolicy=\"no-referrer\" /></div>\n<p>のこいのこ<br />はたらくくるま1</p>\n</li>\n</ul></a></li>\n</ol><p><a class=\"btn btn-outline-dark rounded-pill more-btn\" href=\"https://www.uta-net.com/movie/enka_ranking.php\">もっと見る</a></p></div><div class=\"row pc-right-column-block ms-lg-1 ms-x2 side-ranking-box movie-ranking pt-3 pb-4 d-none d-lg-block\"><p></p><h4>カラオケランキング動画</h4><ol class=\"row list bg_white p-0 m-0 pb-2\">\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/yXZd7xVdpJ0/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"ドライフラワー\" referrerpolicy=\"no-referrer\" /></div>\n<p>優里<br />ドライフラワー</p>\n<a href=\"https://www.uta-net.com/movie/292534/Qp3b-RXtz4w/\">\n<ul><li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/Qp3b-RXtz4w/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"うっせぇわ\" referrerpolicy=\"no-referrer\" /></div>\n<p>Ado<br />うっせぇわ</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/gsT6eKsnT0M/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"猫\" referrerpolicy=\"no-referrer\" /></div>\n<p>DISH//<br />猫</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/x8VYWazR5mE/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"夜に駆ける\" referrerpolicy=\"no-referrer\" /></div>\n<p>YOASOBI<br />夜に駆ける</p>\n</li>\n<li class=\"arrow col-12 pb-2 mb-2\">\n<div class=\"mvthumb\"><img src=\"https://i.ytimg.com/vi/4DxL6IKmXx4/default.jpg\" class=\"play_thumb rounded\" width=\"120\" height=\"90\" alt=\"炎\" referrerpolicy=\"no-referrer\" /></div>\n<p>LiSA<br />炎</p>\n</li>\n</ul></a></li>\n</ol><p><a class=\"btn btn-outline-dark rounded-pill more-btn\" href=\"https://www.uta-net.com/movie/karaoke_ranking.php\">もっと見る</a></p></div></div></div></noscript>")
  (created_at . "2021-04-15T00:56:06+0000")
  (updated_at . "2021-04-15T00:56:06+0000")
  (published_at)
  (published_by)
  (starred_at)
  (annotations .
               [])
  (mimetype . "text/html; charset=UTF-8")
  (language . "ja")
  (reading_time . 2)
  (domain_name . "www.uta-net.com")
  (preview_picture . "https://www.uta-net.com/reverse/mixi_check/uta_net_logo_m.gif")
  (http_status . "200")
  (headers
   (date . "Thu, 15 Apr 2021 00:56:06 GMT")
   (server . "Apache")
   (strict-transport-security . "max-age=15768000")
   (vary . "User-Agent,Accept-Encoding")
   (content-type . "text/html; charset=UTF-8")
   (set-cookie . "uta_history=179761; expires=Fri, 15-Apr-2022 00:56:06 GMT; Max-Age=31536000; path=/; domain=.uta-net.com, uta_rec_id=UID_2074cf55666bbbc236f3a3ecf3c9dc30; expires=Fri, 15-Apr-2022 00:56:06 GMT; Max-Age=31536000; path=/; domain=.uta-net.com, uta_rec_id=UID_4d728a816c8170c0d8e3215d688f1c44; expires=Fri, 15-Apr-2022 00:56:06 GMT; Max-Age=31536000; path=/; domain=.uta-net.com")
   (x-ua-compatible . "IE=edge")
   (transfer-encoding . "chunked"))
  (_links
   (self
    (href . "/api/entries/547"))))

Would you like to give me the version of wallabag you used?

chenyanming avatar Apr 15 '21 05:04 chenyanming

May I know

(published_by .
[#2#])
(annotations . #1#)

is the original data? Since this # is not a valid sybmol in list element. It is difficult to handle this special case. If not, I already have an idea to fix it to support the database format generated by your wallabag instance.

chenyanming avatar Apr 15 '21 05:04 chenyanming

Thanks for reporting. It maybe the your version of wallabag produces a different json structure than me. Would you like to share one of the entries to me (you may retrive only one entry by wallabag-request-entries)? (Json or the result generated at https://github.com/chenyanming/wallabag.el/blob/master/wallabag.el#L185)

Thank you for the reply. I'm a bit busy at the moment but will check the json format soon.

karthink avatar Apr 15 '21 06:04 karthink

The container I'm using is running Wallabag 2.3.8. The hash mark characters in the "entries" variable are internal (Wallabag, emacsql, etc) and not something I entered. There must have been a significant schema change from the 2.3 series to the 2.4. EDIT: it appears the Docker container I was using (ugeek/wallabag for RPI) offers a Wallabag 2.4.0 branch. I wiped my old install in favor of the 2.4.0 branch and wallabag.el is working fine for me. now. Thanks!

HardRockMartian avatar Apr 15 '21 15:04 HardRockMartian

As @HardRockMartian mentions, it is better to update wallabag instance to 2.4.0+. I think it is not necessary to support old wallabag version.

chenyanming avatar May 08 '21 01:05 chenyanming