[0.7-RC1] Bug in deleted Computers list

adrianmarsh · 2007-10-19 10:51:28

Hi,

Another thread: http://glpi-project.org/forum/viewtopic … 269#p42269

I just setup 0.7RC1, and noticed that the show/hide Trashed computers always seems to show both trashed and non-trashed entries when set to NO. If I set it to YES, then no computers get shown at all.

Setup is based off an OCS-Inventory NG installation.

PHP: 5.1.1
apache: 2.2.0
mysql 14.12 distrib 5.0.18

The DB was mysqldump'd from one database to another. The configdb.ini file deleted (if there) and then the whole setup re-run as an Upgrade. It did 3 "database upgrades" in total. Afterwards I noticed this issue. Not there in th 0.68.2 version.

Anyone else see the same?

MoYo · 2007-10-19 13:55:32

your updates need to have problems.
Which is the type of the field deleted of the table glpi_computers in the database ?

adrianmarsh · 2007-10-19 14:38:55

Hi.. I'm not really sure what it is that you are asking.. but heres a record I found from the SQL dump I took, for one item that shouldn't be shown:

(62,'Test record','test','','','',0,'Empty Template','2006-12-04 20:21:34',0,0,0,0,0,0,0,0,3,'0','Blank Template',0,'Y',NULL,0,39,0)

MoYo · 2007-10-19 14:44:37

the update process have a problem.
you do not need have 'Y' field.
You use xampp ?

Somebody have the same problem. Updating xampp to the new version of OCS and problem have been solved.

adrianmarsh · 2007-10-19 14:53:01

Yes theres xampp involved in OCS. I'll go and check the version we have of that too.

MoYo · 2007-10-19 15:45:30

last ocs version is 1.01

adrianmarsh · 2007-10-19 15:57:57

