|
Replies:
12
-
Pages:
1
-
Last Post:
Aug 15, 2011 1:27 PM
by: Mauritz
|
|
|
Posts:
4
Registered:
6/29/11
|
|
|
|
Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 2:05 AM
|
|
|
I get the following error each time I try to execute a query
System.FormatException
Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
Stack Trace:
at System.Guid..ctor(String g)
at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal)
at MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject)
at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms)
at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlDataReader.Read()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
I tried deleting the default.tss file as another post advises but it didn't work.
- Alex
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 8:24 AM
in response to: Alex.I
|
|
|
Do you happen to have a table with a column defined as a GUID that you somehow have managed to put a value into that isn't a GUID?
Would you mind posting the create script for the table that you can't seem to query?
|
|
|
Posts:
4
Registered:
6/29/11
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 5:59 PM
in response to: Mauritz
|
|
|
Below is a DESC of on of the tables. We have many tables that use char(36) as the field type but it doesn't mean we have a GUID in there. All the queries used to work on Toad 4.5 but not on version 5.
Field Type Null Key Default Extra
id char(36) NO PRI
client_id char(36) NO MUL
patron_id char(36) NO
date_time datetime YES
type varchar(50) YES
description longtext YES
link_info varchar(150) YES
source varchar(300) YES
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 6:08 PM
in response to: Alex.I
|
|
|
Yeah, I have to admit that is a very weird assumption. I will make sure this is fixed for version 6.0.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 6:15 PM
in response to: Mauritz
|
|
|
It does happen to me when I tried recreating the table.
Could you please give me the create script of the table (You only provided the column list before).
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 6:16 PM
in response to: Mauritz
|
|
|
Never mind. Missed the CHAR (Used VARCHAR). I got it replicated now.
|
|
|
Posts:
4
Registered:
6/29/11
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 6:20 PM
in response to: Mauritz
|
|
|
create script as follows
CREATE TABLE `patron_logs` (
`id` char(36) NOT NULL,
`client_id` char(36) NOT NULL,
`patron_id` char(36) NOT NULL,
`date_time` datetime default NULL,
`type` varchar(50) default NULL,
`description` longtext,
`link_info` varchar(150) default NULL,
`source` varchar(300) default NULL,
PRIMARY KEY (`id`),
KEY `idx_patronlogs_clientid_patronid` (`client_id`,`patron_id`),
KEY `idx_patron_logs_link_info` (`client_id`,`link_info`),
CONSTRAINT `fk_clients_patronlogs` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 29, 2011 7:11 PM
in response to: Alex.I
|
|
|
Figured out what the issue is and it should be resolved in the next beta drop.
|
|
|
Posts:
4
Registered:
6/29/11
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 30, 2011 12:12 AM
in response to: Mauritz
|
|
|
Thanks for the help. Will keep an eye out for the release.
- Alex
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jun 30, 2011 9:34 AM
in response to: Alex.I
|
|
|
Actually the current beta is at the end of it's cycle so it's pretty stable so you should probably be ok using that until the release comes out.
|
|
|
Posts:
2
Registered:
7/12/11
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Jul 12, 2011 1:26 AM
in response to: Mauritz
|
|
|
I still seem to get this error with 6.0.0.1263.
...just to confirm, the fields are defined as char 36, allowing nulls.
If the value is null or in GUID format, everything works. If the value is not null and not in GUID format we see the error described above.
Message was edited by: CaCtus491
|
|
|
Posts:
2
Registered:
7/12/11
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Aug 14, 2011 11:30 PM
in response to: CaCtus491
|
|
|
I can confirm that this is fixed in 6.0.0.1563.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Guid should contain 32 digits with 4 dashes error
Posted:
Aug 15, 2011 1:27 PM
in response to: CaCtus491
|
|
|
Great. Thanks for letting us know!
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
