Results 1 to 2 of 2

Thread: database errors with new toons

  1. #1

    database errors with new toons

    Been having some strange issues with the new toons in our org bebot... complaints of ID out of range when tryin to execute INSERT statements.


    http://www.anarchy-online.com/conten...kup/chars.html

    using this link I put in one of the names of on of the new toons causing errors on the bot and walla it produces :

    Site Error

    An error was encountered while publishing this resource.

    TALESError
    Error

    exceptions.ValueError on Invalid integer value for charinstance in ""

    Troubleshooting Suggestions

    * The URL may be incorrect.
    * The parameters passed to this resource may be incorrect.
    * A resource that this resource relies on may be encountering an error.

    For more detailed information about the error, please refer to the HTML source for this page.

    If the error persists please contact the site maintainer. Thank you for your patience.

    -

    <HTML>
    <HEAD><TITLE>Site Error</TITLE></HEAD>
    <BODY>

    <TABLE BORDER="0" WIDTH="100%">
    <TR VALIGN="TOP">

    <TD WIDTH="10%" ALIGN="CENTER">
    &nbsp;
    </TD>

    <TD WIDTH="90%">
    <H2>Site Error</H2>
    <P>An error was encountered while publishing this resource.
    </P>

    <P><STRONG>TALESError</STRONG></P>


    <h3>Error</h3>
    <p>exceptions.ValueError on Invalid integer value for <em>charinstance</em> in "<PythonExpr here.guildForChar(charinstance = char.char_instance, dim = char.char_dimension) or nothing>"</p>

    <!--
    Traceback (innermost last):
    File /funcom/servers/Zope/lib/python/Products/Hotfix_2002-04-15/__init__.py, line 51, in publish_module
    File /funcom/servers/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 187, in publish
    File /funcom/servers/Zope-2.3.2-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
    (Object: Traversable)
    File /funcom/servers/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 171, in publish
    File /funcom/servers/Zope-2.3.2-src/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: chars.html)
    File /funcom/servers/Zope-2.3.2-src/lib/python/ZPublisher/Publish.py, line 112, in call_object
    (Object: chars.html)
    File /funcom/servers/Zope-2.3.2-src/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__
    (Object: chars.html)
    File /funcom/servers/Zope-2.3.2-src/lib/python/Shared/DC/Scripts/Bindings.py, line 354, in _bindAndExec
    (Object: chars.html)
    File /funcom/servers/Zope/lib/python/Products/PageTemplates/ZopePageTemplate.py, line 267, in _exec
    (Object: chars.html)
    File /funcom/servers/Zope/lib/python/Products/PageTemplates/PageTemplate.py, line 156, in pt_render
    (Object: chars.html)
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 232, in __call__
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 620, in do_useMacro
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 643, in do_defineSlot
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 445, in do_optTag_tal
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 430, in do_optTag
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 425, in no_tag
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 591, in do_condition
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 445, in do_optTag_tal
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 430, in do_optTag
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 425, in no_tag
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 591, in do_condition
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 445, in do_optTag_tal
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 430, in do_optTag
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 425, in no_tag
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 591, in do_condition
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 576, in do_loop_tal
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 265, in interpret
    File /funcom/servers/Zope/lib/python/TAL/TALInterpreter.py, line 506, in do_setGlobal_tal
    File /funcom/servers/Zope/lib/python/Products/PageTemplates/TALES.py, line 295, in evaluate
    File /funcom/servers/Zope/lib/python/Products/PageTemplates/PythonExpr.py, line 138, in __call__
    (Info: here.guildForChar(charinstance = char.char_instance, dim = char.char_dimension) or nothing)
    File &lt;string&gt;, line 2, in &lt;function&gt;
    (Object: &lt;lambda&gt
    File /funcom/servers/Zope-2.3.2-src/lib/python/Shared/DC/ZRDB/DA.py, line 482, in __call__
    (Object: guildForChar)
    File /funcom/servers/Zope-2.3.2-src/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__
    (Object: &lt;string&gt
    File /funcom/servers/Zope-2.3.2-src/lib/python/Shared/DC/ZRDB/sqlvar.py, line 183, in render
    (Object: charinstance)
    TALESError: (see above)

    -->
    <HR NOSHADE>

    <P>Troubleshooting Suggestions</P>

    <UL>
    <LI>The URL may be incorrect.</LI>
    <LI>The parameters passed to this resource may be incorrect.</LI>
    <LI>A resource that this resource relies on may be encountering an error.</LI>
    </UL>

    <P>For more detailed information about the error, please
    refer to the HTML source for this page.
    </P>

    <P>If the error persists please contact the site maintainer.
    Thank you for your patience.
    </P>
    </TD></TR>
    </TABLE>

    </BODY>
    </HTML>

    We have 6 characters who currently experience this issue, and obviously its on the master database and not on our bot.

    FYI - something is wrong with the ID on some character records.

  2. #2
    It's caused by IDs of toons to be more than allowed by 32bit signed integer.
    Funcom XML server atm is f..ed up and can't sync with their ingame server.
    Kuznechik, Board member of Disciples of Omni-Tek (and few dozens of alts)
    DoOT is recruiting
    -------
    Well, as a well-known fact - I know nothing (especially about engineers).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •