issues: 1052151017
This data as json
id | node_id | number | title | user | state | locked | assignee | milestone | comments | created_at | updated_at | closed_at | author_association | active_lock_reason | draft | pull_request | body | reactions | performed_via_github_app | state_reason | repo | type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1052151017 | I_kwDOBLalGM4-tozp | 3740 | Error Code: 1146 - Table 'ace_world.weenie_properties_float' doesn't exists | 23504389 | closed | 0 | 7 | 2021-11-12T16:30:49Z | 2021-11-13T15:06:15Z | 2021-11-13T15:06:15Z | NONE | <!-- IF YOU DON'T FILL OUT THE FOLLOWING INFORMATION YOUR ISSUE MIGHT BE CLOSED WITHOUT INVESTIGATING --> ### Bug Report or Feature Request (mark with an `x`) ``` - [ ] bug report -> please search issues before submitting - [ ] feature request ``` ### Repro steps. <!-- Please list the steps to reproduce a bug here --> When importing and running the sql update script 2021-03-18-00-Update-Casting-Stone.sql I get an error code 1146. I'm running this script on the shard databas right after running the base sql script found here: https://github.com/ACEmulator/ACE/blob/master/Database/Base/ShardBase.sql ### The log given by the failure. Here is the log contents: Query: /* PropertyFloat.CriticalFrequency - 51899 Casting Stone */ UPDATE biota_properties_float bfloat INNER JOIN biota ON bfloat.object_Id=biota.Id INNER JOIN ace_world.weenie_properties_float wfloat ON wfloat.object_Id=biota.weenie_Class_Id SET bfloat.value=wfloat.value WHERE biota.weenie_Class_Id=51899 and bfloat.`type`=147 and wfloat.`type`=147 Error occured at:2021-11-12 11:18:48 Line no.:7 Error Code: 1146 - Table 'ace_world.weenie_properties_float' doesn't exist <!-- Normally this include a stack trace and some other information about the failure. --> ### Desired functionality. <!-- What would like to see implemented? What is the use case? --> I'd like to be able to apply these updates so I can get my server up and running. ### Mention any other details that might be useful. <!-- Please include any information that can help clarify the request here --> My installation is on Windows 10 Pro with mysql v8.0 community editio [sqlyog.err.txt](https://github.com/ACEmulator/ACE/files/7528996/sqlyog.err.txt) ![Screenshot 2021-11-12 112846](https://user-images.githubusercontent.com/23504389/141501047-4ff0bdbd-c26b-4ef6-a17f-69e6acb31552.jpg) n | {"url": "https://api.github.com/repos/ACEmulator/ACE/issues/3740/reactions", "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | completed | 79078680 | issue |