SQL problem 1.0.6

[Vladok]

Cheerz, I've tried Kiwee 1.0.6, looks very pretty, but I have issues
about DB sql. Something wrong with currencies table, I had to delete
pound and euro, leave dollars alone to get the plugin started. But
still I'm not able to insert new products:
MYSQL ERROR: Unknown column 'active' in 'field list'

in Firebug. I think I'm missing right SQL script, please assist

[Richard Northcott]

Hi, sorry I haven't replied sooner (actually got some paid work thats keeping me busy). I'm hoping to look into your issue (and others) sometime next week.


Richard

[vladok]

thx, man. I'll be waiting when you are free

[bugeye]

I experienced this same issue and was able to get around it by
manually adding an 'active' field (tinyint type) to the kiwee_items
table.

[Vladok]

I appreciate your help, I have to take off not_null option from a
couple of rows(categoryid etc.) in items table. I also had to delete
EUR and GBP entries from currencies table to gde Kiwee work at all.
Now I have when I want to run a test catalogue page

Fatal error: Call to undefined method Kiwee::getPriceCurrency() in D:
\WebSite\Serv\manager\includes\document.parser.class.inc.php(769) :
eval()'d code on line 39

[roybuilt]

Vladok
If you haven't found this out already, here is what I did to fix the
issue.
I found that I needed to change kiwee-install/other/snippets/
snippet.kiwee.tpl.
Change line 39 by changing getPriceCurrency() to just getPrice() and
change line 46 the same way. Then uninstall and reinstall and I also
did the fix suggested by bugeye and fixed kiwee_items
table at the same time. I haven't found any other issues at this time.
Thanks
roybuilt

[Richard Northcott]

Hi

The issue with 'active' is due to the field 'disabled in the table 'items' not being renamed to 'active' - applying this change should allow the process to move forward. Please let me know if you have other problems .


Richard