Forums / Install & configuration / EzPublish / Flow 4.3 on MS SQL

EzPublish / Flow 4.3 on MS SQL

« 
Previous topic
|
Install & configuration
|
Next topic
 »
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...

eZ debug

Timing: Jan 17 2025 23:45:11
Script start
Timing: Jan 17 2025 23:45:11
Module start 'content'
Timing: Jan 17 2025 23:45:11
Module end 'content'
Timing: Jan 17 2025 23:45:11
Script end

Main resources:

Total runtime0.6938 sec
Peak memory usage4,096.0000 KB
Database Queries202

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0065 587.8281180.8281
Module start 'content' 0.00650.5642 768.6563567.5313
Module end 'content' 0.57070.1230 1,336.1875337.3828
Script end 0.6937  1,673.5703 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.5599210.0002
Check MTime0.00150.2202210.0001
Mysql Total
Database connection0.00080.115910.0008
Mysqli_queries0.625290.11282020.0031
Looping result0.00190.26882000.0000
Template Total0.666696.120.3333
Template load0.00210.298720.0010
Template processing0.664595.775720.3322
Template load and register function0.00010.019610.0001
states
state_id_array0.00140.201510.0014
state_identifier_array0.00200.291920.0010
Override
Cache load0.00180.2565330.0001
Sytem overhead
Fetch class attribute can translate value0.00110.154130.0004
Fetch class attribute name0.00100.143160.0002
XML
Image XML parsing0.00090.127630.0003
class_abstraction
Instantiating content class attribute0.00000.003470.0000
General
dbfile0.00190.2708280.0001
String conversion0.00000.001130.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 20
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs