Tags result in error 1064 in easyblog 5
By Michael Papst on Wednesday, 17 June 2015
Posted in Technical Issues
Replies 10
Likes 0
Views 0.9K
Votes 0
1. When i add tags to blog post or autogenerate by the function when clicking a tag it open the follow error:

Erro: 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 '' at line 1 SQL=select count(1) from `letbs_easyblog_post` as a inner join `letbs_easyblog_post_tag` as b on a.`id` = b.`post_id` where b.`tag_id` = '14' and (a.`source_type` = 'easyblog.team'

2. Beside this it seems to be a problem with portugues-brasil translation i use the new build in function to download portugues-brasil but is not half translated while on transiflex marked with 100% ?
Hello Guys,

I am sorry for the delay of this reply.

Can you download the attachment below and place it inside your /administrator/components/com_easyblog/models/ folder and see how it goes?
Ezrul Fazwan
·
Friday, 19 June 2015 14:51
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Michael,

I am sorry for the delay of this reply.

I've to replicate the issue on your site and it seems like the autogenerate tag is working properly without any error, http://screen.stackideas.com/2015-06-18_1342.png . Am I missing something here? Please advise.
Ezrul Fazwan
·
Thursday, 18 June 2015 13:44
·
0 Likes
·
0 Votes
·
0 Comments
·
The same here, happen also when you click on a tag in website frontend, the same error
Valentin Barbu
·
Thursday, 18 June 2015 14:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Here you can see the error on another of your customer

http://www.nomadsroad.com/fr/le-voyage-et-pays-traverses/blog-du-voyage-interactif/tags/35-anniversaire

Rgds
Valentin Barbu
·
Thursday, 18 June 2015 15:39
·
0 Likes
·
0 Votes
·
0 Comments
·
The file help to solve the sql error but after you click on tag link, the page shows no result, it's empty.

Rgds
Valentin Barbu
·
Friday, 19 June 2015 14:54
·
0 Likes
·
0 Votes
·
0 Comments
·
For me the file was working the tags are working correct now. Thank you
Michael Papst
·
Friday, 19 June 2015 20:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Same problem for me "The file help to solve the sql error but after you click on tag link, the page shows no result, it's empty"

But it's only the links in the Tag Module that doesn't work now. If the tag is "paris" they link to "http://www.mywebsite.com/tags/10" instead of "http://www.mywebsite.com/tags/paris"
Peter Pettersson
·
Saturday, 20 June 2015 20:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Peter,

Please try to replace the attached files in:
../modules/mod_easyblogtagcloud/helper.php
../modules/mod_easyblogtagcloud/tmpl/default.php

Hope this helps.
Nik Faris
·
Monday, 22 June 2015 16:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, your awesome!
Peter Pettersson
·
Tuesday, 23 June 2015 04:56
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Peter,

You are most welcome. Glad that your issue has been resolved now.
Ezrul Fazwan
·
Tuesday, 23 June 2015 11:06
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post