error in your SQL syntax with easysocial-blog-biography field
By loic on Wednesday, 07 May 2014
Posted in Technical Issues
Replies 8
Likes 0
Views 632
Votes 0
hello,

i have and error when trying to update my profil biography field for easyblog in easysocial profile...

probably due to special characters ?

see below :

JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'est moi, Loïc, le webmaster qui me cache derrière ce pseudo... Rédaction, mis' at line 1 SQL=update `new_easyblog_users` set `biography` = 'C'est moi, Loïc, le webmaster qui me cache derrière ce pseudo... Rédaction, mise à jour, intégration... "bah ! ça devient un boulot à plein temps ce site perso !"... et pourquoi "le gardien" ? c'est pour l'esprit du site, le côté refuge...' where `id` = '77'

can you check please
Loïc
Hi Loic,

I am sorry for the delay of this reply.
This is the file I've modified to fix the friend widget issue

JOOMLA/media/com_easysocial/apps/user/friends/widgets/profile/view.html.php

Hope this help and have a nice day
Sam
·
Friday, 09 May 2014 16:17
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Loic,

I am sorry for the delay of this reply.

Regarding your issue, I've added a fix on your site and can you give it a try again?
Hope this help and have a nice day
Sam
·
Wednesday, 07 May 2014 20:36
·
0 Likes
·
0 Votes
·
0 Comments
·
thanks a lot sam
it's working well

nice support again
thanks
loïc

can you tell me witch file i'll have to modify after upgrade of easysocial ?
loic
·
Wednesday, 07 May 2014 21:08
·
0 Likes
·
0 Votes
·
0 Comments
·
i am here again...

i found an error in module on the left
in your profil page :
http://awesomescreenshot.com/05f2rml0c4

Warning: array_values() expects parameter 1 to be array, boolean given in /homez.56/xxx/www/administrator/components/com_easysocial/includes/user/user.php on line 589

Warning: array_values() expects parameter 1 to be array, null given in /homez.56/xxx/www/administrator/components/com_easysocial/includes/user/user.php on line 638

that's not happening on mine or other users that have ALBUMS created ! ? !
only on user that have not post a photo yet

loïc
loic
·
Wednesday, 07 May 2014 21:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Loic,

i found an error in module on the left


Issue fixed. It is actually caused by the friend widget. When a user do not have a friend, the user will hit this warning message I've added the fix on your site and now users who do not have any friend no longer see this warning.

The fix will be added into next release of EasySocial
Hope this help and have a nice day
Sam
·
Thursday, 08 May 2014 15:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you sam
can you tell me wich file i have to keep if i decide to update to the latest easysocial
Have a nice day
loic
·
Friday, 09 May 2014 01:51
·
0 Likes
·
0 Votes
·
0 Comments
·
thanks again

will it be included in next release ?
have a nice day
loic
·
Monday, 12 May 2014 03:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Loic,

I am sorry for the delay of this reply.

Yes, those fixes will be added into next release of EasySocial
Have a nice day!
Sam
·
Wednesday, 14 May 2014 12:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post