search

k-mit / unibet-clcupen

1 stars 0 forks source link

Sql exception #6

Closed cocoanton closed 9 years ago

cocoanton commented 9 years ago 
Illuminate\Database\QueryException thrown with message "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,4) order by `total_score` desc' at line 1 (SQL: select users.extra_score+highscores.score as total_score, highscores.*, users.name AS user_name FROM users,`highscores` where highscores.user_id = users.id AND `round` = 10 and `user_id` in (,1,4) order by `total_score` desc)"

Stacktrace:
#63 Illuminate\Database\QueryException in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/Connection.php:620
#62 Illuminate\Database\Connection:select in <#unknown>:0
#61 App\Http\Controllers\FacebookController:viewCanvas in <#unknown>:0
#60 Illuminate\Routing\ControllerDispatcher:Illuminate\Routing\{closure} in <#unknown>:0
#59 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in <#unknown>:0
#58 Illuminate\Routing\Router:Illuminate\Routing\{closure} in <#unknown>:0
#57 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in <#unknown>:0
#56 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in <#unknown>:0
#55 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in <#unknown>:0
#54 PDOException in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/Connection.php:288
#53 PDO:prepare in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/Connection.php:288
#52 Illuminate\Database\Connection:Illuminate\Database\{closure} in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/Connection.php:612
#51 Illuminate\Database\Connection:runQueryCallback in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/Connection.php:576
#50 Illuminate\Database\Connection:run in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/Connection.php:293
#49 Illuminate\Database\Connection:select in <#unknown>:0
#48 call_user_func_array in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:304
#47 Illuminate\Database\DatabaseManager:__call in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:210
#46 Illuminate\Database\DatabaseManager:select in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:210
#45 Illuminate\Support\Facades\Facade:__callStatic in /home/vagrant/unibet-clcup/app/Http/Controllers/FacebookController.php:198
#44 Illuminate\Support\Facades\DB:select in /home/vagrant/unibet-clcup/app/Http/Controllers/FacebookController.php:198
#43 App\Http\Controllers\FacebookController:highscoreFriends in /home/vagrant/unibet-clcup/app/Http/Controllers/FacebookController.php:111
#42 App\Http\Controllers\FacebookController:getAllVars in /home/vagrant/unibet-clcup/app/Http/Controllers/FacebookController.php:372
#41 App\Http\Controllers\FacebookController:viewCanvas in <#unknown>:0
#40 call_user_func_array in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:246
#39 Illuminate\Routing\Controller:callAction in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:162
#38 Illuminate\Routing\ControllerDispatcher:call in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:107
#37 Illuminate\Routing\ControllerDispatcher:Illuminate\Routing\{closure} in <#unknown>:0
#36 call_user_func in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in <#unknown>:0
#34 call_user_func in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:101
#33 Illuminate\Pipeline\Pipeline:then in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:108
#32 Illuminate\Routing\ControllerDispatcher:callWithinStack in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:67
#31 Illuminate\Routing\ControllerDispatcher:dispatch in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Route.php:198
#30 Illuminate\Routing\Route:runWithCustomDispatcher in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Route.php:131
#29 Illuminate\Routing\Route:run in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Router.php:692
#28 Illuminate\Routing\Router:Illuminate\Routing\{closure} in <#unknown>:0
#27 call_user_func in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/app/Http/Middleware/FacebookLoginMiddleware.php:33
#25 App\Http\Middleware\FacebookLoginMiddleware:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#24 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in <#unknown>:0
#23 call_user_func in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:101
#22 Illuminate\Pipeline\Pipeline:then in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Router.php:694
#21 Illuminate\Routing\Router:runRouteWithinStack in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Router.php:661
#20 Illuminate\Routing\Router:dispatchToRoute in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Routing/Router.php:619
#19 Illuminate\Routing\Router:dispatch in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:214
#18 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in <#unknown>:0
#17 call_user_func in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:141
#16 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/vendor/itsgoingd/clockwork/Clockwork/Support/Laravel/ClockworkMiddleware.php:42
#15 Clockwork\Support\Laravel\ClockworkMiddleware:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#14 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:55
#13 Illuminate\View\Middleware\ShareErrorsFromSession:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#12 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:61
#11 Illuminate\Session\Middleware\StartSession:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:36
#9 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#8 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:40
#7 Illuminate\Cookie\Middleware\EncryptCookies:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#6 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:42
#5 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:125
#4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in <#unknown>:0
#3 call_user_func in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:101
#2 Illuminate\Pipeline\Pipeline:then in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:115
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in /home/vagrant/unibet-clcup/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:84
#0 Illuminate\Foundation\Http\Kernel:handle in /home/vagrant/unibet-clcup/public/index.php:53
cocoanton commented 9 years ago

Händer direkt vid första migrate och seed.

cocoanton commented 9 years ago

Vet varför, Kristian mirsch är min kompis men finns inte med i databas-seedningen, så den försöker hitta honom men han finns inte.