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">
</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 <string>, line 2, in <function>
(Object: <lambda>
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: <string>
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.