X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=doc%2Fdb-backend.txt;h=76f423aa82dc896c4cddb1bc7ebb9da3466a9542;hb=f2ac3325d474dea1fc8b82d25099256c78bee803;hp=33155437008ff5c9179c8b7a6d32a59e2554d771;hpb=598294a727a2789b7c562ee7083da703c8bb0628;p=squirrelmail.git diff --git a/doc/db-backend.txt b/doc/db-backend.txt index 33155437..76f423aa 100644 --- a/doc/db-backend.txt +++ b/doc/db-backend.txt @@ -23,7 +23,8 @@ containg them is a part of your PHP include path. See the PHP documentation for information on how to do that. Under Mandrake Linux the PEAR classes are installed as part of the php-devel package and under FreeBSD they are installed as part of -the mod_php4 or php4 port/package. I'm afraid I have no information on +the mod_php4 or php4 port/package. In Debian, you can install the +php4-pear package. I'm afraid I have no information on other systems at the present time. @@ -118,3 +119,24 @@ database. Default preferences can be set by altering the $default array in db_prefs.php. + +Troubleshooting +--------------- +1. Oversized field values. Preferences are not/can't be saved + +Database fields have size limits. Preference table example sets 128 +character limit to owner field, 64 character limit to preference key +field and 64KB (database BLOB field size) limit to value field. + +If interface tries to insert data without checking field limits, it +can cause data loss or database errors. Table information functions +provided by Pear DB libraries are not accurate and some database +backends don't support them. Since 1.5.1 SquirrelMail provides +configuration options that set allowed field sizes. + +If you see oversized field errors in your error logs - check your +database structure. Issue can be solved by increasing database field +sizes. + +If you want to get more debugging information - check setKey() function +in dbPrefs class. Class is stored in functions/db_prefs.php