The latest version of the latest version of the goods E3PRO is wrong. Customers are the latest speed E3PRO, and there is a patch. Now entering the goods information, you have no problem. However, an error will occur if it is entered to a certain amount. For example, primary key or unique index! Please contact your system administrator. ---------- This is a dialog. The younger brother looked at the database. Found that it is such a thing. When the goods added before, Goodsid are 51, then the ID of the added goods may be 6, or may be 2 or 52, etc.. Different numbers. If it is 6, then it is 7, then it is 8, then it will be forwarded to 51, so there will be a dialog box ----- primary key or unique index! Please contact your system administrator ---
Moreover, sometimes "the accumulated amount" of the allocation "is not greater than the amount of the amount that should be returned", here is the goods information, what is going on? ? Customers are dead. After the error has occurred, I repaired the account, and I also delete the reload, and I tried other machines.
However, after deleting the previous goods, it may increase to some items again, and then the same primary key or the unique index.
Finally, import the export to the new account, and you can enter some, it will not. Now the younger brother has modified Goodsid to do it, there is no mistake. Solving: After a few days, the database is studied, the younger brother discovered the following method to solve it. Use the database tool to enter the database, select your own account, find the keyValue value in the L_Gooods record in the keyValuetable table in the table, so it is fast. 1. Handmade this value is OK for the maximum value of Goodsid in Goods. 2, or use SQL language to update it. Update KeyValuetable Set KeyValue = (Select Max (Goodsid) from Goods Where Tablename = 'l_goods'
