[Server-devel] Missing theme for Moodle

[Tony Pearson]

> From: "Myles Carrick" <mylescarrick at gmail.com>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.laptop.org/pipermail/server-devel/attachments/20080713/66bd0bd3/attachment.htm