Search in support tickets

#85 – The problem with Cascade fields

Posted in ‘Support’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Saturday, 28 October 2017 13:50 CEST
Joomla! version :3.7.5
PHP version :7.0
AdsManager version :3.1.11
The problem with Cascade fields. When adding new value, after saving, all the work done before is lost! I made a video screen.
It's weeks of work! What can I do to make the program work correctly? Which resource to increase on hosting?
Custom Fields
Joomla Version
PHP Version
Product Version
Monday, 30 October 2017 08:34 CET

You have way to many value in that field to use the values storage of AdsManager.

You need to use the external table feature.

In the cascade field setting, just above the field values, you can choose what type of storage you wish to use for the field.
Choose 'Data stored in an external table', and then fill the following field.

You need to store the values directly in your database.

Best regards.
Monday, 30 October 2017 09:11 CET
Thank you. Do you of course have a manual for setting up such a specific function? Guide step by step? I first time see this in Joomla.
Tuesday, 31 October 2017 08:31 CET

The documentation is currently being rewritten so it is not available.

You can ask if you need help with this feature.

Best regards.
Tuesday, 31 October 2017 12:12 CET
It will be very good if you explain how I can use this function. On a simple example. I've never had to do this. Very unusual for the Joomla component.
Thursday, 02 November 2017 08:17 CET

I will explain with a step by step process.

1. In your database create a new table with 4 columns:
- id - Primary key, auto increment
- label - The name that will be displayed on the screen, varchar(255)
- value - The name that will be used in the database, must be unique, varchar(255)
- parent - The value of the parent

Populate that table with your datas, you can use a import csv by using the phpmyadmin import feature.

2. Go to the backend of your website and edit the cascade field in components->adsManager->fields
At the end of the settings:
- Enter the name of the parent field in the 'Parent field name' parameter.
- Select 'Data stored in an external table'
- In 'Database table name', enter the name of the table you've created earlier
- In 'Column name for label', enter the name of the label column (label in my example)
- In 'Column name for value', enter the name of the value column (value in my example)
- In 'Column name for parent value', enter the name of the parent value column (parent in my example)

Save the fields and that it.

If it doesn't work, check that the parent value exist in the parent field.

Best regards.
Tuesday, 14 November 2017 17:16 CET
Thank you. Everything is working. excellent manual.
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.