Walter Nuñez

Results 88 comments of 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...