Bład zapisu do bazy danych

[4S_ MARKET 23]

Witam. Nic nie grzebane mam problem z jedna bazą nie da sie nic dodać

jak to naprawić i gdzie ? Problem pojawia sie przy dodawaniu nowej aukcji

Bład zapisu do bazy danych . Zapis spowodował by naruszenie integralności danych

[4S_ MARKET 23]

adr__Address 30611 30610

au__Auction 1392 1377

au_Allegro 1392 1377

au_CategorySpecific 32034 32366 X

au_DescriptionImage 1

au_Ebay 1000

au_Enhancement 27494 27768 X

au_Features 1000

au_Note 1000

au_Payment 33113 33446 X

au_PendingChanges 3447 3446

au_Picture 15379 15548 X

au_Shipping 6354 6241

au_TransactionProperty 1000

cs__Customer 5287 5286

cs_CustEmail 5287 5286

cs_CustIM 1000

cs_CustomerProp 5

cs_CustPhone 5888 5887

ds_DeliveryToShippingMap 1000 20

em__Email 27021 27020

em_Account 1005 1004

em_Attachment 1090 1089

em_Rule 1000

em_RuleWord 1000

em_Source 26072 26071

em_Template 1009 11

ep__Registration 2 3 X

ep_ExternalProgram 1 2 X

ep_UserMapping 1008 1007

im__Image 1542 1541

insx_Parametr 2 1

it__Item 3881 3880

it_AuctionTemplate 1000

it_CustomAttributes 1000

it_ExternalCustomAttributes 3881 3880

it_ItemPictures 1025

it_ItemProp 34

it_ItemSite 1005

jb__Job 69349 69348

jb_Message 191806 191805

nm_IgnoredMessages 1002

nm_NotifierMessage 1019 1016

nt_Note 1967 1966

pb__PostBuyFormData 5394 5393

pb_PostBuyFormTransaction 10983212 10983211

pc__Package 5346 5345

pc_History 10269 10268

pc_Item 6259 6258

pc_SendingList 1404 1403

pc_SendingListPackage 5366 5365

pd_UserPermission 1410 1409

pf_Delivery 1018 1016

pf_PrintForm 1004 1003

pl_PricingListData 1161 1160

reg__Registration 1004 1002

reg_Data 1034 1028

reg_JournalDeals 1000

reg_Site 1018 1016

rn_ReturnedNumber 1000

sl_AuctionGroup 8

sl_AuctionTemplateGroup 2

sl_CommentTemplate 1011 1010

sl_Currency 1007 1006

sl_CurrencyBank 1 1 X

sl_CurrencyExchangeRates 1003

sl_CurrencyExchangeRatesEntry 1004

sl_CustomAttributes 1000

sl_CustomCounter 1000

sl_CustomerGroup 1001 1000

sl_CustomGlobalAttributes 1000

sl_CustProperty 22

sl_Deliverer 1029 1028

sl_Delivery 1057 1056

sl_EmailGroup 1000

sl_ExportType 1003 1002

sl_InstantMessenger 1000 3

sl_ItemGroup 1032 1031

sl_ItemProperty 10

sl_Language 6 4

sl_MsgTemplate 9

sl_PackageSynchronizationParams 1006 1005

sl_PricingList 1007 1004

sl_SendingNumbersPool 1000

sl_SendingNumbersPoolType 1000 3

sl_TransProperty 10

sl_User 1009 1008

st__Site 1001 1000

st_Category 105637 105636

st_CategorySpecific 18620 18619

st_SiteData 1000

tp__HtmlTemplate 1127 15

tp_Image 2843

tr__Transaction 6537 6536

tr_Comment 1025

tr_Group 2098 2097

tr_Item 8215 8214

tr_Property 1001

up_UserParams 1038 1037

xcs_Szum 49 48

xit_Szum 49 48

[Bartosz Rosa 1 775]

Wykonanie poniższego zestawu poleceń powinno pomóc w tej sytuacji.

