Re: MySQLCC Longtext Query

Hi!

> MySQL Control Center 0.8.7-alpha
> Windows 2000 Professional SP3
> MySQLCC ceases to function when accessing a longtext [mine was 105kb]
>
> How-To-Repeat :
> - I created a test database with one table 'site text'.
> - I created a standard autoincrement 'ID' field [int], 'short
description' [text],
> then 'sitetext' [longtext]
> - In the Console Manager MDI window, I doubleclicked my server.
[localhost]
> - I doubleclicked the database.
> - I doubleclicked Tables for an expanded tree view.
> - I doubleclicked the table.
> - I doubleclicked one of the fields on the right window.
> - The field editor comes up.
> - I doubleclicked the longtext, inserted roughly 105 KB.
> - Applied.
> - Then I tried doubleclicking the newly filled [longtext] field. - It
halts right

This bug is already fixed in my local bk-tree. The next version (0.8.8)
will contain this bug-fix.

Thanks for the bug-report.

BTW, a TEXT field will not hold 105Kb of data ... you will need to use
"LONGTEXT" in this case (even though this is not related to the bug).

Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com

MySQL Users Conference and Expo
http://www.mysql.com/events/uc2003/



------------------------------------------------------------ ---------
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 bugs-thread13438@lists.mysql.com
To unsubscribe, e-mail

Re: MySQLCC Longtext Query

This Report was made using the WinMySQLAdmin 1.4 Tool

1/9/2003 8:21:19 AM

Description :
MySQL Control Center 0.8.7-alpha
Windows 2000 Professional SP3
MySQLCC ceases to function when accessing a longtext [mine was 105kb]

How-To-Repeat :
- I created a test database with one table 'site text'.
- I created a standard autoincrement 'ID' field [int], 'short description' [text],
then 'sitetext' [longtext]
- In the Console Manager MDI window, I doubleclicked my server. [localhost]
- I doubleclicked the database.
- I doubleclicked Tables for an expanded tree view.
- I doubleclicked the table.
- I doubleclicked one of the fields on the right window.
- The field editor comes up.
- I doubleclicked the longtext, inserted roughly 105 KB.
- Applied.
- Then I tried doubleclicking the newly filled [longtext] field. - It halts right
there.
Fix :
- That is up to you guys. =/ Unfortunately I am not a good programmer.
Synopsis :
Submitter-Id :
Originator :
Organization : W-XCTV
MySQL support : none
Severity : not-serious
Priority : medium
Category : MySQLCC
Class : bug
OS Platform : Windows 2000 Service Pack 3
Machine description:
Compiler : VC++ 6.0
Architecture : i686
Total Memory : 261616 KB RAM

My.ini File

[mysqld]
basedir=C:/MYSQL
datadir=C:/MYSQL/data

Server Status Values

Server Info 3.23.49-nt
Host Info localhost via TCP/IP
Client Info 3.23.49
Proto Info 10
Aborted_clients 16
Aborted_connects 0
Bytes_received 0
Bytes_sent 0
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 97
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 10
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_insert 2
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 20
Com_set_option 11
Com_show_binlogs 0
Com_show_create 1
Com_show_databases 10
Com_show_fields 75
Com_show_grants 0
Com_show_keys 4
Com_show_logs 0
Com_show_master_stat 0
Com_show_open_tables 0
Com_show_processlist 2
Com_show_slave_stat 0
Com_show_status 101
Com_show_tables 31
Com_show_variables 3
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 5
Connections 23
Created_tmp_disk_tables 0
Created_tmp_tables 0
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 10
Handler_read_first 13
Handler_read_key 15
Handler_read_next 0
Handler_read_prev 0
Handler_read_rnd 0
Handler_read_rnd_next 55
Handler_update 3
Handler_write 2
Key_blocks_used 2
Key_read_requests 27
Key_reads 2
Key_write_requests 22
Key_writes 12
Max_used_connections 2
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 2
Open_files 4
Open_streams 0
Opened_tables 11
Questions 345
Select_full_join 0
Select_full_range_join 0
Select_range 0
Select_range_check 0
Select_scan 8
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
Table_locks_immediate 58
Table_locks_waited 0
Threads_cached 0
Threads_created 22
Threads_connected 1
Threads_running 1
Uptime 2689

Variables Values

back_log 50
basedir C:\MYSQL\
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620
ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251
estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert ON
connect_timeout 5
datadir C:\MYSQL\data\
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 1800
have_bdb NO
have_gemini NO
have_innodb NO
have_isam YES
have_raid NO
have_openssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language C:\MYSQL\share\english\
large_files_support ON
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 1
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file C:\MYSQL\data\_Wanderer.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
query_buffer_size 0
safe_show_database OFF
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket MySQL
sort_buffer 2097144
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone Eastern Standard Time
tmp_table_size 33554432
tmpdir D:\WINNT\TEMP\
version 3.23.49-nt
wait_timeout 28800

