Hi, > Maybe this function is moved to another place in the newest oxid-version
Right. "Update views" can be found in admin -> services -> tools now. Regards Marco From: [email protected] [[email protected]] on behalf of Online-Technik - Bergfreunde.de [[email protected]] Sent: Wednesday, June 15, 2011 1:58 PM To: [email protected] Subject: Re: [oxid-dev-general] Upgrade from 4.2.0 to 4.4.8: missing mysql-statements !? Hi Norman, don’t add these columns manually. The mentioned table is just a view and the columns will be added automatically. You just have to update the views in your shopadmin to get these columns added to your view-table. Stammdaten -> Grundeinstellungen -> Mall -> Update Views Maybe this function is moved to another place in the newest oxid-version, then you have to check the manual. Hope this answer helps you. Best regards, Benni Bergfreunde GmbH Benni Zindel Online-Technik Bahnhofstraße 26 72138 Kirchentellinsfurt Telefon: +49 (0)7121 30459-26 Fax: +49 (0)7121 30459-27 Email: [email protected] Web: www.bergfreunde.de Sitz der Gesellschaft: Kirchentellinsfurt Amtsgericht Stuttgart, HRB: 382746 Geschäftsführer: Martin Theben, Ronny Höhn Von: [email protected] [mailto:[email protected]] Im Auftrag von [email protected] Gesendet: Mittwoch, 15. Juni 2011 12:06 An: [email protected] Betreff: [oxid-dev-general] Upgrade from 4.2.0 to 4.4.8: missing mysql-statements !? 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-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
<<attachment: image001.gif>>
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
