Hi there,
Today I updated from 1.8.0 to 1.8.3 but after installation I got errors on the dashboard. So I installed the latest trunk version. Now I have even more errors:
* Error in query [SELECT e.eventid, e.value, e.clock, e.ns, e.objectid as triggerid, e.acknowledged FROM events e WHERE e.object=0 AND e.objectid=13841 AND e.value=1 ORDER by e.object DESC, e.objectid DESC, e.eventid DESC LIMIT 1 OFFSET 0] [Unknown column 'e.ns' in 'field list']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
* Error in query [SELECT e.eventid, e.value, e.clock, e.ns, e.objectid as triggerid, e.acknowledged FROM events e WHERE e.object=0 AND e.objectid=13870 AND e.value=1 ORDER by e.object DESC, e.objectid DESC, e.eventid DESC LIMIT 1 OFFSET 0] [Unknown column 'e.ns' in 'field list']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
* reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object[/var/www/include/blocks.inc.php:906]
* Error in query [SELECT e.eventid, e.value, e.clock, e.ns, e.objectid as triggerid, e.acknowledged FROM events e WHERE e.object=0 AND e.objectid=13525 AND e.value=1 ORDER by e.object DESC, e.objectid DESC, e.eventid DESC LIMIT 1 OFFSET 0] [Unknown column 'e.ns' in 'field list']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
I must say that I didn't do any sql patches after 1.8.0. but if I understand correctly these are not necessary.
1.8.0 didn't have this problem .
system: Ubuntu 9, php 5.2.6, mysql 5
Thanks,
Roger
Today I updated from 1.8.0 to 1.8.3 but after installation I got errors on the dashboard. So I installed the latest trunk version. Now I have even more errors:
* Error in query [SELECT e.eventid, e.value, e.clock, e.ns, e.objectid as triggerid, e.acknowledged FROM events e WHERE e.object=0 AND e.objectid=13841 AND e.value=1 ORDER by e.object DESC, e.objectid DESC, e.eventid DESC LIMIT 1 OFFSET 0] [Unknown column 'e.ns' in 'field list']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
* Error in query [SELECT e.eventid, e.value, e.clock, e.ns, e.objectid as triggerid, e.acknowledged FROM events e WHERE e.object=0 AND e.objectid=13870 AND e.value=1 ORDER by e.object DESC, e.objectid DESC, e.eventid DESC LIMIT 1 OFFSET 0] [Unknown column 'e.ns' in 'field list']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
* reset() [<a href='function.reset'>function.reset</a>]: Passed variable is not an array or object[/var/www/include/blocks.inc.php:906]
* Error in query [SELECT e.eventid, e.value, e.clock, e.ns, e.objectid as triggerid, e.acknowledged FROM events e WHERE e.object=0 AND e.objectid=13525 AND e.value=1 ORDER by e.object DESC, e.objectid DESC, e.eventid DESC LIMIT 1 OFFSET 0] [Unknown column 'e.ns' in 'field list']
* mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:544]
* mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/include/db.inc.php:546]
I must say that I didn't do any sql patches after 1.8.0. but if I understand correctly these are not necessary.
1.8.0 didn't have this problem .
system: Ubuntu 9, php 5.2.6, mysql 5
Thanks,
Roger
Comment