Resolved Updating available fields gives error

Hello,

Can you post a screenshot of the actual error?

Just to double check, if you go to Tasks do you see the import/export routines there for VirtueMart?

Roland,

Tasks gives me all sort of Virtuemart import and export functions.

Some from the error log when trying to update the fields:

[:error] [pid 29489] [client IP:60021] PHP Notice: Undefined property: FOFTable::$csvi_log_id in /public_html/libraries/fof/table/table.php on line 1261, referer: https://www.website.nl/administrator/index.php?option=com_csvi&view=maintenance&task=read&component=com_csvi&operation=updateavailablefields
[:error] [pid 29489] [client IP:60021] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 130968 bytes) in /public_html/libraries/fof/table/table.php on line 536, referer: https://www.site.nl/administrator/index.php?option=com_csvi&view=maintenance&task=read&component=com_csvi&operation=updateavailablefields

also when going to settings I get:
Missing field in table #__csvi_settings : csvi_setting_id.

Hello,

So the available fields update stops because you run out of memory at 134MB. Wow, I don't even get a problem with a memory limit set at 32MB.

Nor do I see any of the undefined notices, this may be related to the out of memory error.

Let's take a look at the settings error first. It looks like something is wrong with your tables. If you look in the database at the csvi_settings table, which fields do you see there? Looking at the installation SQL file, the table definition is correct. Let me know what you find.

Roland,

Printscreen of the table is attached

Hello,

That is the old table of 5.20 and not the new one. It seems that not all csvi_ tables were removed before. What you can do is, remove all the tables that start with xxx_csvi_, where xxx is your table prefix. Uninstall CSVI 6 from the site and after that install CSVI 6 again. You should have the correct tables now.

Roland,

That solved it.

so the uninstall of old csvi isn´t working right I guess?

Hello,

Uninstallation of CSVI doesn't remove the database tables because you will lose your settings. The tables can be removed from the maintenance menu if you like or using PhpMyAdmin. The same applies to CSVI 6.

Is the cronjob still the same rule as it was in CSVI 5?

That is still the same but I did just find an issue using cron on Joomla 3. So in case you are using Joomla 3, please use this patch which can be applied via the maintenance menu.

This site is still running J2.5 at the moment. so I'll try it thanks.

when it is stable will there be an option to convert the old templates? have som with a lot of rules in it on soms sites.

I haven't fully looked into it but I hope to provide some kind of migration tool to make the transition easier.

You know how to contact me if you need some testing.

Have a nice evening tonight and a good 2015

Rick

Thanks Rick,

Happy partying and a prosperous 2015 to you as well

Roland,

found a difference for the cronjobs,

in CSVI 5 the path is dministrator/components/com_csvi/helpers/cron.php
in CSVI 6 it is dministrator/components/com_csvi/helper/cron.php