Installing and upgrading help

I have increased the php memory limit for scripts. Before I did that the upgrade stopped at:.... Setting up block tables....

After I increased the memory limit I got to the error:

scorm tables could NOT be set up successfully!

What do I do now? Revert back to 1.2.1?

Jerald Volpe

UC Berkeley Extension

_________

scorm

(postgres7): CREATE TABLE mdl_scorm ( id SERIAL PRIMARY KEY, course integer NOT NULL default '0', name varchar(255) NOT NULL default '', reference varchar(255) NOT NULL default '', datadir varchar(255) NOT NULL default '', launch integer NOT NULL default '0', summary text NOT NULL default '', auto integer NOT NULL default '0', popup varchar(255) NOT NULL default '', timemodified integer NOT NULL default '0')  

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: Relation 'mdl_scorm_id_seq' already exists . in /sites/classes2/httpd/htdocs/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-5: ERROR: Relation 'mdl_scorm_id_seq' already exists

Error

(postgres7): CREATE TABLE mdl_scorm_scoes ( id SERIAL PRIMARY KEY, scorm integer NOT NULL default '0', parent varchar(255) NOT NULL default '', identifier varchar(255) NOT NULL default '', launch varchar(255) NOT NULL default '', type varchar(5) NOT NULL default '', title varchar(255) NOT NULL default '', datafromlms text NOT NULL default '' next integer NOT NULL default '0', previous integer NOT NULL default '0')  

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: parser: parse error at or near "next" at character 341 . in /sites/classes2/httpd/htdocs/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-2: ERROR: parser: parse error at or near "next" at character 341

Error

(postgres7): CREATE TABLE mdl_scorm_sco_users ( id SERIAL PRIMARY KEY, userid integer NOT NULL default '0', scormid integer NOT NULL default '0', scoid integer NOT NULL default '0', cmi_core_lesson_location varchar(255) NOT NULL default '', cmi_core_lesson_status varchar(30) NOT NULL default '', cmi_core_exit varchar(30) NOT NULL default '', cmi_core_total_time varchar(13) NOT NULL default '00:00:00', cmi_core_session_time varchar(13) NOT NULL default '00:00:00', cmi_core_score_raw real NOT NULL default '0', cmi_suspend_data text NOT NULL default '')  

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: Relation 'mdl_scorm_sco_users_id_seq' already exists . in /sites/classes2/httpd/htdocs/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-5: ERROR: Relation 'mdl_scorm_sco_users_id_seq' already exists

Error

(postgres7): INSERT INTO mdl_log_display VALUES ('resource', 'view', 'resource', 'name')  

Success

(postgres7): INSERT INTO mdl_log_display VALUES ('resource', 'update', 'resource', 'name')  

Success

(postgres7): INSERT INTO mdl_log_display VALUES ('resource', 'add', 'resource', 'name')  

Success