Tag: Uncategorised

  • [The Jukebox] #67 – ANRI – 悲しいがとまらない I CAN’T STOP THE LONELINESS

    [The Jukebox] #67 – ANRI – 悲しいがとまらない I CAN’T STOP THE LONELINESS

    While listening to some Citypop, a track that seems to be on every playlist that I have on Spotify is ANRI’s I CAN’T STOP THE LONELINESS from her 7th album Timely!!

    ANRI (Real name ‘Eiko Kawashima’) is a singer-songwriter from Yamato, Japan who has been releasing music since her 1978 album “Apricot Jam” and continues to this day with her latest being her 2018 self-titled album release.

    I CAN’T STOP THE LONELINESS was Kawashima’s 2nd hit single. Her first being “Cat’s Eye” which was used as the opening song for the anime of the same name.

    Cat’s Eye Intro

    The songs were released the same year but I CAN’T STOP THE LONELINESS only managed to get to in the Oricon charts. Cat’s Eye would be reach for 5 straight weeks.

    Generally with Citypop (Or Japanese) content, trying to get legal ways of listening to the music can be tricky… but not for Anri! All of her music is available on Spotify (in Ireland at the very least)

    I just wished that other labels would do the same with Japanese music. Yeah, we might not be able to understand or translate the names, but at least we can listen to it.

    Anyway, enough ranting about that… I do enough of that on Twitter 😉

    Live Performance:

    Studio Recording:

    Lyrics:

    JAPANESE (Romanji):

    I CAN’T STOP THE LONELINESS
    Koraekirezu kanashimi ga tomaranai

    I CAN’T STOP THE LONELINESS
    Doushite na no kanashimi ga tomaranai

    Anata ni kanojo
    Awaseta koto wo watashi ima mo
    Koyande iru
    Futari wa SHINPASHII kanjiteta
    Hiru sagari no KYAFETERASU

    Ano hi denwa ga
    Fui ni natta no
    Ano hito to wakarete to kanojo kara

    I CAN’T STOP THE LONELINESS
    Doushite na no kanashimi ga tomaranai

    Gokai da yotte
    anata wa warau dakedo KISSU wa
    Uso no nioi
    Dakishimerarete kizuita no
    Ai ga koko ni nai koto wo

    Koi wa chiisana
    Arashi mitai ni
    Tomodachi mo koibito mo ubatte

    I CAN’T STOP THE LONELINESS
    Kare wo kaeshite kanashimi ga tomaranai

    I CAN’T STOP THE LONELINESS
    Dare ka tasukete kanashimi ga tomaranai

    I CAN’T STOP THE LONELINESS
    Koraekirezu kanashimi ga tomaranai

    I CAN’T STOP THE LONELINESS
    Doushite na no kanashimi ga tomaranai

    ENGLISH:
    I can’t stop the loneliness
    On and on without end
    This sadness won’t stop
    I can’t stop the loneliness
    Why won’t the sadness stop

    I still regret when you met her
    You two made a connection
    That afternoon on the cafe terrace

    Later that day the phone rang suddenly
    It was her telling me to break up with you

    I can’t stop the loneliness
    Why won’t the sadness stop

    You said it was a misunderstanding and smiled
    But your kiss felt like a lie
    And while you were hugging me
    I felt no love

    Love is like a small storm
    Both friends and lovers get swept up by it

    I can’t stop the loneliness
    Please give him back
    The sadness won’t stop
    I can’t stop the loneliness
    Someone help me
    The sadness won’t stop

    I can’t stop the loneliness
    On and on without end
    This sadness won’t stop
    I can’t stop the loneliness
    Why won’t the sadness stop

  • Change Post Author in Ghost

    Change Post Author in Ghost

    When I moved this website from WordPress to Ghost earlier this year, I used their tool to import the posts in.

    What it did, it created a 2nd user and associated the posts with that user while keeping the Ghost author (The main one that I would use) as a separate user. I didn’t want this, so I decided to tinker with the SQLite database and change that.

    Note: If you decide to follow my instructions, I am not responsible for any data loss or breakages to your site, ok? Good! 🙂

    Just for a bit of context, I am using Ghost on Docker via Plesk, (click here for instructions on how to set that up).

    To get into the terminal for your docker instance, run docker ps first and get the name of your docker container and then run docker exec -t -i container_name bash (replacing container_name with your own)

    You will need to ensure that you have sqlite3 installed. On Debian/Ubuntu, you can do this by running apt update && apt install -y sqlite3.

    • BACK UP YOUR DATABASE. This should be obvious. Back up your databases before messing with it.

      * Navigate to /var/lib/ghost/content/data and run cp ghost.db ghostdb-backup2021-10-11

    • While in /var/lib/ghost/content/data run sqlite3 ghost.db
    • You will need to first find out the author_id of your users, to do this, run the command SELECT id, name, slug FROM users;

    This will return the following:

    1|Padraig Fahy|padraig8df7s89f7sd98f7sd|Ghost|ghost7vc89x675x6c78x9c|Padraig Fahy|padraig-2(Note: The id's are different for every instance and are randomised here)

    From this, you might be able to determine which user is your WordPress user. But to be sure, go and view one of the posts that you would have created on the site and click on the link to the author, whether that would be a ‘See more from this author’ or similar link.  

    Then check the URL in the address bar to see what the ‘slug’ is. For me, all my WordPress posts where imported as ‘padraig-2’

    So the ID for ‘padraig-2’ would be 7vc89x675x6c78x9c and now we want to change that to 1 so that it is the Ghost user ‘padraig’

    • UPDATE posts SET author_id = REPLACE(author_id,'7vc89x675x6c78x9c','1');
    • Press enter. Then run:
    • UPDATE posts_authors SET author_id = REPLACE(author_id,'7vc89x675x6c78x9c','1');
    • And press enter again.

    This will update the posts themselves to be the correct user and then update the ‘authors’ page to point it to the correct user.

    When you try to go to the WordPress author page, it should return ‘0 Results’

    You can verify your work by going to your proper author page https://padraig.blog/author/padraig/ and seeing your posts.

    Repeat the process for the different authors if you have them.

    Exit sqlite3 by running .quit and pressing enter.

  • [Podcast] #1 Let me enjoy Professional Wrestling

    [Podcast] #1 Let me enjoy Professional Wrestling

    I want to preface this by stating that this is in response to this tweet by AEW Owner, Tony Khan.

    I like Professional Wrestling and I want be able to do so without the constant Anti-WWE bickering from AEW. It’s childish. He and the rest of the AEW should stop.

    (By the way, I don’t plan to have any schedule for any podcasts as this was just very off the cuff and very last minute. And I needed to upload the episode somewhere)

Welcome to the new padraig.blog. If things feel off, please let me know on Mastodon
toggle