search

DarkstarProject / XiWeb

Darkstar web front end for players
4 stars 12 forks source link

dialog box error message when clicking auction house link #2

Open maxtherabbit opened 6 years ago

maxtherabbit commented 6 years ago

DataTables warning: table id=auctionHouse - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

jdazzle commented 6 years ago

Question: Can you try running the following SQL statement against your database and see if it generates an error?

SELECT auction_house.itemId, name, aH as type, stack, price FROM item_basic, auction_house where item_basic.itemId = auction_house.itemId and sale = 0 ORDER BY 2 asc LIMIT 0, 10

maxtherabbit commented 6 years ago

@whasf it's his DB

On 2/1/2018 10:53 AM, jdazzle wrote:

Question: Can you try running the following SQL statement against your database and see if it generates an error?

|SELECT auction_house.itemId, name, aH as type, stack, price FROM item_basic, auction_house where item_basic.itemId = auction_house.itemId and sale = 0 ORDER BY 2 asc LIMIT 0, 10|

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/DarkstarProject/XiWeb/issues/2#issuecomment-362309136, or mute the thread https://github.com/notifications/unsubscribe-auth/AGPFUfdczZj2ELLOZQlbHaR9E-xO99gSks5tQd39gaJpZM4R1yw1.

jdazzle commented 6 years ago

Nevermind, I think I see the issue now. I didn't know he had XIWeb up on the server. Appears to be an issue with generating the link to ffxiclopedia. I'll take a look at it after lunch :)