Hi,

and thanks to Damien for this useful extension.

Unfortunately, I can't have it working on a fresh eZ publish 4.0.

Here's what happens :

1 - Installing requirements :
* ffmpeg and ffmpeg-php module seem to work, as I get a complete list of " Methods available in class 'ffmpeg_movie' " after running test_ffmpeg.php
* I obviously have installed the eZ components framework
* I use the ezwebin extension
* also note that I am running on an Easyphp Wamp environment, which might be a lead for explanations..?

2 and 3 - Unzip the archive and place it to the extension directory
=> this should not cause any problem

4 - Execute ezvideoflv.sql script
I found it more convenient to run the sql script directly from PhpMyAdmin.
The table seemed to create well, but it was in "MyISAM" whereas all my tables are in "InnoDB". So I altered this table : no better. So I droped it and ran the following sql script :

CREATE TABLE ezvideoflv (


 contentobject_attribute_id int(11) NOT NULL default '0',


 filename varchar(255) NOT NULL default '',


 flv varchar(255) NOT NULL default '',


 height int(11) default NULL,


 mime_type varchar(50) NOT NULL default '',


 original_filename varchar(255) NOT NULL default '',


 version int(11) NOT NULL default '0',


 width int(11) default NULL,


 PRIMARY KEY (contentobject_attribute_id,version)


)TYPE = InnoDB;

But it didn't help because I still get those errors :
a\ When I try to activate the extension from the admin interface, I get a "Fatal error: eZ Publish did not finish its request".

b\ When I try to regenerate the autoload arrays for extensions, I also get a "Fatal error: eZ Publish did not finish its request", whose interesting part of debug is :
################################################################
Notice: eZMySQLDB::query(2 rows, 1.248 ms) query number per page:2 Aug 29 2008 15:31:47

SELECT id, name, locale, disabled
FROM ezcontent_language
ORDER BY name ASC

Notice: eZMySQLDB::query(0 rows, 1.805 ms) query number per page:3 Aug 29 2008 15:31:47

SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.action AS e1_action, e1.is_alias AS e1_is_alias
FROM ezurlalias_ml e0, ezurlalias_ml e1
WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 = MD5( 'setup' )
AND e1.parent = e0.link AND (e1.lang_mask & 7 > 0) AND e1.text_md5 = MD5( 'extensions' )
LIMIT 0, 1

Notice: eZMySQLDB::query(0 rows, 2.315 ms) query number per page:4 Aug 29 2008 15:31:47

SELECT id, source_url, destination_url, type
FROM ezurlwildcard
LIMIT 0, 100

Strict: PHP Aug 29 2008 15:31:47

strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in C:\sites\metajob_proto_1\ez\lib\ezfile\classes\ezlog.php on line 127

Strict: PHP Aug 29 2008 15:31:47

