Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps - Status | Demo | Docs | Install
  1. Cloudron Forum
  2. Invoice Ninja
  3. Migration from Invoice Ninja V4 to V5 failed

Migration from Invoice Ninja V4 to V5 failed

Scheduled Pinned Locked Moved Invoice Ninja
3 Posts 3 Posters 1.2k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • jeauJ Offline
    jeauJ Offline
    jeau
    App Dev
    wrote on last edited by
    #1

    I tried to migrate a production installation of Invoice Ninja V4 (updated, version 4.5.42) to a V5 (updated, version 5 5.3.1).

    I receveid this message (where A.B@X.Y is an admin user email from our Invoice Ninja V4 installation) :

    Migration failed
    
    Looks like something went wrong with the migration for the following company: MY COMPANY
    
    SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from `users` where (`email` = A.B@X.Y) and `users`.`deleted_at` is null) as `exists`)
    
    SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from `users` where (`email` = A.B@X.Y) and `users`.`deleted_at` is null) as `exists`)
    

    I did not notice anything in logs.

    Instead of using the packaged version of Invoice Ninja V5, I installed Invoice Ninja V5 in a LAMP app, and the migration works fine.

    nebulonN girishG 2 Replies Last reply
    0
    • jeauJ jeau

      I tried to migrate a production installation of Invoice Ninja V4 (updated, version 4.5.42) to a V5 (updated, version 5 5.3.1).

      I receveid this message (where A.B@X.Y is an admin user email from our Invoice Ninja V4 installation) :

      Migration failed
      
      Looks like something went wrong with the migration for the following company: MY COMPANY
      
      SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from `users` where (`email` = A.B@X.Y) and `users`.`deleted_at` is null) as `exists`)
      
      SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from `users` where (`email` = A.B@X.Y) and `users`.`deleted_at` is null) as `exists`)
      

      I did not notice anything in logs.

      Instead of using the packaged version of Invoice Ninja V5, I installed Invoice Ninja V5 in a LAMP app, and the migration works fine.

      nebulonN Away
      nebulonN Away
      nebulon
      Staff
      wrote on last edited by
      #2

      @jeau this would need to be debugged further to gain more context. For a start at least we don't have a wholesome v4 data set to test the migration well besides some sample data set.

      1 Reply Last reply
      0
      • jeauJ jeau

        I tried to migrate a production installation of Invoice Ninja V4 (updated, version 4.5.42) to a V5 (updated, version 5 5.3.1).

        I receveid this message (where A.B@X.Y is an admin user email from our Invoice Ninja V4 installation) :

        Migration failed
        
        Looks like something went wrong with the migration for the following company: MY COMPANY
        
        SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from `users` where (`email` = A.B@X.Y) and `users`.`deleted_at` is null) as `exists`)
        
        SQLSTATE[HY000] [2002] No such file or directory (SQL: select exists(select * from `users` where (`email` = A.B@X.Y) and `users`.`deleted_at` is null) as `exists`)
        

        I did not notice anything in logs.

        Instead of using the packaged version of Invoice Ninja V5, I installed Invoice Ninja V5 in a LAMP app, and the migration works fine.

        girishG Do not disturb
        girishG Do not disturb
        girish
        Staff
        wrote on last edited by
        #3

        @jeau said in Migration from Invoice Ninja V4 to V5 failed:

        Instead of using the packaged version of Invoice Ninja V5, I installed Invoice Ninja V5 in a LAMP app, and the migration works fine.

        After this, are you able to export from the lamp v5 app and into the Cloudron v5 app?

        1 Reply Last reply
        0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Bookmarks
        • Search