update ins_ident set ido_wartosc = (select max(au_CategorySpecific.as_Id)+1 from au_CategorySpecific) where ido_nazwa like 'au_CategorySpecific'
update ins_ident set ido_wartosc = (select max(au_Enhancement.ae_Id)+1 from au_Enhancement) where ido_nazwa like 'au_Enhancement'
update ins_ident set ido_wartosc = (select max(au_Payment.ap_Id)+1 from au_Payment) where ido_nazwa like 'au_Payment'
update ins_ident set ido_wartosc = (select max(au_Picture.ap_Id)+1 from au_Picture) where ido_nazwa like 'au_Picture'

 

[4S_ MARKET 23]

Wystąpił błąd podczas wykonywania zapytania.

Szczegóły:

Incorrect syntax near '='.

Incorrect syntax near the keyword 'where'.

Stos wywołań:

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

  at System.Data.SqlClient.SqlDataReader.get_MetaData()

  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)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader()

  at Serwisant.SelloDatabase.ExecuteQuery(String query, Int32& affectedRows)

  at Serwisant.CustomCommandWindow.backgroundWorkerExecutingCommand_DoWork(Object sender, DoWorkEventArgs e)

  at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

[Bartosz Rosa 1 775]

Czy operacja wykonywana jest na właściwej bazie?

[4S_ MARKET 23]

Mój bład Bartku dziękuje działa

[4S_ MARKET 23]

Bartku mam kolejne błędy . Działało kilka dni a teraz gdy chce utworzyć paczkę wali błędem integralności  danych.

 

Dane :

au_DescriptionImage 1

ep_ExternalProgram 1 2 X

sl_CurrencyBank 1 1 X

ep__Registration 2 3 X

insx_Parametr 2 1

sl_AuctionTemplateGroup 2

cs_CustomerProp 5

sl_Language 6 4

sl_AuctionGroup 8

sl_MsgTemplate 9

sl_ItemProperty 10

sl_TransProperty 10

sl_CustProperty 22

it_ItemProp 34

xcs_Szum 49 48

xit_Szum 49 48

au_Ebay 1000

au_Features 1000

au_Note 1000

au_TransactionProperty 1000

cs_CustIM 1000

ds_DeliveryToShippingMap 1000 20

em_Rule 1000

em_RuleWord 1000

it_AuctionTemplate 1000

it_CustomAttributes 1000

reg_JournalDeals 1000

rn_ReturnedNumber 1000

sl_CustomAttributes 1000

sl_CustomCounter 1000

sl_CustomGlobalAttributes 1000

sl_EmailGroup 1000

sl_InstantMessenger 1000 3

sl_SendingNumbersPool 1000

sl_SendingNumbersPoolType 1000 3

st_SiteData 1000

sl_CustomerGroup 1001 1000

st__Site 1001 1000

tr_Property 1001

nm_IgnoredMessages 1002

sl_CurrencyExchangeRates 1003

sl_ExportType 1003 1002

pf_PrintForm 1004 1003

reg__Registration 1004 1002

sl_CurrencyExchangeRatesEntry 1004

em_Account 1005 1004

it_ItemSite 1005

sl_PackageSynchronizationParams 1006 1005

sl_Currency 1007 1006

sl_PricingList 1007 1004

ep_UserMapping 1008 1007

em_Template 1009 11

sl_User 1009 1008

sl_CommentTemplate 1011 1010

pf_Delivery 1018 1016

reg_Site 1018 1016

nm_NotifierMessage 1019 1016

it_ItemPictures 1025

tr_Comment 1025

sl_Deliverer 1029 1028

sl_ItemGroup 1032 1031

reg_Data 1034 1028

up_UserParams 1040 1039

sl_Delivery 1057 1056

em_Attachment 1097 1096

tp__HtmlTemplate 1127 15

pl_PricingListData 1161 1160

pd_UserPermission 1410 1409

pc_SendingList 1414 1416 X

au__Auction 1428 1427

au_Allegro 1442 1441

im__Image 1630 1629

nt_Note 2055 2054

tr_Group 2253 2252

tp_Image 2843

au_PendingChanges 3447 3446

it__Item 3883 3882

it_ExternalCustomAttributes 3883 3882

pc__Package 5647 5649 X

pc_SendingListPackage 5649 5668 X

cs__Customer 5733 5732

cs_CustEmail 5733 5732

pb__PostBuyFormData 5809 5808

