Unable to save module
#26
Posté 16 décembre 2009 - 01:16
Tue Dec 15 19:52:54 2009, ERROR, "d:\\DASecuROMBuild\\main\\dev\\tools\\sdk\\include\\toolsoledb.h", 226, "String or binary data would be truncated."
Tue Dec 15 19:52:54 2009, ERROR, ".\\dbmodule.cpp", 338, "CDBModule::Add caught an exception: Bad HRESULT: 80040e57"
However, if I create a brand new Windows user name, for example, Allan Smith and attempt to create a new module under this new user, no issues or errors occur. I suspect that this problem may be the result of using characters that are not compliant with SQL, which would suggest why any non-English characters in a user name could also cause the problem.
It is important to note though, if the user name already has any offending characters in it, you cannot simply change the user name to resolve the issue. This is likely because while Windows changes the display name on request, it never changes the actual user name at the command shell.
The issue may be caused by other factors too, but hopefully this should allow you to reproduce the problem. For anyone looking for a workaround, try creating a brand new Windows user name, free of any non-standard characters, spaces seem to be okay.
Cheers.
#27
Posté 16 décembre 2009 - 02:36
VenetianLunacy wrote...
Hi Allan - I have a suspicion that the problem may be caused by the Windows user profile name (particularly with 'special' characters in the name), rather than the language of the OS itself. For example, if my Windows Vista (US English Language) user name is E. Henry Thripshaw, the toolset fails to create a new module and generates the following errors in the log:
Tue Dec 15 19:52:54 2009, ERROR, "d:\\\\DASecuROMBuild\\\\main\\\\dev\\\\tools\\\\sdk\\\\include\\\\toolsoledb.h", 226, "String or binary data would be truncated."
Tue Dec 15 19:52:54 2009, ERROR, ".\\\\dbmodule.cpp", 338, "CDBModule::Add caught an exception: Bad HRESULT: 80040e57"
However, if I create a brand new Windows user name, for example, Allan Smith and attempt to create a new module under this new user, no issues or errors occur. I suspect that this problem may be the result of using characters that are not compliant with SQL, which would suggest why any non-English characters in a user name could also cause the problem.
It is important to note though, if the user name already has any offending characters in it, you cannot simply change the user name to resolve the issue. This is likely because while Windows changes the display name on request, it never changes the actual user name at the command shell.
The issue may be caused by other factors too, but hopefully this should allow you to reproduce the problem. For anyone looking for a workaround, try creating a brand new Windows user name, free of any non-standard characters, spaces seem to be okay.
Cheers.
This worked for me. My default user name had an underscore in it. I created a new user with admin rights and I was able to create a new module.
#28
Posté 16 décembre 2009 - 07:31
Apologies for not responding sooner, my computer was in the process of being replaced, and steam no longer works on my old one. When I get the toolkit installed and try again, I'll post my results should I experience the problem again (knowing my luck, it should happen again.)
#29
Posté 16 décembre 2009 - 09:56
#30
Posté 16 décembre 2009 - 04:03
Thanks for the tip. We had seen other manifestations of the username giving us trouble with SQL, but I had not made the connection to this particular problem. Will post this information on the wiki (if it is not there already)
If this solution does not solve the problem for anybody, please speak up so we can chase down any other causes.
Modifié par Allan Smith, 16 décembre 2009 - 04:03 .
#31
Posté 16 décembre 2009 - 05:34
#32
Posté 16 décembre 2009 - 06:10
Modifié par Lejontass, 16 décembre 2009 - 06:11 .
#33
Posté 18 décembre 2009 - 08:09
#34
Posté 31 janvier 2010 - 02:04
#35
Posté 10 février 2010 - 11:02
#36
Posté 09 avril 2010 - 08:08
Some moronic programmer of 3rd party win content had
decided to change my windows computer name into
some random funky nugdropping.
After changing 'Marv-#31/ff7//79841' back into 'Marvin'
here, saving modules again works like a charm...
Modifié par Chairon de Celeste, 09 avril 2010 - 09:23 .





Retour en haut






