Bagisto Forum

    Bagisto

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    Error during php artisan migrate after some migrations

    Bug Report
    5
    8
    588
    Loading More Posts
    • 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.
    • A
      ahmadsaeedchdev last edited by

      when i run this command php artisan migrate after some migrations i got this error
      In PDOConnection.php line 43:

      SQLSTATE[HY000]: General error: 1558 Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, now running 100411.
      Please use mysql_upgrade to fix this error
      Screenshot from 2020-03-21 16-32-53.png

      1 Reply Last reply Reply Quote 0
      • V
        Vaishali Agarwal last edited by

        @ahmadsaeedchdev

        run: mysql_upgrade -u root -p
        Also, restart the mysql service by running : service mysqld restart

        A 1 Reply Last reply Reply Quote 0
        • A
          ahmadsaeedchdev @Vaishali Agarwal last edited by

          @Vaishali-Agarwal i run this both command and i got this on terminal![0_1584796844531_Screenshot from 2020-03-21 18-17-48.png](Uploading 100%)

          A 1 Reply Last reply Reply Quote 0
          • A
            ahmadsaeedchdev @ahmadsaeedchdev last edited by

            @ahmadsaeedchdev this one messages
            ahmadch@ahmadch-ThinkPad-T420:~/Desktop/personalProjects/experimentProject/bagisto-master$ mysql_upgrade -u root -p
            Enter password:
            The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
            To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
            The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
            It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.
            ahmadch@ahmadch-ThinkPad-T420:~/Desktop/personalProjects/experimentProject/bagisto-master$ service mysqld restart
            Failed to restart mysqld.service: Unit mysqld.service not found.

            1 Reply Last reply Reply Quote 0
            • V
              Vaishali Agarwal last edited by

              @ahmadsaeedchdev

              Can you mentioned about your database and its version so that we can check.

              1 Reply Last reply Reply Quote 0
              • D
                Dev last edited by

                @Vaishali-Agarwal
                Do you find any solution for @ahmadsaeedchdev 's problem ? then please do share i'm facing the exact same problem when try to create a procedure in mysql.

                F 1 Reply Last reply Reply Quote 0
                • R
                  rahul last edited by

                  Hi @ahmadsaeedchdev

                  Can you tell, what is your database version so that we can check on that?

                  1 Reply Last reply Reply Quote 0
                  • F
                    farhan @Dev last edited by

                    @Dev the same solution that @Vaishali-Agarwal post when you run these 2 commands you must start your mysql and apache from xampp control panel. Thank you @Vaishali-Agarwal .

                    1 Reply Last reply Reply Quote 1
                    • First post
                      Last post