Installation error: Administrator content object does not have 'first_name' and 'last_name' fields

Author Message

Greg Rundlett

Sunday 13 February 2005 4:59:02 pm

The setup wizard was not able to complete the creation of your selected sites.

The following errors were detected:

* EZSW-023Administrator content object does not have a 'first_name' field
* EZSW-024Administrator content object does not have a 'last_name' field
* EZSW-040Failed to initialize site package shop

I have been trying all day to install EZPublish 3.5.0 on a 1and1.com dedicated Linux server (Fedora Core 2). I managed to set open_basedir to none using the Apache conf file, and also used mysql to make sure that the db user has all privileges on the db in case the script uses some alter table command or something. I'm thinking of putting it into debug mode now (gotta find out how) so that I can see what might be going wrong. I have tried to setup a plain install, as well as a shop with the same results. I have sufficient versions of Apache, MySQL and PHP.

It looks to me like there is an error in some SQL somewhere, trying to insert the pre-populated 'first_name' and 'last_name' values that are in the form/wizard. It doesn't matter whether I change the values, or blank them out, the install still refuses to finish.

I have tried the manual setup, but without luck there either since the documentation on a manual installation is actually lacking some concrete examples on what at a minimum should be put into the site.ini.append.php file (actually the docs say to edit site.ini which is incorrect)

Any help would be appreciated.

Thanks,

nothing to sig here, move along

Greg Rundlett

Sunday 13 February 2005 7:05:52 pm

After turning on the debugging output by creating a site.ini.append.php file in the settings/override directory, I get the following error message:

Error: eZMySQLDB Feb 13 2005 21:48:46

Query error: Got error 28 from table handler. Query: SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.name as class_attributename
FROM ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '56' AND
ezcontentobject_attribute.language_code = 'eng-GB'
ORDER by
ezcontentclass_attribute.placement ASC

<b>and this notice</b>

Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Feb 13 2005 21:48:46

SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.name as class_attributename
FROM ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '56' AND
ezcontentobject_attribute.language_code = 'eng-GB'
ORDER by
ezcontentclass_attribute.placement ASC

<b>Which then leads to this warning:</b>

Warning: PHP Feb 13 2005 21:48:46

Invalid argument supplied for foreach() in /home/httpd/vhosts/harbor-lights.com/httpdocs/ezpublish/kernel/classes/ezcontentobjectversion.php on line 812

nothing to sig here, move along

Greg Rundlett

Monday 14 February 2005 10:55:45 am

With help from agentbob on IRC, I solved my problem. It turns out that error 28 means that the disk is out of space. There is plenty of disk space in my server account, however a little investigation shows that the MySQL temporary directory

mysql> show variables like "tmpdir";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| tmpdir        | /tmp/ |
+---------------+-------+
1 row in set (0.00 sec)

checking the disk partitions

[root@u15178040 ezpublish]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/hda1             510M  510M     0 100% /
none                  122M     0  122M   0% /dev/shm
/dev/hda7              27G  196M   26G   1% /home
/dev/hda5             4.9G  1.3G  3.7G  26% /usr
/dev/hda6             4.9G  302M  4.6G   7% /var

showed that the root partition was indeed full. /tmp doesn't show it's own partition above, so therefore it is part of '/'. I deleted some junk in /tmp, and reloaded my MySQL database using a prior data dump from a known good installation on my local development box.

mysql -u ez_admin ez_db -pSomePassword <MyDefaultData.sql

I wish I had though on my own to search for the error code on mysql.com. I just figured it was an internal ezPublish error code, but now it is obvious to me that the smart folks at ezPublish would trap and report any native error codes.

Thanks again agentbob!

nothing to sig here, move along

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 19 2025 04:25:32
Script start
Timing: Jan 19 2025 04:25:32
Module start 'layout'
Timing: Jan 19 2025 04:25:32
Module start 'content'
Timing: Jan 19 2025 04:25:33
Module end 'content'
Timing: Jan 19 2025 04:25:33
Script end

Main resources:

Total runtime1.1036 sec
Peak memory usage4,096.0000 KB
Database Queries55

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0060 591.0234152.7188
Module start 'layout' 0.00600.0040 743.742239.5859
Module start 'content' 0.01001.0921 783.3281522.2734
Module end 'content' 1.10210.0014 1,305.601616.0156
Script end 1.1035  1,321.6172 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.3071160.0002
Check MTime0.00140.1277160.0001
Mysql Total
Database connection0.00070.061510.0007
Mysqli_queries1.035293.8057550.0188
Looping result0.00060.0576530.0000
Template Total1.064596.520.5322
Template load0.00210.188020.0010
Template processing1.062496.267420.5312
Template load and register function0.00010.012410.0001
states
state_id_array0.00130.120510.0013
state_identifier_array0.00150.137120.0008
Override
Cache load0.00180.1635550.0000
Sytem overhead
Fetch class attribute can translate value0.00100.095110.0010
Fetch class attribute name0.00110.100540.0003
XML
Image XML parsing0.00200.179610.0020
class_abstraction
Instantiating content class attribute0.00000.001460.0000
General
dbfile0.00280.2556160.0002
String conversion0.00000.001040.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
3content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 23
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs