Menu
▾
▴
webical-developers
|
From: Mattijs H. <ma...@fu...> - 2007-09-14 15:22:15
|
hi all, i uploaded the webical 0.2 release candidate to a public file hoster for testing. Feel free to download it and test it on your machines. webical-0.2.zip: http://www.mediafire.com/?53o5z1deing webical-0.2.tar.gz: http://www.mediafire.com/?dveweoj9y4a cheers -- Mattijs Hoitink Func. Internet Integration W http://www.func.nl T +31 20 4230000 F +31 20 4223500 |
|
From: Zoran K. <zo...@fu...> - 2007-09-14 17:44:52
|
> Feel free to download it and test it on your machines. It doesn't work. The applicationContext-release.xml misses an enclosing <beans> tag please add the following at the top: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> and a closing </beans> tag at the end. -- Zoran Kovacevic Func. Internet Integration W http://www.func.nl M +31 6 48104284 T +31 20 4230000 F +31 20 4223500 GPG http://www.func.nl/keys/z.k...@fu... |
|
From: Zoran K. <zo...@fu...> - 2007-09-14 18:01:26
Attachments:
webical_bootstrap.sql
|
> Feel free to download it and test it on your machines. I also had a problem with the database: zorankovacevic$ /usr/local/mysql/bin/mysql -u root < /Users/zorankovacevic/Desktop/webical-0.2\ Folder/DB_setup.sql ERROR 1064 (42000) at line 47: 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 'IF NOT EXISTS CREATE DATABASE `webical` `lastRefreshTimeStamp` bigint(20) defa' at line 10 I fixed it by temporarily letting hibernate create the needed tables. I have dumped the created and clean tables in the attached file. Please verify! (the AUTH_webical.sql does work) -- Zoran Kovacevic Func. Internet Integration W http://www.func.nl M +31 6 48104284 T +31 20 4230000 F +31 20 4223500 GPG http://www.func.nl/keys/z.k...@fu... |
|
From: Zoran K. <zo...@fu...> - 2007-09-14 18:08:11
|
hmm, not sure now if the db dump i've provided is correct ... signing off for now. Zoran Kovacevic wrote: >> Feel free to download it and test it on your machines. > > I also had a problem with the database: > > zorankovacevic$ /usr/local/mysql/bin/mysql -u root < > /Users/zorankovacevic/Desktop/webical-0.2\ Folder/DB_setup.sql > ERROR 1064 (42000) at line 47: 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 'IF NOT EXISTS CREATE DATABASE `webical` > `lastRefreshTimeStamp` bigint(20) defa' at line 10 > > I fixed it by temporarily letting hibernate create the needed tables. I > have dumped the created and clean tables in the attached file. Please > verify! > > (the AUTH_webical.sql does work) > -- Zoran Kovacevic Func. Internet Integration W http://www.func.nl M +31 6 48104284 T +31 20 4230000 F +31 20 4223500 GPG http://www.func.nl/keys/z.k...@fu... |
|
From: Ivo v. D. <ivo...@gm...> - 2007-09-14 19:40:38
|
Hey, I've taken a look at it and it seems the sql file is not incorrect, just a bit impractical. The file does work if you execute it without first selecting a database (because it wants to create the database as well). Perhaps this line needs to be dropped or the documentation sharpened. I'll let Mattijs decide. The applicationContext-release.xml is fixed. Perhaps a new release on monday (after some testing)? Regards, Ivo On 9/14/07, Zoran Kovacevic <zo...@fu...> wrote: > > > Feel free to download it and test it on your machines. > > I also had a problem with the database: > > zorankovacevic$ /usr/local/mysql/bin/mysql -u root < > /Users/zorankovacevic/Desktop/webical-0.2\ Folder/DB_setup.sql > ERROR 1064 (42000) at line 47: 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 'IF NOT EXISTS CREATE DATABASE `webical` > `lastRefreshTimeStamp` bigint(20) defa' at line 10 > > I fixed it by temporarily letting hibernate create the needed tables. I > have dumped the created and clean tables in the attached file. Please > verify! > > (the AUTH_webical.sql does work) > > -- > Zoran Kovacevic > Func. Internet Integration > W http://www.func.nl > M +31 6 48104284 > T +31 20 4230000 > F +31 20 4223500 > GPG http://www.func.nl/keys/z.k...@fu... > > -- MySQL Administrator dump 1.4 > -- > -- ------------------------------------------------------ > -- Server version 5.0.45 > > > /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; > /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; > /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; > /*!40101 SET NAMES utf8 */; > > /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; > /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, > FOREIGN_KEY_CHECKS=0 */; > /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' > */; > > > -- > -- Create schema webical > -- > > USE webical; > > -- > -- Definition of table `webical`.`application_settings` > -- > > DROP TABLE IF EXISTS `webical`.`application_settings`; > CREATE TABLE `webical`.`application_settings` ( > `applicationSettingsId` bigint(20) NOT NULL auto_increment, > `customPageTitle` mediumtext, > `pluginWorkPath` mediumtext, > `pluginPackageExtension` mediumtext, > `calendarRefreshTimeMs` int(11) default NULL, > `pluginCleanupEnabled` bit(1) default NULL, > `configurationUsername` mediumtext, > `configurationPassword` mediumtext, > PRIMARY KEY (`applicationSettingsId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`application_settings` > -- > > /*!40000 ALTER TABLE `application_settings` DISABLE KEYS */; > LOCK TABLES `application_settings` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `application_settings` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`application_settings_plugin_paths` > -- > > DROP TABLE IF EXISTS `webical`.`application_settings_plugin_paths`; > CREATE TABLE `webical`.`application_settings_plugin_paths` ( > `applicationSettingsId` bigint(20) NOT NULL, > `plugin_path` mediumtext, > KEY `FK888DA9CFD92BC9E2` (`applicationSettingsId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`application_settings_plugin_paths` > -- > > /*!40000 ALTER TABLE `application_settings_plugin_paths` DISABLE KEYS */; > LOCK TABLES `application_settings_plugin_paths` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `application_settings_plugin_paths` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`application_settings_resource_paths` > -- > > DROP TABLE IF EXISTS `webical`.`application_settings_resource_paths`; > CREATE TABLE `webical`.`application_settings_resource_paths` ( > `applicationSettingsId` bigint(20) NOT NULL, > `resource_path` mediumtext, > KEY `FK8C31272AD92BC9E2` (`applicationSettingsId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`application_settings_resource_paths` > -- > > /*!40000 ALTER TABLE `application_settings_resource_paths` DISABLE KEYS > */; > LOCK TABLES `application_settings_resource_paths` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `application_settings_resource_paths` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`calendar` > -- > > DROP TABLE IF EXISTS `webical`.`calendar`; > CREATE TABLE `webical`.`calendar` ( > `calendarId` bigint(20) NOT NULL auto_increment, > `name` mediumtext NOT NULL, > `type` mediumtext NOT NULL, > `url` mediumtext NOT NULL, > `username` mediumtext, > `password` mediumtext, > `visible` bit(1) default NULL, > `offSetFrom` bigint(20) default NULL, > `offSetTo` bigint(20) default NULL, > `lastRefreshTimeStamp` bigint(20) default NULL, > `userId` varchar(255) NOT NULL, > PRIMARY KEY (`calendarId`), > KEY `FKF55EFB3EF4310590` (`userId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`calendar` > -- > > /*!40000 ALTER TABLE `calendar` DISABLE KEYS */; > LOCK TABLES `calendar` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `calendar` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event` > -- > > DROP TABLE IF EXISTS `webical`.`event`; > CREATE TABLE `webical`.`event` ( > `eventId` bigint(20) NOT NULL auto_increment, > `calendarId` bigint(20) NOT NULL, > `clazz` mediumtext, > `description` mediumtext, > `geo` mediumtext, > `location` mediumtext, > `organizer` mediumtext, > `status` mediumtext, > `summary` mediumtext, > `transp` mediumtext, > `uid` mediumtext, > `url` mediumtext, > `created` datetime default NULL, > `dtStart` datetime default NULL, > `lastMod` datetime default NULL, > `dtStamp` datetime default NULL, > `seq` int(11) default NULL, > `dtEnd` datetime default NULL, > `duration` varchar(255) default NULL, > PRIMARY KEY (`eventId`), > KEY `FK5C6729A5DB02C36` (`calendarId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event` > -- > > /*!40000 ALTER TABLE `event` DISABLE KEYS */; > LOCK TABLES `event` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_attach` > -- > > DROP TABLE IF EXISTS `webical`.`event_attach`; > CREATE TABLE `webical`.`event_attach` ( > `eventId` bigint(20) NOT NULL, > `attach` mediumtext, > KEY `FK2079378A47C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_attach` > -- > > /*!40000 ALTER TABLE `event_attach` DISABLE KEYS */; > LOCK TABLES `event_attach` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_attach` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_attendee` > -- > > DROP TABLE IF EXISTS `webical`.`event_attendee`; > CREATE TABLE `webical`.`event_attendee` ( > `eventId` bigint(20) NOT NULL, > `attendee` mediumtext, > KEY `FKE746D8BF47C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_attendee` > -- > > /*!40000 ALTER TABLE `event_attendee` DISABLE KEYS */; > LOCK TABLES `event_attendee` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_attendee` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_categories` > -- > > DROP TABLE IF EXISTS `webical`.`event_categories`; > CREATE TABLE `webical`.`event_categories` ( > `eventId` bigint(20) NOT NULL, > `categories` mediumtext, > KEY `FKD2164E147C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_categories` > -- > > /*!40000 ALTER TABLE `event_categories` DISABLE KEYS */; > LOCK TABLES `event_categories` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_categories` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_comment` > -- > > DROP TABLE IF EXISTS `webical`.`event_comment`; > CREATE TABLE `webical`.`event_comment` ( > `eventId` bigint(20) NOT NULL, > `comment` mediumtext, > KEY `FK4F94CDBA47C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_comment` > -- > > /*!40000 ALTER TABLE `event_comment` DISABLE KEYS */; > LOCK TABLES `event_comment` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_comment` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_contact` > -- > > DROP TABLE IF EXISTS `webical`.`event_contact`; > CREATE TABLE `webical`.`event_contact` ( > `eventId` bigint(20) NOT NULL, > `contact` mediumtext, > KEY `FK4FA6037B47C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_contact` > -- > > /*!40000 ALTER TABLE `event_contact` DISABLE KEYS */; > LOCK TABLES `event_contact` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_contact` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_exDate` > -- > > DROP TABLE IF EXISTS `webical`.`event_exDate`; > CREATE TABLE `webical`.`event_exDate` ( > `eventId` bigint(20) NOT NULL, > `exDate` datetime default NULL, > KEY `FK276F284647C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_exDate` > -- > > /*!40000 ALTER TABLE `event_exDate` DISABLE KEYS */; > LOCK TABLES `event_exDate` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_exDate` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_exRule` > -- > > DROP TABLE IF EXISTS `webical`.`event_exRule`; > CREATE TABLE `webical`.`event_exRule` ( > `eventId` bigint(20) NOT NULL, > `exRule` mediumtext, > KEY `FK2775CF9447C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_exRule` > -- > > /*!40000 ALTER TABLE `event_exRule` DISABLE KEYS */; > LOCK TABLES `event_exRule` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_exRule` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_rDate` > -- > > DROP TABLE IF EXISTS `webical`.`event_rDate`; > CREATE TABLE `webical`.`event_rDate` ( > `eventId` bigint(20) NOT NULL, > `rDate` datetime default NULL, > KEY `FK1AABD55B47C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_rDate` > -- > > /*!40000 ALTER TABLE `event_rDate` DISABLE KEYS */; > LOCK TABLES `event_rDate` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_rDate` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_rRule` > -- > > DROP TABLE IF EXISTS `webical`.`event_rRule`; > CREATE TABLE `webical`.`event_rRule` ( > `eventId` bigint(20) NOT NULL, > `rRule` mediumtext, > KEY `FK1AB27CA947C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_rRule` > -- > > /*!40000 ALTER TABLE `event_rRule` DISABLE KEYS */; > LOCK TABLES `event_rRule` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_rRule` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_rStatus` > -- > > DROP TABLE IF EXISTS `webical`.`event_rStatus`; > CREATE TABLE `webical`.`event_rStatus` ( > `eventId` bigint(20) NOT NULL, > `rStatus` mediumtext, > KEY `FK39A7FE5F47C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_rStatus` > -- > > /*!40000 ALTER TABLE `event_rStatus` DISABLE KEYS */; > LOCK TABLES `event_rStatus` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_rStatus` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_related` > -- > > DROP TABLE IF EXISTS `webical`.`event_related`; > CREATE TABLE `webical`.`event_related` ( > `eventId` bigint(20) NOT NULL, > `related` mediumtext, > KEY `FK57EE7B8647C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_related` > -- > > /*!40000 ALTER TABLE `event_related` DISABLE KEYS */; > LOCK TABLES `event_related` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_related` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_resources` > -- > > DROP TABLE IF EXISTS `webical`.`event_resources`; > CREATE TABLE `webical`.`event_resources` ( > `eventId` bigint(20) NOT NULL, > `resources` mediumtext, > KEY `FKA08132C047C8C010` (`eventId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_resources` > -- > > /*!40000 ALTER TABLE `event_resources` DISABLE KEYS */; > LOCK TABLES `event_resources` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_resources` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`event_xProps` > -- > > DROP TABLE IF EXISTS `webical`.`event_xProps`; > CREATE TABLE `webical`.`event_xProps` ( > `id` bigint(20) NOT NULL, > `xprop_value` mediumtext, > `xprop_name` varchar(255) NOT NULL, > PRIMARY KEY (`id`,`xprop_name`), > KEY `FK45BCAD1D99D48BF6` (`id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`event_xProps` > -- > > /*!40000 ALTER TABLE `event_xProps` DISABLE KEYS */; > LOCK TABLES `event_xProps` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `event_xProps` ENABLE KEYS */; > > > -- > -- Definition of table `webical`.`user` > -- > > DROP TABLE IF EXISTS `webical`.`user`; > CREATE TABLE `webical`.`user` ( > `userId` varchar(255) NOT NULL, > `firstName` text, > `lastNamePrefix` text, > `lastName` text, > `birthDate` date default NULL, > PRIMARY KEY (`userId`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > -- > -- Dumping data for table `webical`.`user` > -- > > /*!40000 ALTER TABLE `user` DISABLE KEYS */; > LOCK TABLES `user` WRITE; > UNLOCK TABLES; > /*!40000 ALTER TABLE `user` ENABLE KEYS */; > > > > > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; > /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; > /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; > /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; > /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; > /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Webical-developers mailing list > Web...@li... > https://lists.sourceforge.net/lists/listinfo/webical-developers > > -- Ivo van Dongen Func. Internet Integration W http://www.func.nl T +31 20 4230000 F +31 20 4223500 |
Thanks for helping keep SourceForge clean.
X