Home Forums Support Signature generating error on approve

This topic contains 17 replies, has 2 voices, and was last updated by  Hillel Coren 2 weeks, 5 days ago.

Viewing 18 posts - 1 through 18 (of 18 total)
  • Author
    Posts
  • #23291

    Randy
    Participant

    Hey,

    I’m on self hosted version 4.5.17 but I can’t get the signature system to work.

    I get following message after signing and approving the quote/invoice:

    Failed to load resource: the server responded with a status of 405 (Method Not Allowed)

    Anyone encountered the same problem?

    #23316

    Hillel Coren
    Keymaster

    Hi, are there any details in storage/logs/laravel-error.log or the web server error logs?

    #23342

    Randy
    Participant

    No, nothing at all but I discovered an error in the log file that makes me think that I maybe didn’t do the update like I should.

    He’s trying to reach a column that doesn’t exist.

    How can I update the database without losing data?

    I only copied the documents of the latest version over my 4.5.16 version and nothing else.

    #23343

    Hillel Coren
    Keymaster

    Do you have SSH access? You can run the database migrations using php artisan migrate, otherwise you can load /update in the browser.

    #23363

    Randy
    Participant

    No SSH access and /update isn’t an option.
    I’m using Invoice Ninja on a shared hosting, so I don’t have the rights to perform anything I want and /update needs some rights that I don’t have

    Isn’t there an update script that I could run?

    #23364

    Hillel Coren
    Keymaster

    Umm… yes, it’s run using /update

    Assuming you can’t get SSH access or the permissions enabled one workaround is to copy your database to your local environment, run the migration and then copy it back.

    #23365

    Randy
    Participant

    Is there a difference between the 4.5.16 DB and the 4.5.17 DB?

    #23366

    Hillel Coren
    Keymaster

    No, but my guess would be the database migration failed with a past release

    #23370

    Randy
    Participant

    In that case the problem isn’t related to the DB.
    I’ll try a fresh install to check if it’s related to my installation or to the version

    #23397

    Hillel Coren
    Keymaster

    I believe I’ve seen this problem in the past, if the database migration hasn’t run the feature fails to work because it depends on the table field to track the value.

    One solution would be to setup a new install and transfer the data as JSON, this isn’t ideal though as it isn’t a complete transfer. Alternatively you could copy the database to a system where you have command line access to work through the migrations.

    #23401

    Randy
    Participant

    I’m thinking about moving my data to a VPS so I can get more access than I get now but the problem remains, I still get the 405 error when I try to accept a quote.

    I’ve seen somewhere that you suggested that it might be permissions related but for another problem but with the same error message, couldn’t this be the same problem?

    #23408

    Hillel Coren
    Keymaster

    We’ve sometimes seen server mod security rules causes issues.

    It may help to check that the migrations table is up to date with this list

    https://github.com/invoiceninja/invoiceninja/tree/master/database/migrations

    #23427

    Randy
    Participant

    Thanks for the tip Hillel!

    I don’t think the DB has changed between version 4.5.16 and 4.5.17 (based on your URL), so we can exclude that.

    What can be the reason the system won’t accept the signature?

    Would it be my fault (hosting) or your fault (coding) ?

    #23432

    Hillel Coren
    Keymaster

    Which version are you upgrading from? Was the feature working before you upgraded?

    #23452

    Randy
    Participant

    I had 4.5.16 and I uploaded the files of 4.5.17.

    I can’t really answer that question because I saw that option only after upgrading to 4.5.17.

    I’ve installed the 4.5.16 version locally (through wamp64) but I get the same error.

    #23467

    Hillel Coren
    Keymaster

    When testing locally was it a clean install or did you use your database backup?

    #23469

    Randy
    Participant

    I did a clean install based on a copy of the 4.5.16 zip file

    #23472

    Hillel Coren
    Keymaster

    Are you still seeing the 405 error? Can you reproduce the problem?

Viewing 18 posts - 1 through 18 (of 18 total)

You must be logged in to reply to this topic.

Posted in: