Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
I use the "Create from column values" feature to populate a select box filter, (I am using an SQL database query) and it has been working perfectly for months. I just increased the number of rows in the SQL table, and suddenly the "Create from column values" feature is not functioning properly. "Create from column values" populates the "Possible values" box, BUT when I "Save" the table, the Possible values box erases all of the values and changes to one value: "0".
I just increased the number of rows in the SQL table from 35,000 rows to 50,600 rows which changed the number of possible values for the select box from 4,626 (which works properly) to 5,172 which results in the problem. Is there a limit to the number of values for the select box filter when using "Create from column values" and if so can I override it? (Note that I have confirmed that this is not a problem with my data.) Thanks.
UPDATE: I just manually pasted the 5,172 values (separated by "|") into the "Possible values" box, and it works perfectly. Is this possibly a time-out issue with my website server (BlueHost shared)?
Hi ORA55,
Thank you for your purchase.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Alan,
I received the email but I must ask you to continue the conversation here.
We get a lot of emails daily and it is very difficult for me to find yours and be able to help you quickly.
" I believe that the problem is related to the total size or total number of characters in the “Possible values” box."
This is the common issue when you have a lot of values in "Possible value box".
So my suggestion is to increase that column to have more than 3000 characters in database or in your case like you did, decrease it to 7 or 8 characters.
Can you please tell me is everything working fine now?
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Bogdan:
Yes, from now on I will only communicate here. Sorry.
I am not sure I understand your suggestion "to increase that column to have more than 3000 characters in database". Our SQL database has 50,000+ rows and that column has 5,172 values with an average of ~ 12.66 characters each for a total of 5172 x 12.66 = 65,482 characters, which is many more than the 3000 characters you suggest for that column.
Yes, it works when I reduced the average size to 8 characters (5172 x 8 = 41,376 total characters) but we really need the larger capacity. Are you saying that this is a known limitation of wpDataTables? If so, could we pay one of your developers to customize the program to increase the capacity for us? (Note that we previously paid your developers to customize search for us.)
Thanks.
Alan
Hi Alan,
There is no need for customization for this "issue".
I will write you a guide how to increase the capacity.
Go to your phpmyadmin panel and choose wp_wpdatatables_columns , click on structure and find possible values column.
Click the change and change the type to long string.
Please take a look at attachment files.
Also just a note about mysql text size
"TINYTEXT is a string data type that can store up to to 255 characters.
TEXT is a string data type that can store up to 65,535 characters. TEXT is commonly used for storing blocks of text used for brief articles.
LONGTEXT is a string data type with a maximum length of 4,294,967,295 characters."
So maybe this can be useful.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Bogdan:
Thanks very much for your help. I know about MySQL data types so I know how to change it for this table. This is a very easy solution. I should have figured this out myself when I determined that the problem happened when I reached ~ 65K characters! Thanks again.
Alan
Hi Alan,
You are welcome.
I am glad that we solved the issue.
If you like our plugin and support please rate our plugin at CodeCanyon on this link. It means a lot to us. Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables