ALL Primary Photo went Blank...

All the topics other than the two goes here.
  • Ads

ALL Primary Photo went Blank...

Postby azhan » Tue Jan 12, 2010 3:51 am

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
azhan
Newbie
Newbie
 
Posts: 7
Joined: Tue Jan 12, 2010 3:50 am

Re: ALL Primary Photo went Blank...

Postby Administrator » Wed Jan 13, 2010 12:59 pm

"All rows are affected". It seems you have run a wrong query that updated all the rows.
Regards,
Praveen
Administrator
Administrator
Administrator
 
Posts: 1069
Joined: Mon Aug 25, 2008 7:18 am
Location: India

Re: ALL Primary Photo went Blank...

Postby azhan » Wed Jan 13, 2010 8:51 pm

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
azhan
Newbie
Newbie
 
Posts: 7
Joined: Tue Jan 12, 2010 3:50 am

Re: ALL Primary Photo went Blank...

Postby Administrator » Thu Jan 14, 2010 12:10 am

I meant that you might have executed a query wrongly without limit. which affected the entire table.
Regards,
Praveen
Administrator
Administrator
Administrator
 
Posts: 1069
Joined: Mon Aug 25, 2008 7:18 am
Location: India

Re: ALL Primary Photo went Blank...

Postby azhan » Mon Jan 18, 2010 6:17 am

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
azhan
Newbie
Newbie
 
Posts: 7
Joined: Tue Jan 12, 2010 3:50 am

Re: ALL Primary Photo went Blank...

Postby Administrator » Mon Jan 18, 2010 7:17 am

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.
Regards,
Praveen
Administrator
Administrator
Administrator
 
Posts: 1069
Joined: Mon Aug 25, 2008 7:18 am
Location: India

Re: ALL Primary Photo went Blank...

Postby azhan » Mon Jan 18, 2010 8:48 pm

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

azhan
Malaysia
azhan
Newbie
Newbie
 
Posts: 7
Joined: Tue Jan 12, 2010 3:50 am

Re: ALL Primary Photo went Blank...

Postby azhan » Fri Jan 29, 2010 4:08 am

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. :)
azhan
Newbie
Newbie
 
Posts: 7
Joined: Tue Jan 12, 2010 3:50 am

  • Ads

Return to Dolphin General Help

Who is online

Users browsing this forum: No registered users and 1 guest

cron