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

Is the box steer and fcgi_gw servers running?

Quote:

---

Originally Posted by vileninja

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

Code:

---


IF criteria_ IS NOT NULL THEN
        SET @ConditionQuery = CONCAT @ConditionQuery,        ' AND (CAST(A.actionLogIDint AS CHAR) like ''%', criteria_, '%''',        ' OR F.displayName like ''%', criteria_, '%'')');    END IF;

[Err] 1310 - End-label $$ without match

---

all is import in Navicat

Quote:

---

Originally Posted by shadow66

guys any idea

steer sp error

Code:

---


IF criteria_ IS NOT NULL THEN
        SET @ConditionQuery = CONCAT @ConditionQuery,        ' AND (CAST(A.actionLogIDint AS CHAR) like ''%', criteria_, '%''',        ' OR F.displayName like ''%', criteria_, '%'')');    END IF;

[Err] 1310 - End-label $$ without match

---

all is import in Navicat

---

Mysql version? Try to use HeidiSQL. Also check this https://forum.ragezone.com/f797/tera...ml#post9130091

Quote:

---

Originally Posted by hsdn

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.

Quote:

---

Originally Posted by hsdn

@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?

Quote:

---

Originally Posted by hsdn

@mesmoro You need create Service Item first. Or you can use Tera API Admin Panel, it does it automatically.

---

I agree with hsdn and using Tera API Admin Panel, is way better that play with Box app.

Quote:

---

Originally Posted by mesmoro

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 solved the error that was in the message, apparently it doesn't work in firefox. But I still don't get anything by itemclaim, in tera api I get the message "HubError: OpArb.opmsg.CreateBox: 23:1707"

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

Quote:

---

Originally Posted by mesmoro

https://uploaddeimagens.com.br/image...jpg?1661633618

---

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.

Quote:

---

Originally Posted by mesmoro

I solved the error that was in the message, apparently it doesn't work in firefox. But I still don't get anything by itemclaim, in tera api I get the message "HubError: OpArb.opmsg.CreateBox: 23:1707"

---

Error 1707 indicates that you are missing a box tag on box server side.
I recommend recreating the box server database.

Quote:

---

Originally Posted by hsdn

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.

Quote:

---

Originally Posted by hsdn

@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?

Quote:

---

Originally Posted by hsdn

@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?

Quote:

---

Originally Posted by hsdn

@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.

@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:

Code:

---

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

---

with:

Code:

---

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.

Quote:

---

Originally Posted by 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:

Code:

---

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

---

with:

Code:

---

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.

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

Quote:

---

Originally Posted by 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:
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?

Quote:

---

Originally Posted by 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.

---

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

Quote:

---

Originally Posted by shadow66

@mesmoro

did you try run all app as administrator?

---

Yes as administrator or not the error persists

Quote:

---

Originally Posted by mesmoro

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

---

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

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.

Quote:

---

Originally Posted by hsdn

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.

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.

Quote:

---

Originally Posted by 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.

---

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

Quote:

---

Originally Posted by mesmoro

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.

Quote:

---

Originally Posted by hsdn

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.