[Phpwebsite-developers] Re: Testing request

[Brian G. <br...@vf...>]

> 12:21:34 11/10/03 Error [notice] [-1] INSERT INTO modules (title, 
> proper_name, version, active, register) VALUES ('users', 'Users', '2.0', 
> 1, 1) [nativecode=ERROR:  ExecInsert: Fail to add null value in not null 
> attribute priority
> ] 

I thought I would provide more information here on my previous post.  From 
core/boost/install.sql: 

CREATE TABLE modules (
       title CHAR(40) NOT NULL,
       proper_name CHAR(40) NOT NULL,
       priority SMALLINT NOT NULL,
       active SMALLINT NOT NULL,
       version CHAR(20) NOT NULL,
       register SMALLINT NOT NULL
       ); 

The query setup uses is like this: 

INSERT INTO modules (title, proper_name, version, active, register) VALUES 
('layout', 'Layout', '2.0', 1, 0) 

The column "priority", which is not null, is not present but needs to be in 
order to make it work (or alternatively, don't declare it not null). 

I manually adjusted the core/boost/install.sql file to have a DEFAULT 0 on 
the priority line which solved that problem.  The users module installed ok 
although the other SQL errors regarding ID still persist.  I manually 
inserted two users by adding the ID and a corresponding value to the SQL 
queries.  Then I went to the next step, here is the boost.log file: 

13:54:12 11/10/03  [notice] Module - users : Copying directory 
/web/ggc-bmw-cca.org/www/mod/users/img/ to 
/web/ggc-bmw-cca.org/www/images/mod/users/
13:58:04 11/10/03  [notice] Module - layout : No installation file found.
13:58:06 11/10/03  [notice] Module - controlpanel : No installation file 
found.
13:58:10 11/10/03  [notice] Module - controlpanel : Core::getConfigFile() - 
File not found. [file = config/users                                   
/controlpanel.php]
13:58:10 11/10/03  [notice] Module - controlpanel : Core::getConfigFile() - 
File not found. [file = config/layout                                  
/controlpanel.php]
13:58:10 11/10/03  [notice] Module - controlpanel : Core::getConfigFile() - 
File not found. [file = config/users                                   
/controlpanel.php] 

Those spaces in there between the directory names is how it reads in the 
logfile... not sure if that is just a display bug or there are really spaces 
in the path. 

As an FYI, table prefix naming isn't on right now, but I'm sure that's 
something to be added later (and not something I'm complaining about :) 


Brian