Setting 'host' value in database configuration corrupts bytea data saving
Trying to save data into a bytea field in a PostrgreSQL (i.e. a photo upload, storing the photo into the db) I encountered a problem: retrieving saved data later those data ended up to be corrupted. In particular investingating within those files I found that the character ' have been doubled. Removing 'host' parameter from config/database.php file data were saved correctly and I was able to retrieve them and creating my files without any problem. The database configuration for our web application contained the value 'host' = 'localhost' in the config/database.php file. Now the problem is that we can not use a DB on a different server than localhost from the moment we can not specify any values for 'host' key in database configuration. Did anyone of you encounter the same issue? How did you manage it? Greetings, Marco --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Setting 'host' value in database configuration corrupts bytea data saving
Ok, after further tests now I know that I was wrong: now even dropping the 'hos' value from database config the generated files are corrupted. The problem seems to be the same: the characters ' appers twice instead of one. Any ideas? Marco On Mar 17, 12:46 pm, Morail marco.frass...@gmail.com wrote: Trying to save data into a bytea field in a PostrgreSQL (i.e. a photo upload, storing the photo into the db) I encountered a problem: retrieving saved data later those data ended up to be corrupted. In particular investingating within those files I found that the character ' have been doubled. Removing 'host' parameter from config/database.php file data were saved correctly and I was able to retrieve them and creating my files without any problem. The database configuration for our web application contained the value 'host' = 'localhost' in the config/database.php file. Now the problem is that we can not use a DB on a different server than localhost from the moment we can not specify any values for 'host' key in database configuration. Did anyone of you encounter the same issue? How did you manage it? Greetings, Marco --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Setting 'host' value in database configuration corrupts bytea data saving
Your data is being escaped. Have a look at DboSource to see if there's a way to stop certain fields from being escaped. On Tue, Mar 17, 2009 at 11:52 AM, Morail marco.frass...@gmail.com wrote: Ok, after further tests now I know that I was wrong: now even dropping the 'hos' value from database config the generated files are corrupted. The problem seems to be the same: the characters ' appers twice instead of one. Any ideas? Marco On Mar 17, 12:46 pm, Morail marco.frass...@gmail.com wrote: Trying to save data into a bytea field in a PostrgreSQL (i.e. a photo upload, storing the photo into the db) I encountered a problem: retrieving saved data later those data ended up to be corrupted. In particular investingating within those files I found that the character ' have been doubled. Removing 'host' parameter from config/database.php file data were saved correctly and I was able to retrieve them and creating my files without any problem. The database configuration for our web application contained the value 'host' = 'localhost' in the config/database.php file. Now the problem is that we can not use a DB on a different server than localhost from the moment we can not specify any values for 'host' key in database configuration. Did anyone of you encounter the same issue? How did you manage it? Greetings, Marco --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Setting 'host' value in database configuration corrupts bytea data saving
I supposed it too since I tried with a MySQL db and there's no problem in that case. So the problem must be somewhere in the DboSource related to PostgreSQL On Mar 17, 5:17 pm, brian bally.z...@gmail.com wrote: Your data is being escaped. Have a look at DboSource to see if there's a way to stop certain fields from being escaped. On Tue, Mar 17, 2009 at 11:52 AM, Morail marco.frass...@gmail.com wrote: Ok, after further tests now I know that I was wrong: now even dropping the 'hos' value from database config the generated files are corrupted. The problem seems to be the same: the characters ' appers twice instead of one. Any ideas? Marco On Mar 17, 12:46 pm, Morail marco.frass...@gmail.com wrote: Trying to save data into a bytea field in a PostrgreSQL (i.e. a photo upload, storing the photo into the db) I encountered a problem: retrieving saved data later those data ended up to be corrupted. In particular investingating within those files I found that the character ' have been doubled. Removing 'host' parameter from config/database.php file data were saved correctly and I was able to retrieve them and creating my files without any problem. The database configuration for our web application contained the value 'host' = 'localhost' in the config/database.php file. Now the problem is that we can not use a DB on a different server than localhost from the moment we can not specify any values for 'host' key in database configuration. Did anyone of you encounter the same issue? How did you manage it? Greetings, Marco --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---