cs_CustPhone 6395 6394

pc_Item 6666 6679 X

au_Shipping 6975 6974

tr__Transaction 7101 7100

tr_Item 8976 8975

pc_History 10900 10997 X

st_CategorySpecific 18620 18619

au_Picture 18691 18690

em_Source 28185 28184

em__Email 29134 29133

au_Enhancement 32908 32907

adr__Address 33463 33453

au_CategorySpecific 38650 38649

au_Payment 39819 39818

jb__Job 74743 74742

st_Category 105637 105636

jb_Message 206486 206485

pb_PostBuyFormTransaction 12340479 12340478

[Bartosz Rosa 1 775]

update ins_ident set ido_wartosc = (select max(pc__Package.pc_Id)+1 from pc__Package) where ido_nazwa like 'pc__Package'
update ins_ident set ido_wartosc = (select max(pc_SendingList.pl_Id)+1 from pc_SendingList) where ido_nazwa like 'pc_SendingList'
update ins_ident set ido_wartosc = (select max(pc_SendingListPackage.pp_Id)+1 from pc_SendingListPackage) where ido_nazwa like 'pc_SendingListPackage'
update ins_ident set ido_wartosc = (select max(pc_Item.pt_Id)+1 from pc_Item) where ido_nazwa like 'pc_Item'
update ins_ident set ido_wartosc = (select max(pc_History.ph_Id)+1 from pc_History) where ido_nazwa like 'pc_History'

 

Czy na bazie Sello pracują jakieś zewnętrzne programy? Czy może jakieś problemy typu zanik napięcia, nagłe wyłączenie komputera miały miejsce?

 

Generalnie doraźne rozwiązanie tego typu problemów, to w tabeli ins_Ident należy odszukać wpis dla tabelki przy której widnieje znak X w wynikach polecenia sprawdzającego i ustawić tam identyfikator o 1 większy niż ostatni identyfikator dla danej tabeli.

[4S_ MARKET 23]

Server jest codziennie rano za pomocą skryptu ale nie ma nagłych utrat zasilania. Dodam że 3 pozostałe bazy danych działają beż zarzutu . Dodam jeszcze iż w dniu wczorajszym sello używającej tej bazy , samo się wyłączało wyrzucając błąd Visiual studio Error.

 

Zapytanie sql zadziałało . Dziękuje

[4S_ MARKET 23]

Bartku nowa baza danych ale problem wrócił Prosze o pomoc

 

 

adr__Address 353850 354036 X

au__Auction 4308 4306

au_Allegro 4308 4306

au_CategorySpecific 220031 225124 X

au_DescriptionImage 1

au_Ebay 1000

au_Enhancement 155269 158578 X

au_Features 1001

au_Note 1000

au_Payment 220431 225417 X

au_PendingChanges 19507 19506

au_Picture 194282 199025 X

au_Shipping 28871 28870

au_TransactionProperty 1000

cs__Customer 113063 113088 X

cs_CustEmail 113328 113348 X

cs_CustIM 1000

cs_CustomerProp 5

cs_CustPhone 129723 129732 X

ds_DeliveryToShippingMap 1004 1003

em__Email 6426 21774 X

em_Account 1010 1009

em_Attachment 1027 1026

em_Rule 1000

em_RuleWord 1000

em_Source 5477 20825 X

em_Template 1009 11

ep__Registration 2 3 X

ep_ExternalProgram 1 2 X

ep_UserMapping 1008 1007

im__Image 6171 6171 X

insx_Parametr 2 1

it__Item 4103 4102

it_AuctionTemplate 1000

it_CustomAttributes 1000

it_ExternalCustomAttributes 4103 4102

it_ItemPictures 1025

it_ItemProp 34

it_ItemSite 1005

jb__Job 41911 41910

jb_Message 8275678 8283273 X

nm_IgnoredMessages 1007 1003

nm_NotifierMessage 1044 1043

nt_Note 13236 13235

pb__PostBuyFormData 54620 54658 X

pb_PostBuyFormTransaction 285332 285331

pc__Package 17029 17028

pc_History 31506 31505

pc_Item 21106 21105

pc_SendingList 1004 1003

pc_SendingListPackage 1066 1065

