Forums / Install & configuration / ezpublish-3.9.3 SQL Injection Error

ezpublish-3.9.3 SQL Injection Error

Author Message

XXX XXX

Wednesday 05 September 2007 7:39:11 am

I cant install ezpublish-3.9.3...

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 18000 bytes) in /home/damian/domains/site.com/public_html/site/lib/ezi18n/classes/ezchartransform.php on line 296
Fatal error: eZ publish did not finish its request

The execution of eZ publish was abruptly ended, the debug output is present below.

How to fix it via shell or where I can find all SQL files to install it manually via phpmyadmin.

THX for help,
Damian

J-A Eberhard

Wednesday 05 September 2007 8:03:40 am

Hi,

You just need a bit more memory ...

have a look here http://ez.no/doc/ez_publish/technical_manual/3_9/installation/normal_installation/requirements_for_doing_a_normal_installation#comment12831

Open Source Solution Provider
Open-Net Ltd Switzerland
http://www.open-net.ch

XXX XXX

Wednesday 05 September 2007 10:23:26 am

It isn't because of RAM, my server have 2 GB and when I install script I have about 819616 kB free memory space!

XXX XXX

Wednesday 05 September 2007 10:27:15 am

INFORMATIONS after installing:

Webserver info:
Version - Apache/1.3.37 (Unix) mod_ssl/2.8.28 OpenSSL/0.9.7a PHP/4.4.4 mod_perl/1.29 FrontPage/5.0.2.2510

PHP info:
Version - 4.4.4

OS info
Name - Linux...
CPU Type - Intel(R) Pentium(R) 4 CPU 2.80GHz
CPU Speed - 2793.298 MHz
Memory Size - 2117423104 (1.97 GB)

Database info:
Type - MySQL
Driver - ezmysql


Email info:
Transport - sendmail

Image conversion:
ImageMagick was found and used.
Path - /usr/bin
Executable - convert
ImageGD extension was found and used.

Regional info:
Primary - eng-GB
Additional - pol-PL, eng-GB

Critical tests

directory_permissions - Success
phpversion - Success
database_extensions - Success
image_conversion - Success
open_basedir - Success
safe_mode - Success
memory_limit - Success
execution_time - Success
magic_quotes_runtime - Success
allow_url_fopen - Success
accept_path_info - Success
php_session - Success
file_upload - Success
zlib_extension - Success

Other tests:

php_magicquotes - Failure
mbstring_extension - Success
imagegd_extension - Success
imagemagick_program - Success
database_all_extensions - Failure
php_register_globals - Failure
texttoimage_functions - Failure

What should I do? Installation is done (100%) however my database doesn't have all tables (only 103 tables and some are missing)

André R.

Wednesday 05 September 2007 12:06:15 pm

You don't need more ram, you need to increase php's memory limit.
By the error it seems that it's currently set to 64mb.

From the page J-A is linking to:

PHP memory limit issue

eZ Publish needs at least 64 MB in order to complete the setup wizard. This means that you'll have to increase the default "memory_limit" setting which is located in the "php.ini" configuration file. (Don't forget to restart apache after editing "php.ini".) Normal operation requires about 16 MB. However, it is highly recommended that you keep the 64 MB setting since eZ Publish consumes a lot more memory as soon as you use PDF export feature, reindex the search, etc. Multi-lingual sites that store the content in Unicode (UTF-8) will also require at least 64 MB.

So while installing you need to set it to 96mb, then you can set it back to 64mb after the install if you want to.
This is something being worked on and in the upcomming php 5 port this should improve because of converting to useing php5's xml functions instead of the code we currently have (ezxml).

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

eZ debug

Timing: Jan 31 2025 01:32:58
Script start
Timing: Jan 31 2025 01:32:58
Module start 'content'
Timing: Jan 31 2025 01:32:58
Module end 'content'
Timing: Jan 31 2025 01:32:58
Script end

Main resources:

Total runtime0.3339 sec
Peak memory usage8,192.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0119 588.0547370.2813
Module start 'content' 0.01190.0193 958.33591,005.7031
Module end 'content' 0.03110.3027 1,964.03913,893.9922
Script end 0.3339  5,858.0313 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00571.7072200.0003
Check MTime0.00160.4764200.0001
Mysql Total
Database connection0.00100.300710.0010
Mysqli_queries0.157647.19961410.0011
Looping result0.00170.50881390.0000
Template Total0.302290.510.3022
Template load0.00100.289310.0010
Template processing0.301290.191110.3012
Override
Cache load0.00070.197110.0007
Sytem overhead
Fetch class attribute can translate value0.00200.587010.0020
XML
Image XML parsing0.00030.089510.0003
General
dbfile0.070821.1890200.0035
String conversion0.00000.002430.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs