9 réponses à ce sujet

[NErWOnek]

I've been playing this game for a long time and now all of the sudden the toolset doesn't want to start up! I got the cannot connect error and when I started reading this forum I got so @#$@#$@!! 

WTF ;/

I installed a clean version of awakening, haven't run it yet.
I installed the toolset with the default option, sql thing 2005 is fine and running, but the database isn't created at all.

What should I do ? 

The wiki guide sucks c**k... it doesn't actually describe what to do exactly.
The database restore thing doesn't work and it returns an error that Restore failed because the backup holds a backup of a database other than bw_dragonage_content.

Honestly I've been using the toolset for a long time and now this, I reinstalled the whole F***ng game and the toolset and still nothing.

Help plox or please oh please release software a little bit user friendly god damnit lol...

[Kilrogg_]

When I got a similar issue I followed this guide and got it to work.



http://social.biowar...se_installation



Have you tried it?

[NErWOnek]

YEAH, like for the last 3 hours

the stupid sql service is running but the damn database isn't created.

and I can't just run the .bak file cuz I get the error

so I'd have to manually create the database and those instructions and that 500 kb file are NOT CLEAR, NOT FRIENDLY, NOT USEFULL.

Modifié par NErWOnek, 23 mai 2010 - 05:02 .

[NErWOnek]

to add more:

a) The toolset installs a default collation in whatever the language of Your os is

and since I have Polish Collation and english Dragonage installation I can't get this piece of crap to run properly.



Don't tell me that I'd have to install this sh$tty polish voiceover to be able to use the toolset

[CID-78]

if it's just the database your missing it can easily be restored from the backup.



http://social.biowar...kup_and_restore



Note that the bat is using the old installation path and not the newer so you need to modify the .bat file for it to work.



if it's a MS SQL issue it can be a bit trickier.

[NErWOnek]

well even with polish instalation the same problem occurs ;/
I tried all those fancy ways and I can't even find the collation used in those .sql's in wiki so most probably the tables are read badly and that's why I can't make the db
I just can't select Latin1_General_something_something_something (3 parameters, SP1 and 2 others) cuz I don't see that option there.

and I'm 300% sure that I need to have EXACTLY the same collation to make this thing work, otherwise the second .sql batch file doesn't execute at all, it just throws a million errors.

I need to find this one:
Latin1_General_CP1_CS_AS

Modifié par NErWOnek, 23 mai 2010 - 08:41 .

[NErWOnek]

1.The service is running fine:




2. I can connect to dragon age database server set up by toolset 1.01 install

3. There is no bw_dragonage_content database created

4.The default collation is Polish, I change it to the one that this batch script uses. 

5.This is the database collation, I think I got it right this time:

6.I set up those 3 database rights write, read,lock



And then I entered the first batch file, here's a ton of errors.


This is the error message log that I get when using the Content Create Script.sql from Wiki:

