php - Unexpectedly truncated mediumtext field in MariaDB -


  • system: gnu/linux lmde 2, linux 3.16
  • db: mariadb 10.0.30-mariadb-0+deb8u1
  • server: apache/2.4.10
  • db interface module: libmysql - 5.5.55
  • php: php 5.6.30-0+deb8u1 mysqli + mbstring module
  • wcms: contao 3.0.5
  • browser: opera 12

at reworking 1 of websites wcms contao, strange behaviour longer texts in »text« , »accordion« elements. after 4448 chars or 4598 bytes, text truncated. db field »text« in table »tl_content« has size »mediumtext«, 16mb in size. repeated correcting article in contao doesn’t help.

then tried same correcting directly phpmyadmin in versions 4.8.0-dev, 4.7.0, 4.4.2 , 4.1.1, there’s still no changing of truncated text. in phpmyadmin 4.4.2 there additional message »oops, went wrong!!«. no error no., no explanation, meaningless message!

does know, what’s going wrong when longer texts truncated, , what’s solution solving this? lot!

addendum 2017-08-22 16:00 gmt

  • mariadb updated 10.0.32-mariadb-0+deb8u1
  • db interface module updated 5.5.57
  • another browser (firefox 50.1.0) has same problems
  • textfield updating not browser+phpmyadmin bash job perfectly!

therefore conclusion: seems disfunctional part can 1 or more of followings:

  • browsers transmit per phpmyadmin not enough data (unlikely)
  • javascript interferes (unlikely)
  • php interferes (unlikely)
  • db interface module can’t stand mariadb

addendum 2017-08-22 18:30 gmt

  • db interface module libmariadb installed

now i’m looking nessesary updates in /etc/php5/apache2/php.ini and/or other files. suggestions right places edit redirect php mysql functions libmariadb?

bert


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more