Error when updating "Pages based on Tables"

[cpcmec_tech]

Hi,

I have added a table that has a Primary Key in phpmyadmin and I was able to install it on Dadabik. When I try to change the page name or do any sort of editting when the table is added, I receive the error below:

-------------------------
unexpected error include_tables_form.submit ajax error{"readyState":4,"responseText":"\n\n<br />\n<b>Notice</b>: Undefined index: tablename_to_update in <b>/var/www/html/api.php</b> on line <b>0</b><br />\n<p><b>[08] Error:</b> during query execution. show columns from ``<br/>The DBMS server said: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name ''","status":200,"statusText":"OK"}

-------------------------

Environment Details:

DaDaBIK version 9.2.1-Monterosso enterprise, installed on 12-30-2018
Browser: Chrome 78.0.3904.70
OS: Win10
phpMyadmin 4.5.4.1
Apache 2.4.18

Thank you.

 

[eugenio]

Hi,
what is the name of the table?

This can happen if you have a lot of fields in the table, if this is the reason you can fix the problem by increasing
max_input_vars
in your php.ini

Best,

 

[cpcmec_tech]

Hi Eugenio,

The name of the table is "argos_count_users".

This table has about 3.9 million rows.

What should i set the max_input_vars to?

 

[eugenio]

What matters is the number of fields, not the number of rows. If you have a lot of fields, try to increase max_input_vars until it works correctly.

Best,

 

[cpcmec_tech]

Is there a way to set an "unlimited" number?

I currently have it set to 10000000 (10 million)

 

[cpcmec_tech]

Hi!

It is working now.. it's silly of me.

The variable was commented out lol.

I've removed the semi-colon and it's good to go. Thank you very much for your help.

 

[eugenio]

You are welcome!