Detailed item view of item database is broken (homepage)

Find any bug ? Report it !
Locked
User avatar
Moat
Wanderer
Wanderer
Posts: 6
Joined: Sun Oct 16, 2022 1:49 pm

Detailed item view of item database is broken (homepage)

When selecting an item from the search results the response of the fetch is 'Data too long for column 'ip' at row 1' which then results in the message 'No item found. Update your filters!' within the container of the site where previously the items were listed withina table. The fetch of course already is fired with the above error code when the site tries to generate the specific item data as tooltip while showing 'Loading...'

edit: the behavious is experienced in google chrome, i not have data about other browsers

edit2: this describes the issue more accurate: viewtopic.php?t=1407
Last edited by Moat on Wed Nov 30, 2022 12:47 am, edited 1 time in total.
User avatar
Fyr
Wanderer
Wanderer
Posts: 7
Joined: Mon Aug 15, 2022 4:30 pm

Item Database Item Info doesnt work from IPv6 IPs

Worked with Jabstar to figure this out (in animist channel).

If someone tries to bring up the item information page from an ipv6 site, they get "No Item Found".

If they hit the item page directly (example: itm/item.php?id=160245), they get the error: "Data too long for column 'ip' at row 1"

This is because they are hitting the site via an ipv6, which is much longer than an ipv4 address, and the application looks to be only expecting an ipv4 address at the moment. Had Jabstar try hitting the site after turning off ipv6 and it worked correctly.

Let me know if you need any more info.
User avatar
Fyr
Wanderer
Wanderer
Posts: 7
Joined: Mon Aug 15, 2022 4:30 pm

Re: Detailed item view of item database is broken (homepage)

Issue is probably due to the client coming from an ipv6 address: viewtopic.php?t=1407
User avatar
Moat
Wanderer
Wanderer
Posts: 6
Joined: Sun Oct 16, 2022 1:49 pm

Re: Detailed item view of item database is broken (homepage)

Sounds plausible to me. So my post could atually be deleted/closed while the other post describes the issue more accurate.
User avatar
Karen
Developer
Developer
Posts: 1775
Joined: Thu May 19, 2022 9:14 pm

Re: Detailed item view of item database is broken (homepage)

Could you please check if this has been resolved? Ctrl+F5 to clear browser cache.
User avatar
Moat
Wanderer
Wanderer
Posts: 6
Joined: Sun Oct 16, 2022 1:49 pm

Re: Detailed item view of item database is broken (homepage)

Karen wrote: Wed Nov 30, 2022 11:40 am Could you please check if this has been resolved? Ctrl+F5 to clear browser cache.
The responds once again contain the correct array data.

This issue can be considered solved i think.

Thank you very much.
User avatar
Karen
Developer
Developer
Posts: 1775
Joined: Thu May 19, 2022 9:14 pm

Re: Detailed item view of item database is broken (homepage)

Thank you for confirming. Allow me to close this one.
Locked