Is the box steer and fcgi_gw servers running?
Printable View
Is the box steer and fcgi_gw servers running?
yes everyone is running
https://uploaddeimagens.com.br/image...jpg?1659297283
guys any idea
steer sp error
all is import in Navicat
Mysql version? Try to use HeidiSQL. Also check this https://forum.ragezone.com/f797/tera...ml#post9130091
all came with VM from Bobson so I even don't check.
Any way i run all .bat files i can login to steer and to box web, but I will setup all again.
THX for your help @hsdn
There is some error like "No message defined as error code exists. [285212422]" , guys any chance that some one can upload some files that we can import them from Import box data.
https://forum.ragezone.com/attachmen...3&d=1659876099
Attachment 172163
Strange errors in log of SteerSession:
Code:2022-08-09 10:33:29,477, CRITICAL, $ Server ready $
Traceback (most recent call last):
File "D:\TERA_SERVER\steerserver\pyCruise\DB.py", line 65, in CallProc cursor.callproc(procedureName, inParams + outParams)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 260, in callproc self._query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 312, in _query rowcount = self._do_query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 276, in _do_query db.query(q)
OperationalError: (2006, 'MySQL server has gone away')
Traceback (most recent call last):
File "D:\TERA_SERVER\steerserver\pyCruise\DB.py", line 65, in CallProc cursor.callproc(procedureName, inParams + outParams)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 260, in callproc self._query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 312, in _query rowcount = self._do_query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 276, in _do_query db.query(q)
OperationalError: (2006, 'MySQL server has gone away')
Traceback (most recent call last):
File "D:\TERA_SERVER\steerserver\pyCruise\DB.py", line 65, in CallProc cursor.callproc(procedureName, inParams + outParams)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 260, in callproc self._query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 312, in _query
rowcount = self._do_query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 276, in _do_quer
y
db.query(q)
OperationalError: (2006, 'MySQL server has gone away')
Traceback (most recent call last):
File "D:\TERA_SERVER\steerserver\pyCruise\DB.py", line 65, in CallProc cursor.callproc(procedureName, inParams + outParams)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 260, in callproc self._query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 312, in _query rowcount = self._do_query(q)
File "c:\Python26\lib\site-packages\MySQLdb\cursors.py", line 276, in _do_query db.query(q)
OperationalError: (2006, 'MySQL server has gone away')
@TieLay problems with MySQL server connection or max connection issue. I recommend using the official MySQL Server (installed as System Service) instead of portable releases from laragon, xampp, etc.
I solved the problem I was having but now when I try to add an item I just see this message.
https://i.ibb.co/cCyLrbL/Screenshot-1.jpg
@mesmoro You need create Service Item first. Or you can use Tera API Admin Panel, it does it automatically.
I did it the way you said and I think it worked but I can't test it because my launcher doesn't open (I still have to fix it). However when using the API Admin Panel and trying to create a test account to ban it I get messages like this:
https://uploaddeimagens.com.br/image...jpg?1661633618
Messages similar to this one appearing all the time in several tabs, did I do something wrong?
I install all on clean VM with Windows 10 ROG Edition.
Install full IIS setup web app on two different path with two different port and I don't get any errors. Maybe because I run all app and use Chrome.
For another test I make a small app in C# with cefsharp for test and no any errors.
All web app and Tera API admin working perfectly fine.
https://www.youtube.com/watch?v=Tobjyl5S2bQ
This error is due to the fact that your browser does not support HTML input fields of type datetime-local.
Use a modern browser like Google Chrome.
Error 1707 indicates that you are missing a box tag on box server side.
I recommend recreating the box server database.
I'm using chrome the problem appears when I enter the game and it records something in the "report_activity" field, then the tera API starts showing the following error:
https://uploaddeimagens.com.br/image...png?1661661464
I reinstalled the database again but no luck.
@mesmoro Check this: https://forum.ragezone.com/f797/tera...ml#post9138901
The reportTime field, which you have empty, should be automatically updated by the database when a row is inserted. If this does not happen, the database table has invalid structure, or you are using an older version of MySQL.
The issue with itemclaim was resolved, you were right, it was a tag that was not created.
But the report_activity problem continues even cleaning or recreating the database with 00_db_schema.sql.
The reportTime field has data, it is always recorded when the player enters the game.
@mesmoro What version of MySQL are you using? What data is in reportTime field?
MySQL 5.7.38
Usually to multiple entries in the table
These are the field data:
https://uploaddeimagens.com.br/image...jpg?1661671754
But it is not limited to this table, all that have TIMESTAMP have problems, even in the browser at the time of loading I get an error in the tera API and the API WEB ADMIN cannot load them.
@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?
@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:
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();
I made the change but the problem persists.
I tried to change my time zone but without success.
https://uploaddeimagens.com.br/image...jpg?1661709917
@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:
https://i.imgur.com/608dJ7T.png
I logged out and relog but the error persists.
I've used several different time zones, currently I'm using my local time
https://uploaddeimagens.com.br/image...jpg?1661712343
@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.
@mesmoro
did you try run all app as administrator?
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.
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.
https://uploaddeimagens.com.br/image...jpg?1661717278
when trying to enter the profile:
https://uploaddeimagens.com.br/image...jpg?1661717294
@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.
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.