Done with DB Structure
Setting foreign key checks to zero
An error has occured. Report being generated now...
Error:
This is the SQL error:
Cannot load from mysql.proc. The table is probably corrupted
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.
--
Best regards
Bgone
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I just downloaded and run install it, but received the error below:
http://localhost/genus/install/index.php?step=3
Done with DB Structure
Setting foreign key checks to zero
An error has occured. Report being generated now...
Error:
This is the SQL error:
Cannot load from mysql.proc. The table is probably corrupted
This is the SQL:
CREATE DEFINER=
root@localhostPROCEDUREchannel_service_detail(INserviceid 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.
--
Best regards
Bgone