[DiscordArchive] Not sure what im doing wrong O.o Can anyone lend a hand?
[DiscordArchive] Not sure what im doing wrong O.o Can anyone lend a hand?
Archived author: Jinnai • Posted: 2021-09-18T13:56:10.884000+00:00
Original source
du you have the slightest idea how sql works? 
Archived author: Jinnai • Posted: 2021-09-18T13:56:30.999000+00:00
Original source
first of all, it would help if you paste the file instead of some random cropped screenshots
Archived author: Jinnai • Posted: 2021-09-18T13:57:02.244000+00:00
Original source
second - commenting always needs a space but i guess you figured it out (-- abc instead of --abc)
Archived author: Jinnai • Posted: 2021-09-18T13:57:37.756000+00:00
Original source
data too long means there is a predefined value for each field and you are breaking this
![[Image: unknown.png?ex=690c00c3&is=690aaf43&hm=a...535bd6c60&]](https://cdn.discordapp.com/attachments/870722120458600528/888786052721020928/unknown.png?ex=690c00c3&is=690aaf43&hm=ae92306e9d20d22845e0ee680d4763d86db13bbb22642aba6de8a3e535bd6c60&)
Archived author: Jinnai • Posted: 2021-09-18T13:58:28.337000+00:00
Original source
example
script name is data type char and has length of 64 - this is the limit of characters that is valid for that field
![[Image: unknown.png?ex=690c00c3&is=690aaf43&hm=a...535bd6c60&]](https://cdn.discordapp.com/attachments/870722120458600528/888786052721020928/unknown.png?ex=690c00c3&is=690aaf43&hm=ae92306e9d20d22845e0ee680d4763d86db13bbb22642aba6de8a3e535bd6c60&)
Archived author: Sanctuary • Posted: 2021-09-18T14:16:03.492000+00:00
Original source
Here's the template i made to add custom items into the item database, I must have done something really wrong because I can't see any of the items now in the database, but I kept the "If errors in sql, don't run" option enabled when i ran this.
RR_Custom_Item_Template.sql