Roster Maker 15 (RM 15) by mrliioadin

mrliioadin

Senior Squad
Robbles_Quin;3842482 said:
Data Source=RAQ\SQLEXPRESS;Initial Catalog=FIFA15Editing_AzureBackup;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False

C:\Users\jesus\Documents\Roster Maker 15 by mrliioadin\

yes i got them installed in win10

If you open a new sql query and type

Code:
SET IDENTITY_INSERT FIFA15Editing_AzureBackup.dbo.runningteamplayerlinks ON

How does it respond?
 

mrliioadin

Senior Squad
Robbles_Quin;3842487 said:
what do i do after i insert it? how do i activate it?
same thing just happened again

Type that code into a new sql query then run it with f5. Tell me if you get an error
 

mrliioadin

Senior Squad
Robbles_Quin;3842494 said:
nope :( everything happens to me lol ahaha everything hates me

I don't know what you mean. That isn't going to fix the issue. It's just going to help me better understand what is going on. Please type it into SQL and run it. Then tell me what SQL says.
 

Robbles_Quin

Club Supporter
mrliioadin;3842497 said:
I don't know what you mean. That isn't going to fix the issue. It's just going to help me better understand what is going on. Please type it into SQL and run it. Then tell me what SQL says.

"SET IDENTITY_INSERT FIFA15Editing_AzureBackup.dbo.runningteamplayerlinks ON"
"Command(s) completed successfully"

"************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table 'runningteamplayerlinks' when IDENTITY_INSERT is set to OFF.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Roster_Maker_15.selectBaseTables.runTeamPlayerLinks()
at Roster_Maker_15.selectBaseTables.button5_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
ClientConnectionId:ca290fc6-b47e-4502-99e7-8b080f2156bb
Error Number:544,State:1,Class:16


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Roster Maker 15
Assembly Version: 0.1.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/jesus/AppData/Local/Apps/2.0/LVMVJ373.Y8M/953PCC48.1E1/rost..tion_8bd03a1ff2103bf1_0002.0000_31251be746e68b27/Roster%20Maker%2015.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------"
 

mrliioadin

Senior Squad
Robbles_Quin;3842500 said:
"SET IDENTITY_INSERT FIFA15Editing_AzureBackup.dbo.runningteamplayerlinks ON"
"Command(s) completed successfully"

"************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table 'runningteamplayerlinks' when IDENTITY_INSERT is set to OFF.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Roster_Maker_15.selectBaseTables.runTeamPlayerLinks()
at Roster_Maker_15.selectBaseTables.button5_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
ClientConnectionId:ca290fc6-b47e-4502-99e7-8b080f2156bb
Error Number:544,State:1,Class:16


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Roster Maker 15
Assembly Version: 0.1.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/jesus/AppData/Local/Apps/2.0/LVMVJ373.Y8M/953PCC48.1E1/rost..tion_8bd03a1ff2103bf1_0002.0000_31251be746e68b27/Roster%20Maker%2015.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------"

You shouldn't be getting C# exception text if you're running it in SQL.
 

mrliioadin

Senior Squad
Robbles_Quin;3842505 said:
i get the error when i execute from RM after applying the files

Forget RM15 for a minute. RM 15 is based on a combination of SQL and C# code. The error you are running into is a SQL error. It's a database problem. I need to figure out why the database isn't cooperating for you. That will tell me how to reprogram it to avoid this problem in the future.

I think there is a very low chance that I can fix it for you remotely so I wouldn't bother with RM15 right now.

So, if you open SQL Server Management Studio and run that bit of code, I'm curious if it gives you any errors. It sounds like it did not.
 

mrliioadin

Senior Squad
Actually, I have another idea. Make sure you have all of your important files backed up. Don't bank on RM15 preserving them for a minute.

Go into SQL Server Management Studio. Navigate to the FIFA15Editing_AzureBackup database. Open the list of tables and find a table called runningteamplayerlinks (that's the one that is causing our problem).

Right click on that table and select design. It will pull up a window with about 3 columns (Column Name, Data Type, Allow nulls).

We have to identify which one is the identity column. I am pretty sure that it is the column called artificialkey. The identity column will be one where "Allow Nulls" is unchecked. You can't have null values in identity columns.

Once you figure out which one is the identity column (probably ArtificialKey). Highlight that row. Then look down at the bottom where it says Column Properties and scroll down until you see identity specification. It is probably set to "yes" right now. Set it to "no."

Close and save the table, then try RM15.
 

mrliioadin

Senior Squad
You might have to expand that and change the property called (is identity) first. In either case, set them to no.
 

Robbles_Quin

Club Supporter
ahaha cant save it after that.
says "saving changes is not permitted. the changes you made require the following tables to be dropped and re-created. but i think it might be the problem
 

Robbles_Quin

Club Supporter
hmm i deleted the table but saved the changes to the documents folder. now how do i add this table to the tables folder
 

mrliioadin

Senior Squad
Robbles_Quin;3842530 said:
hmm i deleted the table but saved the changes to the documents folder. now how do i add this table to the tables folder

Well deleting the table means you have to start over. Restore the database from scratch
 

Robbles_Quin

Club Supporter
ahhh okay hmm well lets come to this later. maybe upload a database version with those steps and see if it works. for now i'll write up a few excels for you to do this week or whatever. take your time. hope tommorow goes well for you
 

mrliioadin

Senior Squad
Robbles_Quin;3842541 said:
ahhh okay hmm well lets come to this later. maybe upload a database version with those steps and see if it works. for now i'll write up a few excels for you to do this week or whatever. take your time. hope tommorow goes well for you

It's something you can easily do on your end. In General, though, don't go around Just deleting important tables from programs. It will generally break them.

Below is how you deal with the saving issue.

http://stackoverflow.com/questions/6810425/saving-changes-is-not-permitted-in-sql-server
 

mrliioadin

Senior Squad
Wait, I have a better idea. Open a new SQL query and paste/run (F5) this instead:

Code:
drop table FIFA15Editing_AzureBackup.dbo.runningteamplayerlinks

create table FIFA15Editing_AzureBackup.dbo.runningteamplayerlinks
(
leaguegoals nvarchar(50),
isamongtopscorers numeric(1,0),
yellows numeric(3,0),
isamongtopscorersinteam numeric(1,0),
jerseynumber numeric(2,0),
position numeric(2,0),
artificialkey int,
teamid numeric(8,0),
injury numeric(8,0),
leagueappearances numeric(18,0),
pervform numeric(2,0),
istopscorer numeric(1,0),
playerid numeric(8,0),
form numeric(2,0),
reds numeric(2,0)
)

If you do that, you will have to insert a new set of base tables, but you were planning to do that anyway. 90% confident that will fix your issue.
 


Top