ChronoEngine Forums
Welcome, Guest
Please Login or Register.    Lost Password?
ChronoEngine Forums ChronoForms Forums Bugs
No Insert made when the character ' is present (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: No Insert made when the character ' is present
#7619
shoeshut (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
No Insert made when the character ' is present 2 Months, 2 Weeks ago Karma: 0  
Hello,
I have the following issue:
I have a Textarea in my form.
The Insert in the database from the form works fine when there is no special character but when I add an ' it won't Insert in the database.
In Debug mode I see this \' Which is their to prevent the classic error when inserting data.
Want can I do?
Where can I add another addslashes to be sure?
Thank you for your help.

Database Version: 5.0.22-Debian_0ubuntu6.06.9-log
Database Collation: latin1_swedish_ci
PHP Version: 5.1.2
Web Server: Apache
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.1 Production/Stable ello,
I have the following issue:
I have a Textarea in my form.
The Insert in the database from the form works fine when there is no special character but when I add an ' it won't Insert in the database.
In Debug mode I see this \' Which is their to prevent the classic error when inserting data.
Want can I do?
Where can I add another addslashes to be sure?
Thank you for your help.

Database Version: 5.0.22-Debian_0ubuntu6.06.9-log
Database Collation: latin1_swedish_ci
PHP Version: 5.1.2
Web Server: Apache
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.1 Production/Stable [ Seenu ]
ChronoForms V2.5 J1.5 RC3.1
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#7627
GreyHead (Admin)
Admin
Posts: 2801
graph
User Offline Click here to see the profile of this user
Re:No Insert made when the character ' is present 2 Months, 2 Weeks ago Karma: 59  
Hi shoeshut,

Please see post #4722 in this thread.

Bob
 
Report to moderator   Logged Logged  
 
Bob Janes
info at greyhead.net
ChronoForms Support If you like ChronoForms please vote or post a review at Joomla.org
  The administrator has disabled public write access.
#7668
shoeshut (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Data not included in DB when character ' used 2 Months, 2 Weeks ago Karma: 0  
Hello,
This doesn't help. I'm using Joolma v1.5.1
The Textarea data received by mail went through the Addslashes function somewhere in the process. I see the \' when it's needed.
What I don't understand is why the data is not included in the database.
Any idea?
Thx
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#7685
shoeshut (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:Data not included in DB when character ' used 2 Months, 2 Weeks ago Karma: 0  
I just followed the instructions here to delete and recreate database.
Still no change.

Am I the only one with the problem?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#7871
admin (Admin)
Admin
Posts: 1570
graphgraph
User Online Now Click here to see the profile of this user
Re:Data not included in DB when character ' used 2 Months ago Karma: 22  
Hi,

its the magic quotes may work on posted variables and not for DB inserts, long issue, but did you try to add the addslashes to the text area mosGetParam part at the autogenerated code ?

Cheers

Max
 
Report to moderator   Logged Logged  
 
ChronoForms Developer Thanks for using ChronoForms.
If you have any problems with ChronoForms please tell us.
If you like ChronoForms please post a review at Joomla.org
  The administrator has disabled public write access.
#7962
shoeshut (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:Data not included in DB when character ' used 2 Months ago Karma: 0  
Hi,
I'm not much of a programmer so I'm not sure where to add the Addslashes function, what file...?
Thank you for your input.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 


equalheight If you have any questions you can post to our forums and we will be glad to help ASAP

Members Login






Lost Password?
No account yet? Register

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for
goods and services provided by ChronoEngine.com

ChronoForms License

equalheightTo be able to continue working at this component we decided to get a small profit out of it but at the same time don't force everybody to pay in order to use this great component.

 

 From version 1.5 and up a link at the bottom of everyform created will be placed, saying "joomla professional work", the link will be to us here htttp://www.chronoengine.com, its illegal to remove this link from the source code unless you have a license,

so the license is very simply for the same ChronoForms component without a link, thats all!

This License is for 5 different websites ONLY. 

 

 However, in order to allow everybody to still use the component and even get out of this, the link is inside a div with class : chronoform , use this to hide the link by using different colors or whatever if you really can't pay, but of course the link is still exists at your page source.

 

The license is ONLY 25$ can be bought here :

 

Thank you!

 

ChronoEngine.com Team 

2007 © ChronoEngine.com

Joomla Modules
Joomla Templates and Joomla Tutorials