Hi, I have the same problem every time I want to create a block, it already exist!! However there are no blocks created yet. Somebody knows why? (of course, I am logged-in as admin). The exact message is:

"Save failed. ERROR => The block TESTBLOCK already exists!" (And the same with every name I make up...)

On the other hand, I have no problems creating hosts, subnets, vlans, vlan campuses, locations, ... Moreover, I have created blocks without problems with the demo version (http://opennetadmin.com/demo). Then, I don't understand what happens

Is there some MySQL table related to blocks, because I have been looking for that without success.

I am using the last version of ONA: v09.05.02

Thank you for your attention.

Well it looks like I screwed something up there.. I too get the block exists error.. I'll have a look and fix it up for the next release.

As far as a blocks table, yes it is called simply "blocks"..

Exactly. I am pleased to know that was not a problem in my system.

I have ask you about the table for blocks because it doesn't exist (at moment), however I have been watching some modules about it and I found some references to 'block' as a table although I wasn't sure.

Thank you Matt.

Hmm ok so I wasnt paying attention on my side.. I'm not getting the "already exists" error.. (when I acutaly use something that doesnt exist!)

If you truly don't have a blocks table in your database then I would suspect that is the problem here. you should have 39 tables in your ONA database. The file /opt/ona/install/ona-tables.sql contains all the info on creating those tables. If they are not there then it may have been an error during install?

I'd check that you have all the right tables and or re-install.

I checked through the code on the blocks thing and it "looks" ok at this point to me.

Hi again Matt,

Augh! I have only 38 tables. I think we are near the problem. I have just sighted the file ona-tables.sql and has copy and paste de code of creating the table 'blocks" and it generates a syntax error. Here is the code:

DROP TABLE IF EXISTS `blocks`;
CREATE TABLE `blocks` (
`id` int(10) unsigned NOT NULL,
`ip_addr_start` int(10) unsigned NOT NULL,
`ip_addr_end` int(10) unsigned NOT NULL,
`name` varchar(63) NOT NULL,
`notes` varchar(255) text NOT NULL, <--------------------------------- This and the following line generate the error.
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='User Defined IP Address Ranges';

Could be the problem the word 'text' in the definition of the atribute 'notes'??

See you

That is exactly the problem. the word "text" should be removed from that statement.

I'll fix it up in my files.. you'll have to manually make the changes of course, or wait for the next revision.

Yeah, I have just tried deleting the word 'text' of that line and now all is perfect. Maybe you must know that in the installation process (that I did two times before posting this thread) I never watch any error message about a problem creating the database.

Matt, thank you very much for your help.