Re: [phpesp-general] Weird refusal to install

[Peter F. <pf...@uc...>]

Franky Van Liedekerke wrote:
> On Wed, 07 Jan 2009 10:23:50 +0000
> Peter Flynn <pf...@uc...> wrote:
> 
>> I'm trying to install phpESP 2.1.2 under RHEL5 with the default
>> Apache 2.2.3 and PHP 5.1.6. I have had an older version of phpESP
>> (1.8) running very successfully elsewhere under Fedora Core 4 for
>> years, so I'll eventually want to import all the old data; but the
>> problem right now is more baffling: installing the database, which
>> went perfectly on the old machine. Procedure was:
>>
>>   1. detar the installation into the web server document root
>>   2. check httpd.conf for .php (added AddType; SetOutputFilter not
>> used) 3. set the ownership of the whole phpESP directory tree to
>> apache 4. edit a phpESP.ini.php to set db_pass, date_format, and
>> emails 5. edit mysql_create.sql password to match the db_pass in [4]
>>   6. execute  mysql -u root -p < mysql_create.sql to set up database
>>   7. log in with Firefox and change phpESP's root password
>>   8. try to install, and I get
>>
>> Installing
>> [ Install FAILED ]
>> [ Initial data entering failed ]
>> [ Version delete FAILED ]
>> [ Version update FAILED ]
>>
>> I've obviously missed something, but what?
> 
> Heh ... seems I missed something in the INSTALL file. Just omit step 5
> and 6 (just create the db, don't enter any data in it). 

But that's exactly what I did. I just created the empty db using 
mysql_create.sql (steps 5 and 6). If you omit this, you can't even start.

You seem to be referring to mysql_populate.sql, which should not be run 
by hand, as it should get done through the web install interface.

The problem is that it's not even getting this far: it's gagging on 
whatever it tries to do with schema.xml

> The web based install will do the rest. 

But it doesn't. It gives me the error above.

> If drop/create tables is not permitted, just
> copy/paste the created sql statements from the web based install in a
> sql file and use that one.

But the web based install tries to do all kinds of stuff with schema.xml 
and that's what's failing.

///Peter