pd_UserPermission 1602 1601

pf_Delivery 1002 1001

pf_PrintForm 1000 34

pl_PricingListData 1082 1081

reg__Registration 1008 1007

reg_AfterSalesServiceConditions 1017 1016

reg_Data 1077 1076

reg_JournalDeals 49522 49610 X

reg_Site 1022 1021

rn_ReturnedNumber 1000

sl_AuctionGroup 8

sl_AuctionTemplateGroup 2

sl_CommentTemplate 1011 1010

sl_Currency 1007 1006

sl_CurrencyBank 1 1 X

sl_CurrencyExchangeRates 1003

sl_CurrencyExchangeRatesEntry 1004

sl_CustomAttributes 1000

sl_CustomCounter 1000

sl_CustomerGroup 1001 1000

sl_CustomGlobalAttributes 1000

sl_CustProperty 22

sl_Deliverer 1028 101

sl_Delivery 1056 101

sl_EmailGroup 1000

sl_ExportType 1000 4

sl_InstantMessenger 1000 3

sl_ItemGroup 1032 1031

sl_ItemProperty 10

sl_Language 6 4

sl_MsgTemplate 9

sl_PackageSynchronizationParams 1000

sl_PricingList 1005 1004

sl_SendingNumbersPool 1000

sl_SendingNumbersPoolType 1000 3

sl_TransProperty 1009 1008

sl_User 1009 1008

st__Site 1001 1000

st_Category 104006 104005

st_CategorySpecific 20723 20722

st_SiteData 1000

tp__HtmlTemplate 1127 15

tp_Image 2843

tr__Transaction 23501 23543 X

tr_Comment 1025

tr_Group 6709 6708

tr_Item 28680 28711 X

tr_Property 7363 7359

up_UserParams 1051 1050

xcs_Szum 49 48

xit_Szum 49 48

[Bartosz Rosa 1 775]

update ins_ident set ido_wartosc = (select max(adr__Address.adr_Id)+1 from adr__Address) where ido_nazwa like 'adr__Address'
update ins_ident set ido_wartosc = (select max(au_CategorySpecific.as_Id)+1 from au_CategorySpecific) where ido_nazwa like 'au_CategorySpecific'
update ins_ident set ido_wartosc = (select max(au_Enhancement.ae_Id)+1 from au_Enhancement) where ido_nazwa like 'au_Enhancement'
update ins_ident set ido_wartosc = (select max(au_Payment.ap_Id)+1 from au_Payment) where ido_nazwa like 'au_Payment'
update ins_ident set ido_wartosc = (select max(au_Picture.ap_Id)+1 from au_Picture) where ido_nazwa like 'au_Picture'
update ins_ident set ido_wartosc = (select max(cs__Customer.cs_Id)+1 from cs__Customer) where ido_nazwa like 'cs__Customer'
update ins_ident set ido_wartosc = (select max(cs_CustEmail.ce_Id)+1 from cs_CustEmail) where ido_nazwa like 'cs_CustEmail'
update ins_ident set ido_wartosc = (select max(em_Source.es_Id)+1 from em_Source) where ido_nazwa like 'em_Source'
update ins_ident set ido_wartosc = (select max(cs_CustPhone.cp_Id)+1 from cs_CustPhone) where ido_nazwa like 'cs_CustPhone'
update ins_ident set ido_wartosc = (select max(im__image.im_Id)+1 from im__Image) where ido_nazwa like 'im__Image'
update ins_ident set ido_wartosc = (select max(jb_Message.jm_Id)+1 from jb_Message) where ido_nazwa like 'jb_Message'
update ins_ident set ido_wartosc = (select max(pb__PostBuyFormData.pb_Id)+1 from pb__PostBuyFormData) where ido_nazwa like 'pb__PostBuyFormData'
update ins_ident set ido_wartosc = (select max(reg_JournalDeals.rjd_Id)+1 from reg_JournalDeals) where ido_nazwa like 'reg_JournalDeals'
update ins_ident set ido_wartosc = (select max(tr__Transaction.tr_Id)+1 from tr__Transaction) where ido_nazwa like 'tr__Transaction'
update ins_ident set ido_wartosc = (select max(tr_Item.tt_Id)+1 from tr_Item) where ido_nazwa like 'tr_Item'

