Error migration database

[mobiusrpi]

Hi
I follow your guideline to install on local server GPS Tracker
On step 7, I have the following error message

The command "mysql --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_L
OAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}
" --database="${:LARAVEL_LOAD_DATABASE}" < "${:LARAVEL_LOAD_PATH}"" failed.

Exit Code: 1(General error)

Working directory: /var/www/GPS-Tracker

Output:

Error Output:

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

No table created in database gpstracker, only alarm item, appear

Thank for your help

[eusonlito]

Are you using MySQL 8.0.12 or higher?

[mobiusrpi]

I use Mysql 8.3

[mobiusrpi]

Sorry I upgraded my server and the database is mariadb 10.11.6

Serveur : Localhost via UNIX socket
Type de serveur : MariaDB
Connexion au serveur : SSL n'est pas utilisé Documentation
Version du serveur : 10.11.6-MariaDB-0+deb12u1 - Debian 12
Version du protocole : 10
Utilisateur : root@localhost
Jeu de caractères du serveur : UTF-8 Unicode (utf8mb4)

[eusonlito]

Sorry but MariaDB is not supported.

[adarsh23590]

then which is supported i am using XAMPP

[mobiusrpi]

Hi Thank you for your help I replaced the database Mariadb by mysql 8.0.37 I finished the installation I attached my configuration file for test as localhost When I run in my navigator I have a message error : 500 Internal server error In the error.log; the error is located in .htaccess file /var/www/GPS-Tracker/public/.htaccess: Invalid command 'Header', perhaps misspelled or defined by a module not included in the server configuration Do you have an idea ? Joel Le sam. 25 mai 2024 à 18:41, Lito ***@***.***> a écrit :

…

Sorry but MariaDB is not supported. — Reply to this email directly, view it on GitHub <#66 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABHSDNENGZ4KM6G2YJYSESTZEC5LJAVCNFSM6AAAAABIJAGJ6WVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TKNJWHA4TI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[eusonlito]

You need to enable Apache headers module.

[mobiusrpi]

Le dim. 26 mai 2024 à 13:39, Joel Tremblet ***@***.***> a écrit :

…

Hi Thank you for your help I replaced the database Mariadb by mysql 8.0.37 I finished the installation I attached my configuration file for test as localhost When I run in my navigator I have a message error : 500 Internal server error In the error.log; the error is located in .htaccess file /var/www/GPS-Tracker/public/.htaccess: Invalid command 'Header', perhaps misspelled or defined by a module not included in the server configuration Do you have an idea ? Joel Le sam. 25 mai 2024 à 18:41, Lito ***@***.***> a écrit : > Sorry but MariaDB is not supported. > > — > Reply to this email directly, view it on GitHub > <#66 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ABHSDNENGZ4KM6G2YJYSESTZEC5LJAVCNFSM6AAAAABIJAGJ6WVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TKNJWHA4TI> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >

[adarsh23590]

Hi I follow your guideline to install on local server GPS Tracker On step 7, I have the following error message

The command "mysql --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_L OAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT} " --database="${:LARAVEL_LOAD_DATABASE}" < "${:LARAVEL_LOAD_PATH}"" failed.

Exit Code: 1(General error)

Working directory: /var/www/GPS-Tracker

Output:

Error Output:

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

No table created in database gpstracker, only alarm item, appear

Thank for your help

I also get same error. I am using Xampp and php version 8.2. any solution?

[eusonlito]

Are you using MySQL 8.0.12 or higher?

[adarsh23590]

I am using XAMPP

please check

[eusonlito]

MariaDB does not support the required GIS functionalities.

[adarsh23590]

I have changes to mysql from mariadb but stilll getting error


my environment variables are already set but still getting error

[eusonlito]

Sorry, windows is not supported by the requirements to be able to run the protocol servers.