strftime() [<a href='function.strftime'>function.strftime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in C:\sites\metajob_proto_1\ez\lib\ezfile\classes\ezlog.php on line 127

Timing: Aug 29 2008 15:31:47

Module start 'setup'

Notice: eZMySQLDB::query(1 rows, 1.692 ms) query number per page:5 Aug 29 2008 15:31:47

SELECT DISTINCT ezrole.id,
ezrole.name,
ezuser_role.limit_identifier,
ezuser_role.limit_value,
ezuser_role.id as user_role_id
FROM ezrole,
ezuser_role
WHERE ezuser_role.contentobject_id IN ( 12,4,14 ) AND
ezuser_role.role_id = ezrole.id

Notice: eZMySQLDB::query(1 rows, 0.676 ms) query number per page:6 Aug 29 2008 15:31:47

SELECT id, role_id, module_name, function_name
FROM ezpolicy
WHERE role_id='2'
ORDER BY id ASC

Notice: eZMySQLDB::query(0 rows, 0.933 ms) query number per page:7 Aug 29 2008 15:31:47

SELECT id, policy_id, identifier
FROM ezpolicy_limitation
WHERE policy_id='308'
ORDER BY id ASC
################################################################

c\ When I try to create a content from the FLV class I created with an Video FLV attribute, I get a "Fatal error: eZ Publish did not finish its request" whose debug output is below :
#########################################################"
Timing: Aug 29 2008 15:11:37

Script start

Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Aug 29 2008 15:11:37

SET NAMES 'utf8'

Notice: eZMySQLDB::query(1 rows, 2.371 ms) query number per page:1 Aug 29 2008 15:11:37

SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='7uf27lpljegnch174r31poi8c5'

Notice: eZMySQLDB::query(2 rows, 0.727 ms) query number per page:2 Aug 29 2008 15:11:37

SELECT id, name, locale, disabled
FROM ezcontent_language
ORDER BY name ASC

Notice: eZMySQLDB::query(0 rows, 0.865 ms) query number per page:3 Aug 29 2008 15:11:37

SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.action AS e1_action, e1.is_alias AS e1_is_alias
FROM ezurlalias_ml e0, ezurlalias_ml e1
WHERE e0.parent = 0 AND (e0.lang_mask & 7 > 0) AND e0.text_md5 = MD5( 'content' )
AND e1.parent = e0.link AND (e1.lang_mask & 7 > 0) AND e1.text_md5 = MD5( 'action' )
LIMIT 0, 1

Timing: Aug 29 2008 15:11:37

Module start 'content'

Notice: eZMySQLDB::query(1 rows, 1.183 ms) query number per page:4 Aug 29 2008 15:11:37

SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id IN ( 2 ) AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 7 > 0

and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 1 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 1 )
)

Notice: eZMySQLDB::query(1 rows, 0.738 ms) query number per page:5 Aug 29 2008 15:11:37

SELECT id, version, serialized_name_list, identifier, contentobject_name, url_alias_name, creator_id,
modifier_id, created, remote_id, modified, is_container, always_available, language_mask,
initial_language_id, sort_field, sort_order
FROM ezcontentclass
WHERE id='44' AND version='0'
ORDER BY version ASC
LIMIT 0, 2

Notice: eZMySQLDB::query(0 rows, 0.394 ms) query number per page:6 Aug 29 2008 15:11:37

BEGIN WORK

Notice: eZMySQLDB::query(4 rows, 1.100 ms) query number per page:7 Aug 29 2008 15:11:37

SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE contentclass_id='44' AND version='0'
ORDER BY placement ASC

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/contentclass): 'New %1' with comment()

Notice: eZMySQLDB::query(1 rows, 0.641 ms) query number per page:8 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject (section_id, owner_id, contentclass_id, name, is_published, published, modified, current_version, status, remote_id, language_mask, initial_language_id) VALUES(1, 14, 44, 'New ', 0, 0, 0, 1, 0, '7d637437d8fe80333137b8b6c88d0ea6', 2, 2)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/contentclass): 'New %1' with comment()

Notice: eZMySQLDB::query(1 rows, 0.708 ms) query number per page:9 Aug 29 2008 15:11:37

SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '62'
AND content_version = '1' AND content_translation ='fre-FR'

Notice: eZMySQLDB::query(1 rows, 0.598 ms) query number per page:10 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject_name( contentobject_id,
name,
content_version,
content_translation,
real_translation,
language_id )
VALUES( '62',
'New ',
'1',
'fre-FR',
'fre-FR',
'2' )

Notice: eZMySQLDB::query(1 rows, 0.605 ms) query number per page:11 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject_version (contentobject_id, creator_id, version, status, created, modified, workflow_event_pos, user_id, language_mask, initial_language_id) VALUES(62, 14, 1, 5, 1220015496, 1220015496, 0, 0, 2, 2)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'Text line' with comment(Datatype name)

Notice: eZMySQLDB::query(1 rows, 0.797 ms) query number per page:12 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(62, 1, 'fre-FR', 2, 353, 0, 0, '', 'ezstring', '', NULL, 0.000000)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'XML block' with comment(Datatype name)

