DO NOT HIJACK OTHER PEOPLES THREADS. Thanks.
On Tue, Jul 06, 2010 at 11:12:48AM +0200, Tamás Falus wrote: > Dear All, > > > I did not get or I havent seen an answer to my funambol and mysql > problem. > > can someone validate the the mysql structure that i'am using is correct? > > > -- > -- Table structure for table `sogo_user_profile` > -- > > CREATE TABLE IF NOT EXISTS `sogo_user_profile` ( > `c_uid` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_defaults` text collate utf8_hungarian_ci, > `c_settings` text collate utf8_hungarian_ci, > PRIMARY KEY (`c_uid`) > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; > > > -- > -- Table structure for table `sogo_folder_info` > -- > > CREATE TABLE IF NOT EXISTS `sogo_folder_info` ( > `c_folder_id` bigint(20) unsigned NOT NULL auto_increment, > `c_path` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_path1` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_path2` varchar(255) collate utf8_hungarian_ci default NULL, > `c_path3` varchar(255) collate utf8_hungarian_ci default NULL, > `c_path4` varchar(255) collate utf8_hungarian_ci default NULL, > `c_foldername` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_location` varchar(2048) collate utf8_hungarian_ci NOT NULL, > `c_quick_location` varchar(2048) collate utf8_hungarian_ci default > NULL, > `c_acl_location` varchar(2048) collate utf8_hungarian_ci default NULL, > `c_folder_type` varchar(255) collate utf8_hungarian_ci NOT NULL, > PRIMARY KEY (`c_path`), > UNIQUE KEY `c_folder_id` (`c_folder_id`) > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci > AUTO_INCREMENT=10 ; > > / user tables > -- > -- Table structure for table `sogoteszt00443ec00a4` > -- > > CREATE TABLE IF NOT EXISTS `sogoteszt00443ec00a4` ( > `c_name` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_content` mediumtext collate utf8_hungarian_ci NOT NULL, > `c_creationdate` int(11) NOT NULL, > `c_lastmodified` int(11) NOT NULL, > `c_version` int(11) NOT NULL, > `c_deleted` int(11) default NULL, > PRIMARY KEY (`c_name`) > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; > > -- > -- Table structure for table `sogoteszt00443ec00a4_acl` > -- > > CREATE TABLE IF NOT EXISTS `sogoteszt00443ec00a4_acl` ( > `c_uid` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_object` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_role` varchar(80) collate utf8_hungarian_ci NOT NULL > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; > > > -- > -- Table structure for table `sogoteszt00443ec00a4_quick` > -- > > CREATE TABLE IF NOT EXISTS `sogoteszt00443ec00a4_quick` ( > `c_name` varchar(255) collate utf8_hungarian_ci NOT NULL, > `c_givenname` varchar(255) collate utf8_hungarian_ci default NULL, > `c_cn` varchar(255) collate utf8_hungarian_ci default NULL, > `c_sn` varchar(255) collate utf8_hungarian_ci default NULL, > `c_screenname` varchar(255) collate utf8_hungarian_ci default NULL, > `c_l` varchar(255) collate utf8_hungarian_ci default NULL, > `c_mail` varchar(255) collate utf8_hungarian_ci default NULL, > `c_o` varchar(255) collate utf8_hungarian_ci default NULL, > `c_ou` varchar(255) collate utf8_hungarian_ci default NULL, > `c_telephoneNumber` varchar(255) collate utf8_hungarian_ci default > NULL, > `c_component` varchar(10) collate utf8_hungarian_ci NOT NULL, > PRIMARY KEY (`c_name`) > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; > > > > The error is like this: > > [2010-06-17 12:28:36,728] [funambol.sogo] [INFO] > [D1C608EDD31DA21FB5ADF5CB2CA5AFAB] [fol-QUdORVM6wWduZXM=] [[email protected] > ] [sogo-card] Exception during getDeletedSyncItemsKeys(): > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'null WHERE > c_deleted = 1 AND c_lastmodified >= 1276770487 AND c_lastmodified <= ' > at line 1 > > > > > THANKS FOR YOUR KIND ANSWER > > regards > > Tamás > > > > > > On Jul 6, 2010, at 10:58 AM, Mark Adams wrote: > >> Hi All, >> >> I've just investigated this further, And it seems the other "Personal >> Calendars" listed are actually the calendars of OTHER users that have >> been subscribed to (for ical purposes) through the ACL. >> >> Is there a way to have the Delegates list populated in iCal without >> having all the accounts loaded in the web interface? >> >> Regards, >> Mark >> >> On Tue, Jul 06, 2010 at 09:52:34AM +0100, Mark Adams wrote: >>> On a new setup (nightly from last Thursday) we are seeing numerous >>> duplicate Personal Calendars showing up under a single user. When we >>> put >>> the install in we noticed the "ghost" calendar issue with the >>> integrator >>> so we compiled the pre2 integrator which stopped the ghosting issue. >>> Are >>> these related? >>> >>> Has anybody seen this and managed to get rid of them? >>> >>> Cheers, >>> Mark >> -- >> [email protected] >> https://inverse.ca/sogo/lists > > -- > [email protected] > https://inverse.ca/sogo/lists
-- [email protected] https://inverse.ca/sogo/lists
