hi!
i just updated from 4.2.0._23610 to 4.4.8_34028 using the package
UPDATE_OXID_ESHOP_EE_V.4.2.0_23610_TO_V.4.4.8_34028
and following the instructions at
http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/update-one-release-<http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/update-one-release-another>
another<http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/update-one-release-another>
.
After successful installation i noticed mysql exceptions like this:
Exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column
'oxv_oxarticles_1.oxmpn' in 'field list'] in EXECUTE("select
oxv_oxarticles_1.oxid, oxv_oxarticles_ [...] where 1 and
oxv_oxarticles_1.oxparentid = '' LIMIT 0, 10")
As mentioned in the exception, the field (and several others) "oxmpn" from
view "oxv_oxarticles_1" was missing. Trying to add these fields i ended up
with the following modifiation of the view "oxv_oxarticles_1" to solve my
problems:
CREATE ALGORITHM=UNDEFINED DEFINER=`shop_qa`@`localhost` SQL SECURITY
DEFINER VIEW `oxv_oxarticles_1` AS
SELECT
*
FROM `oxarticles`
WHERE (((`oxarticles`.`OXSHOPINCL` & 1) > 0)
AND ((`oxarticles`.`OXSHOPEXCL` & 1) = 0))
i would like to know if my modification is right and if there might be some
other statements missing in the update-package mentioned above...
thx in advance
norman
_______________________________________________
dev-general mailing list
[email protected]
http://dir.gmane.org/gmane.comp.php.oxid.general
