Hi Norman,
dont 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 bf-logo-email-signatur 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 <http://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-re lease-another> http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/update-one-rel ease- <http://www.oxid-esales.com/en/resources/help-faq/eshop-manual/update-one-re lease-another> 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
<<image001.gif>>
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
