Recent changes to 471: DB Errors with MySQLhttps://sourceforge.net/p/phpipam/bugs/471/2022-04-26T22:43:51.567000ZRecent changes to 471: DB Errors with MySQLDB Errors with MySQL2022-04-26T22:43:51.567000Z2022-04-26T22:43:51.567000ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net77f602b2c44d33e1461ad5560582118e1be0ce2a<div class="markdown_content"><p>Running v1.4 w/ MySQL 8.0 on Ubuntu 20.04 w/ Apache</p>
<p>Errors pop up on almost every page.</p>
<p>Error: SQLSTATE<span>[42S22]</span>: Column not found: 1054 Unknown column 'SQL_CACHE' in 'field list'</p>
<p>and</p>
<p>These appear to be related to the number of discovered devices on a subnet. I get a list of the same error X the number of devices on a subnet.</p>
<p>Error: SQLSTATE<span>[42000]</span>: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM <code>ipaddresses</code> WHERE <code>state</code><>4 AND <code>ip_addr</code> IN (SELECT <code>ip_addr</code> FROM `ipa' at line 1</p></div>