Page 1 of 1

HTTP ERROR 500

Posted: 17 Mar 2019, 13:37
by Asyesh
Hello
I have problems with the tradepost especially with the guild trade and the stock ..
in the stock no action possible and the trader guild takes the articles but displays HTML Error 500 which is a shame because only the trades with the possible crown remain

Tradepost actived
Image

Re: HTTP ERROR 500

Posted: 18 Mar 2019, 05:08
by Asyesh
guild exchange fails to write and is not in stock

Re: HTTP ERROR 500

Posted: 18 Mar 2019, 18:57
by Nyuton
Please share a server logfile and your Server ID so I can track errors in the webserver log.

Re: HTTP ERROR 500

Posted: 18 Mar 2019, 19:32
by Asyesh
thanks for adding the French translation as fast, here are the files:
last log server, stats log tradepost, server id 3174

Re: HTTP ERROR 500

Posted: 19 Mar 2019, 17:59
by Nyuton
I think there's something wrong with the install script. This will affect new installations that didn't have an earlier mod version installed.

Please run these two commands in your database:

Code: Select all

ALTER TABLE `nyu_tradepost_log` ADD COLUMN `RegionID` TINYINT UNSIGNED NULL DEFAULT NULL AFTER `ObjectTypeID`;
ALTER TABLE `nyu_tradepost_offers` ADD COLUMN `RegionID` TINYINT UNSIGNED NULL DEFAULT NULL AFTER `ObjectTypeID`;
Let me know if that helps.

Re: HTTP ERROR 500

Posted: 19 Mar 2019, 20:22
by Asyesh
here is the return of the database
MySQL returned an empty result (that is, no rows). (dealt with in 0.4038 second (s).)
ALTER TABLE `nyu_tradepost_log` ADD COLUMN` RegionID` TINYINT UNSIGNED NULL DEFAULT NULL AFTER `ObjectTypeID`

  MySQL returned an empty result (that is, no rows). (Processed in 0.4705 second (s).)
ALTER TABLE `nyu_tradepost_offers` ADD COLUMN` RegionID` TINYINT UNSIGNED NULL DEFAULT NULL AFTER `ObjectTypeID`
I do not see this error 500 after a few tests, I will still test a few days is forwarding the closure of the post, thank you very much you are very professional.

Re: HTTP ERROR 500

Posted: 20 Mar 2019, 04:16
by Asyesh
After already several test everything works thanks for the repair error 500, I noticed a String id which seems to me identical because after verification of the translation everything seems normal, to checked but it seems to me logical in view of the XML that the title will have to be String id 12, but nothing very dramatic.
Image

Re: HTTP ERROR 500

Posted: 20 Mar 2019, 04:21
by Asyesh
Fixed problem Thank you