SQL errors - possible caused by upgrade from 0.8.6 to 0.8.7

pookey · Post by **pookey** » Wed Oct 31, 2007 9:02 am

I've noticed this in the logs:

 10/31/2007 02:18:55 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='custom_fonts' and user_id="
10/31/2007 02:18:55 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='custom_fonts' and user_id="
10/31/2007 02:18:55 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='custom_fonts' and user_id="
10/31/2007 02:18:55 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='custom_fonts' and user_id="
10/31/2007 02:18:55 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='default_datechar' and user_id="
10/31/2007 02:18:55 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select value from settings_graphs where name='default_date_format' and user_id="

This might have only started after upgrading from 0.8.6 to 0.8.7.

I have 'Authentication Method' set to none, with a 'default' user setup for 'Guest User'.

Does anyone know what might be causing this issue?

pookey · Post by **pookey** » Wed Oct 31, 2007 9:11 am

patch

Code: Select all

# diff lib/functions.php.off lib/functions.php
69c69
<               $guest_uid = db_fetch_cell("SELECT id FROM user_auth WHERE username='guest'");
---
>               $guest_uid = db_fetch_cell("SELECT id FROM user_auth JOIN settings ON user_auth.username = settings.value WHERE settings.name='guest_user'");

Post by **rony** » Wed Oct 31, 2007 9:29 am

Not the preferred method to fix the issue, but it works.

Please submit a bug to http://www.cacti.net/bugs.php

pookey · Post by **pookey** » Wed Oct 31, 2007 11:23 am

done: 0001057

Post by **rony** » Wed Oct 31, 2007 1:39 pm

Thank you!

Post by **rony** » Sat Nov 10, 2007 4:26 pm

Resolved in SVN.

weSh · Post by **weSh** » Mon Nov 12, 2007 4:24 am

rony wrote:Resolved in SVN.

ok, but how can i use svn to correct the bug ?

thx

fmangeant · Post by **fmangeant** » Mon Nov 12, 2007 4:34 am

Hi

this bugs seems to be corrected by SVN revision 4320

The diff is here : http://svn.cacti.net/cgi-bin/viewvc.cgi ... threv=4320

You should test it on a test Cacti server, or at least backup lib/functions.php

weSh · Post by **weSh** » Mon Nov 12, 2007 5:35 am

ok...
thanks a lot...

i'm going to try this...

SQL errors - possible caused by upgrade from 0.8.6 to 0.8.7

SQL errors - possible caused by upgrade from 0.8.6 to 0.8.7

Who is online