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: cdbcommand failed execute sql statement sqlstate 23000, yii integrity constraint violation, cdbcommand failed execute sql statement, cdbcommand failed execute sql statement sqlstate 23000 integrity, yii cdbcommand failed execute sql statement, yii cdbcommand failed execute sql, yii duplicate, yii cdbcommand, yii session integrity constraint violation 1062 duplicate entry, yii integrity constraint violation 1062, yii cdbcommand integrity error, sql duplicate entry yii, yii session integrity constraint violation, php error session yii, yii duplicate entry, yii cdbcommand session failed execute sql statement session, yii 1062, yii sql error, integrity constraint violation 1062 duplicate entry yii, yii integrity constraint violation 1062 duplicate entry, you fix it, what is the fix, what is freelancers website, website for sql freelancers, user experience freelancers

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

Project ID: #1113452

Awarded to:


Hello I can fix that error, check my PM.

$60 USD in 1 day
(23 Reviews)