EzPublish / Flow 4.3 on MS SQL

Author Message

Rafael Ximenes

Monday 20 September 2010 4:52:06 am

Hello guys!

I'm learning ezPublish for some projects. I'm trying without positive results to connect the ezPublish/Flow on my MS (Microsoft) SQL Server 2005.

I'm trying to install this extension with this MS Driver for php. When I turn on the mssql extension in my portal, it fails and I need to run autoloads again . My test environment is apache 2.2 + php 5.3 + ezPublish 4.3 + Windows Xp as Server.

I'd like to know if someone has a tutorial/article/something showing how to configure the ezPublish in this environment, if it is possible... some step-by-step, please! Has someone?

Edit: I'm already did some searches on community forum, but the most recent is a 2005 topic

André R.

Monday 20 September 2010 9:47:29 am

We don't provide a driver for it. There are some commercial eZ Publish ms sql driver alternatives, but you should ask the creator / company behind it for support on those.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Rafael Ximenes

Monday 20 September 2010 10:04:22 am

Ok. I've noticed that the ez don't provide a driver... but anyone try out to install this environment?

I'm just want some help/hint to do this.

André R.

Tuesday 21 September 2010 1:11:55 am

Relevant project on projects.ez.no:

http://projects.ez.no/mssql

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Rafael Ximenes

Tuesday 21 September 2010 10:29:34 am

"

Hello guys!

I'm learning ezPublish for some projects. I'm trying without positive results to connect the ezPublish/Flow on my MS (Microsoft) SQL Server 2005.

I'm trying to install this extension with this MS Driver for php. When I turn on the mssql extension in my portal, it fails and I need to run autoloads again . My test environment is apache 2.2 + php 5.3 + ezPublish 4.3 + Windows Xp as Server.

I'd like to know if someone has a tutorial/article/something showing how to configure the ezPublish in this environment, if it is possible... some step-by-step, please! Has someone?

Edit: I'm already did some searches on community forum, but the most recent is a 2005 topic

"

Hi, Guys!

Sorry! Just with the André's reply I noticed that links haven't appeared..

So.. when I told "this extension" I was referring exactly to http://projects.ez.no/mssql and when I told "this MS Driver for php" I was referring to http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=ccdf728b-1ea0-48a8-a84a-5052214caad9

So... What's my Drama?

The MSSQL referred extension is apparently using the old driver php_mssql.dll, so I can't do it works fine...

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 18 2025 03:03:58
Script start
Timing: Jan 18 2025 03:03:58
Module start 'layout'
Timing: Jan 18 2025 03:03:58
Module start 'content'
Timing: Jan 18 2025 03:03:59
Module end 'content'
Timing: Jan 18 2025 03:03:59
Script end

Main resources:

Total runtime0.8147 sec
Peak memory usage4,096.0000 KB
Database Queries65

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0046 588.0313152.6406
Module start 'layout' 0.00460.0027 740.671939.4766
Module start 'content' 0.00730.8058 780.1484562.4375
Module end 'content' 0.81310.0015 1,342.585916.1484
Script end 0.8147  1,358.7344 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.3971160.0002
Check MTime0.00130.1617160.0001
Mysql Total
Database connection0.00070.089110.0007
Mysqli_queries0.740290.8501650.0114
Looping result0.00060.0764630.0000
Template Total0.767894.220.3839
Template load0.00220.265420.0011
Template processing0.765693.971320.3828
Template load and register function0.00010.015110.0001
states
state_id_array0.00110.140810.0011
state_identifier_array0.00180.217920.0009
Override
Cache load0.00190.2319330.0001
Sytem overhead
Fetch class attribute can translate value0.00060.070920.0003
Fetch class attribute name0.00150.189760.0003
XML
Image XML parsing0.00070.082020.0003
class_abstraction
Instantiating content class attribute0.00000.002270.0000
General
dbfile0.00390.4776170.0002
String conversion0.00000.000940.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
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
2content/datatype/view/ezxmltags/link.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/link.tplEdit templateOverride template
1content/datatype/view/ezxmltags/quote.tpldatatype/ezxmltext/quote.tplextension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 20
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs