In Progress

Fix Yii website error

Hi there,

I am looking for freelancers who are skilled with PHP and Yii.

I have a Flash based script which lets users create bead patterns then upload them to my server via PHP. The script is integrated with my Yii website, and pulls in the currently logged in user's user ID and username and saves them in the database along with the path file to their created pattern.

However, since moving to a new server the pattern saving/loading feature no longer works. When I directly access the function that loads the picture, it gives this error: "CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'bb5cae4ec81cacb55fc55d0deca99d03' for key 'PRIMARY'."

I am using a database session system so it seems like maybe there is some interaction there. But what's weird is that I had sessions working fine with this on a different server.

I need someone who is experienced with Yii and PHP to figure out what is causing this error and fix it so that the pattern saving/loading functions of the Flash script work again. The Flash file itself is not broken, so no Flash/ActionScript experience is necessary.

Link to the script: [url removed, login to view] (the last two buttons on the toolbar are the features that are broken)

Link to what happens when the getPictures function is called: [url removed, login to view]

Thanks, and I look forward to working with you!

Skills: MySQL, PHP, Yii

See more: yii integrity constraint violation, yii duplicate, yii cdbcommand, yii cdbcommand integrity error, sql duplicate entry yii, php error session yii, yii duplicate entry, yii 1062, yii sql error, website sql freelancers, user experience freelancers, this error, skilled freelancers, new website freelancers, mysql freelancers, maybe freelancers, loading function php, id freelancers, freelancers sql server, fix broken link website, create website freelancers, error 0, yii website, yii freelancers, weird

About the Employer:
( 5 reviews ) Lytham St Annes, United Kingdom

Project ID: #1113452

Awarded to:

sv3tli0

Hello I can fix that error, check my PM.

$60 USD in 1 day
(23 Reviews)
4.3