Hi, I am using the version of Moodle 1.4.4+
I
download shared.zip, I placed the files where it was necessary, I renamed mysql.php to postgres7.php
I translate mysql.sql to postgres7.sql like this you can see at the end of the mail,
but there is the last 3 commands that refers to a table that doesn't exist, isn't?
INSERT INTO prefix_log_display VALUES ('shared_files',
'add', 'shared_files', 'name');
INSERT INTO prefix_log_display VALUES ('shared_files',
'update', 'shared_files', 'name');
INSERT INTO prefix_log_display VALUES ('shared_files',
'view', 'shared_files', 'name');
Anyway I have problems when I try to install, I tried even to install manually the tables, but nothing...
there is a way to see the log to determine more exactly why the instalation fails ???
Because at the begining I obtained
Error
Error
Error
Error
Error
Error
Success
Success
Success
After doing the manual instalation I obtained once
Error
Success
Success
Success
Success
Success
Success
Success
Success
and after the refresh :
Error
Error
Error
Error
Error
Error
So I don't know what to do, I wanted to select Moodle e-learning
tool, but I need the possibility to share files !!!! and I am not able.
Someone can help me !!!!!!!!!!!!!!!!!!!!!!
POSTGRES7.SQL:
--------------------------
CREATE TABLE prefix_shared_files_external (
id serial NOT NULL ,
userid int NOT NULL default '0',
category int NOT NULL default '0',
name VARCHAR(255) NOT NULL default '',
url VARCHAR(255) NOT NULL default '',
intro text NOT NULL default '',
attachment VARCHAR(100) NOT NULL default '',
timemodified int NOT NULL default '0',
course int NOT NULL default '0',
PRIMARY KEY (id)
);
CREATE TABLE prefix_shared_files_file (
id serial NOT NULL ,
userid int NOT NULL default '0',
category int NOT NULL default '0',
name VARCHAR(255) NOT NULL default '',
url VARCHAR(255) NOT NULL default '',
intro text NOT NULL default '',
attachment VARCHAR(100) NOT NULL default '',
timemodified int NOT NULL default '0',
course int NOT NULL default '0',
PRIMARY KEY (id)
);
CREATE TABLE prefix_shared_files_categories (
id serial NOT NULL ,
userid int NOT NULL default '0',
name VARCHAR(255) NOT NULL default '',
timemodified int NOT NULL default '0',
course int NOT NULL default '0',
PRIMARY KEY (id)
);
CREATE TABLE prefix_shared_files_shared (
id serial NOT NULL ,
bookid int NOT NULL default '0',
userid int NOT NULL default '0',
original int NOT NULL default '0',
course int NOT NULL default '0',
PRIMARY KEY (id)
);
CREATE TABLE prefix_shared_files_sharedfile (
id serial NOT NULL ,
bookid int NOT NULL default '0',
userid int NOT NULL default '0',
original int NOT NULL default '0',
course int NOT NULL default '0',
PRIMARY KEY (id)
);
CREATE TABLE prefix_shared_files_maxuploads (
id serial NOT NULL ,
unid int NOT NULL default '1',
maxupload int NOT NULL default '0',
maxdir int NOT NULL default '0',
PRIMARY KEY (id)
);
