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: 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!