bugs
As with all software, ZenMagick has got it’s flaws.
One thing I just noticed is that the SQL install feature does not work in 0.6.3! That means installing requires to run the SQL script found in zenmagic/etq/sql using the zen-cart SQL patch tool. This can be found in the admin area under Tools.
Por people having trouble finding all this relevant suff, I am in the process of setting up a Known Bugs or similar page, so bear with me…
Hiya - love the look of zen magick and think you’re on to a very good idea here! Unfortunately I couldn’t get it to install - reckon it might be my version of mySQl - couldn’t find any references to which versions of mySQL etc that you run on currently. I completed the install from inside zen admin fine and ran the sql to create the features tables successfully on my database - but then when I went to my cart home page - nothing! I have products in my database .. and when I tried to run zen magick / category maintenance I kept getting an sql error when I tried to drill down on a category that held products. I’m running mySQL 5.0.27 and here’s the statement that broke … with the error ‘unknown p.products in on clause’ … anyways I’ll check back for updates .. but in the meantime had to uninstall … hopefully it’s a simple thing cos I’d love to get this working!
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_tax_class_id, pd.products_description, IF(s.status = ‘1′, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =’1′, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from
products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c
left join specials s on p.products_id = s.products_id where p.products_status = ‘1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = 1 and p2c.categories_id = 2 order by p.products_sort_order, pd.products_name
Comment by welshcathy — March 2, 2007 @ 12:59 pm
Hmm,
Currently running PHP 5.1.2 with MySQL 5.0.24 without any problems - could you please send me the complete error message, perhaps as email? I’ll have a look….
Also, are you sure that you installed the SQL correctly? There is a bug in the installation screen where it claims to have installed the SQL but hasn’t.
If in doubt, you can run the sql also using the zen-cart SQL patch menu item under tools. The sql is under zenmagick/etc/sq
mano
Comment by DerManoMann — March 5, 2007 @ 12:52 am
Right, got it, I think.
There is definitely something broken in 5.0.27. I have a fix, but it will perhaps take another week before the next official release. So if anyone needs the fix before that, drop me a line…
Also, the SQL to create the features tables is broken in the current MySQL version. This will also be fixed. You can fix it yourself by removing the default value for feature_value in line #70)
Comment by DerManoMann — March 5, 2007 @ 9:31 am