Need some help with Redux V2 5065 source

[HauntedBoi]

Hey guys, having some drama when i go to start the server via Visual Studio.

When i go to "Run"

UPDATE: Now when starting/ gets to the create server window, input the IP and password etc, then comes back to this error.

Exception Unhandled; NHibernate.Exceptions.GenericADOException: 'could not execute query
[ CALL GetGuildMemberList(?p0) ]
Name:guildId - Value:37
[SQL: CALL GetGuildMemberList(?p0)]'

return session
.GetNamedQuery("GetGuildMemberList")
.SetParameter("guildId", guildId)
.SetResultTransformer(Transformers.AliasToBean<DbG uildMemberInfo>())
.List<DbGuildMemberInfo>();

Is there something here with the NHibernate that needs to be changed?
[Unsure if related, but when Executing SQL file, the only error that comes up is related to a guild list issue also] Heres the SQL error [when excecuting SQL file];

"[SQL] Query Nov_16_Backup start
[ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!=guildRank LIMIT 1;
END' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned)
BEGIN
DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;
END
[ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned)
BEGIN
SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name;
END
[SQL] Finished with error
"

Apologies for a wall of text. Just frustrating :P

[Spirited]

Since you're using a newer version of MySQL and updated the assemblies for it (as you mentioned in an earlier version of your post), you could try updating the assemblies for NHibernate as well. I think there are a few: Iesi.Collections.* and NHibernate.*.

[HauntedBoi]

Originally Posted by Spirited

Since you're using a newer version of MySQL and updated the assemblies for it (as you mentioned in an earlier version of your post), you could try updating the assemblies for NHibernate as well. I think there are a few: Iesi.Collections.* and NHibernate.*.

Can't find replacement files for NHibernate or Iesi anywhere in MySQL files etc. Have found the old ones in the source files. Is there something I havn't installed to obtain these files?

[Spirited]

Originally Posted by HauntedBoi

Can't find replacement files for NHibernate or Iesi anywhere in MySQL files etc. Have found the old ones in the source files. Is there something I havn't installed to obtain these files?

It's a separate library you have to download.


If you know how to use nuget, I'd suggest using that instead. Instructions are on their website, or you can google a tutorial. If you do a straight download, you'll have to add it to the bin folder and then add that as a reference in your project's solution. I think Chris manually copied everything, so it's just a bit repetitive.

[HauntedBoi]

Alright thanks bro, i'll put in some time tonight and see how I go.

Yeah nah, I got the swing of NuGet, but just cant install what I need to, as the source says its not compatible. Gah haha not sure how to get past this

[Yupmoh]

Originally Posted by HauntedBoi

Hey guys, having some drama when i go to start the server via Visual Studio.

When i go to "Run"

UPDATE: Now when starting/ gets to the create server window, input the IP and password etc, then comes back to this error.

Exception Unhandled; NHibernate.Exceptions.GenericADOException: 'could not execute query
[ CALL GetGuildMemberList(?p0) ]
Name:guildId - Value:37
[SQL: CALL GetGuildMemberList(?p0)]'

return session
.GetNamedQuery("GetGuildMemberList")
.SetParameter("guildId", guildId)
.SetResultTransformer(Transformers.AliasToBean<DbG uildMemberInfo>())
.List<DbGuildMemberInfo>();

Is there something here with the NHibernate that needs to be changed?
[Unsure if related, but when Executing SQL file, the only error that comes up is related to a guild list issue also] Heres the SQL error [when excecuting SQL file];

"[SQL] Query Nov_16_Backup start
[ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!=guildRank LIMIT 1;
END' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned)
BEGIN
DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1;
END
[ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3
[ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned)
BEGIN
SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name;
END
[SQL] Finished with error
"

Apologies for a wall of text. Just frustrating :P

Been through that before. Basically the stored procedures aren't being imported properly into your DB due to a version difference.

The way to fix it is to write your own stored procedure to handle the same task or to just query the DB normally and remove the procedure call from the method that is calling it in your repository class.

Good luck.