API tools faq
paste
Advertisement
Guest User

error

a guest
Oct 18th, 2017
86
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.81 KB | None | 0 0
raw download clone embed print report
  1. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'until_date'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  2. Stack trace:
  3. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  4. #1 /home/meridian/public_html/application/models/model.character.php(0): db->execute()
  5. #2 /home/meridian/public_html/application/models/model.rankings.php(0): Mcharacter->check_hidden_char()
  6. #3 /home/meridian/public_html/application/models/model.rankings.php(0): Mrankings->load_player_rankings()
  7. #4 /home/meridian/public_html/application/controllers/controller.rankings.php(0): Mrankings->get_ranking_data()
  8. #5 /home/meridian/public_html/system/router.class.php(0): rankings->load_ranking_data()
  9. #6 /home/meridian/public_html/system/dmn.php(0): router->route()
  10. #7 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  11. #8 {main}
  12. ================================================================================
  13. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'credits'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  14. Stack trace:
  15. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  16. #1 /home/meridian/public_html/application/helpers/helper.website.php(0): db->execute()
  17. #2 /home/meridian/public_html/application/views/ver3/view.right_sidebar.php(39): website->get_user_credits_balance('kn0ws', 'DEFAULT', 1, '1034')
  18. #3 /home/meridian/public_html/system/load.class.php(0): unknown()
  19. #4 /home/meridian/public_html/application/views/ver3/rankings/view.index.php(133): load->view('ver3/view.right...')
  20. #5 /home/meridian/public_html/system/load.class.php(0): unknown()
  21. #6 /home/meridian/public_html/application/controllers/controller.rankings.php(0): load->view()
  22. #7 /home/meridian/public_html/system/router.class.php(0): rankings->index()
  23. #8 /home/meridian/public_html/system/dmn.php(0): router->route()
  24. #9 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  25. #10 {main}
  26. ================================================================================
  27. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'credits'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  28. Stack trace:
  29. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  30. #1 /home/meridian/public_html/application/helpers/helper.website.php(0): db->execute()
  31. #2 /home/meridian/public_html/application/views/ver3/view.right_sidebar.php(39): website->get_user_credits_balance('kn0ws', 'DEFAULT', 1, '1034')
  32. #3 /home/meridian/public_html/system/load.class.php(0): unknown()
  33. #4 /home/meridian/public_html/application/views/ver3/rankings/view.online.php(101): load->view('ver3/view.right...')
  34. #5 /home/meridian/public_html/system/load.class.php(0): unknown()
  35. #6 /home/meridian/public_html/application/controllers/controller.rankings.php(0): load->view()
  36. #7 /home/meridian/public_html/system/router.class.php(0): rankings->online_players('DEFAULT')
  37. #8 /home/meridian/public_html/system/dmn.php(0): router->route()
  38. #9 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  39. #10 {main}
  40. ================================================================================
  41. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'credits'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  42. Stack trace:
  43. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  44. #1 /home/meridian/public_html/application/helpers/helper.website.php(0): db->execute()
  45. #2 /home/meridian/public_html/application/views/ver3/view.right_sidebar.php(39): website->get_user_credits_balance('kn0ws', 'DEFAULT', 1, '1034')
  46. #3 /home/meridian/public_html/system/load.class.php(0): unknown()
  47. #4 /home/meridian/public_html/application/views/ver3/view.footer.php(2): load->view('ver3/view.right...')
  48. #5 /home/meridian/public_html/system/load.class.php(0): unknown()
  49. #6 /home/meridian/public_html/application/views/ver3/home/view.home.php(47): load->view('ver3/view.foote...')
  50. #7 /home/meridian/public_html/system/load.class.php(0): unknown()
  51. #8 /home/meridian/public_html/application/controllers/controller.home.php(0): load->view()
  52. #9 /home/meridian/public_html/system/router.class.php(0): home->index()
  53. #10 /home/meridian/public_html/system/dmn.php(0): router->route()
  54. #11 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  55. #12 {main}
  56. ================================================================================
  57. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'credits'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  58. Stack trace:
  59. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  60. #1 /home/meridian/public_html/application/helpers/helper.website.php(0): db->execute()
  61. #2 /home/meridian/public_html/application/views/ver3/view.right_sidebar.php(39): website->get_user_credits_balance('kn0ws', 'DEFAULT', 1, '1034')
  62. #3 /home/meridian/public_html/system/load.class.php(0): unknown()
  63. #4 /home/meridian/public_html/application/views/ver3/rankings/view.index.php(133): load->view('ver3/view.right...')
  64. #5 /home/meridian/public_html/system/load.class.php(0): unknown()
  65. #6 /home/meridian/public_html/application/controllers/controller.rankings.php(0): load->view()
  66. #7 /home/meridian/public_html/system/router.class.php(0): rankings->index()
  67. #8 /home/meridian/public_html/system/dmn.php(0): router->route()
  68. #9 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  69. #10 {main}
  70. ================================================================================
  71. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'credits'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  72. Stack trace:
  73. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  74. #1 /home/meridian/public_html/application/helpers/helper.website.php(0): db->execute()
  75. #2 /home/meridian/public_html/application/views/ver3/view.right_sidebar.php(39): website->get_user_credits_balance('kn0ws', 'DEFAULT', 1, '1034')
  76. #3 /home/meridian/public_html/system/load.class.php(0): unknown()
  77. #4 /home/meridian/public_html/application/views/ver3/view.footer.php(2): load->view('ver3/view.right...')
  78. #5 /home/meridian/public_html/system/load.class.php(0): unknown()
  79. #6 /home/meridian/public_html/application/views/ver3/home/view.home.php(47): load->view('ver3/view.foote...')
  80. #7 /home/meridian/public_html/system/load.class.php(0): unknown()
  81. #8 /home/meridian/public_html/application/controllers/controller.home.php(0): load->view()
  82. #9 /home/meridian/public_html/system/router.class.php(0): home->index()
  83. #10 /home/meridian/public_html/system/dmn.php(0): router->route()
  84. #11 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  85. #12 {main}
  86. ================================================================================
  87. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'until_date'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  88. Stack trace:
  89. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  90. #1 /home/meridian/public_html/application/models/model.character.php(0): db->execute()
  91. #2 /home/meridian/public_html/application/models/model.rankings.php(0): Mcharacter->check_hidden_char()
  92. #3 /home/meridian/public_html/application/models/model.rankings.php(0): Mrankings->load_player_rankings()
  93. #4 /home/meridian/public_html/application/controllers/controller.rankings.php(0): Mrankings->get_ranking_data()
  94. #5 /home/meridian/public_html/system/router.class.php(0): rankings->load_ranking_data()
  95. #6 /home/meridian/public_html/system/dmn.php(0): router->route()
  96. #7 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  97. #8 {main}
  98. ================================================================================
  99. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'until_date'. [20018] (severity 16) [(null)]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  100. Stack trace:
  101. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDOStatement->execute()
  102. #1 /home/meridian/public_html/application/models/model.character.php(0): db->execute()
  103. #2 /home/meridian/public_html/application/models/model.rankings.php(0): Mcharacter->check_hidden_char()
  104. #3 /home/meridian/public_html/application/models/model.rankings.php(0): Mrankings->load_player_rankings()
  105. #4 /home/meridian/public_html/application/controllers/controller.rankings.php(0): Mrankings->get_ranking_data()
  106. #5 /home/meridian/public_html/system/router.class.php(0): rankings->load_ranking_data()
  107. #6 /home/meridian/public_html/system/dmn.php(0): router->route()
  108. #7 /home/meridian/public_html/index.php(44): require_once('/home/meridian/...')
  109. #8 {main}
  110. ================================================================================
  111. CREATE PROCEDURE [dbo].[WZ_CONNECT_MEMB]
  112. @uid varchar(20),
  113. @server varchar(20),
  114. @uip varchar(20)
  115. AS
  116. BEGIN
  117. BEGIN TRANSACTION
  118. SET NOCOUNT ON
  119. IF EXISTS (SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid)
  120. BEGIN
  121. UPDATE MEMB_STAT SET ip = @uip, connectstat = 1, servername = @server, ConnectTM = (GETDATE()) WHERE memb___id = @uid
  122. END
  123. ELSE
  124. BEGIN
  125. INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) VALUES (@uid, @uip, 1, @server)
  126. END
  127.  
  128. IF EXISTS (SELECT account FROM [dmncms].dbo.DmN_IP_Log WITH (READUNCOMMITTED) WHERE account = @uid AND ip = @uip)
  129. BEGIN
  130. UPDATE [dmncms].dbo.DmN_IP_Log SET last_connected = (GETDATE()), login_type = 0 WHERE account = @uid AND ip = @uip
  131. END
  132. ELSE
  133. BEGIN
  134. INSERT INTO [dmncms].dbo.DmN_IP_Log (account, ip, last_connected) VALUES (@uid, @uip,GETDATE())
  135. END
  136.  
  137. IF(@@Error <> 0 )
  138. ROLLBACK TRANSACTION
  139. ELSE
  140. COMMIT TRANSACTION
  141. SET NOCOUNT OFF
  142. END
  143. ================================================================================
  144. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 20018 Invalid column name 'ip'. [20018] (severity 16) [CREATE PROCEDURE [dbo].[WZ_CONNECT_MEMB]
  145. @uid varchar(20),
  146. @server varchar(20),
  147. @uip varchar(20)
  148. AS
  149. BEGIN
  150. BEGIN TRANSACTION
  151. SET NOCOUNT ON
  152. IF EXISTS (SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid)
  153. BEGIN
  154. UPDATE MEMB_STAT SET ip = @uip, connectstat = 1, servername = @server, ConnectTM = (GETDATE()) WHERE memb___id = @uid
  155. END
  156. ELSE
  157. BEGIN
  158. INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) VALUES (@uid, @uip, 1, @server)
  159. END
  160.  
  161. IF EXISTS (SELECT account FROM [dmncms].dbo.DmN_IP_Log WITH (READUNCOMMITTED) WHERE account = @uid AND ip = @uip)
  162. BEGIN
  163. UPDATE [dmncms].dbo.DmN_IP_Log SET last_connected = (GETDATE()), login_type = 0 WHERE account = @uid AND ip = @uip
  164. END
  165. ELSE
  166. BEGIN
  167. INSERT INTO [dmncms].dbo.DmN_IP_Log (account, ip, last_connected) VALUES (@uid, @uip,GETDATE())
  168. END
  169.  
  170. IF(@@Error <> 0 )
  171. ROLLBACK TRANSACTION
  172. ELSE
  173. COMMIT TRANSACTION
  174. SET NOCOUNT OFF
  175. END]' in /home/meridian/public_html/application/libraries/lib.db.php:0
  176. Stack trace:
  177. #0 /home/meridian/public_html/application/libraries/lib.db.php(0): PDO->query()
  178. #1 /home/meridian/public_html/setup/application/models/model.setup.php(0): db->query()
  179. #2 /home/meridian/public_html/setup/application/controllers/controller.setup.php(0): Msetup->insert_sql_data()
  180. #3 /home/meridian/public_html/system/router.class.php(0): setup->step9()
  181. #4 /home/meridian/public_html/setup/index.php(0): router->route()
  182. #5 {main}
  183. ================================================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!