• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

Roster Maker 15 (RM 15) by mrliioadin

M

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
Click to expand...

If you open a new sql query and type

Code: 
SET IDENTITY_INSERT FIFA15Editing_AzureBackup.dbo.runningteamplayerlinks ON

How does it respond?
 
M

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
Click to expand...

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

mrliioadin

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

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.
 
R

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.
Click to expand...

"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
----------------------------------------"
 
M

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
----------------------------------------"
Click to expand...

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

mrliioadin

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

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.
 
M

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.
 
M

mrliioadin

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

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
 
R

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
 
M

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
Click to expand...

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

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
 
M

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
Click to expand...

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
 
M

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.
 
You must log in or register to reply here.


Top