Cannot create new nodes

The forum for help and support with FreeNATS as well as any useful hints and tips
Post Reply
paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

Cannot create new nodes

Post by paullanders » Sat Jul 03, 2010 4:32 pm

Hi Dave!

I am abruptly unable to create new nodes in 1.09.2/b. I populate all fields, but when I click SAVE it saves only the NODEID and the ALERTS ACTIVE tic-box. All other fields are not saved.

Thank you!

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Cannot create new nodes

Post by dave » Sun Jul 04, 2010 4:05 pm

Hi Paul,

Hmm... weird.

Do you see any errors in the log (Configuration -> System Settings -> System Event Log) which would indicate a query failing?

In the meantime let me have a poke around and see if I think I can find anything that may cause your problem.

Cheers,

Dave.

paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

Re: Cannot create new nodes

Post by paullanders » Tue Jul 06, 2010 4:16 pm

Dave, I see this query failure:

10:13:29 06/07/2010 DB Query 2 Query Error: Unknown column 'ulink0' in 'field list' (1054)
10:13:29 06/07/2010 DB Query 2 Query Failed: UPDATE fnnode SET nodename="biblio",nodedesc="biblio",testinterval=5,scheduleid=0,nodeicon="tux32.png",nodealert=1,nodeenabled=1,pingtest=1,pingfatal=0,nsenabled=0,masterid="",masterjustping=1,hostname="biblio.ttuhsc.edu",ulink0=0,...

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Cannot create new nodes

Post by dave » Tue Jul 06, 2010 5:37 pm

Hi Paul,

Looks like an SQL schema problem to me - specifically with the changes that were released in 1.08.0a and beyond (utility links).

Did you do a schema import/upgrade when you installed the most recent version?

If not you need to run:
* server/base/sql/schema.sql
* server/base/sql/schema.upgrade.sql

Against your database to create and update the new fields.

Cheers,

Dave.

paullanders
Posts: 92
Joined: Thu Sep 04, 2008 9:48 pm

Re: Cannot create new nodes

Post by paullanders » Tue Jul 06, 2010 9:01 pm

And as usual you have fixed it!

Thanks, Dave!

dave
Site Admin
Posts: 260
Joined: Fri May 30, 2008 9:09 pm
Location: UK
Contact:

Re: Cannot create new nodes

Post by dave » Tue Jul 06, 2010 9:28 pm

Hi Paul,

Excellent - glad to hear it.

Actually getting useful information from the system event log as well... Wonders will never cease.

Regards,

Dave.

Post Reply