Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Blob error after Migrating

+4 votes
1,157 views
asked Jun 18, 2013 in Q2A Core by Muhammad Junaid

Hi there i have moved images from database to disk but now in category and admin and some comments i am getting an errors like you can see in the images category and admin pages doesn't showing avatars but there links are also different 

Q2A version: 6.1
commented Jun 19, 2013 by William Orellana
I have the same error on my Google webmaster report. The link on the site map but can not be reach.
commented Jul 25, 2013 by jatin.soni
@gideon,
I have tried all possible way but nothing work.. This error is still exists.

1 Answer

+3 votes
answered Jul 25, 2013 by gidgreen
selected Jul 26, 2013 by Muhammad Junaid
 
Best answer

I've seen this sort of problem before, due to a MySQL bug.

What happens if you make this substitution in qa_db_user_account_selectspec(...) in qa-db-selects.php:

'avatarblobid'

... to ...

'avatarblobid' => 'BINARY avatarblobid'

commented Jul 25, 2013 by jatin.soni
Wonderful! issue resolved.. tested and working great.. thanks a lot..
BTW closing my question related to this....
commented Jul 26, 2013 by Muhammad Junaid
Fantastic ,Issue resolved thanks
...