nileshkapse1991 / genusproject

Automatically exported from code.google.com/p/genusproject
0 stars 0 forks source link

INstallation problem #16

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.
2.
3.

Step 1
Step2
Step3
    An error has occured. Report being generated now...
Error:
This is the SQL error:

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 'SET SQL_MODE=''*/; 
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,' at line 9

What is the expected output? What do you see instead?

This is the SQL:

/* SQLyog Enterprise - MySQL GUI v7.02 MySQL - 5.1.30-community : Database - 
genus2 ********************************************************************* */ 
/*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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 
DATABASE /*!32312 IF NOT EXISTS*/`genus2` /*!40100 DEFAULT CHARACTER SET latin1 
*/; USE `genus2`; /*Table structure for table `core_module_master` */ DROP 
TABLE IF EXISTS `core_module_master`; CREATE TABLE `core_module_master` ( 
`module_id` smallint(6) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT 
NULL, `description` varchar(255) DEFAULT NULL, `dependency_group` varchar(25) 
DEFAULT NULL, `dashboard_filename` varchar(255) DEFAULT NULL, `logo` 
varchar(255) DEFAULT NULL, `introduction` text, `core_module` char(1) DEFAULT 
'n', `default_module` char(1) DEFAULT 'n', `available_teamspaces` char(1) 
DEFAULT 'n', `signup_module` char(1) DEFAULT 'n', `available_all_workspaces` 
char(1) DEFAULT 'n', `anonymous_access` char(1) DEFAULT 'n', PRIMARY KEY 
(`module_id`) ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1; /*Data 
for the table `core_module_master` */ LOCK TABLES `core_module_master` WRITE; 
insert into 
`core_module_master`(`module_id`,`name`,`description`,`dependency_group`,`dashbo
ard_filename`,`logo`,`introduction`,`core_module`,`default_module`,`available_te
amspaces`,`signup_module`,`available_all_workspaces`,`anonymous_access`) values 
(14,'HRMS','Human Resources 
System','CORE','','nuvola/48x48/apps/kdmconfig.png','','y','n','n','n','y','n'),
(15,'Teamspace','Teamspace 
System','CORE','','nuvola/48x48/apps/kdmconfig.png','','y','n','n','n','y','n'),
(16,'Documents','Document Management 
System','DOCUMENTS','','nuvola/48x48/actions/filesave.png','','y','n','y','n','y
','n'),(17,'Leave','Leave Management 
System','LEAVE','','nuvola/48x48/apps/kdmconfig.png','','y','n','n','n','y','n')
,(19,'Helpdesk','Helpesk 
System','ITIL','','nuvola/48x48/apps/kdmconfig.png','','n','n','y','n','y','n'),
(20,'Visitors','Visitor Entry 
System','VISITORS','','nuovext/48x48/apps/messenger.png','','n','n','y','y','y',
'n'),(25,'SStars','Simple Stationary Request 
System','SSTARS','','nuovext/48x48/apps/messenger.png','','n','n','y','y','y','y
'),(26,'Core','Core','CORE','','','','n','n','n','n','n','y'),(27,'Project','Pro
jects','PROJECTS',NULL,'nuvola/48x48/apps/kdmconfig.png',NULL,'n','n','y','n','n
','n'),(28,'CRM','Customer Relationship 
Management','CRM',NULL,'nuvola/48x48/apps/kdmconfig.png',NULL,'n','n','y','n','n
','n'),(29,'Messaging','Messaging','MESSAGING',NULL,NULL,NULL,'n','n','y','n','n
','n'),(30,'Groups','Groups','MESSAGING',NULL,NULL,NULL,'n','n','y','n','n','n')
,(31,'Facilities','Facilities Management and 
Booking','FACILITIES',NULL,NULL,NULL,'n','n','n','n','n','n'),(32,'Senex','Staff
 Entry and 
Exit','SENEX',NULL,NULL,NULL,'n','n','n','n','n','n'),(33,'TransChat','Translati
on 
Chat','TRANSCHAT',NULL,NULL,NULL,'n','n','n','n','n','n'),(34,'Auction','Simple 
Auction ','AUCTION',NULL,NULL,NULL,'n','n','n','n','n','n'),(35,'Tasks','Task 
management','TASKS',NULL,NULL,NULL,'n','n','y','n','n','n'),(36,'Adverts','Adver
ts','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(37,'Channels','Channels','O
DISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(38,'Flash','Flash 
Content','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(39,'Graphics','Graphic
s 
Content','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(40,'Reporting','Report
ing 
Tool','REPORTING',NULL,NULL,NULL,'n','n','n','n','n','n'),(41,'StaffSMS','SMS 
tool','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(42,'StudentAds','Adverts'
,'ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(43,'Survey','Survey 
Tool','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(44,'Timetable','Timetable
','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(45,'Traffic','Traffic','ODISS
',NULL,NULL,NULL,'n','n','n','n','n','n'),(46,'Video','Video','ODISS',NULL,NULL,
NULL,'n','n','n','n','n','n'),(47,'Weather','Weather','ODISS',NULL,NULL,NULL,'n'
,'n','n','n','n','n'),(48,'RSS','RSS','ODISS',NULL,NULL,NULL,'n','n','n','n','n'
,'n'),(49,'Announcements','Announcements','ODISS',NULL,NULL,NULL,'n','n','n','n'
,'n','n'),(50,'WebClient','WebClient','ODISS',NULL,NULL,NULL,'n','n','n','n','n'
,'n'),(51,'Monitor','ODISS 
Monitor','ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(52,'MyHalo','MyHalo','
ODISS',NULL,NULL,NULL,'n','n','n','n','n','n'),(53,'Twitter','Twitter','ODISS',N
ULL,NULL,NULL,'n','n','n','n','n','n'),(54,'Atom','Atom','ODISS',NULL,NULL,NULL,
'n','n','n','n','n','n'),(55,'Screens','Screens','ODISS',NULL,NULL,NULL,'n','n',
'n','n','n','n'),(56,'Changes','Change 
Management','ITIL',NULL,NULL,NULL,'n','n','n','n','n','n'),(57,'WebMon','Web 
Monitor','MONITORING',NULL,NULL,NULL,'n','n','n','n','n','n'); UNLOCK TABLES; 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET 
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Report generated. Please go back and continue. The problem will be resolved 
soon.
Success, starting database installation now...
Creating Database Structure Now...
Creating Database Stored Procedures...
Creating Database Functions...
Dumping Database Data Now...
What version of the product are you using? On what operating system?

latetst version
Please provide any additional information below.

can you please help me

Gregory

Original issue reported on code.google.com by gregory....@gmail.com on 7 Jun 2011 at 2:56

GoogleCodeExporter commented 8 years ago
Fixed in the new 3 release we believe.

Original comment by terence....@gmail.com on 26 Jul 2011 at 11:47