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
TOPIC: Adding an author with an apostrophe causes error
#20532
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 2 Months, 3 Weeks 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.
#20565
Taras (Admin)
Admin
Posts: 2638
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 2 Months, 3 Weeks ago Karma: 53  
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.
#20566
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 2 Months, 3 Weeks 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.
#20586
Taras (Admin)
Admin
Posts: 2638
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 2 Months, 2 Weeks ago Karma: 53  
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.
#20610
Taras (Admin)
Admin
Posts: 2638
graphgraph
User Offline Click here to see the profile of this user
Re:Adding an author with an apostrophe causes error 2 Months, 2 Weeks ago Karma: 53  
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.
#20611
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 2 Months, 2 Weeks 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
What are you looking for?
Anti-spam question: How many eyes has a typical person?