christian-putzke / Roundcube-CardDAV

Roundcube CardDAV Plugin
http://www.graviox.de
GNU Affero General Public License v3.0
119 stars 28 forks source link

$preset['active'] is 't' instead of an integer. #84

Open jmerino-iib opened 10 years ago

jmerino-iib commented 10 years ago

Using: Debian 7.6 roundcube 0.7.2-9+deb7u1 postgresql 8.4 rcmcarddav-carddav 0.9.2 davical 1.1.1-1

When a user logs in, roundcube drops an error:

[24-Jul-2014 13:22:23] MDB2 Error: invalid number (-11): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_pgsql_7105263081f609afed9e7ee5d7388a0f268843695 ('Direcciones en la nube (Nombre Apellido1 Apellido2 addressbook)', '%u', '{BASE64}JXA=', 'https://caldav.server:443/caldav.php/username/addresses/', '1101', 't', 'nube01', '02:00:00')]
[Native message: ERROR:  invalid input syntax for integer: "t"
LÍNEA 1: ...s:443/caldav.php/bsoldevilla/addresses/', '1101', 't', 'nube...
                                                              ^]

I have solved it by inserting this code in carddav.php:

root@roundcube2:/var/lib/roundcube/plugins/carddav# diff carddav.php carddav.php.ORIG 
157,159d156
<                               if ( $preset['active'] == 't' ) {
<                                       $preset['active'] = 1;
<                               }

PD: Sorry about my english, my code, and my ignorance in the use of github.