TERA 92/100 Steer Server + Box Server (Item Claim System)

[mesmoro]

@mesmoro The table looks correct. For some reason, the API cannot query data from TIMESTAMP fields.
We were unable to get this problem on our test server. What version of node.js are you using?

I'm using v18.8.0-x64.
I also get the same problem on v18.1.0-x64.

[hsdn]

@mesmoro Probably in your case the problem is related to the incorrect definition of the time zone.
Try to log out of the Admin Panel using the Logout button and log in again.

- - - Updated - - -

Also, try to solve this problem, open file src\controllers\admin.controller.js and replace this line:

req.user.tz = req.body.tz || moment.tz.guess();

with:

req.user.tz = moment.tz.zone(req.body.tz)?.name || moment.tz.guess();

Restart the API, log out of the admin panel and log in again.

[mesmoro]

@mesmoro Probably in your case the problem is related to the incorrect definition of the time zone.
Try to log out of the Admin Panel using the Logout button and log in again.

- - - Updated - - -

Also, try to solve this problem, open file src\controllers\admin.controller.js and replace this line:

req.user.tz = req.body.tz || moment.tz.guess();

with:

req.user.tz = moment.tz.zone(req.body.tz)?.name || moment.tz.guess();

Restart the API, log out of the admin panel and log in again.

I made the change but the problem persists.
I tried to change my time zone but without success.

[hsdn]

@mesmoro You need log out of the admin panel and log in again. You can also try deleting the sessions directory.

- - - Updated - - -

Also, show me what timezone you have when you run the API:

[mesmoro]

@mesmoro You need log out of the admin panel and log in again. You can also try deleting the sessions directory.

- - - Updated - - -

Also, show me what timezone you have when you run the API:

I logged out and relog but the error persists.

I've used several different time zones, currently I'm using my local time

[hsdn]

@mesmoro Show me the Profile page in Admin Panel.

- - - Updated - - -

According to my tests, an error like yours only appears if the req.user.tz variable is null or undefined.
This variable is filled when you log-in (written to the session file). For some reason it doesn't work for you.

[shadow66]

@mesmoro

did you try run all app as administrator?

[mesmoro]

@mesmoro Show me the Profile page in Admin Panel.

- - - Updated - - -

According to my tests, an error like yours only appears if the req.user.tz variable is null or undefined.
This variable is filled when you log-in (written to the session file). For some reason it doesn't work for you.

Is this file in "tera-api\sessions" ?

@mesmoro

did you try run all app as administrator?

Yes as administrator or not the error persists

[hsdn]

Is this file in "tera-api\sessions" ?

Yes, you need to remove this folder. Also please show the Profile page.

[shadow66]

At the moment i Uploading full preinstalled clean VM All is installed and working perfect.

WebApp access from two address: 127.0.0.1 and 127.0.0.1:88 and all other api works ok

All tested with Chrome and Edge Browser and no any issues.

Soon will post links and info.

[mesmoro]

Yes, you need to remove this folder. Also please show the Profile page.

Deleting the folder, tera API will crash.
When opening again the folder is recreated.


sorry I didn't quite understand where this Profile page is so I'm sorry if I sent something wrong.



when trying to enter the profile:

[hsdn]

@mesmoro Unfortunately, I have no idea how to fix this problem. For some reason your user.tz variable is empty.

Variable can only be empty if you login the API from an old browser (before the fix https://github.com/justkeepquiet/ter...1145c215f0a4f4) and then didn't delete the sessions folder. Installing this fix and deleting the sessions folder (with the stopped API) should have completely solved the problem.

[mesmoro]

@mesmoro Unfortunately, I have no idea how to fix this problem. For some reason your user.tz variable is empty.

Variable can only be empty if you login the API from an old browser (before the fix https://github.com/justkeepquiet/ter...1145c215f0a4f4) and then didn't delete the sessions folder. Installing this fix and deleting the sessions folder (with the stopped API) should have completely solved the problem.

well, so in this case I will have to remain with this problem. Thanks for your help you helped me a lot with this and other problems, I will post if I have any solution

[hsdn]

well, so in this case I will have to remain with this problem. Thanks for your help you helped me a lot with this and other problems, I will post if I have any solution

Try to install this update:

1. Download updated API: https://github.com/justkeepquiet/ter...ads/master.zip
2. Replace all files of tera-api\src directory with new ones.
3. Stop TeraAPI.
4. Delete tera-api\sessions folder.
5. Start TeraAPI.

I fixed the algorithm for passing variables to the session, this should help in solving the problem.

[mesmoro]

Try to install this update:

1. Download updated API: https://github.com/justkeepquiet/ter...ads/master.zip
2. Replace all files of tera-api\src directory with new ones.
3. Stop TeraAPI.
4. Delete tera-api\sessions folder.
5. Start TeraAPI.

I fixed the algorithm for passing variables to the session, this should help in solving the problem.

You got it.
The issue has been resolved with this update.
Thanks for helping me with this.

Now I can use the WEB APP API without errors and I can also send things through the Item claim.
I don't think I will have any more problems with that. Thank you.