Advertisement
Guest User

Industry Error

a guest
Dec 14th, 2015
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.64 KB | None | 0 0
  1.  
  2. Whoops, looks like something went wrong.
  3. 2/2 QueryException in Connection.php line 651: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'seat.ramActivities' doesn't exist (SQL: select
  4. *,
  5.  
  6. --
  7. -- Start Facility Name Lookup
  8. --
  9. CASE
  10. when a.stationID BETWEEN 66015148 AND 66015151 then
  11. (SELECT s.stationName FROM staStations AS s
  12. WHERE s.stationID = a.stationID-6000000)
  13. when a.stationID BETWEEN 66000000 AND 66014933 then
  14. (SELECT s.stationName FROM staStations AS s
  15. WHERE s.stationID = a.stationID-6000001)
  16. when a.stationID BETWEEN 66014934 AND 67999999 then
  17. (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c
  18. WHERE c.stationID = a.stationID-6000000)
  19. when a.stationID BETWEEN 60014861 AND 60014928 then
  20. (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c
  21. WHERE c.stationID = a.stationID)
  22. when a.stationID BETWEEN 60000000 AND 61000000 then
  23. (SELECT s.stationName FROM staStations AS s
  24. WHERE s.stationID = a.stationID)
  25. when a.stationID >= 61000000 then
  26. (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c
  27. WHERE c.stationID = a.stationID)
  28. else (SELECT m.itemName FROM mapDenormalize AS m
  29. WHERE m.itemID = a.stationID) end
  30. AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = 92993682 order by `endDate` desc)
  31.  
  32. in Connection.php line 651
  33. at Connection->runQueryCallback('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682'), object(Closure)) in Connection.php line 611
  34. at Connection->run('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682'), object(Closure)) in Connection.php line 324
  35. at Connection->select('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682'), true) in Builder.php line 1406
  36. at Builder->runSelect() in Builder.php line 1383
  37. at Builder->get() in CharacterRepository.php line 303
  38. at ViewController->getCharacterIndustry('92993682') in ViewController.php line 119
  39. at ViewController->getIndustry('92993682')
  40. at call_user_func_array(array(object(ViewController), 'getIndustry'), array('character_id' => '92993682')) in Controller.php line 256
  41. at Controller->callAction('getIndustry', array('character_id' => '92993682')) in ControllerDispatcher.php line 164
  42. at ControllerDispatcher->call(object(ViewController), object(Route), 'getIndustry') in ControllerDispatcher.php line 112
  43. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  44. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
  45. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  46. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  47. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 114
  48. at ControllerDispatcher->callWithinStack(object(ViewController), object(Route), object(Request), 'getIndustry') in ControllerDispatcher.php line 69
  49. at ControllerDispatcher->dispatch(object(Route), object(Request), 'Seat\Web\Http\Controllers\Character\ViewController', 'getIndustry') in Route.php line 203
  50. at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134
  51. at Route->run(object(Request)) in Router.php line 708
  52. at Router->Illuminate\Routing\{closure}(object(Request))
  53. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
  54. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CharacterBouncer.php line 69
  55. at CharacterBouncer->handle(object(Request), object(Closure), 'industry')
  56. at call_user_func_array(array(object(CharacterBouncer), 'handle'), array(object(Request), object(Closure), 'industry')) in Pipeline.php line 124
  57. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Mfa.php line 51
  58. at Mfa->handle(object(Request), object(Closure))
  59. at call_user_func_array(array(object(Mfa), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  60. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Authenticate.php line 67
  61. at Authenticate->handle(object(Request), object(Closure))
  62. at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  63. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  64. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  65. at Pipeline->then(object(Closure)) in Router.php line 710
  66. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 675
  67. at Router->dispatchToRoute(object(Request)) in Router.php line 635
  68. at Router->dispatch(object(Request)) in Kernel.php line 236
  69. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  70. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
  71. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 50
  72. at VerifyCsrfToken->handle(object(Request), object(Closure))
  73. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  74. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  75. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  76. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  77. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 62
  78. at StartSession->handle(object(Request), object(Closure))
  79. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  80. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  81. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  82. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  83. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59
  84. at EncryptCookies->handle(object(Request), object(Closure))
  85. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  86. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  87. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  88. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  89. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  90. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  91. at Pipeline->then(object(Closure)) in Kernel.php line 122
  92. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 87
  93. at Kernel->handle(object(Request)) in index.php line 54
  94.  
  95. 1/2 PDOException in Connection.php line 319: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'seat.ramActivities' doesn't exist
  96.  
  97. in Connection.php line 319
  98. at PDO->prepare('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc') in Connection.php line 319
  99. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682')) in Connection.php line 644
  100. at Connection->runQueryCallback('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682'), object(Closure)) in Connection.php line 611
  101. at Connection->run('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682'), object(Closure)) in Connection.php line 324
  102. at Connection->select('select *, -- -- Start Facility Name Lookup -- CASE when a.stationID BETWEEN 66015148 AND 66015151 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000000) when a.stationID BETWEEN 66000000 AND 66014933 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID-6000001) when a.stationID BETWEEN 66014934 AND 67999999 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID-6000000) when a.stationID BETWEEN 60014861 AND 60014928 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) when a.stationID BETWEEN 60000000 AND 61000000 then (SELECT s.stationName FROM staStations AS s WHERE s.stationID = a.stationID) when a.stationID >= 61000000 then (SELECT c.stationName FROM `eve_conquerable_station_lists` AS c WHERE c.stationID = a.stationID) else (SELECT m.itemName FROM mapDenormalize AS m WHERE m.itemID = a.stationID) end AS facilityName from `character_industry_jobs` as `a` left join `ramActivities` on `ramActivities`.`activityID` = `a`.`activityID` where `a`.`characterID` = ? order by `endDate` desc', array('92993682'), true) in Builder.php line 1406
  103. at Builder->runSelect() in Builder.php line 1383
  104. at Builder->get() in CharacterRepository.php line 303
  105. at ViewController->getCharacterIndustry('92993682') in ViewController.php line 119
  106. at ViewController->getIndustry('92993682')
  107. at call_user_func_array(array(object(ViewController), 'getIndustry'), array('character_id' => '92993682')) in Controller.php line 256
  108. at Controller->callAction('getIndustry', array('character_id' => '92993682')) in ControllerDispatcher.php line 164
  109. at ControllerDispatcher->call(object(ViewController), object(Route), 'getIndustry') in ControllerDispatcher.php line 112
  110. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  111. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
  112. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  113. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  114. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 114
  115. at ControllerDispatcher->callWithinStack(object(ViewController), object(Route), object(Request), 'getIndustry') in ControllerDispatcher.php line 69
  116. at ControllerDispatcher->dispatch(object(Route), object(Request), 'Seat\Web\Http\Controllers\Character\ViewController', 'getIndustry') in Route.php line 203
  117. at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134
  118. at Route->run(object(Request)) in Router.php line 708
  119. at Router->Illuminate\Routing\{closure}(object(Request))
  120. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
  121. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CharacterBouncer.php line 69
  122. at CharacterBouncer->handle(object(Request), object(Closure), 'industry')
  123. at call_user_func_array(array(object(CharacterBouncer), 'handle'), array(object(Request), object(Closure), 'industry')) in Pipeline.php line 124
  124. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Mfa.php line 51
  125. at Mfa->handle(object(Request), object(Closure))
  126. at call_user_func_array(array(object(Mfa), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  127. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Authenticate.php line 67
  128. at Authenticate->handle(object(Request), object(Closure))
  129. at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  130. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  131. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  132. at Pipeline->then(object(Closure)) in Router.php line 710
  133. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 675
  134. at Router->dispatchToRoute(object(Request)) in Router.php line 635
  135. at Router->dispatch(object(Request)) in Kernel.php line 236
  136. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  137. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
  138. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 50
  139. at VerifyCsrfToken->handle(object(Request), object(Closure))
  140. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  141. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  142. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  143. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  144. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 62
  145. at StartSession->handle(object(Request), object(Closure))
  146. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  147. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  148. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  149. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  150. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59
  151. at EncryptCookies->handle(object(Request), object(Closure))
  152. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  153. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  154. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  155. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
  156. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  157. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
  158. at Pipeline->then(object(Closure)) in Kernel.php line 122
  159. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 87
  160. at Kernel->handle(object(Request)) in index.php line 54
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement