|
Saagkri | Fri 27-May-16 04:51 PM |
Member since 17th Jun 2014
801 posts
| |
|
#63665, "Issue with Daphedee's IMM comments in PBF"
Edited on Fri 27-May-16 04:51 PM
|
Looks like one page got duplicated and there are no entries after ~750 hrs., so maybe one got left out?
|
|
|
|
|
Umiron | Fri 27-May-16 06:43 PM |
Member since 29th May 2017
1499 posts
| |
|
#63667, "RE: Issue with Daphedee's IMM comments in PBF"
In response to Reply #0
|
They have a "max length", essentially, and hers overflowed that. The same things happens with super deathful long-lived characters at PK wins.
|
|
|
|
  |
Sertius | Fri 27-May-16 10:10 PM |
Member since 17th Nov 2008
360 posts
| |
|
#63669, "Update the data model perhaps?"
In response to Reply #1
|
ALTER TABLE pbf_data MODIFY imm_comment VARCHAR(max);
Or something similar, plus the appropriate changes in code if needed.
(Please disregard if not feasible due to X, I know nothing about your code)
|
|
|
|
    |
Umiron | Fri 27-May-16 10:48 PM |
Member since 29th May 2017
1499 posts
| |
|
#63670, "RE: Update the data model perhaps?"
In response to Reply #2
|
That stuff isn't a SQL database. Very little in CF is. The limitation has more to do with the maximum number of bytes various string functions or structures can work with or store. It's been a very low priority to refactor because it's messy code that works fine (per se) with the exception of the length limitation which isn't hit 99.9% of the time.
|
|
|
|
      |
Kstatida | Mon 30-May-16 10:02 AM |
Member since 12th Feb 2015
2214 posts
| |
|
#63708, "We should really fix that"
In response to Reply #3
|
Both with PK Wins/Deaths and imm comments. Could this perhaps be sponsored in any way? Because it's like I'm paying for PBF and don't get the whole amount of info, which well... sucks
|
|
|
|
      |
Saagkri | Wed 01-Jun-16 01:17 AM |
Member since 17th Jun 2014
801 posts
| |
|
#63726, "RE: Update the data model perhaps?"
In response to Reply #3
|
I understand that it's a rarity. The only problem is that the few PBFs that are hit with this limitation are the ones we want to see the most And they omit the comments from the most interesting parts of the char's life.
A fix could be to duplicate the IMM_comments code and make a IMM_comments2 to store comments after IMM_comments is full. Then publish both.
|
|
|
|
|