<br><tt><font size=2>> From: "Myles Carrick" <mylescarrick@gmail.com></font></tt>
<br><tt><font size=2>> Tony,<br>
> re item 2: the Moodle site is not set up correctly - and it's not
a Postgres<br>
> issue. Viewing the source you'll see that you're not displaying valid<br>
> html... in fact the header and footer files (displayed from the chosen<br>
> theme) aren't present... and therefore no CSS either. Have you perhaps<br>
> chosen a theme then subsequently deleted it from the /themes directory?
What<br>
> are the current contents of that directory?<br>
> Myles</font></tt>
<br>
<br><font size=2 face="Courier New">Myles,</font>
<br><font size=2 face="Courier New">Here is my theme directory.</font>
<br>
<br><font size=2 face="Courier New">[XS-tony theme]$ pwd</font>
<br><font size=2 face="Courier New">/var/www/html/EduBlog/moodle/theme</font>
<br><font size=2 face="Courier New">[XS-tony theme]$ ls -al</font>
<br><font size=2 face="Courier New">total 36</font>
<br><font size=2 face="Courier New">drwxr-xr-x 4 apache nobody 4096
2008-07-12 18:02 .</font>
<br><font size=2 face="Courier New">drwxr-xr-x 36 apache nobody 4096 2008-07-13
05:47 ..</font>
<br><font size=2 face="Courier New">-rw-r--r-- 1 apache nobody 5161
2008-07-12 18:02 index.php</font>
<br><font size=2 face="Courier New">-rw-r--r-- 1 apache nobody 1335
2008-07-12 18:02 preview.php</font>
<br><font size=2 face="Courier New">drwxr-xr-x 3 apache nobody 4096
2008-07-12 18:02 standard</font>
<br><font size=2 face="Courier New">-rw-r--r-- 1 apache nobody 4918
2008-07-12 18:02 UPGRADE.txt</font>
<br><font size=2 face="Courier New">drwxr-xr-x 3 apache nobody 4096
2008-07-12 18:02 xo</font>
<br><font size=2 face="Courier New">[XS-tony theme]$</font>
<br>
<br><font size=2 face="sans-serif">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.</font>
<br>
<br><font size=2 face="Courier New">(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) ) </font>
<br><font size=2 face="Courier New">Success</font>
<br><font size=2 face="sans-serif">....</font>
<br><font size=2 face="Courier New">(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) ) </font>
<br><font size=2 face="Courier New">Success</font>
<br>
<br><font size=2 face="Courier New">(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) ) </font>
<br><font size=2 face="Courier New">Success</font>
<br><font size=2 face="Courier New">...</font>
<br><font size=2 face="Courier New">(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) ) </font>
<br><font size=2 face="Courier New">Success</font>
<br>
<br><font size=2 face="sans-serif">If I need to drop into "psql"
to read the values of these, please let me know.</font>
<br>
<br><font size=2 face="sans-serif">Thanks</font>
<br><font size=2 face="sans-serif">Tony Pearson</font>
<br>