Installation of Genus stop at steps 3

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Installation stop at 3rd steps and unable to continue. 
2. Please refer to attached screen print.
3.

What is the expected output? What do you see instead?
Please advise and help on the installation.

What version of the product are you using? On what operating system?

genus3.1.4.tar on Windows 7 with my sql

Please provide any additional information below.

Original issue reported on code.google.com by royn...@yahoo.com on 14 Mar 2012 at 12:18

Attachments:

• error.jpg

[GoogleCodeExporter]

Hi there,

Any update on this ? i amusing the latest version(3.2.3) available and i am 
getting the same error

Original comment by patmoeke...@gmail.com on 4 Apr 2012 at 8:43

Attachments:

• lams.png

[GoogleCodeExporter]

the issue above i believe is to do with the default data that the install 
script tries to add to the DB. its trying to add '' (null) to an integer field 
that requires a value.

files you need to update are in /install/data. attached is a txt file with the 
contents that 'appear' to work - just swap these over.

j

Original comment by jamesjmo...@gmail.com on 18 Apr 2012 at 3:44

Attachments:

• sql_changes.txt

[GoogleCodeExporter]

Hi there,

I have made the required changes to the 3 sql files as per instructions and i 
am still getting the same error, is there any changes that needs to be made to 
the addcategorymaster.sql file ?

Thank you 

Original comment by patmoeke...@gmail.com on 19 Apr 2012 at 6:33

[GoogleCodeExporter]

I am getting below error on Step 3?

----------------------------

Setting foreign key checks to one
Done with DB Structure
Setting foreign key checks to zero
An error has occured. Report being generated now...
Error: 
This is the SQL error:
Access denied; you need the SUPER privilege for this operation

This is the SQL:

CREATE DEFINER=`root`@`localhost` PROCEDURE `channel_service_detail`(IN 
serviceid int(5), IN detailid int(5)) BEGIN IF serviceid = 2 THEN SELECT 
video_name AS descr FROM video_master WHERE video_id = detailid; ELSEIF 
serviceid = 3 THEN SELECT graphic_name AS descr FROM graphic_master WHERE 
graphic_id = detailid; ELSEIF serviceid = 7 THEN SELECT description AS descr 
FROM rss_master WHERE rss_id = detailid; ELSEIF serviceid = 8 THEN SELECT 
description AS descr FROM rss_master WHERE rss_id = detailid; ELSEIF serviceid 
= 12 THEN SELECT description AS descr FROM twitter_master WHERE tweet_id = 
detailid; ELSEIF serviceid = 14 THEN SELECT category_name AS descr FROM 
announcement_categories WHERE category_id = detailid; ELSEIF serviceid = 18 
THEN SELECT sms_msg AS descr FROM sms_messages WHERE id = detailid; ELSEIF 
serviceid = 19 THEN SELECT message AS descr FROM announcements WHERE id = 
detailid; END IF; END
Report generated. Please go back and continue. The problem will be resolved 
soon.

Original comment by h.k.she...@gmail.com on 26 May 2012 at 2:26

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Hi, 
I am not able to install and i get the following error. Please help

Creating table video_master.sql ... done
Creating table visitor_category_master.sql ... done
Creating table visitor_master.sql ... done
Creating table weather_master.sql ... done
Setting foreign key checks to one
Done with DB Structure
Setting foreign key checks to zero
An error has occured. Report being generated now...
Error: 
This is the SQL error:
Access denied; you need (at least one of) the SUPER privilege(s) for this 
operation

This is the SQL:

CREATE DEFINER=`root`@`localhost` PROCEDURE `channel_service_detail`(IN 
serviceid int(5), IN detailid int(5)) BEGIN IF serviceid = 2 THEN SELECT 
video_name AS descr FROM video_master WHERE video_id = detailid; ELSEIF 
serviceid = 3 THEN SELECT graphic_name AS descr FROM graphic_master WHERE 
graphic_id = detailid; ELSEIF serviceid = 7 THEN SELECT description AS descr 
FROM rss_master WHERE rss_id = detailid; ELSEIF serviceid = 8 THEN SELECT 
description AS descr FROM rss_master WHERE rss_id = detailid; ELSEIF serviceid 
= 12 THEN SELECT description AS descr FROM twitter_master WHERE tweet_id = 
detailid; ELSEIF serviceid = 14 THEN SELECT category_name AS descr FROM 
announcement_categories WHERE category_id = detailid; ELSEIF serviceid = 18 
THEN SELECT sms_msg AS descr FROM sms_messages WHERE id = detailid; ELSEIF 
serviceid = 19 THEN SELECT message AS descr FROM announcements WHERE id = 
detailid; END IF; END
Report generated. Please go back and continue. The problem will be resolved 
soon.

Original comment by joel...@gmail.com on 17 Jun 2012 at 2:55

[GoogleCodeExporter]

I want complete instalation guide. Can any one help me out?

Original comment by jada...@gmail.com on 3 Jul 2012 at 12:42

[GoogleCodeExporter]

Have got same issue, can help? thanks

Creating table visitor_category_master.sql ... done
Creating table visitor_master.sql ... done
Creating table weather_master.sql ... done
Setting foreign key checks to one
Done with DB Structure
Setting foreign key checks to zero
An error has occured. Report being generated now...
Error: 
This is the SQL error:
Access denied; you need the SUPER privilege for this operation

This is the SQL:

CREATE DEFINER=`root`@`localhost` PROCEDURE `channel_service_detail`(IN 
serviceid int(5), IN detailid int(5)) BEGIN IF serviceid = 2 THEN SELECT 
video_name AS descr FROM video_master WHERE video_id = detailid; ELSEIF 
serviceid = 3 THEN SELECT graphic_name AS descr FROM graphic_master WHERE 
graphic_id = detailid; ELSEIF serviceid = 7 THEN SELECT description AS descr 
FROM rss_master WHERE rss_id = detailid; ELSEIF serviceid = 8 THEN SELECT 
description AS descr FROM rss_master WHERE rss_id = detailid; ELSEIF serviceid 
= 12 THEN SELECT description AS descr FROM twitter_master WHERE tweet_id = 
detailid; ELSEIF serviceid = 14 THEN SELECT category_name AS descr FROM 
announcement_categories WHERE category_id = detailid; ELSEIF serviceid = 18 
THEN SELECT sms_msg AS descr FROM sms_messages WHERE id = detailid; ELSEIF 
serviceid = 19 THEN SELECT message AS descr FROM announcements WHERE id = 
detailid; END IF; END
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...

Original comment by amen.ch...@gmail.com on 16 Jul 2012 at 2:58

[GoogleCodeExporter]

Same error...fixing the 3 files as recommended above does not help either. Any 
updates?

Original comment by huzaifah...@gmail.com on 17 Jan 2013 at 6:17

[GoogleCodeExporter]

I am experiencing the error as being displayed in the attached image. This 
happens in step3. 

Original comment by venkates...@gmail.com on 14 Feb 2013 at 2:48

Attachments:

• error.png

[GoogleCodeExporter]

I also have access define issue. Does anyone solve this question?

Original comment by kenny.ch...@gmail.com on 16 Apr 2014 at 4:03

[GoogleCodeExporter]

i gave up and move to this program, works best and has support. www.lewe.com

Original comment by patmoeke...@gmail.com on 16 Apr 2014 at 4:35

[GoogleCodeExporter]

Fatal error: Maximum execution time of 30 seconds exceeded in 
C:\xampp\htdocs\genus\classes\db\mysql.php on line 31

Original comment by mwendamo...@gmail.com on 16 Aug 2014 at 6:39