> From: "Myles Carrick" <[EMAIL PROTECTED]> > Tony, > re item 2: the Moodle site is not set up correctly - and it's not a Postgres > issue. Viewing the source you'll see that you're not displaying valid > html... in fact the header and footer files (displayed from the chosen > theme) aren't present... and therefore no CSS either. Have you perhaps > chosen a theme then subsequently deleted it from the /themes directory? What > are the current contents of that directory? > Myles
Myles, Here is my theme directory. [XS-tony theme]$ pwd /var/www/html/EduBlog/moodle/theme [XS-tony theme]$ ls -al total 36 drwxr-xr-x 4 apache nobody 4096 2008-07-12 18:02 . drwxr-xr-x 36 apache nobody 4096 2008-07-13 05:47 .. -rw-r--r-- 1 apache nobody 5161 2008-07-12 18:02 index.php -rw-r--r-- 1 apache nobody 1335 2008-07-12 18:02 preview.php drwxr-xr-x 3 apache nobody 4096 2008-07-12 18:02 standard -rw-r--r-- 1 apache nobody 4918 2008-07-12 18:02 UPGRADE.txt drwxr-xr-x 3 apache nobody 4096 2008-07-12 18:02 xo [XS-tony theme]$ I saved all 10 screens from the "unattended operations" and the only place "theme" shows up is in the first page, as fields on four databases. (postgres7): CREATE TABLE mdl_course ( id BIGSERIAL, category BIGINT NOT NULL DEFAULT 0, sortorder BIGINT NOT NULL DEFAULT 0, password VARCHAR(50) NOT NULL DEFAULT '', fullname VARCHAR(254) NOT NULL DEFAULT '', shortname VARCHAR(100) NOT NULL DEFAULT '', idnumber VARCHAR(100) NOT NULL DEFAULT '', summary TEXT, format VARCHAR(10) NOT NULL DEFAULT 'topics', showgrades SMALLINT NOT NULL DEFAULT 1, modinfo TEXT, newsitems INTEGER NOT NULL DEFAULT 1, teacher VARCHAR(100) NOT NULL DEFAULT 'Teacher', teachers VARCHAR(100) NOT NULL DEFAULT 'Teachers', student VARCHAR(100) NOT NULL DEFAULT 'Student', students VARCHAR(100) NOT NULL DEFAULT 'Students', guest SMALLINT NOT NULL DEFAULT 0, startdate BIGINT NOT NULL DEFAULT 0, enrolperiod BIGINT NOT NULL DEFAULT 0, numsections INTEGER NOT NULL DEFAULT 1, marker BIGINT NOT NULL DEFAULT 0, maxbytes BIGINT NOT NULL DEFAULT 0, showreports SMALLINT NOT NULL DEFAULT 0, visible SMALLINT NOT NULL DEFAULT 1, hiddensections SMALLINT NOT NULL DEFAULT 0, groupmode SMALLINT NOT NULL DEFAULT 0, groupmodeforce SMALLINT NOT NULL DEFAULT 0, defaultgroupingid BIGINT NOT NULL DEFAULT 0, lang VARCHAR(30) NOT NULL DEFAULT '', theme VARCHAR(50) NOT NULL DEFAULT '', cost VARCHAR(10) NOT NULL DEFAULT '', currency VARCHAR(3) NOT NULL DEFAULT 'USD', timecreated BIGINT NOT NULL DEFAULT 0, timemodified BIGINT NOT NULL DEFAULT 0, metacourse SMALLINT NOT NULL DEFAULT 0, requested SMALLINT NOT NULL DEFAULT 0, restrictmodules SMALLINT NOT NULL DEFAULT 0, expirynotify SMALLINT NOT NULL DEFAULT 0, expirythreshold BIGINT NOT NULL DEFAULT 0, notifystudents SMALLINT NOT NULL DEFAULT 0, enrollable SMALLINT NOT NULL DEFAULT 1, enrolstartdate BIGINT NOT NULL DEFAULT 0, enrolenddate BIGINT NOT NULL DEFAULT 0, enrol VARCHAR(20) NOT NULL DEFAULT '', defaultrole BIGINT NOT NULL DEFAULT 0, CONSTRAINT mdl_cour_id_pk PRIMARY KEY (id) ) Success .... (postgres7): CREATE TABLE mdl_course_categories ( id BIGSERIAL, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT, parent BIGINT NOT NULL DEFAULT 0, sortorder BIGINT NOT NULL DEFAULT 0, coursecount BIGINT NOT NULL DEFAULT 0, visible SMALLINT NOT NULL DEFAULT 1, timemodified BIGINT NOT NULL DEFAULT 0, depth BIGINT NOT NULL DEFAULT 0, path VARCHAR(255) NOT NULL DEFAULT '', theme VARCHAR(50), CONSTRAINT mdl_courcate_id_pk PRIMARY KEY (id) ) Success (postgres7): CREATE TABLE mdl_user ( id BIGSERIAL, auth VARCHAR(20) NOT NULL DEFAULT 'manual', confirmed SMALLINT NOT NULL DEFAULT 0, policyagreed SMALLINT NOT NULL DEFAULT 0, deleted SMALLINT NOT NULL DEFAULT 0, mnethostid BIGINT NOT NULL DEFAULT 0, username VARCHAR(100) NOT NULL DEFAULT '', password VARCHAR(32) NOT NULL DEFAULT '', idnumber VARCHAR(255) NOT NULL DEFAULT '', firstname VARCHAR(100) NOT NULL DEFAULT '', lastname VARCHAR(100) NOT NULL DEFAULT '', email VARCHAR(100) NOT NULL DEFAULT '', emailstop SMALLINT NOT NULL DEFAULT 0, icq VARCHAR(15) NOT NULL DEFAULT '', skype VARCHAR(50) NOT NULL DEFAULT '', yahoo VARCHAR(50) NOT NULL DEFAULT '', aim VARCHAR(50) NOT NULL DEFAULT '', msn VARCHAR(50) NOT NULL DEFAULT '', phone1 VARCHAR(20) NOT NULL DEFAULT '', phone2 VARCHAR(20) NOT NULL DEFAULT '', institution VARCHAR(40) NOT NULL DEFAULT '', department VARCHAR(30) NOT NULL DEFAULT '', address VARCHAR(70) NOT NULL DEFAULT '', city VARCHAR(20) NOT NULL DEFAULT '', country VARCHAR(2) NOT NULL DEFAULT '', lang VARCHAR(30) NOT NULL DEFAULT 'en', theme VARCHAR(50) NOT NULL DEFAULT '', timezone VARCHAR(100) NOT NULL DEFAULT '99', firstaccess BIGINT NOT NULL DEFAULT 0, lastaccess BIGINT NOT NULL DEFAULT 0, lastlogin BIGINT NOT NULL DEFAULT 0, currentlogin BIGINT NOT NULL DEFAULT 0, lastip VARCHAR(15) NOT NULL DEFAULT '', secret VARCHAR(15) NOT NULL DEFAULT '', picture SMALLINT NOT NULL DEFAULT 0, url VARCHAR(255) NOT NULL DEFAULT '', description TEXT, mailformat SMALLINT NOT NULL DEFAULT 1, maildigest SMALLINT NOT NULL DEFAULT 0, maildisplay SMALLINT NOT NULL DEFAULT 2, htmleditor SMALLINT NOT NULL DEFAULT 1, ajax SMALLINT NOT NULL DEFAULT 1, autosubscribe SMALLINT NOT NULL DEFAULT 1, trackforums SMALLINT NOT NULL DEFAULT 0, timemodified BIGINT NOT NULL DEFAULT 0, trustbitmask BIGINT NOT NULL DEFAULT 0, imagealt VARCHAR(255), screenreader SMALLINT NOT NULL DEFAULT 0, CONSTRAINT mdl_user_id_pk PRIMARY KEY (id) ) Success ... (postgres7): CREATE TABLE mdl_mnet_host ( id BIGSERIAL, deleted SMALLINT NOT NULL DEFAULT 0, wwwroot VARCHAR(255) NOT NULL DEFAULT '', ip_address VARCHAR(39) NOT NULL DEFAULT '', name VARCHAR(80) NOT NULL DEFAULT '', public_key TEXT NOT NULL, public_key_expires BIGINT NOT NULL DEFAULT 0, transport SMALLINT NOT NULL DEFAULT 0, portno SMALLINT NOT NULL DEFAULT 0, last_connect_time BIGINT NOT NULL DEFAULT 0, last_log_id BIGINT NOT NULL DEFAULT 0, force_theme SMALLINT NOT NULL DEFAULT 0, theme VARCHAR(100), applicationid BIGINT NOT NULL DEFAULT 1, CONSTRAINT mdl_mnethost_id_pk PRIMARY KEY (id) ) Success If I need to drop into "psql" to read the values of these, please let me know. Thanks Tony Pearson
_______________________________________________ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel