Resolved Issue after upgrade Joomla 3.5.0 & CSVi 6.5.5

Hello,
Very strange, honestly we are not seeing this issue. Can you try installing CSVI6.5.5 package again and see if it solves the issue?

Hi, Ive installed it again, i got these errors and its still not appearing as a Components menu item:

Warning
JFolder: :delete: Path is not a folder. Path: /components/com_csvi/models
JFolder: :delete: Path is not a folder. Path: /administrator/components/com_csvi/helpers
JFolder: :delete: Path is not a folder. Path: /administrator/components/com_csvi/install
Table '#__csvi_availablefields' already exists SQL=RENAME TABLE `#__csvi_available_fields` TO `#__csvi_availablefields`;

Error
Error installing component

Id very much appreciate your help.
Thanks again!

Hello Jimmy,

You seem to have come from an older CSVI version like CSVI 5 and not followed the Installation or updating of CSVI 6 document.

See if you can uninstall CSVI and then install it. If this fails, you will either need to remove all the tables in your database that start with csvi_ manually and then do a clean install. Or if you wish to keep your templates, remove the tables from the database that start with csvi_ and restore the tables from a backup and add them to your database and then install the new CSVI version.

Hi Roland,

Thanks for your reply, im very pleased to say its ok now, im upgraded although a little more testing still to do

Just one immediate concern, previously my client used the URL below (rather than accessing the admin panel) to run imports/exports, but now this url is giving me a 404 error?

https://www.mydomain.co.uk/administrator/components/com_csvi/helpers/cron.php?username=username&passwd=password&template_id=5

Many thanks in advance!

Hello Jimmy,

There is another post with the same request. The cron file is a real cron file now and as such can only be run as a cron job.

That this worked in the past was a fluke nor intended as such

I am working on a way to trigger templates from the front-end again as it turns out people are using this link rather than using the administrator area. There is already such a system for the export by creating a menu item. Once I have something working I will let you know.

Hi,

Ok thanks, any ideas how long roughly I might be waiting?
Thanks again!

Hello,

I have posted a patch in the original thread. Please give it a try and let me know how it goes.

Hi,

I have uploaded your patch and have attempted to create a CSVi menu item.

I successfully select the 'Menu Item Type:' but the next step 'Select template: select option' when I click the dropdown, nothing is available to me (I already have 1 import and 2 exports setup).

So thats as far as I got, your help would be very much appreciated! Thanks again!

Hello,

You need to enable the front-end usage of the template by setting the option Enable front-end/cron to Yes in the template. Don't forget, the secret key is required as well.

All this to prevent abuse of the template by manipulating a URL.

Great thanks yep, the import seems to be working fine now.

Although the 2 exports aren't working, depending on the 'destination' setting is bringing up just a plain white screen

unless I use 'use template settings' then this is the error

Fatal error: Call to a member function get() on a non-object in /homepages/43/d445035053/htdocs/clickandbuilds/Joomla/Luxury_Flatshares/components/com_csvi/controllers/exports.php on line 140

Although for one export I seem to be getting this error:

'Unfortunately, there are no fields set for this template. Now I don't know what to export. Go to Templates -> Template fields and add the fields you would like to export.'


Your help would once again be much appreciated!

Hello,

Are you running the exports from the front-end as well?

bringing up just a plain white screen

Enable the error reporting in System -> Global Configuration -> Server -> Error reporting -> Developer. After that run it again to see the error message.

Which URL are you accessing?

The other error, indicates you have selected a template but there are no fields in this template. Is that the case?

Hi, Ye all the errors I reported are when trying to access to export from the url in the frontend.

Regarding fields in the template, everything appears to be setup as it was prior the upgrade, when I look in the template I see the relevant fields setup which all seem correct.

Once again your help is much appreciated, thanks!

Hello,

The export template works via the administrator part?

Do you know what the error is on the white page?

Hi,

Im not sure what is going on here, im thinking something must have been messed up during the upgrade but I dont know what (everything was perfect prior to the upgrade) firstly the import seems to be working fine.

I have 2 exports:

- User Export -
Running in the frontend or backend, gives me the following error, although fields appear to be setup.

Error
Unfortunately, there are no fields set for this template. Now I don't know what to export. Go to Templates -> Template fields and add the fields you would like to export.


- Mailing list export -

I get this error when running the URL on the frontend
Fatal error: Call to a member function get() on a non-object in /homepages/43/d445035053/htdocs/clickandbuilds/Joomla/Luxury_Flatshares/components/com_csvi/controllers/exports.php on line 140

And when i run within admin nothing is processed?
Processed
0


Your help would be very much appreciated, im really hoping I dont have to redo all this

Hello Jimmy,

Let's get this export working via the admin first before we try the front. Let's focus on the user export first. You say there are fields linked to this template. Do you see the fields when you edit the template and go to the Fields tab?

Do you have a backup of your old websites/CSVI installation?

Hi,
Yes I see the fields

Yes I have a backup

thanks again!

Hello,

Since you see the fields let's see what creating a backup of the templates does. Can you go to Maintenance and choose CSVI Pro -> Backup templates. Backup the templates and post the resulting XML file here. So I can check the templates to see if anything is odd.

Hi Roland,
Ok, XML is attached.

Many thanks!

Hello Jimmy,

I am able to reproduce the error you have during export saying there are no fields found because I don't have the table acymailing_action. There is something I want you to check. Go to Maintenance -> Available Fields and filter this list on Export / CSVI Pro / Custom tables. Check the box "Show ID fields" and click on Go.

Do you see your fields there? If not, go to Templates -> Templates and edit your template and make sure the correct table is selected on the Options tab and save the template. Go back to Maintenance -> Available fields and click the Update button and once it is done go back to the list of Available Fields and see if they are there. In case they are not there, go to Logs and click on the CSVI Maintenance Update available fields entry to see the details of the update. Check in the messages if you see a line like Available fields have been added for table acymailing_action.

The table should have been indexed now and once that is done, you should be able to export. You may also need to double check if the fields you have in your template actually exist in the acymailing_action table.

Hi Roland,

Thanks again for your help/reply.

Yes I could see the fields in Maintenance > Available fields without having to do anything, they show as being in 'acymailing_action' table. But when I export I see processed 0.

To be honest, when I intiially setup both import and the 2 exports they are fairly complication with replacement fields etc etc etc. Im concerned that during the joomla/csvi upgrade ive lost other elements vital for the import/export.

I have actually gone ahead and ive setup a backup of the site on a seperate domain (taken prior to the recent joomla/csvi upgrade).

So I now have access to the old site admin, isit easier/safer/better for me to export the import/export settings from the old installation and I can then use them on the new upgraded site and be 100% sure they are exactly correct. Would this be the best fail/safe way forward.