Walter Nuñez
Walter Nuñez
I've been digging a bit deeper on the subject and it seems that everything points to a mysql server problem and the "INFORMATION_SCHEMA". ```sql DROP TABLE IF EXISTS `Tbl_Lis_Agencias`; CREATE...
the error is related to the mysql Statistics implementation: Some way to solve i found this: https://stackoverflow.com/a/57383942/13810463 https://stackoverflow.com/a/64214609/13810463 Running this: ```sql SET GLOBAL information_schema_stats_expiry = 0; ```
> Thank you so much for the final explanation! > By the way you can disable information schema usage with https://docs.phpmyadmin.net/en/latest/config.html?highlight=DisableIS#cfg_Servers_DisableIS > > `$cfg['Servers'][$i]['DisableIS']` **_This is an error related to...
@ophian @williamdes the problem is related to: you have inserted some records into a table; for some reason you emptied the table; but once your self-increase you perceive the value;...
@ophian Well I can clarify that this error thread does not have to do with the version of php in execution. This error also occurs when data was deleted from...
@ophian "visual error" I mean that phpmyadmin shows a cached data; while the database is updated and correct; The whole problem is that phpmyadmin uses the variable `information_schema_stats_expiry `and this...
@ophian I really don't know what tests you did; adding records is not the problem; the problem occurs when removing them ... I think the post is detailed enough to...
@ophian zorry for response to late ... and yes i propose to use: `SET GLOBAL information_schema_stats_expiry = 0;` or `$cfg['Servers'][$i]['DisableIS']` By Default in phpmyadmin... since I think of phpmyadmin as...
Ok, I would like to close this issue, but there are two ways to solve it: In the scenario that whatever it is... the mysql server has the cache enabled......
Is bad practice merge Html code with PHP; you look like need to store your "foreach loop" in a variable in top of php file and short print the variable...