Can't update and script won't restore either from Sofaculous Backup

Self-Hosted | v4/Legacy
21

Yes it is: https://tinyhousechattanooga.com/phpinfo.php

22

Nope… I copied and pasted the exact error.

23

Should I PM you my log in details so you can poke around?

24

Where are you seeing this error?

Our policy is to not login to user’s apps.

25

https://tinyhousechattanooga.com/inv/public/update

Gotcha.

26

Is it possible you made a typo when changing the migration file?

27

Sure, anything is possible. Though I’ve looked a couple times and don’t see where an error was made. Maybe there is a character out of place? Maybe you can tell me… this is a copy and paste of my 2017_08_14_085334_increase_precision.php file:

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class IncreasePrecision extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table(‘products’, function ($table) {
$table->decimal(‘cost’, 15, 4)->change();

  •        $table-&gt;decimal('qty', 15, 4)-&gt;change();

  •        $table-&gt;decimal('qty', 15, 4)-&gt;default(0)-&gt;change();
   });

   Schema::table('invoice_items', function ($table) {
       $table-&gt;decimal('cost', 15, 4)-&gt;change();

  •        $table-&gt;decimal('qty', 15, 4)-&gt;change();

  •        $table-&gt;decimal('qty', 15, 4)-&gt;default(0)-&gt;change();
   });

   Schema::table('clients', function ($table) {

    /**

    • Reverse the migrations.
    • @return void
      */
      public function down()
      {
      Schema::table(‘clients’, function ($table) {
      $table->dropColumn(‘credit_number_counter’);
      });
      }
      }
28

Is it possible that I download the v3.8.1 sql file and upload it to a new, 4.1.4 installation? Would that work?

29

To apply change you need to add the lines starting with + and remove the lines starting with -

The end result should be: https://github.com/invoiceninja/invoiceninja/blob/develop/database/migrations/2017_08_14_085334_increase_precision.php

I’d suggest fixing the code, restoring a database backup and upgrading again.

30

It WORKED! No need to restore from backup… the script successfully upgraded itself to 4.1.4… and all of my data is FINALLY there! Thank you so much, Hillel!!!

31

Great to hear!

32

I’m sure you’re relieved as I am! :slight_smile: