this will drive me crazy .. shell i have 2 admin site ?!

Tuesday 02 September 2003 12:31:11 am

any help... or idea ... please ... almost finished ,,, I found this in the last test befor publishing the site ... this site is onhold because of this !

Tuesday 02 September 2003 2:50:06 am

I have tried somehow, but din`t work for me, it loading :

design/standard/templates/content/version/view/plain.tpl
design/standard/templates/node/view/plain.tpl

am upset ... :(

Tuesday 02 September 2003 11:35:40 pm

Its look like that no one using approve workflow with multi-bilingual site !

Please help me out of this with idea or solution !

Wednesday 03 September 2003 2:13:31 am

Hi Jan ...

its easy to check the sql debug, but i don`t think any1 can know which query is the needed debug, i got more than 4 page sql debug :(

any way, when i cjange the 'RegionalSettings' to eng-GB I got the data, but I got black listing with any another language, and from the dubeg i get just this query with 0 rows :

---------------
Notice: eZMySQLDB::query(0 rows, 2.571 ms) query number per page:1 Mar 04 2004 12:03:47
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE md5_path = '22016f8fa5b336a09c3b20c0d2a02262' AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'hu'
----------------------------

Notice: eZMySQLDB::query(0 rows, 3.489 ms) query number per page:6 Mar 04 2004 12:03:47
SELECT id, collaboration_id, message_id, message_type, participant_id, created, modified
FROM ezcollab_item_message_link
WHERE collaboration_id='1'
-----------------------------------

Notice: eZMySQLDB::query(0 rows, 2.992 ms) query number per page:12 Mar 04 2004 12:03:47
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=127 AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
--------------------------------------

Notice: eZMySQLDB::query(0 rows, 23.086 ms) query number per page:13 Mar 04 2004 12:03:47
SELECT ezcontentobject_attribute.* 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 = '127' AND
ezcontentobject_attribute.language_code = 'hu'
ORDER by
ezcontentclass_attribute.placement ASC

------------------------------

SELECT
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
WHERE
ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='127' AND
ezcontentobject_link.from_contentobject_version='1'
and ezcontentobject.id = ezcontentobject_name.contentobject_id and
ezcontentobject.current_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'hu' ;;

###------------ why here is 2 ';;' above ------------ ##

is this bug or I have some mistake here with the template, or with the data insertion ?

thx alot !!

Wednesday 03 September 2003 5:02:01 am

Jan , don`t you think the 'language_code' should be removed from the query for the approve workflow ?

Thursday 04 September 2003 12:35:26 am

Selmah,

I can't help you with the problem, I wish i could, it sounds like your really stuck. When i have been in this situation when I could not get support on the forums. I used my support contract with eZ to get the problem answered. We have used it to solve several problems. If this project is critical then give it a whirl.

I hope it gets you to be able to solve the current problem.

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Thursday 04 September 2003 1:49:30 am

Selmah,

You can buy support by the hour if need be... it not pricey. Don't wait get it know and solve your problem, its cheaper than you banging your head on the wall.

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Thursday 04 September 2003 7:44:51 am

This is another use of support, getting ez to finish what they started.

When we started with our e-commerce site we used our support to find out how to write workflow code to link with our commerce engine. This should have been in ez3 from the start but for some reason it is not.

Paul

Friday 05 September 2003 2:49:05 am

OK ... i`ll pay for support .. but 1st just let me know if this my mistake or its missing code from the ezp ?!

2nd where to pay, Ihad read read 1 hour 129$ ... how they will count this hour(s) ... should i pay now or after, what if they said this a week job ?!

Saturday 06 September 2003 2:15:43 am

If you pay for support then specify that you want to them to spend X hours on that problem. Be very specific on that. Also, chat to them before they start work on it how long they think it will take. You may have your own estimate.

Paul