Extra details for the inventory

[rbp88]

Hello,

I'd like to know why extra details for the inventory fields are in blank whether I press Update button?
And It occurs the same with the mail template, if I want to translate some template to Spanish it doesn't update.

Is it an Integria bug? Or is professional support required?

Thanks.

[Sancho Lerena]

Hello,

I'd like to know why extra details for the inventory fields are in blank whether I press Update button?
And It occurs the same with the mail template, if I want to translate some template to Spanish it doesn't update.

Is it an Integria bug? Or is professional support required?

Thanks.

What version are you using, the SVN current version ?

[rbp88]

Version 2.1 Development Snapshot Feb2010

[Sancho Lerena]

Version 2.1 Development Snapshot Feb2010

Try to upgrade to current SVN version, it works fine for me ¿?

[rbp88]

How or where can I get it? Because in the download page the last version is which I'm using...

Thanks.

[Sancho Lerena]

How or where can I get it? Because in the download page the last version is which I'm using...

Thanks.

Get a subversion command line client and execute this:

svn co https://integria.svn.sourceforge.net/svnroot/integria/trunk

This will grab all the current code for 2.1-dev version from our public code repository and store in your system. You can repeat this procedure to update your copy:

svn update https://integria.svn.sourceforge.net/svnroot/integria/trunk

[rbp88]

Ok, I did that and I installed a new integria from /trunk/install.php file and I have the same problem, the Extra details for the inventory aren't updated when I modified...
and the same problem wih the mail templates...

What is wrong?

Thank you very much

[Sancho Lerena]

Sorry, you're totally right, I've check the code and we have a bug, use the same method as before  (svn update ...) to get the changes.

Check also that your current database schema (in the database manager) has included the extra fields, for that, go to database manager and run

describe tinventory;

See the screenshot attached. You should have, at the end the extra fields, if not run, line by line following sentences in the SQL manager to add the fields:

ALTER TABLE tinventory ADD `generic_1` varchar(255) default '';
ALTER TABLE tinventory ADD  `generic_2` varchar(255) default '';
ALTER TABLE tinventory ADD  `generic_3` text;
ALTER TABLE tinventory ADD  `generic_4` text;
ALTER TABLE tinventory ADD  `generic_5` varchar(255) default '';
ALTER TABLE tinventory ADD  `generic_6` varchar(255) default '';
ALTER TABLE tinventory ADD  `generic_7` varchar(255) default '';
ALTER TABLE tinventory ADD  `generic_8` text;

Thanks for noticing us about this problem !

Ok, I did that and I installed a new integria from /trunk/install.php file and I have the same problem, the Extra details for the inventory aren't updated when I modified...
and the same problem wih the mail templates...

What is wrong?

Thank you very much

[rbp88]

I did that you say but anyway the extra details for the inventory are never updated...
and the same with the mail templates. I know I'm repetitive but we need these utilities.

I attached a screenshot where you can see I added these fields.

Thanks.

[Sancho Lerena]

Execute:

svn update https://integria.svn.sourceforge.net/svnroot/integria/trunk

In the same directory you execute before the

svn co https://integria.svn.sourceforge.net/svnroot/integria/trunk

(or execute the last command again and put all the files in the apache publication directory).

[rbp88]

That's what I did, I put all the files in the apache publication directory but is like nothing... :\

[Sancho Lerena]

This is a output of my tinventory table. This is obtained with "DESCRIBE tinventory;" in SQL manager:

id    mediumint(8) unsigned    NO    PRI       auto_increment
name    varchar(100)    NO          
description    varchar(250)    YES          
serial_number    varchar(250)    YES          
part_number    varchar(250)    YES          
comments    varchar(250)    YES          
confirmed    tinyint(1)    YES       0    
cost    float(10,3)    YES       0.000    
ip_address    varchar(60)    YES          
id_contract    mediumint(8) unsigned    YES    MUL       
id_product    mediumint(8) unsigned    YES    MUL       
id_sla    mediumint(8) unsigned    YES    MUL       
id_manufacturer    mediumint(8) unsigned    YES    MUL       
id_building    mediumint(8) unsigned    YES    MUL       
id_parent    mediumint(8) unsigned    YES    MUL       
generic_1    varchar(255)    YES          
generic_2    varchar(255)    YES          
generic_3    text    YES          
generic_4    text    YES          
generic_5    varchar(255)    YES          
generic_6    varchar(255)    YES          
generic_7    varchar(255)    YES          
generic_8    text    YES       

Yours should be the same.
I've defined my custom fields in the setup, because I've it working with current SVN code ¿?

[rbp88]

Ok I have the same, but the problem still cotinues... does it work for you?

[Sancho Lerena]

Ok I have the same, but the problem still cotinues... does it work for you?

Yes, mine works fine, I check it and fix the problem when you started the thread in the forum.