Last Lines from Err File

MySql: ready for connections

030108 13:42:09 MySql: Shutdown Complete

030108 13:42:08 MySql: Normal shutdown
MySql: ready for connections
MySql: ready for connections
MySql: ready for connections

030107 9:58:48 MySql: Shutdown Complete

030107 9:58:47 MySql: Normal shutdown
MySql: ready for connections
MySql: ready for connections


Quoting bugs@lists.mysql.com:

> Your message cannot be posted to bugs@lists.mysql.com because it did not
> follow the format expected by our spam/off-topic filter. To this list we
> accept only repeatable bugs reports, meaning that you can describe a
> set of steps we can follow to repeat the bug on our systems.
>
> If you are having problems with MySQL but are unable to provide the
> required
> description, and have not purchased a support contract from MySQL AB,
> you should send your message to mysql@lists.mysql.com and possibly one of
> our
> knowledgable users or developers will help you. However, we do not
> guarantee
> that every message on mysql@lists.mysql.com will be answered. We can afford
> to provide free code, but unfortunately, we cannot afford to provide
> guaranteed free support on top of that. We do, nevertheless, fix our bugs
> regardless of who reports them and whose systems they affect, and will
> investigate your problem if you can prove to us with a test case that the
> error is in our code and not yours.
>
> If you have purchased a support contract from MySQL AB, you should follow
> the standard support request procedure to report this problem. Support
> contracts are available at https://order.mysql.com/.
>
> If you are able to describe how we can repeat the problem, include the
> string
> "How-To-Repeat:" in the body of your message, followed by the detailed
> description of what we need to do to make it happen, and our filter will
> accept your message. If you use mysqlbug script, which comes with the MySQL
> distribution, to post the message, it will be automatically accepted.
>
> You have written the following:
>
> ---start of your message----
> MySQL Control Center 0.8.7-alpha
> Windows 2000 Professional SP3
> I am going to write out exactly what I did to cause this issue. Hopefully
> it will be
> helpful in the debugging of this application.
>
> Short Description :
> MySQLCC ceases to function when accessing a longtext [mine was 105kb]
>
> Steps to Bug :
> - I created a test database with one table 'site text'.
> - I created a standard autoincrement 'ID' field [int], 'short description'
> [text],
> then 'sitetext' [longtext]
> - In the Console Manager MDI window, I doubleclicked my server.
> [localhost]
> - I doubleclicked the database.
> - I doubleclicked Tables for an expanded tree view.
> - I doubleclicked the table.
> - I doubleclicked one of the fields on the right window.
> - The field editor comes up.
> - I doubleclicked the longtext, inserted roughly 105 KB.
> - Applied.
> - Then I tried doubleclicking the newly filled [longtext] field.
> - It halts right there.
>
>
> ------------------------------------------------------------ -------------------------
------
> ***Protect your PC from local E-Mail Application security holes***
> ***Maintain your Privacy - Passport Free***
> ***Anti SPAM "Whitelist" feature***
>
> http://www.x-mail.net Web Based E-Mail, accessible anywhere
>
> Voice Messages, Voice Calls, Live Chat, X-Mail Messenger,
> Personal Web Hosting, 128 bit SSL Secure, Calendar, Bookmarks,
> Forwarding, Virtual Mail Map Aliasing
>
> X-Mail Premium: 20MB Messages, 100MB Storage, POP3, Ad Free
>
>
>
>
>
> ---end of your message-------
>
> MySQL Development Team
>



- Administrator of Sword of Doom [Ultima Onilne Player Shard]
Sword of Doom is no more unfortunately. Had to switch hosts
three times in two weeks. I am convinced that there are no good
affordable long term hosting services. If you know of an
excelent Windows application hosting provider with remote
administration capabilities via VNC programs of my choice,
please do tell.

------------------------------------------------------------ -------------------------------
***Protect your PC from local E-Mail Application security holes***
***Maintain your Privacy - Passport Free***
***Anti SPAM "Whitelist" feature***

http://www.x-mail.net Web Based E-Mail, accessible anywhere

Voice Messages, Voice Calls, Live Chat, X-Mail Messenger,
Personal Web Hosting, 128 bit SSL Secure, Calendar, Bookmarks,
Forwarding, Virtual Mail Map Aliasing

X-Mail Premium: 20MB Messages, 100MB Storage, POP3, Ad Free





------------------------------------------------------------ ---------
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 bugs-thread13431@lists.mysql.com
To unsubscribe, e-mail