Build an Online Store

Σε Εξέλιξη Αναρτήθηκε Mar 13, 2014 Πληρώθηκε κατά την παράδοση
Σε Εξέλιξη Πληρώθηκε κατά την παράδοση

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.

Ηλεκτρονικό εμπόριο HTML PHP Καλάθια Αγορών

Ταυτότητα Εργασίας: #5552696

Σχετικά με την εργασία

19 προτάσεις Απομακρυσμένη εργασία Ενεργό Mar 20, 2014

Ανατέθηκε στον:

alifinteractive

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] Περισσότερα

$350 USD σε 7 μέρες
(59 Αξιολογήσεις)
7.0

19 freelancers κάνουν προσφορές κατά μέσο όρο $269 για αυτή τη δουλειά

gopalvora

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 Περισσότερα

$185 USD σε 8 μέρες
(254 Αξιολογήσεις)
7.3
techwelfare

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..

$252 USD σε 10 μέρες
(66 Αξιολογήσεις)
6.5
VnBestSolutions

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 !! Περισσότερα

$568 USD σε 7 μέρες
(58 Αξιολογήσεις)
5.8
prashushinde9

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 Περισσότερα

$789 USD σε 20 μέρες
(24 Αξιολογήσεις)
5.7
pointlogic

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 Περισσότερα

$206 USD σε 8 μέρες
(44 Αξιολογήσεις)
5.6
Time2win

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

$257 USD σε 10 μέρες
(27 Αξιολογήσεις)
5.0
pintalpandey92

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

$210 USD σε 3 μέρες
(12 Αξιολογήσεις)
4.2
sohail9

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

$155 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0