API tools faq
paste
Advertisement
fabizockt96

Untitled

fabizockt96
May 11th, 2023 (edited)
21
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.35 KB | None | 0 0
raw download clone embed print report
  1. [ script:oxmysql] SCRIPT ERROR in promise (unhandled rejection): Error: jobs_creator was unable to execute a query!
  2. [ script:oxmysql] Table 'zap1084519-1.addon_account' doesn't exist
  3. [ script:oxmysql] SELECT 1 FROM `addon_account` WHERE BINARY(name)=? ["society_test"]
  4. [ script:oxmysql] > <unknown> (@oxmysql/dist/build.js:21833)
  5. [ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
  6. [ script:oxmysql]
  7. [ script:oxmysql] SCRIPT ERROR in promise (unhandled rejection): Error: jobs_creator was unable to execute a query!
  8. [ script:oxmysql] Table 'zap1084519-1.datastore' doesn't exist
  9. [ script:oxmysql] SELECT 1 FROM datastore WHERE BINARY(name)=? ["society_test"]
  10. [ script:oxmysql] > <unknown> (@oxmysql/dist/build.js:21833)
  11. [ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
  12. [ script:oxmysql]
  13. [ script:oxmysql]
  14. [ script:oxmysql]
  15. [ script:oxmysql] SCRIPT ERROR in promise (unhandled rejection): Error: jobs_creator was unable to execute a query!
  16. [ script:oxmysql] Unknown column 'skin_male' in 'field list'
  17. [ script:oxmysql] INSERT INTO job_grades(job_name, name, label, grade, salary, skin_male, skin_female)
  18. [ script:oxmysql] VALUES (?, ?, ?, ?, ?, "{}", "{}");
  19. [ script:oxmysql] ["test","test_1","Test 1",0,10]
  20. [ script:oxmysql] > <unknown> (@oxmysql/dist/build.js:21833)
  21. [ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96)
  22. [ script:oxmysql]
  23. [ script:jobs_creator] SCRIPT ERROR: ?:-1: attempt to index a nil value (field 'ESX')
  24. [ script:jobs_creator] SCRIPT ERROR: ?:-1: attempt to index a nil value (field 'ESX')
  25. [ script:jobs_creator] server/common.lua can't be found in es_extended
  26. [ script:jobs_creator]
  27. [ script:jobs_creator] Failed to add integration to 'es_extended/server/common.lua', probably the file is read-only
  28. [ script:jobs_creator] To fix, please manually add this code at the bottom of the file in new lines:
  29. [ script:jobs_creator] ----------------------------------
  30. [ script:jobs_creator] -- Jobs Creator integration (jobs_creator)
  31. [ script:jobs_creator] RegisterNetEvent('esx:refreshJobs')
  32. [ script:jobs_creator] AddEventHandler('esx:refreshJobs', function()
  33. [ script:jobs_creator] MySQL.Async.fetchAll('SELECT * FROM jobs', {}, function(jobs)
  34. [ script:jobs_creator] for k,v in ipairs(jobs) do
  35. [ script:jobs_creator] ESX.Jobs[v.name] = v
  36. [ script:jobs_creator] ESX.Jobs[v.name].grades = {}
  37. [ script:jobs_creator] end
  38. [ script:jobs_creator]
  39. [ script:jobs_creator] MySQL.Async.fetchAll('SELECT * FROM job_grades', {}, function(jobGrades)
  40. [ script:jobs_creator] for k,v in ipairs(jobGrades) do
  41. [ script:jobs_creator] if ESX.Jobs[v.job_name] then
  42. [ script:jobs_creator] ESX.Jobs[v.job_name].grades[tostring(v.grade)] = v
  43. [ script:jobs_creator] else
  44. [ script:jobs_creator] print(('[es_extended] [WARNING] Ignoring job grades for "%s" due to missing job'):format(v.job_name))
  45. [ script:jobs_creator] end
  46. [ script:jobs_creator] end
  47. [ script:jobs_creator]
  48. [ script:jobs_creator] for k2,v2 in pairs(ESX.Jobs) do
  49. [ script:jobs_creator] if ESX.Table.SizeOf(v2.grades) == 0 then
  50. [ script:jobs_creator] ESX.Jobs[v2.name] = nil
  51. [ script:jobs_creator] print(('[es_extended] [WARNING] Ignoring job "%s" due to no job grades found'):format(v2.name))
  52. [ script:jobs_creator] end
  53. [ script:jobs_creator] end
  54. [ script:jobs_creator] end)
  55. [ script:jobs_creator] end)
  56. [ script:jobs_creator] end)
  57. [ script:jobs_creator]
  58. [ script:jobs_creator] ----------------------------------
  59. [ script:jobs_creator]
  60. [ script:jobs_creator] server/main.lua can't be found in esx_addonaccount
  61. [ script:jobs_creator]
  62. [ script:jobs_creator] Failed to add integration to 'esx_addonaccount/server/main.lua', probably the file is read-only
  63. [ script:jobs_creator] To fix, please manually add this code at the bottom of the file in new lines:
  64. [ script:jobs_creator] ----------------------------------
  65. [ script:jobs_creator] -- Jobs Creator integration (jobs_creator)
  66. [ script:jobs_creator] RegisterNetEvent('esx_addonaccount:refreshAccounts')
  67. [ script:jobs_creator] AddEventHandler('esx_addonaccount:refreshAccounts', function()
  68. [ script:jobs_creator] local result = MySQL.Sync.fetchAll('SELECT * FROM addon_account')
  69. [ script:jobs_creator]
  70. [ script:jobs_creator] for i=1, #result, 1 do
  71. [ script:jobs_creator] local name = result[i].name
  72. [ script:jobs_creator] local label = result[i].label
  73. [ script:jobs_creator] local shared = result[i].shared
  74. [ script:jobs_creator]
  75. [ script:jobs_creator] local result2 = MySQL.Sync.fetchAll('SELECT * FROM addon_account_data WHERE account_name = @account_name', {
  76. [ script:jobs_creator] ['@account_name'] = name
  77. [ script:jobs_creator] })
  78. [ script:jobs_creator]
  79. [ script:jobs_creator] if shared == 0 then
  80. [ script:jobs_creator] table.insert(AccountsIndex, name)
  81. [ script:jobs_creator] Accounts[name] = {}
  82. [ script:jobs_creator]
  83. [ script:jobs_creator] for j=1, #result2, 1 do
  84. [ script:jobs_creator] local addonAccount = CreateAddonAccount(name, result2[j].owner, result2[j].money)
  85. [ script:jobs_creator] table.insert(Accounts[name], addonAccount)
  86. [ script:jobs_creator] end
  87. [ script:jobs_creator] else
  88. [ script:jobs_creator] local money = nil
  89. [ script:jobs_creator]
  90. [ script:jobs_creator] if #result2 == 0 then
  91. [ script:jobs_creator] MySQL.Sync.execute('INSERT INTO addon_account_data (account_name, money, owner) VALUES (@account_name, @money, NULL)', {
  92. [ script:jobs_creator] ['@account_name'] = name,
  93. [ script:jobs_creator] ['@money'] = 0
  94. [ script:jobs_creator] })
  95. [ script:jobs_creator]
  96. [ script:jobs_creator] money = 0
  97. [ script:jobs_creator] else
  98. [ script:jobs_creator] money = result2[1].money
  99. [ script:jobs_creator] end
  100. [ script:jobs_creator]
  101. [ script:jobs_creator] local addonAccount = CreateAddonAccount(name, nil, money)
  102. [ script:jobs_creator] SharedAccounts[name] = addonAccount
  103. [ script:jobs_creator] end
  104. [ script:jobs_creator] end
  105. [ script:jobs_creator] end)
  106. [ script:jobs_creator]
  107. [ script:jobs_creator] ----------------------------------
  108. [ script:jobs_creator]
  109. [ script:jobs_creator] server/common.lua can't be found in es_extended
  110. [ script:jobs_creator]
  111. [ script:jobs_creator] Failed to add integration to 'es_extended/server/common.lua', probably the file is read-only
  112. [ script:jobs_creator] To fix, please manually add this code at the bottom of the file in new lines:
  113. [ script:jobs_creator] ----------------------------------
  114. [ script:jobs_creator] -- Jobs Creator integration (jobs_creator)
  115. [ script:jobs_creator] ESX.ServerCallbacks = Core.ServerCallbacks
  116. [ script:jobs_creator]
  117. [ script:jobs_creator] ----------------------------------
  118. [ script:jobs_creator]
  119. [ script:jobs_creator] Setting up database (it may take few seconds)...
  120. [ script:jobs_creator] Database ready
  121. [ script:jobs_creator]
  122. [ script:jobs_creator] Config loaded successfully
  123. [ script:jobs_creator] Couldn't find file es_extended/client/common.lua
  124. [ script:jobs_creator] ESX Shared Object is nil
  125.  
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!