|
You last visited: Today at 03:11
Advertisement
[Release] My edited version of Redux
Discussion on [Release] My edited version of Redux within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.
11/07/2016, 13:44
|
#46
|
elite*gold: 0
Join Date: Jul 2007
Posts: 137
Received Thanks: 4
|
when I create a new character, I am faced with this problem:
Code:
NHibernate.Exceptions.GenericADOException: could not insert: [Redux.Database.Domain.DbCharacter#1003003][SQL: INSERT INTO characters (Name, Spouse, Lookface, Hair, Level, PreviousLevel, Money, WhMoney, WhPassword, CP, Experience, Strength, Agility, Spirit, Vitality, ExtraStats, Life, Mana, Map, X, Y, PrevMap, PrevX, PrevY, Pk, Profession, Profession1, Profession2, Profession3, QuizPoints, VirtuePoints, Online, HeavenBlessExpires, DoubleExpExpires, TrainingTime, OfflineTGEntered, LuckyTimeRemaining, StoredMeteors, StoredDBalls, StoredPhoenix, StoredDragon, StoredFury, StoredRainbow, StoredKylin, StoredVoilet, StoredMoon, StoredTortise, IsHunter, MonsterID, MonsterKills, MonsterCount, Newbie, VotePoints, VipExpire, VoteExpire, UID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Column 'WhPassword' cannot be null
em MySql.Data.MySqlClient.MySqlStream.ReadPacket()
em MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
em MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
em MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
em MySql.Data.MySqlClient.MySqlDataReader.NextResult()
em MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
em MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
em NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:linha 216
em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 39
em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2643
--- Fim do rastreamento de pilha de exceções internas ---
em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2663
em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 3015
em NHibernate.Action.EntityInsertAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityInsertAction.cs:linha 59
em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 169
em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
em Redux.Database.Repositories.Repository`2.Add(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 26
NHibernate.StaleStateException: Unexpected row count: 0; expected: 1
em NHibernate.AdoNet.Expectations.BasicExpectation.VerifyOutcomeNonBatched(Int32 rowCount, IDbCommand statement) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\Expectations.cs:linha 29
em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 40
em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2777
em NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2689
em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2965
em NHibernate.Action.EntityUpdateAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityUpdateAction.cs:linha 79
em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 170
em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
em Redux.Database.Repositories.Repository`2.Update(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 42
EDIT
Solved
|
|
|
11/09/2016, 21:35
|
#47
|
elite*gold: 0
Join Date: Feb 2009
Posts: 295
Received Thanks: 29
|
off topic..
umm wat does fps unlock or unlocker do?
thanks in adv
|
|
|
11/10/2016, 12:34
|
#48
|
elite*gold: 0
Join Date: Jun 2015
Posts: 34
Received Thanks: 7
|
Good @ Keep it up .
|
|
|
01/29/2018, 18:11
|
#49
|
elite*gold: 0
Join Date: Jan 2017
Posts: 20
Received Thanks: 0
|
can not create account , i can but can not log in.
|
|
|
01/31/2018, 01:38
|
#50
|
elite*gold: 0
Join Date: Jul 2009
Posts: 908
Received Thanks: 390
|
Quote:
Originally Posted by cloudwind360
off topic..
umm wat does fps unlock or unlocker do?
thanks in adv
|
it unlocks your fps
|
|
|
02/01/2019, 01:18
|
#51
|
elite*gold: 0
Join Date: Jan 2017
Posts: 20
Received Thanks: 0
|
Can't create an account.
|
|
|
08/05/2019, 01:54
|
#52
|
elite*gold: 0
Join Date: Sep 2010
Posts: 13
Received Thanks: 2
|
PROBLEM
Quote:
Originally Posted by zakkwilde_17
when I create a new character, I am faced with this problem:
Code:
NHibernate.Exceptions.GenericADOException: could not insert: [Redux.Database.Domain.DbCharacter#1003003][SQL: INSERT INTO characters (Name, Spouse, Lookface, Hair, Level, PreviousLevel, Money, WhMoney, WhPassword, CP, Experience, Strength, Agility, Spirit, Vitality, ExtraStats, Life, Mana, Map, X, Y, PrevMap, PrevX, PrevY, Pk, Profession, Profession1, Profession2, Profession3, QuizPoints, VirtuePoints, Online, HeavenBlessExpires, DoubleExpExpires, TrainingTime, OfflineTGEntered, LuckyTimeRemaining, StoredMeteors, StoredDBalls, StoredPhoenix, StoredDragon, StoredFury, StoredRainbow, StoredKylin, StoredVoilet, StoredMoon, StoredTortise, IsHunter, MonsterID, MonsterKills, MonsterCount, Newbie, VotePoints, VipExpire, VoteExpire, UID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Column 'WhPassword' cannot be null
em MySql.Data.MySqlClient.MySqlStream.ReadPacket()
em MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
em MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
em MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
em MySql.Data.MySqlClient.MySqlDataReader.NextResult()
em MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
em MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
em NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:linha 216
em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 39
em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2643
--- Fim do rastreamento de pilha de exceções internas ---
em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2663
em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 3015
em NHibernate.Action.EntityInsertAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityInsertAction.cs:linha 59
em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 169
em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
em Redux.Database.Repositories.Repository`2.Add(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 26
NHibernate.StaleStateException: Unexpected row count: 0; expected: 1
em NHibernate.AdoNet.Expectations.BasicExpectation.VerifyOutcomeNonBatched(Int32 rowCount, IDbCommand statement) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\Expectations.cs:linha 29
em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 40
em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2777
em NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2689
em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2965
em NHibernate.Action.EntityUpdateAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityUpdateAction.cs:linha 79
em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 170
em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
em Redux.Database.Repositories.Repository`2.Update(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 42
EDIT
Solved
|
HOW TO FIX THIS PROBLEM? SOME PROBLEM TO ME
|
|
|
08/05/2019, 18:59
|
#53
|
elite*gold: 0
Join Date: Jul 2009
Posts: 908
Received Thanks: 390
|
Quote:
Column 'WhPassword' cannot be null
|
Hardcore
|
|
|
08/06/2019, 00:08
|
#54
|
elite*gold: 0
Join Date: Sep 2010
Posts: 13
Received Thanks: 2
|
Quote:
Originally Posted by pintinho12
Hardcore
|
tell me bro ? How to fix character create problem ?
|
|
|
08/06/2019, 20:30
|
#55
|
elite*gold: 0
Join Date: Jul 2009
Posts: 908
Received Thanks: 390
|
I gave you the reply already.
If you don't know the basics of databases and programming, I can't help you. I've been working as a teacher for kids and teenagers for over 6 years and I'm tired of seeing lazy people who wants to get the job done with no efforts.
I simplified the error message for you.
Quote:
Column 'WhPassword' cannot be null
|
|
|
|
08/08/2019, 21:36
|
#56
|
elite*gold: 0
Join Date: Nov 2008
Posts: 63
Received Thanks: 11
|
Quote:
Originally Posted by pintinho12
I gave you the reply already.
If you don't know the basics of databases and programming, I can't help you. I've been working as a teacher for kids and teenagers for over 6 years and I'm tired of seeing lazy people who wants to get the job done with no efforts.
I simplified the error message for you.
|
Totally agree with you.People who create servers without knowing
|
|
|
08/13/2019, 01:49
|
#57
|
elite*gold: 0
Join Date: Aug 2019
Posts: 12
Received Thanks: 0
|
ur have scrip vip tokem 30 day ?
|
|
|
10/25/2019, 23:46
|
#58
|
elite*gold: 0
Join Date: Oct 2005
Posts: 26
Received Thanks: 2
|
To anyone who still cares about Redux
At the Characters SQL Database for creating a new character:
under the column Lookface
2xxy00z <-
xx = Face portrait (not going to list the many different face ids)
y = 1 Male Face options @ Beautician
y = 2 Female Face options @ Beautician
z=1 Small F
z=2 Large F
z=3 Small M
z=4 Large M
under the column Hair
xyy
x = Hair Color (3 - 9, anything outside will show no hair)
yy = Hairstyles (see below)
Barber.cs
Cut my Hair option will randomly style the new design only which are ID to 30-51.
For those who want the classic hairs you have to add that option to the NPC. And the classic hairs IDs are 10-17 and any numbers outside these range will show no hair.
Equipmentmanager.cs
One of the script region is preventing Trojans from equipping that left-handed Duals Weapons
Looking around the lines
if (location == 5)
|
|
|
11/14/2019, 02:52
|
#59
|
elite*gold: 0
Join Date: Aug 2011
Posts: 6
Received Thanks: 0
|
if (location == 5)
Quote:
Originally Posted by KingGannon
At the Characters SQL Database for creating a new character:
under the column Lookface
2xxy00z <-
xx = Face portrait (not going to list the many different face ids)
y = 1 Male Face options @ Beautician
y = 2 Female Face options @ Beautician
z=1 Small F
z=2 Large F
z=3 Small M
z=4 Large M
under the column Hair
xyy
x = Hair Color (3 - 9, anything outside will show no hair)
yy = Hairstyles (see below)
Barber.cs
Cut my Hair option will randomly style the new design only which are ID to 30-51.
For those who want the classic hairs you have to add that option to the NPC. And the classic hairs IDs are 10-17 and any numbers outside these range will show no hair.
Equipmentmanager.cs
One of the script region is preventing Trojans from equipping that left-handed Duals Weapons
Looking around the lines
if (location == 5)
|
Helo, Found a solution to fix the Duals Weapons problem?
if (location == 5)
|
|
|
06/01/2020, 09:01
|
#60
|
elite*gold: 0
Join Date: Jun 2020
Posts: 1
Received Thanks: 0
|
wowowo
thanks buddy
|
|
|
All times are GMT +2. The time now is 03:11.
|
|