Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Creating a listing throws mysql error with mysql Ver 8.0.18 #106

Open
goehlemichael opened this issue Nov 25, 2019 · 1 comment
Open

Creating a listing throws mysql error with mysql Ver 8.0.18 #106

goehlemichael opened this issue Nov 25, 2019 · 1 comment

Comments

@goehlemichael
Copy link

This happens when trying to post a listing.

Illuminate\Database\QueryException thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION marketplace.GeomFromText does not exist (SQL: update listings set price = 120, location = GeomFromText('POINT(-74.9858 42.738)'), lat = 42.738, lng = -74.98579999999998, updated_at = 2019-11-25 16:16:34 where id = 10)"

Stacktrace:
#85 Illuminate\Database\QueryException in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
#84 PDOException in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:479
#83 PDO:prepare in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:479
#82 Illuminate\Database\Connection:Illuminate\Database{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657
#81 Illuminate\Database\Connection:runQueryCallback in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624
#80 Illuminate\Database\Connection:run in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:490
#79 Illuminate\Database\Connection:affectingStatement in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423
#78 Illuminate\Database\Connection:update in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2508
#77 Illuminate\Database\Query\Builder:update in /opt/bitnami/frameworks/laravel/vendor/spiritix/lada-cache/src/Spiritix/LadaCache/Database/QueryBuilder.php:134
#76 Spiritix\LadaCache\Database\QueryBuilder:update in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:780
#75 Illuminate\Database\Eloquent\Builder:update in /opt/bitnami/frameworks/laravel/vendor/grimzy/laravel-mysql-spatial/src/Eloquent/Builder.php:18
#74 Grimzy\LaravelMysqlSpatial\Eloquent\Builder:update in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:693
#73 Illuminate\Database\Eloquent\Model:performUpdate in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:608
#72 Illuminate\Database\Eloquent\Model:save in /opt/bitnami/frameworks/laravel/app/Http/Controllers/CreateController.php:485
#71 App\Http\Controllers\CreateController:update in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#70 call_user_func_array in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
#69 Illuminate\Routing\Controller:callAction in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
#68 Illuminate\Routing\ControllerDispatcher:dispatch in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
#67 Illuminate\Routing\Route:runController in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
#66 Illuminate\Routing\Route:run in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php:665
#65 Illuminate\Routing\Router:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#64 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/app/Http/Middleware/IsVerified.php:23
#63 App\Http\Middleware\IsVerified:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#62 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#61 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/app/Http/Middleware/Authenticate.php:43
#60 App\Http\Middleware\Authenticate:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#59 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#58 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/app/Http/Middleware/IsBanned.php:38
#57 App\Http\Middleware\IsBanned:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#56 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#55 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41
#54 Illuminate\Routing\Middleware\SubstituteBindings:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#53 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#52 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/app/Http/Middleware/PushURL.php:42
#51 App\Http\Middleware\PushURL:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#50 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#49 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
#48 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#47 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#46 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
#45 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#44 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#43 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
#42 Illuminate\Session\Middleware\StartSession:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#41 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#40 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
#39 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#37 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
#36 Illuminate\Cookie\Middleware\EncryptCookies:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#34 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#33 Illuminate\Pipeline\Pipeline:then in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php:667
#32 Illuminate\Routing\Router:runRouteWithinStack in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php:642
#31 Illuminate\Routing\Router:runRoute in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php:608
#30 Illuminate\Routing\Router:dispatchToRoute in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Router.php:597
#29 Illuminate\Routing\Router:dispatch in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
#28 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
#27 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/genealabs/laravel-caffeine/src/Http/Middleware/LaravelCaffeineDripMiddleware.php:11
#26 GeneaLabs\LaravelCaffeine\Http\Middleware\LaravelCaffeineDripMiddleware:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#25 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#24 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php:58
#23 Barryvdh\Debugbar\Middleware\InjectDebugbar:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#22 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#21 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/fideloper/proxy/src/TrustProxies.php:57
#20 Fideloper\Proxy\TrustProxies:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#19 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#18 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:31
#17 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#16 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#15 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:31
#14 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#12 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27
#11 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#9 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62
#8 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#6 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/barryvdh/laravel-cors/src/HandlePreflight.php:35
#5 Barryvdh\Cors\HandlePreflight:handle in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:151
#4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
#3 Illuminate\Routing\Pipeline:Illuminate\Routing{closure} in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
#2 Illuminate\Pipeline\Pipeline:then in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /opt/bitnami/frameworks/laravel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116
#0 Illuminate\Foundation\Http\Kernel:handle in /opt/bitnami/frameworks/laravel/public/index.php:55
@goehlemichael
Copy link
Author

Just an update:

i managed to fix this by changing this line:

marketplacekit/app/Http/Controllers/CreateController.php

Line 470 in 7e0681e

$listing->location = \DB::raw("GeomFromText('POINT(".$point->getLng()." ".$point->getLat().")')");

I updated it to :
$listing->location = \DB::raw("ST_GeomFromText('POINT(".$point->getLng()." ".$point->getLat().")')");

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@goehlemichael