@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?
req.user.tz = req.body.tz || moment.tz.guess();
req.user.tz = moment.tz.zone(req.body.tz)?.name || moment.tz.guess();
@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.
Also, try to solve this problem, open file src\controllers\admin.controller.js and replace this line:
with:Code:req.user.tz = req.body.tz || moment.tz.guess();
Restart the API, log out of the admin panel and log in again.Code:req.user.tz = moment.tz.zone(req.body.tz)?.name || moment.tz.guess();
@mesmoro You need log out of the admin panel and log in again. You can also try deleting the sessions directory.
Also, show me what timezone you have when you run the API:
![]()
@mesmoro Show me the Profile page in Admin Panel.
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" ?
Yes, you need to remove this folder. Also please show the Profile page.
@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 fixTo view the content, you need to sign in or register) 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
Try to install this update:
1. Download updated API:To view the content, you need to sign in or register
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.
In your API folder, go to config folder, then open and edit admin.js with notepad, change those ips and you're good to goHello, I'm new to all this but really enjoying the challenge and this community. I've set up a online version of 92.04 and got everything working ok, shop, web admin etc...However my luck ran out yesterday, and I have changed 'something'. Now I cannot access the webpanel, box panel or steer panels in web admin..when I press the buttons they are trying to find 10.64.16.109, (Port 8050 missing) 10.64.16.109:8070 and 10.64.16.109:8060..
If i type 127.0.0.1:8050, 127.0.0.1:8060, 127.0.0.1:8070 etc into browser they appear ok. Would anybody know whats happening and how to correct..its like trying to access the admin panel of a router (mine doesnt use this address)
Check my WebApp video tutoAwesome Thank you for your help.. the box and steer are working fine now, however I'm not getting anything from the WebApp panel which is kind of a big deal lol. I confirmed a gadmin user in Steer..Might I have to drop the tables and start the process from scratch..would that mess up anything? If there are any suggestions as to what I can check?