View Issue Details

IDProjectCategoryView StatusLast Update
0002136OXID eShop (all versions)4.07. Source code, Testpublic2012-12-10 13:45
Reportermindaugas 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.4.2 revision 29492 
Target VersionFixed in Version4.4.4 revision 30554 
Summary0002136: oxzoom field SQL errors
DescriptionWe are loging a lot of SQL errors, reporting about not found field in DB (oxzoom).
Where is some performance decrease.
Steps To ReproduceNavigate to details page.
Additional Information--------------DEBUG TRACE----------------------
Array
(
    [0] => Array
        (
            [file] => core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc
            [line] => 369
            [function] => nfq_log_db_errors
        )

    [1] => Array
        (
            [file] => core/adodblite/adodb.inc.php
            [line] => 316
            [function] => do_query
            [class] => mysql_driver_ADOConnection
            [type] => ->
        )

    [2] => Array
        (
            [file] => core/oxbase.php
            [line] => 268
            [function] => Execute
            [class] => ADOConnection
            [type] => ->
        )

    [3] => Array
        (
            [file] => core/oxarticle.php
            [line] => 543
            [function] => __get
            [class] => oxBase
            [type] => ->
        )

    [4] => Array
        (
            [file] => modules/nfq/nfq_oxarticle.php
            [line] => 25
            [function] => __get
            [class] => oxArticle
            [type] => ->
        )

    [5] => Array
        (
            [file] => core/oxarticle.php
            [line] => 3881
            [function] => __get
            [class] => nfq_OxArticle
            [type] => ->
        )

    [6] => Array
        (
            [file] => core/oxarticle.php
            [line] => 3097
            [function] => _isFieldEmpty
            [class] => oxArticle
            [type] => ->
        )

    [7] => Array
        (
            [file] => core/oxarticle.php
            [line] => 2179
            [function] => getZoomPictureUrl
            [class] => oxArticle
            [type] => ->
        )

    [8] => Array
        (
            [file] => views/details.php
            [line] => 1057
            [function] => getPictureGallery
            [class] => oxArticle
            [type] => ->
        )

    [9] => Array
        (
            [file] => views/details.php
            [line] => 1069
            [function] => getPictureGallery
            [class] => Details
            [type] => ->
        )

    [10] => Array
        (
            [file] => views/details.php
            [line] => 435
            [function] => getActPictureId
            [class] => Details
            [type] => ->
        )

    [11] => Array
        (
            [file] => modules/nfq/nfq_details.php
            [line] => 95
            [function] => render
            [class] => Details
            [type] => ->
        )

    [12] => Array
        (
            [file] => views/oxshopcontrol.php
            [line] => 344
            [function] => render
            [class] => nfq_details
            [type] => ->
        )

    [13] => Array
        (
            [file] => views/oxshopcontrol.php
            [line] => 91
            [function] => _process
            [class] => oxShopControl
            [type] => ->
        )

    [14] => Array
        (
            [file] => index.php
            [line] => 94
            [function] => start
            [class] => oxShopControl
            [type] => ->
        )

    [15] => Array
        (
            [file] => oxseo.php
            [line] => 33
            [function] => require
        )

)
------------------------------------------------
TagsNo tags attached.
Theme
BrowserAll
PHP Versionany
Database Versionany

Activities

dainius.bigelis

2010-09-29 17:25

reporter   ~0003556

Reminder sent to: mindaugas

Hi,

Are you sure that this still happens when cache and temps is cleared after some changes?
Do you noticed on what actions these errors occurs in the log?

Best regards,

mindaugas

2010-10-01 10:04

reporter   ~0003564

Yes, i am sure.

The problem is in file oxarticle.php
Function: getZoomPictureUrl()
Function call: if ( $this->_isFieldEmpty( "oxarticles__oxzoom" . $iIndex ) ) ....

I recommend to integrate SQL error logging to OXID AdoDb library.

rimvydas_paskevicius

2010-10-14 13:20

reporter   ~0003599

Added additional checking in oxarticle class if oxzoom field exists in database. Only if it exists, lazy loading will load it from database. For this was newly added method oxarticle::_assignZoomPictureValues() which is called from magic getter.