shlomi-noach / common-schema-legacy

Automatically exported from code.google.com/p/common-schema
5 stars 6 forks source link

Install error #78

Open applibs opened 8 years ago

applibs commented 8 years ago

Hi, I downloaded common_schema-2.2.sql from https://code.google.com/archive/p/common-schema/downloads into mySql 5.6.23 (Win 10 x64), but I got error on line:

---- 
-- Metadata: information about this project
-- 
DROP TABLE IF EXISTS help_content;

CREATE TABLE help_content (
  topic VARCHAR(32) CHARSET ascii NOT NULL,
  help_message TEXT CHARSET utf8,
  PRIMARY KEY (topic)
) ENGINE=InnoDB
;

I fixed it with:

--
-- Metadata: information about this project
--
...

Then I got error on this line:

-- 
-- Complement INFORMATION_SCHEMA.ROUTINES with missing param_list    
-- 
CREATE OR REPLACE
ALGORITHM = MERGE
SQL SECURITY INVOKER
VIEW routines AS
  SELECT 
    ROUTINES.*, proc.param_list
  FROM
    INFORMATION_SCHEMA.ROUTINES
    JOIN mysql.proc ON (db = ROUTINE_SCHEMA and name = ROUTINE_NAME and type = ROUTINE_TYPE)
;

but this I dont know how to solve it. Ohh now I see that its same error like this #71 .

Can you upload already fixed issues to https://code.google.com/archive/p/common-schema/downloads please for other users?