|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
I'm battling with this problem: I can open backend promotions' page (I don't have promotions actually so nothing is listed in page) but when I try to create new promotion nothing happens and this error is logged... suggestions?
-----------------------------------------------------------------------------
>> Version:2,8004
>> Page:
-----------------------------------------------------------------------------
>> 10/09/2015 10:47:02
>> 192.168.169.254
>> DESCRIPTION:
System.Data.ConstraintException: Impossibile attivare i vincoli. Una o più righe contengono valori che violano il vincolo non-null, unique o foreign-key.
in System.Data.DataTable.EnableConstraints()
in System.Data.DataTable.set_EnforceConstraints(Boolean value)
in System.Data.DataTable.EndLoadData()
in System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
in System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in kartrisPromotionsDataTableAdapters.PromotionStringsTblAdptr._GetByType(String PartNo, Nullable`1 LANG_ID)
in PromotionsBLL._GetPromotionStringsByType(Char charType, Byte languageID)
in UserControls_Back_PromotionStringBuilder.CreatePromotionPart(Char chrPartNo)
in UserControls_Back_EditPromotion.PrepareNewPromotion()
in UserControls_Back_EditPromotion.EditPromotion(Int32 PromotionID)
in Admin_Promotions.lnkBtnNewPromotion_Click(Object sender, EventArgs e)
in System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
in System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
in System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
in System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
in System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
in System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
==================================================
|
|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
I had to complete information: I tried on two pc, a local installation and a remote installation.
The local installation works, the remote installations shows the problem.
If I create a promotion using EN language in backend in remote installation it works, If I do the same thing with IT language it shows the problem.
I opened the tables involved in PromotionStringsTblAdptr creation (tblKartrisLanguageElements and tblKartrisLanguageStrings, if I'm not wrong) but can't say which is data that generates not-null, unique or foreign-key violation in datatable.... what should I check?
thank you
|
|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
Another piece of puzzle:
Once I created working promotion using backend in EN language, I changed user's language in Login menu, relogged and tried to open the promotion previously made but unsuccessfully... same error logged.
|
|
Group: Administrators
Last Active: 2 hours ago
Posts: 806,
Visits: 2,738
|
I think the problem is that parts of a promotion have language specific records created for them. When you view the italian language in the back end, does it indicate missing language strings or elements?
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
No, regional settings/language&mail setup page tells it's all right...
Using italian language in backend I can see in _Promotions.aspx the promotion made using english language listed with no lacks, but can't edit it (see attchment)
Cattura.PNG
(3 views,
10.13 KB)
|
|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
This is english detail of promotion viewed by english backend...
Cattura.PNG
(4 views,
26.63 KB)
|
|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
... and this is italian version of promotion (inserted/viewed using english backend)
Cattura.PNG
(4 views,
21.66 KB)
|