HELP, I'm sinking!!! mysql is truncating content
Posted 01 August 2006 - 10:24 PM
I have a WYSIWYG HTML editor that allows users to edit their little page online. they edit the page and it's happy. it looks good. and it stays for a day or two.
but then, without warning, you go to their page one day, and the page's content has been truncated. I have had to pull database backups to fix this in the past, but I really want to know what is causing it?
typically the page is not edited anywhere, it just gets cut. Here's the detail:
keyfield int(11) PRI NULL auto_increment
the part that's being truncated is the "content" field. The one that was truncated is 7,840 in length (after being truncated).
The longest field is 65,542 in length (is there a limit? 65,536 or something?)
seriously, I have indigestion. Any insights would be a tremendous help.
Edit: I have just yum updated mysql to 4.1.20 from 4.1.18 (in the hopes that mysql may have fixed something that caused this?)
Edit2: Is there a mysql log that can tell me when a database has been modified, scanned, or otherwise touched and by whom?
Posted 02 August 2006 - 02:45 PM
Posted 02 August 2006 - 03:01 PM
Plesk is also running its own mysqldump every day at 5:14AM -- but as far as I can tell, it's just for plesk stuff (and horde's webmail stuff)
Posted 02 August 2006 - 03:06 PM
mysqldump should have no effect on the table's contents... there must be something else running.
Posted 02 August 2006 - 08:09 PM
problem is, I believe plesk restarts mysqld every so often. I will probably need to figure out where the options are (or if there are any options)
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users