[4S_ MARKET 23]

Dzięki . Działa

[4S_ MARKET 23]

Bartku

 

adr__Address 369839 369838

au__Auction 4834 4833

au_Allegro 4834 4833

au_CategorySpecific 258906 258905

au_DescriptionImage 1

au_Ebay 1000

au_Enhancement 181120 181119

au_Features 1002

au_Note 1000

au_Payment 258147 258146

au_PendingChanges 19561 19560

au_Picture 230800 230799

au_Shipping 33097 33096

au_TransactionProperty 1000

cs__Customer 115082 115081

cs_CustEmail 115387 115386

cs_CustIM 1000

cs_CustomerProp 5

cs_CustPhone 132224 132223

ds_DeliveryToShippingMap 1004 1003

em__Email 12391 21774 X

em_Account 1010 1009

em_Attachment 1145 1144

em_Rule 1000

em_RuleWord 1000

em_Source 26790 26789

em_Template 1009 11

ep__Registration 2 3 X

ep_ExternalProgram 1 2 X

ep_UserMapping 1008 1007

im__Image 7514 7513

insx_Parametr 2 1

it__Item 4106 4105

it_AuctionTemplate 1000

it_CustomAttributes 1000

it_ExternalCustomAttributes 4106 4105

it_ItemPictures 1025

it_ItemProp 1007 1006

it_ItemSite 1005

jb__Job 43125 43124

jb_Message 9098617 9098616

nm_IgnoredMessages 1008 1003

nm_NotifierMessage 1045 1043

nt_Note 17721 17720

pb__PostBuyFormData 57159 57158

pb_PostBuyFormTransaction 393557 393556

pc__Package 19422 19421

pc_History 34184 34183

pc_Item 24153 24152

pc_SendingList 1004 1003

pc_SendingListPackage 1066 1065

pd_UserPermission 1620 1619

pf_Delivery 1002 1001

pf_PrintForm 1000 34

pl_PricingListData 1082 1081

reg__Registration 1008 1007

reg_AfterSalesServiceConditions 1017 1016

reg_Data 1077 1076

reg_JournalDeals 55153 55152

reg_Site 1022 1021

rn_ReturnedNumber 1000

sl_AuctionGroup 8

sl_AuctionTemplateGroup 2

sl_CommentTemplate 1011 1010

sl_Currency 1007 1006

sl_CurrencyBank 1 1 X

sl_CurrencyExchangeRates 1003

sl_CurrencyExchangeRatesEntry 1004

sl_CustomAttributes 1000

sl_CustomCounter 1000

sl_CustomerGroup 1001 1000

sl_CustomGlobalAttributes 1000

sl_CustProperty 22

sl_Deliverer 1028 101

sl_Delivery 1056 101

sl_EmailGroup 1000

sl_ExportType 1000 4

sl_InstantMessenger 1000 3

sl_ItemGroup 1032 1031

sl_ItemProperty 1002 1001

sl_Language 6 4

sl_MsgTemplate 9

sl_PackageSynchronizationParams 1000

sl_PricingList 1005 1004

sl_SendingNumbersPool 1000

sl_SendingNumbersPoolType 1000 3

sl_TransProperty 1009 1008

sl_User 1009 1008

st__Site 1001 1000

st_Category 104015 104014

st_CategorySpecific 20723 20722

st_SiteData 1000

tp__HtmlTemplate 1127 15

tp_Image 2843

tr__Transaction 26731 26730

tr_Comment 1025

tr_Group 7630 7629

tr_Item 32688 32687

tr_Property 8200 8199

up_UserParams 1053 1052

xcs_Szum 49 48

xit_Szum 49 48

[Bartosz Rosa 1 775]

Coś często Wam się psują te identyfikatory. Może to wyłączanie serwera jest zbyt brutalne?

 

update ins_ident set ido_wartosc = (select max(em__Email.em_Id)+1 from em__Email) where ido_nazwa like 'em__Email'

[4S_ MARKET 23]

Ostaniami czasy w naszej okolicy były problemy z zasilaniem . UPS juz w drodze 

 

Poraz kolejny wielkie dzięki