Build an Online Store

PHP development of shopping FEED IMPORT BUG It was working When it stops and why for what reasons It stops during shops feed updates, and stops because of an error while preparing the new data to become live. The automatic process is intended to fill with both new and existing data a temporary table in the database. As part of preparing that temporary table, a temporary key column is deleted, then a new key column is supposed to be created. It is in the creation of this new key column that the error occurs. In order to become a proper key column, all values must be unique, none can occur more than once. However, there is usually a duplicate, and so the preparation of the table fails. What you did to fix the problem I was not able to fix the problem. I tried many times to remove shops which are associated with the duplicate key, which can sometimes allow an update to succeed. But then on the next update, there is another duplicate in another shop. I also tried re-creating the shops on dev and started with only one shop. This was successful. Added two, three and four shops to test and they were all successful. It appears that the chances of having a key value collision increase proportionately to the number of item records in the shops database. There is probably some threshold number of records at which the chances of having a collision are at or near 100%. What they shall do to fix the problem Fix the key value generation method to guarantee that there will never be any collisions. What that means? No value in the key can be the same as any other, and the way in which those values are created has to be changed so none are the same. Method shall be possible for duplicate? A primary key is a specific thing in MySQL (and all DBs, I think) that requires all unique values. Or the value shall be how? Explain more here please what are the suggestions? The only suggestion I have is to use an auto-incrementing (this is a known term, a thing in MySQL that any DBA should know well) column. All value must be unique this criteria shall be changed, correct Well, the criterion that all values be unique cannot be changed so long as the table requires a primary key. If the values are not unique, then the column cannot be a primary key. Having a primary key is important for making fast look-ups on that table but not required if it is possible so we can import can you check. Imports often fail with the following error: Exception raised Error Number: 1062, The duplicate key error happens because we try to import a new shop, and one or more of the products in that new shop have ID values that are identical to values that already exist in the database and belong to a different shop. So, we can prevent the error by not trying to import the new shop. In other words, each time this error happens, there is another new shop that we can never import. It also means that the error was not introduced by adding affiliates to [login to view URL], and so reverting to older versions will not solve the problem. I think the bug is in the method by which these ID values are calculated. The method fails to guarantee that there won't be duplicates.