doodle, I will copy the table structure below. Thanks for responding.
By "The fourth table will not display." I mean that I have four table references all created the same way using "model tablename" and "crud tablename". tAssignments, tCompleted and tSessions will all show a screen with "http://localhost/tAssignments/?r=tAssignments" etc, but tLessons will give a blank screen using the same url.
Again this morning I deleted all references to tLessons in the protected folder and tried again with the same result of a blank screen when typing "http://localhost/tLessons/?r=tLessons".
Will deleting from the protected folder and its sub folders all files that appear to be derived from the table name allow one to start over with a new "model tablename" and "crud tablename" or must one start over with a fresh copy of Yii?
The table structure could use some work as there are inconsistencies between the table structure and the comments. I removed the enums on a few of the fields thinking that that might cause a problem for Yii, but I got the same blank screen results.
Neither the commands model or crud cause any error messages when run with tLessons. The procedure displayed after running model tLessons displayed the structure of the table.
I have simplified both the table name and the table structure several times with no change in the results. Below is the current table structure:
– phpMyAdmin SQL Dump
– version 3.2.2.1deb1
– http://www.phpmyadmin.net
–
– Host: localhost
– Generation Time: Dec 21, 2009 at 11:03 AM
– Server version: 5.1.37
– PHP Version: 5.2.10-2ubuntu6.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
–
– Database: jlf_edu
–
–
– Table structure for table tLessons
–
CREATE TABLE IF NOT EXISTS tLessons
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
tG_StartStop
char(9) DEFAULT NULL COMMENT ‘Some lessons are collected into threads. This record signifies the start or stop of a thread or the non-thread nature of this lesson as it is both a start and an end.’,
tG_Split-or-List
char(5) DEFAULT NULL COMMENT ‘A split divides the time between two lessons. A list divides the time between a list of lessons.’,
tG_ThreadName
text NOT NULL COMMENT ‘If null this is a single lesson.’,
tG_AssignmentName
char(80) NOT NULL,
tG_FormName
char(80) NOT NULL COMMENT ‘Identifies the view file.’,
tG_TableName
char(80) NOT NULL COMMENT ‘Source of the data for the form.’,
tG_StartRec
smallint(5) unsigned NOT NULL COMMENT ‘Identifies the data record for this lesson.’,
tG_StopRec
smallint(5) unsigned NOT NULL COMMENT ‘Identifies the stop record from the data table.’,
tG_Immediate_Loops
tinyint(3) unsigned NOT NULL COMMENT ‘Repeat this exact lesson this number of times.’,
tG_RepsPerRecord
tinyint(3) unsigned NOT NULL COMMENT ‘Iterations of a lesson that should be done before going to another record.’,
tG_RecordsPerSet
tinyint(4) NOT NULL,
tG_Lesson_if_Correct
char(80) NOT NULL COMMENT ‘GA to do next if lesson is completed successfully.’,
tG_Lesson_if_Error
char(80) NOT NULL COMMENT ‘GA to do next if lesson is not done successfully.’,
tG_Percent_1
tinyint(4) NOT NULL COMMENT ‘Used for splits. % of lessons assigned to first split. % is of time assigned to the lesson before the split.’,
tG_Percent_2
tinyint(3) unsigned NOT NULL COMMENT ‘Used for splits. % of lessons assigned to second split. % is of time assigned to the lesson before the split.’,
PRIMARY KEY (id
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
–
– Dumping data for table tLessons
–
INSERT INTO tLessons
(id
, tG_StartStop
, tG_Split-or-List
, tG_ThreadName
, tG_AssignmentName
, tG_FormName
, tG_TableName
, tG_StartRec
, tG_StopRec
, tG_Immediate_Loops
, tG_RepsPerRecord
, tG_RecordsPerSet
, tG_Lesson_if_Correct
, tG_Lesson_if_Error
, tG_Percent_1
, tG_Percent_2
) VALUES
(1, NULL, NULL, ‘’, ‘tG_typing_101’, ‘/typing/index.html’, ‘’, 0, 0, 0, 0, 0, ‘’, ‘’, 100, 0);