Error Code: 1146 - Table 'ace_world.weenie_properties_float' doesn't exists

[davidwheelen]

Bug Report or Feature Request (mark with an x)

- [ ] bug report -> please search issues before submitting
- [ ] feature request

Repro steps.

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

Desired functionality.

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.

My installation is on Windows 10 Pro with mysql v8.0 community editio
sqlyog.err.txt

n

[ziang4891]

Why are you doing that? If this is a new server, you don't need to run any of the update scripts

[ziang4891]

This error means that there is probably something wrong with your database, as the ace_world DB or weenie_properties_float table is missing, the latter of which is a critical table for ACE operation, and shouldn't be missing

[davidwheelen]

I'm following the install instructions from acemulator and under updates for the shard database these update scripts exist. These update scripts are also in the ace.master zip under database\updates

On Fri, Nov 12, 2021 at 12:36 PM ziang4891 ***@***.***> wrote: This error means that there is probably something wrong with your database, as the ace_world DB or weenie_properties_float table is missing, the latter of which is a critical table for ACE operation, and shouldn't be missing — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3740 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFTKMBOPDP5ZA7642C73KT3ULVGCZANCNFSM5H5G6CZQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

-- <https://5gstore.com/> <https://5gstore.com/>[image: 5gstore] <https://5gstore.com/> *David Wheelen* *Sales and Technical Support* O:833-547-8673 EXT: 292 ***@***.*** | 5Gstore.com 220 Exchange Dr, Suite A Crystal Lake, IL 60014 [image: facebook] <https://www.facebook.com/the5Gstore>[image: linkedin] <http://linkedin.com/company/3gstore.com>[image: youtube] <https://www.youtube.com/channel/UCPfPFshSC-rH4IbaClXrWSQ> [image: PCE][image: PCSS][image: cpns][image: cpsa][image: cpcnp] [image: dcss][image: dcts]

[ziang4891]

You don't need to use the update scripts for a new install. The update scripts in
ACE/Database/Updates/Shard/ are for those with existing servers that already have data in the Shard that needs to be modified

[davidwheelen]

Oh ok, the guide said to apply any updates that were there. Good to know, thank you.

On Fri, Nov 12, 2021 at 1:13 PM ziang4891 ***@***.***> wrote: You don't need to use the update scripts for a new install — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3740 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFTKMBOQTRW2LTGJ2KIUB7DULVKNLANCNFSM5H5G6CZQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

-- <https://5gstore.com/> <https://5gstore.com/>[image: 5gstore] <https://5gstore.com/> *David Wheelen* *Sales and Technical Support* O:833-547-8673 EXT: 292 ***@***.*** | 5Gstore.com 220 Exchange Dr, Suite A Crystal Lake, IL 60014 [image: facebook] <https://www.facebook.com/the5Gstore>[image: linkedin] <http://linkedin.com/company/3gstore.com>[image: youtube] <https://www.youtube.com/channel/UCPfPFshSC-rH4IbaClXrWSQ> [image: PCE][image: PCSS][image: cpns][image: cpsa][image: cpcnp] [image: dcss][image: dcts]

[ziang4891]

Many of those scripts were made assuming that the World DB already exists, which it won't if following the install guide for a new install. There may be one or two that might be needed, so I would suggest continuing on with your install and then try running those again after the World DB is setup.

[davidwheelen]

It was exactly what you said, imported base world db and ran update scripts, bam server up and running. :D

On Fri, Nov 12, 2021 at 1:22 PM ziang4891 ***@***.***> wrote: Many of those scripts were made assuming that the World DB already exists, which it won't if following the install guide for a new install. There may be one or two that might be needed, so I would continue on with your install and then try running those again after the World DB is setup. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3740 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFTKMBKYYDKIFDUV75TVP3DULVLOBANCNFSM5H5G6CZQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

-- <https://5gstore.com/> <https://5gstore.com/>[image: 5gstore] <https://5gstore.com/> *David Wheelen* *Sales and Technical Support* O:833-547-8673 EXT: 292 ***@***.*** | 5Gstore.com 220 Exchange Dr, Suite A Crystal Lake, IL 60014 [image: facebook] <https://www.facebook.com/the5Gstore>[image: linkedin] <http://linkedin.com/company/3gstore.com>[image: youtube] <https://www.youtube.com/channel/UCPfPFshSC-rH4IbaClXrWSQ> [image: PCE][image: PCSS][image: cpns][image: cpsa][image: cpcnp] [image: dcss][image: dcts]