Problem Editing mysql Text field
Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem Editing mysql Text field
Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:13 PM Subject: Problem Editing mysql Text field Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem Editing mysql Text field
This is weird, all of a sudden it starts working, if it happens again though I will try another front end. Thank you for your advice Thank you, --- -Daniel Negron // \\* / _ __ ___ \Lotus Notes Admin / Developer | | |/ /| _ ) | KB Electronic, Inc. | | ' | _ \ | 12095 NW 39th Street | |_|\ \|___/ | Coral Springs, FL. 33065 \ \_\ /954.346.4900 x 122 \\ // email: [EMAIL PROTECTED] - http://www.kbelectronics.com --- |+- || Insanely | || Great | || insanely420@Pu| || nkAss.com | || | || 02/13/2003 | || 11:22 AM | || | |+- | | | | To: [EMAIL PROTECTED], Daniel Negron/KBE [EMAIL PROTECTED] | | cc: | | Subject: Re: Problem Editing mysql Text field | | Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:13 PM Subject: Problem Editing mysql Text field Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php