[SOGo] MYSQL problem.

[Tamás Falus]

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=] [x...@xxxx.xxxx 
] [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
--
users@sogo.nu
https://inverse.ca/sogo/lists

-- 
users@sogo.nu
https://inverse.ca/sogo/lists