Msg 208, Level 16, State 1, Procedure v_ModuleTree, Line 6
Invalid object name 't_moduleassociation'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'v_ModuleTree', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 8
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 8
Invalid column name 'stringid'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 9
Invalid column name 'stringid'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 9
Invalid column name 'stringid'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 10
Invalid column name 'moduleresrefversionid'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 10
Invalid column name 'moduleresrefversionid'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 11
Invalid column name 'stringlanguagevariantid'.
Msg 207, Level 16, State 1, Procedure v_StringVersionText, Line 6
Invalid column name 'OwnerresRefID'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'v_StringVersionText', because it does not exist or you do not have permission.
Msg 208, Level 16, State 1, Procedure v_UserResourceInfo, Line 5
Invalid object name 't_moduleresref'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'v_UserResourceInfo', because it does not exist or you do not have permission.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.bsp_DetermineVOScriptLineCharacters'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 207, Level 16, State 1, Procedure bsp_AddStringTable, Line 21
Invalid column name 'id'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_AddStringTable', because it does not exist or you do not have permission.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.bsp_AddStringTable'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 207, Level 16, State 1, Procedure bsp_AddResRef, Line 33
Invalid column name 'moduleid'.
Msg 207, Level 16, State 1, Procedure bsp_AddResRef, Line 33
Invalid column name 'resrefid'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_AddResRef', because it does not exist or you do not have permission.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'dbo.bsp_AddResRef'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 51
Invalid column name 'moduleID'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 39
Invalid column name 'moduleID'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 39
Invalid column name 'moduleID'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 36
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 70
Invalid column name 'tag'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 70
Invalid column name 'tag'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 97
Invalid column name 'tag'.
Msg 207, Level 16, State 1, Procedure bsp_AreaObjectInstanceChanges, Line 97
Invalid column name 'tag'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_AreaObjectInstanceChanges', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_CheckinResource, Line 34
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure bsp_CheckinResource, Line 35
Invalid column name 'ModuleId'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_CheckinResource', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 28
Invalid column name 'ModuleId'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 58
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 66
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 68
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 63
Invalid column name 'name'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 69
Invalid column name 'level'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 86
Invalid column name 'moduleid'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 86
Invalid column name 'resrefid'.
Msg 207, Level 16, State 1, Procedure bsp_CheckoutResource, Line 87
Invalid column name 'scratchmoduleresrefversionid'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_CheckoutResource', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_DeleteResource, Line 29
Invalid column name 'id'.
Msg 207, Level 16, State 1, Procedure bsp_DeleteResource, Line 30
Invalid column name 'state'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_DeleteResource', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_DeleteString, Line 32
Invalid column name 'id'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_DeleteString', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_GetResourceReferenceList, Line 72
Invalid column name 'SoundsetResRefID'.
Msg 207, Level 16, State 1, Procedure bsp_GetResourceReferenceList, Line 191
Invalid column name 'SoundsetResRefID'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_GetResourceReferenceList', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_LockResource, Line 30
Invalid column name 'moduleid'.
Msg 207, Level 16, State 1, Procedure bsp_LockResource, Line 30
Invalid column name 'resrefid'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_LockResource', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_RestoreResourceVersion, Line 21
Invalid column name 'moduleid'.
Msg 207, Level 16, State 1, Procedure bsp_RestoreResourceVersion, Line 21
Invalid column name 'moduleid'.
Msg 207, Level 16, State 1, Procedure bsp_RestoreResourceVersion, Line 22
Invalid column name 'resrefid'.
Msg 207, Level 16, State 1, Procedure bsp_RestoreResourceVersion, Line 22
Invalid column name 'resrefid'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_RestoreResourceVersion', because it does not exist or you do not have permission.
Msg 207, Level 16, State 1, Procedure bsp_UpdateResourceProperties, Line 84
Invalid column name 'moduleid'.
Msg 207, Level 16, State 1, Procedure bsp_UpdateResourceProperties, Line 84
Invalid column name 'resrefid'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'bsp_UpdateResourceProperties', because it does not exist or you do not have permission.

 


And one last thing, if I won't change the bw_dragonage_content collation I get this



Here's what I get when I try to just "back up" the database


it's a no-win situation and I don't know what to do... this wiki page doesn't say anything about whacky situations like this one


Here's yet another long list of errors when running the coredatascript.sql

Msg 207, Level 16, State 1, Line 38
Invalid column name 'NAME'.
Msg 468, Level 16, State 9, Line 329
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.
Msg 2812, Level 16, State 62, Line 15
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 16
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 18
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 19
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 21
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 22
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 24
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 25
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 27
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 28
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 30
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 31
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 2812, Level 16, State 62, Line 33
Could not find stored procedure 'bsp_AddResRef'.
Msg 515, Level 16, State 2, Line 34
Cannot insert the value NULL into column 'ModuleResRefVersionID', table 'bw_dragonage_content.dbo.t_Script'; column does not allow nulls. INSERT fails.
The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Modifié par NErWOnek, 23 mai 2010 - 09:35 .

[NErWOnek]

EDIT: GUESS WHAT WORKED:



SQL_Latin1_General_CP1_CI_AS



This is the correct collation, everything else results in editor not being able to connect, we could add this info into Dragonage Toolset wiki.

[Kilrogg_]

You can add it, its a wiki

[NErWOnek]

edited, I hope that noone else will have to go through this "guessing" process again...