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)?
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.
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?
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.)
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."
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.
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
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
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
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
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