Notice: eZMySQLDB::query(1 rows, 0.741 ms) query number per page:13 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(62, 1, 'fre-FR', 2, 354, 0, 0, '', 'ezxmltext', '<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<section xmlns:image=\"http://ez.no/namespaces/ezpublish3/image/\" xmlns:xhtml=\"http://ez.no/namespaces/ezpublish3/xhtml/\" xmlns:custom=\"http://ez.no/namespaces/ezpublish3/custom/\"/>\n', 1045487555, 0.000000)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'Keywords' with comment(Datatype name)

Notice: eZMySQLDB::query(1 rows, 0.813 ms) query number per page:14 Aug 29 2008 15:11:37

SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='62' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0

Notice: eZMySQLDB::query(0 rows, 19.469 ms) query number per page:15 Aug 29 2008 15:11:37

SELECT * FROM ezkeyword WHERE keyword IN ( '' ) AND class_id='44'

Notice: eZMySQLDB::query(0 rows, 1.459 ms) query number per page:16 Aug 29 2008 15:11:37

SELECT ezkeyword.id FROM ezkeyword LEFT JOIN ezkeyword_attribute_link ON ezkeyword.id=ezkeyword_attribute_link.keyword_id WHERE ezkeyword_attribute_link.keyword_id IS NULL

Notice: eZMySQLDB::query(1 rows, 0.680 ms) query number per page:17 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(62, 1, 'fre-FR', 2, 356, 0, 0, '', 'ezkeyword', '', NULL, 0.000000)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'Video FLV' with comment(Datatype name)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'Video FLV' with comment(Datatype name)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'Video FLV' with comment(Datatype name)

Notice: eZMySQLDB::query(1 rows, 0.646 ms) query number per page:18 Aug 29 2008 15:11:37

INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(62, 1, 'fre-FR', 2, 357, 0, 0, '', 'ezvideoflv', '', NULL, 0.000000)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(kernel/classes/datatypes): 'Video FLV' with comment(Datatype name)

Warning: ezi18n Aug 29 2008 15:11:37

No translation for file(translation.ts) in context(lib/template): 'The maximum nesting level of 40 has been reached. The execution is stopped to avoid infinite recursion.' with comment()
###################################################################

=> I have the impression that the ezvideoflv table is not reached, and that it causes the fatal error..?
If this is right, should I modifiy the sql script that created this table? (maybe a matter of PRIMARY KEY INDEX..?)

5\ Activate the extension
=> as explained above, the extension won't install (=> probably because of a my sql problem)

6\ Cronjob setting
=> I passed this step as it is not necessary for testing on small files...

7\ Policies
=> Unnecessary for a fully granted administrator...

8\Apache Virtual Host rewrite rule
I added this to the Virtual Host part in httpd.conf file in Easyphp

 RewriteEngine On


 RewriteRule content/treemenu/?$ /index_treemenu.php [L]


 Rewriterule ^/var/storage/.* - [L]


 Rewriterule ^/var/[^/]+/storage/.* - [L]


 RewriteRule ^/var/cache/texttoimage/.* - [L]


 RewriteRule ^/var/[^/]+/cache/texttoimage/.* - [L]


 Rewriterule ^/design/[^/]+/(stylesheets|images|javascript)/.* - [L]


 Rewriterule ^/share/icons/.* - [L]


 Rewriterule ^/extension/[^/]+/design/[^/]+/(stylesheets|images|javascripts?)/.* - [L]


 Rewriterule ^/packages/styles/.+/(stylesheets|images|javascript)/[^/]+/.* - [L]


 RewriteRule ^/packages/styles/.+/thumbnail/.* - [L]


 RewriteRule ^/favicon.ico - [L]


 RewriteRule ^/robots.txt - [L]


 RewriteRule .* /index.php


Rewriterule ^/extension/ezvideoflv/design/standard/flash/player_flv_maxi.swf - [L]

Would anybody have ideas or solution to my installation problem ?

Thanks a lot in advance,

Mickael.