Hello guys,


Im kinda stuck to find whats wrong with my dolphin. After I set primary photo for each user for testing. After a few moment, the whole column of "PrimPhoto" and "Picture" in Profiles table are set to zero automatically. ALL of rows are effected.


What seems the problem?


Azhan

M'sia

"All rows are affected". It seems you have run a wrong query that updated all the rows.

Do you mind to tell me where is the query is? i try search all code that related with "PrimPhoto" column using notepad++ but there is no code that update all the rows...there is just one code that is "reset primary photo" but that code only run according to MemberID and LIMIT 1 only.

thanks
Azhan

I meant that you might have executed a query wrongly without limit. which affected the entire table.

hurmm..i've check all the queries and even I search all queries that related with those column but only one query that related which is "function reset primphoto" and when I disabled it / comment out, the problem still occurs.

and one more thing...i even idle the web page or leave for some time and guess what? the column set itself to zero automatically without even i click any function on the web.

Im really2 confused now.

need help

thanks
azhan
Malaysia

It seems there is some file which was edited wrongly and updates the table.

Just rename the table. and when this happens again, you will get the database error report. You can find the wrong part in this manner.

thanks admin...ill give it a try and let u know the result...

azhan
Malaysia

Hello guys,

Sorry for the late reply...my problem solved now. The solution is not altering any of the query scripts but instead it is a localhost problem. The problem solve only when i'm uploading all the files into my production server.

And another case is, I've store my images into another server to avoid large space consumption on production server.
So, when doing a validating profile image....the program doesnt detect the profile image in another server during the files in the localhost.

Thanks for help.