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

Page 8 of 9 FirstFirst 123456789 LastLast
Results 106 to 120 of 135
  1. #106
    Account Upgraded | Title Enabled! TieLay is offline
    MemberRank
    Jan 2011 Join Date
    RussiaLocation
    650Posts
    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')

  2. #107
    TERA Foundation hsdn is offline
    MemberRank
    Jun 2020 Join Date
    RussiaLocation
    356Posts
    @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.

  3. #108
    Enthusiast mesmoro is offline
    MemberRank
    Jul 2022 Join Date
    39Posts
    I solved the problem I was having but now when I try to add an item I just see this message.


  4. #109
    TERA Foundation hsdn is offline
    MemberRank
    Jun 2020 Join Date
    RussiaLocation
    356Posts
    @mesmoro You need create Service Item first. Or you can use Tera API Admin Panel, it does it automatically.

  5. #110
    Enthusiast mesmoro is offline
    MemberRank
    Jul 2022 Join Date
    39Posts
    Quote Originally Posted by hsdn View Post
    @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:


    Messages similar to this one appearing all the time in several tabs, did I do something wrong?
    Last edited by mesmoro; 28-08-22 at 12:44 AM.

  6. #111
    [DEV]ShadoW shadow66 is offline
    MemberRank
    Feb 2014 Join Date
    C#,SQL,C++Location
    365Posts
    Quote Originally Posted by hsdn View Post
    @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.

  7. #112
    Enthusiast mesmoro is offline
    MemberRank
    Jul 2022 Join Date
    39Posts
    Quote Originally Posted by mesmoro View Post
    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:


    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"

  8. #113
    [DEV]ShadoW shadow66 is offline
    MemberRank
    Feb 2014 Join Date
    C#,SQL,C++Location
    365Posts
    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.


  9. #114
    TERA Foundation hsdn is offline
    MemberRank
    Jun 2020 Join Date
    RussiaLocation
    356Posts
    Quote Originally Posted by mesmoro View Post
    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 View Post
    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.

  10. #115
    Enthusiast mesmoro is offline
    MemberRank
    Jul 2022 Join Date
    39Posts
    Quote Originally Posted by hsdn View Post
    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:


    I reinstalled the database again but no luck.

  11. #116
    TERA Foundation hsdn is offline
    MemberRank
    Jun 2020 Join Date
    RussiaLocation
    356Posts
    @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.
    Last edited by hsdn; 28-08-22 at 07:09 AM.

  12. #117
    Enthusiast mesmoro is offline
    MemberRank
    Jul 2022 Join Date
    39Posts
    Quote Originally Posted by hsdn View Post
    @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.

  13. #118
    TERA Foundation hsdn is offline
    MemberRank
    Jun 2020 Join Date
    RussiaLocation
    356Posts
    @mesmoro What version of MySQL are you using? What data is in reportTime field?

  14. #119
    Enthusiast mesmoro is offline
    MemberRank
    Jul 2022 Join Date
    39Posts
    Quote Originally Posted by hsdn View Post
    @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:



    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.

  15. #120
    TERA Foundation hsdn is offline
    MemberRank
    Jun 2020 Join Date
    RussiaLocation
    356Posts
    @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?



Advertisement