OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Adding an author with an apostrophe causes error (0 viewing) 

BookLibrary Modules Support

Go to bottom Favoured: 0

Adding an author with an apostrophe causes error

gemagb (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Adding an author with an apostrophe causes error 8 Years, 3 Months ago
Karma: 0  
If I try to add a new author with the surname O'Donaghue ie with an apostrophe I get an error on screen which says:

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 'Donaghue%'' at line 4 SQL=SELECT id,langshow FROM #__booklibrary_authors WHERE authors_name LIKE '%O'Donaghue%'

This is on the site which we emailed you details for earlier.
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 8 Years, 2 Months ago
Karma: 58  
Hello,

You can not add author with an apostrophe.

We can not allow to add author with an apostrophe, because it influence of security of website.


Please, do not use apostrophe in names of authors.


If you will have any other questions, please ask.
Best Wishes,
Taras
OrdaSoft team
Logged Logged
Last Edit: 2016/07/12 14:13 By Taras.
The administrator has disabled public write access.
gemagb (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 8 Years, 2 Months ago
Karma: 0  
Can I ask why you wouldn't use mysql_real_escape_string to deal with characters that need escaping please?
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 8 Years, 2 Months ago
Karma: 58  
Hello,

We used mysql_real_escape_string, but it has conflicts with other function.

So, we can offer next: we will find solution for you, we will update component and you will be able add apostrophe, but for this need some.

During one week we will send You new version.

In this version we make possible add apostrophe.

Thank you for your understanding.

If you would like any further information, please do not hesitate to contact us too.

Best Wishes,
Taras
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Taras (User)
Platinum Boarder
Posts: 2857
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 8 Years, 2 Months ago
Karma: 58  
Hello,

We have find solution for adding authors with apostrophe.

Please, give us
full FTP and admin access
and our team will integrate it for your website, FTP and admin access You can send to our contact form.
ordasoft.com/contact-us-form


Link on website

Joomla Admin

username
password


FTP

FTP host

FTP username

FTP password

In topic write: :Adding an author with an apostrophe
Thanks,
Taras
OrdaSoft team.
Logged Logged
The administrator has disabled public write access.
gemagb (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 8 Years, 2 Months ago
Karma: 0  
Hello

This is for the website at: which we have emailed you the details for already. Please email who has been dealing with Taras regarding this website.

Thanks
Logged Logged
The administrator has disabled public write access.
Go to top
»