Loading...
 
Skip to main content

Long (more than 200 char.) wiki page description output white page on save

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Long (more than 200 char.) wiki page description output white page on save
Version
22.x
23.x
Category
  • Error
  • Regression
  • Easy for Newbie Dev
Feature
Meta Tag
Wiki (page view, edit, history, rename, etc)
Resolution status
Fixed or Solved
Submitted by
Bernard Sfez / Tiki Specialist
Lastmod by
Bernard Sfez / Tiki Specialist
Rating
(0)
Related-to
Description

There is no visible limit about the length of the description field in Tiki for the user.
However this field is limited and if you go over the limit you will have a white page when saving your work potentially losing your last edit.

Copy to clipboard
[Mon Jun 14 09:11:25.437718 2021] [proxy_fcgi:error] [pid 46913:tid 140057356769024] [client 10.0.0.138:52983] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught TikiDb_Exception: Data too long for column 'description' at row 1 in /home/bernardsfez/public_html/lib/core/TikiDb/Exception.php:20\nStack trace:\n#0 /home/bernardsfez/public_html/lib/core/TikiDb.php(193): TikiDb_Exception::classify()\n#1 /home/bernardsfez/public_html/lib/core/TikiDb/Pdo.php(145): TikiDb->handleQueryError()\n#2 /home/bernardsfez/public_html/lib/core/TikiDb.php(101): TikiDb_Pdo->query()\n#3 /home/bernardsfez/public_html/lib/core/TikiDb/Table.php(130): TikiDb->queryException()\n#4 /home/bernardsfez/public_html/lib/core/TikiDb/Table.php(112): TikiDb_Table->updateMultiple()\n#5 /home/bernardsfez/public_html/lib/tikilib.php(5368): TikiDb_Table->update()\n#6 /home/bernardsfez/public_html/tiki-editpage.php(1227): TikiLib->update_page()\n#7 {main}\n  thrown in /home/bernardsfez/public_html/lib/core/TikiDb/Exception.php on line 20', referer: https://bernardsfez.com/tiki-editpage.php?page=Comp%C3%A9tences+cl%C3%A9s+et+portefeuille+clients


It is an important bug (edit may be lost) on a popular feature (wiki page) and require an easy fix (real limit of text + small warning".
it should be fixed asap.

UPDATE:The value of the length accepted by the field in the database is 200 characters.
Image


Solution

While the suggested length for a meta-tag description is around 50-200 for SEO there are many factors that should influence in favour of a change of length.

First using the description as meta-tags is an option. Therefore this suggestion can't be the main factor for a decision. With social medias the description can be also used as body of a post, share, etc.

I suggest:

  • We set the Length/Values for the Description field to 350~400 characters in the database.
  • We had a physical limitation to the length of the value that can be submit for the field description (to avoid WSoD in case the user add more characters than allowed).
  • We add a note about description : " You are allowed to insert 350 characters maximum."
  • ...
Importance
10 high
Easy to solve?
10 easy
Priority
99
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7767
Created
Monday 14 June, 2021 06:17:59 UTC
by Bernard Sfez / Tiki Specialist
LastModif
Tuesday 06 September, 2022 10:45:46 UTC


Show PHP error messages