Instalacion fallida

[ysernah]

Excelente desarrollo quisiera su ayuda al instalar en local y ejecutar el comando
php artisan migrate --path=database/migrations me sale el error y no puedo avanzar espero su respuesta gracias
**The command "mysql --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}" --da
tabase="${:LARAVEL_LOAD_DATABASE}" < "${:LARAVEL_LOAD_PATH}"" failed.
Working directory: C:\xampp\htdocs\GPS-Tracker

Output:

Error Output:

ERROR 1901 (HY000) at line 30: Function or expression 'st_latitude()' cannot be used in the GENERATED ALWAYS AS clause of latitude**

[eusonlito]

Me podrías pasar el log completo desde el fichero storage/logs/laravel/2024/04/2024-04-08.log?

[ysernah]

Gracias asi me sale

Error Output:

ERROR 1901 (HY000) at line 30: Function or expression 'st_latitude()' cannot be used in the GENERATED ALWAYS AS clause of latitude

 at C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\symfony\\process\\Process.php:267)
[stacktrace]
#0 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Schema\\MySqlSchemaState.php(76): Symfony\\Component\\Process\\Process->mustRun(NULL, Array)
#1 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\MigrateCommand.php(284): Illuminate\\Database\\Schema\\MySqlSchemaState->load('C:\\\\xampp\\\\htdocs...')
#2 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\View\\Components\\Task.php(40): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#3 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\View\\Components\\Factory.php(58): Illuminate\\Console\\View\\Components\\Task->render('C:\\\\xampp\\\\htdocs...', Object(Closure))
#4 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\MigrateCommand.php(276): Illuminate\\Console\\View\\Components\\Factory->__call('task', Array)
#5 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\MigrateCommand.php(153): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->loadSchemaState()
#6 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\MigrateCommand.php(110): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->prepareDatabase()
#7 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Migrations\\Migrator.php(622): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#8 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection(NULL, Object(Closure))
#9 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Console\\Migrations\\MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#10 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#11 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#12 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))
#13 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))
#14 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Container\\Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)
#15 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(212): Illuminate\\Container\\Container->call(Array)
#16 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\symfony\\console\\Command\\Command.php(279): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#17 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Console\\Command.php(181): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))
#18 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\symfony\\console\\Application.php(1049): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#19 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\symfony\\console\\Application.php(318): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#20 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\symfony\\console\\Application.php(169): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#21 C:\\xampp\\htdocs\\GPS-Tracker\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Console\\Kernel.php(196): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#22 C:\\xampp\\htdocs\\GPS-Tracker\\artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))
#23 {main}
"} 

[eusonlito]

Estás usando MySQL 8.0.12 o superior?

[ysernah]

Tengo instalado xampp me sale esta version

[eusonlito]

MariaDB no está soportado ya que no dispone de algunas de las funcionalidades GIS usadas en la plataforma.

[ysernah]

Gracias instalare el MySQL 8.0.12 :)