Yes.. (Feb 07) and I'm sure thats what we're using (I've all the downloads for 1.01 from back then..).. but I can't find documentation in OCS that shows whats versions of the s/w are in 1.01 so I can compare... will keep looking.

MoYo · 2007-10-19 16:03:28

which version is display on ocsreports ? the web interface ?
I think last version is 4100

MoYo · 2007-10-19 16:06:41

you could try to modify php configuration like this :
max_execution_time = 120 ; Maximum execution time of each script, in seconds
max_input_time = 120 ; Maximum amount of time each script may spend parsing request data
memory_limit = 64M ; Maximum amount of memory a script may consume (16MB)

adrianmarsh · 2007-10-19 16:08:51

Yes its 4100.. and I've already made those php.ini changes (see some of the other thread).

So I guess I'm up-to-date then.

MoYo · 2007-10-19 16:33:25

hummm.
you could comment the line error_reporting(0) in install.php file to see if you have more informations about problems during the update process.

adrianmarsh · 2007-10-19 16:44:48

Are you sure this is a bug in the conversion? Not in the GUI interface ?

MoYo · 2007-10-19 17:26:52

Yes I am sure.
It is not normal that deleted fields contain Y or N datas.
it need to be 0 or 1

adrianmarsh · 2007-10-19 17:53:20

Ok... but that data in my sample is the output from the 0.68.3 release database dump.. Should it be a 0 or a 1 in that ?

MoYo · 2007-10-19 17:54:23

no should be 0 or 1 in the 0.7 version.

adrianmarsh · 2007-10-19 18:00:42

ok.. so I've done a dump of the 0.7 database, and heres the same record:

(62,0,'Test record','test','','','',0,'Empty Template','2006-12-04 20:21:34',0,0,0,NULL,NULL,0,0,0,0,0,3,0,'Blank Template',0,0,NULL,0,39,0,0,'0.0000')

So that seems to suggest the "conversion" worked but maybe it got the conversion wrong? (Putting a 0 instead of a 1 ?)

MoYo · 2007-10-19 18:57:15

Yes it happens something wrong.
Y need to be convert in 1.
Really strange.

Is it possible to you to send me your database to check on my test environments ?

MoYo · 2007-10-22 22:55:20

do you have news ?

adrianmarsh · 2008-01-05 13:13:35

Sorry... didn't get to look at 0.7 in a long time.. Just added the latest 0.7 and still the same issue.
I'll email through the database to you

MoYo · 2008-01-05 13:19:57

you can send mail to moyo !at! indepnet !dot! net

adrianmarsh · 2008-01-05 13:24:51

ok.. on its way

MoYo · 2008-01-05 13:59:16

No problem to update in my computers. deleted are deleted.
You may have a problem on you install. mysql php bug maybe ?

adrianmarsh · 2008-01-05 14:46:07

hmmm... well GLPI is installed into an OCS installation on windows which uses Xampp. I just looked to see how easy it would be to update xampp, and it doesn't look too simple, so I think what I'll try next is adding GLPI .7 onto a new linux server, copy the .68 DB across, and try the upgrade there.

Last edited by adrianmarsh (2008-01-05 14:46:21)

adrianmarsh · 2008-01-05 17:33:13

ok... so I tried the DB that you sent me on a test system, and that looks fine.. so I guess it must be in the conversion process.. I've emailed you through my converted database for comparison

MoYo · 2008-01-09 00:25:49

I close the topic. No idea why it happens. Correct DB send.

Forum GLPI-Project

Announcement

#1 2007-10-19 10:51:28

[0.7-RC1] Bug in deleted Computers list

#2 2007-10-19 13:55:32

Re: [0.7-RC1] Bug in deleted Computers list

#3 2007-10-19 14:38:55

Re: [0.7-RC1] Bug in deleted Computers list

#4 2007-10-19 14:44:37

Re: [0.7-RC1] Bug in deleted Computers list

#5 2007-10-19 14:53:01

Re: [0.7-RC1] Bug in deleted Computers list

#6 2007-10-19 15:45:30

Re: [0.7-RC1] Bug in deleted Computers list

#7 2007-10-19 15:57:57

Re: [0.7-RC1] Bug in deleted Computers list

#8 2007-10-19 16:03:28

Re: [0.7-RC1] Bug in deleted Computers list

#9 2007-10-19 16:06:41

Re: [0.7-RC1] Bug in deleted Computers list

#10 2007-10-19 16:08:51

Re: [0.7-RC1] Bug in deleted Computers list

#11 2007-10-19 16:33:25

Re: [0.7-RC1] Bug in deleted Computers list

#12 2007-10-19 16:44:48

Re: [0.7-RC1] Bug in deleted Computers list

#13 2007-10-19 17:26:52

Re: [0.7-RC1] Bug in deleted Computers list

#14 2007-10-19 17:53:20

Re: [0.7-RC1] Bug in deleted Computers list

#15 2007-10-19 17:54:23

Re: [0.7-RC1] Bug in deleted Computers list

#16 2007-10-19 18:00:42

Re: [0.7-RC1] Bug in deleted Computers list

#17 2007-10-19 18:57:15

Re: [0.7-RC1] Bug in deleted Computers list

#18 2007-10-22 22:55:20

Re: [0.7-RC1] Bug in deleted Computers list

#19 2008-01-05 13:13:35

Re: [0.7-RC1] Bug in deleted Computers list

#20 2008-01-05 13:19:57

Re: [0.7-RC1] Bug in deleted Computers list

#21 2008-01-05 13:24:51

Re: [0.7-RC1] Bug in deleted Computers list

#22 2008-01-05 13:59:16

Re: [0.7-RC1] Bug in deleted Computers list

#23 2008-01-05 14:46:07

Re: [0.7-RC1] Bug in deleted Computers list

#24 2008-01-05 17:33:13

Re: [0.7-RC1] Bug in deleted Computers list

#25 2008-01-09 00:25:49

Re: [0.7-RC1] Bug in deleted Computers list

Board footer