MySQL: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) No edit summary |
Jkuehlthau (talk | contribs) No edit summary |
||
Line 13: | Line 13: | ||
To resolve this, make sure to cast any Guid fields: | To resolve this, make sure to cast any Guid fields: | ||
SELECT id, cast(team_id as char(36)) id, name FROM kbdocuments | SELECT id, cast(team_id as char(36)) id, name FROM kbdocuments | ||
=Issues= | |||
Some users have reported receiving this error after a few hundred to a few thousand rows: | |||
<source lang="vb"> | |||
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during data read. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream. | |||
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) | |||
at MySql.Data.MySqlClient.MySqlStream.LoadPacket() | |||
at MySql.Data.MySqlClient.MySqlStream.LoadPacket() | |||
at MySql.Data.MySqlClient.MySqlStream.ReadPacket() | |||
at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 columns) | |||
at MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns) | |||
at MySql.Data.MySqlClient.ResultSet.GetNextRow() | |||
at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) | |||
at MySql.Data.MySqlClient.MySqlDataReader.Read() | |||
at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) | |||
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) | |||
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) | |||
at StarfishEngine.StarfishService.AdvanceOrigin(rowdat& RowData) | |||
</source> |
Revision as of 15:12, 28 November 2017
MySQL Origin
Note that the connection string must match the sample connection string shown in Starfish:
server=<server_name>;uid={0};pwd={1};database=<db_name>;
The string components must be placed in that order. {0} is a variable that refers to the Username field. {1} is a variable that refers to the Password field.
Sample Origin Filter
Use standard MySQL statements.
When connecting directly to a Sugar MySQL database, and possibly other databases, when running a standard MySQL query, it can fail when a field type is a standard MySQL ID field which requires 32 characters and Sugar uses the id "1" for the admin team:
SELECT id, team_id, name FROM accounts
This will cause an error in the MySQL connector:
Failed, error message was: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
To resolve this, make sure to cast any Guid fields:
SELECT id, cast(team_id as char(36)) id, name FROM kbdocuments
Issues
Some users have reported receiving this error after a few hundred to a few thousand rows:
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during data read. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream. at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.FetchDataRow(Int32 statementId, Int32 columns) at MySql.Data.MySqlClient.Driver.FetchDataRow(Int32 statementId, Int32 columns) at MySql.Data.MySqlClient.ResultSet.GetNextRow() at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlDataReader.Read() at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) at StarfishEngine.StarfishService.AdvanceOrigin(rowdat& RowData)