The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb






Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Huge tags = sphere crash
Author Message
Ben
Sphere Developer
*****

Posts: 612
Likes Given: 2
Likes Received: 123 in 70 posts
Joined: Mar 2010
Reputation: 18

SphereCommunity

Post: #10
RE: Huge tags = sphere crash
Are you sure it wouldn't be a problem with tags not matching?

TAG.Sync.Paperdoll="layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713, layer1=5184, layercor1=NULL, layer2=7030, layercor2=2057, layer6=NULL, layercor6=NULL, layer6=5138, layercor6=2057, layer1=NULL, layercor1=NULL, layer2=NULL, layercor2=NULL, layer6=NULL, layercor6=NULL, layer6=5447, layercor6=713, layer22=NULL, layercor22=NULL, layer22=9860, layercor22=1940, layer2=5122, layercor2...

LOCAL.SQL=<DB.AEXECUTE SQLAsyncResponse, UPDATE paperdoll SET <TAG.SQLSync.PaperdollItem> WHERE uid='<UID>' LIMIT 1>

Using your code and a simple debug message, it showed me that it was trying to "UPDATE paperdoll SET 0 WHERE uid='...' LIMIT 1"
I did not actually do the AEXECUTE here, I was simply trying to see if the query was properly formed.
Now I'm not an SQL expert here, but I don't think doing SET 0 is proper syntax... and doing so inside an async query is probably not very good... So I'm gonna take a wild guess here and say the issue might be with async database handling not being able to handle USER mistakes properly.

When it comes to Sphere string handling, I think we are ok.
Any strings can hold up to 2147483647 characters (the 4096 Feeh mentioned is only for SCRIPT lines but it's still higher then what you need)

AxisII's current version: 2.0.4j
AxisII SourceCode on Github
AxisII up to date changelog
(This post was last modified: 04-28-2014 10:24 AM by Ben.)
04-28-2014 10:18 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Messages In This Thread
Huge tags = sphere crash - Coruja - 04-28-2014, 03:21 AM
RE: Huge tags = sphere crash - Alaric - 04-28-2014, 03:45 AM
RE: Huge tags = sphere crash - Feeh - 04-28-2014, 04:14 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 05:14 AM
RE: Huge tags = sphere crash - Ben - 04-28-2014, 05:36 AM
RE: Huge tags = sphere crash - XuN - 04-28-2014, 05:39 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 06:06 AM
RE: Huge tags = sphere crash - XuN - 04-28-2014, 06:49 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 07:07 AM
RE: Huge tags = sphere crash - Ben - 04-28-2014 10:18 AM
RE: Huge tags = sphere crash - Coruja - 04-28-2014, 12:59 PM
RE: Huge tags = sphere crash - Feeh - 04-29-2014, 08:53 AM
RE: Huge tags = sphere crash - Coruja - 04-29-2014, 04:33 PM
RE: Huge tags = sphere crash - Ben - 04-29-2014, 08:40 PM
RE: Huge tags = sphere crash - Coruja - 04-30-2014, 02:35 AM
RE: Huge tags = sphere crash - Avatar - 04-30-2014, 06:12 AM
RE: Huge tags = sphere crash - Ben - 04-30-2014, 07:30 AM
RE: Huge tags = sphere crash - Avatar - 04-30-2014, 08:30 AM
RE: Huge tags = sphere crash - Coruja - 05-02-2014, 11:30 AM
RE: Huge tags = sphere crash - Avatar - 05-06-2014, 10:32 AM
RE: Huge tags = sphere crash - Extreme - 05-10-2014, 02:42 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)