Build an Online Store
$30-250 USD
Πληρώθηκε κατά την παράδοση
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 [url removed, login to view], 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.
Ταυτότητα Εργασίας: #5552696
Σχετικά με την εργασία
Ανατέθηκε στον:
Hi, We have a rich experience in ecommerce website development and have completed many successful projects. Please check our some good works using the below URLs. E-Commerce Projects [login to view URL] Περισσότερα
19 freelancers κάνουν προσφορές κατά μέσο όρο $269 για αυτή τη δουλειά
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo Περισσότερα
hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..
Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Περισσότερα
Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu Περισσότερα
Hello..We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us this Περισσότερα
Hello, We have excellent team of programmers and designers to work on your project efficiently and complete job in time. We have read your deepest requirement at our best and will surely give better results. thanks
I can do this, I am a php expert, and can do this. I just need 24 hours from you to finish this project, if i dont complete it on time then no need to pay
Hi, I am a working professional a full time freelancer expert in this type of work. I am new to this website and I am offering you best quality work intime and your satisfaction. thanks