Testing 0.65 RC2

megabrain · 2006-03-13 23:00:33

Hi
I am very impressed of actual improvements to GLPI It is almost perfect.
While testing last RC i found this bugs :

Module Assistance
In Tracking while trying to add followup to ticet, nothing happened.

Module Managment
when trying to enter to Contracts, I've got such error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ITEM_7, glpi_contracts.ID AS ID FROM glpi_contracts LEFT JOIN glpi_dropdown_' at line 1

Module Administration

Missing ALL dropdowns entered before upgrade to RC2

Tested on :
mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 5.0
PHP 4 and PHP 5
apache 2.0.55

Last edited by megabrain (2006-03-13 23:24:44)

MoYo · 2006-03-13 23:38:07

which version do you used before RC2 ?

megabrain · 2006-03-13 23:57:29

for a long time 0.6p1 and CVS version ( trallball ftom 15 feb 06 ).
I'have looked into database for a dropdowns, and data are sill there. they only doesn't appear on web pages

MoYo · 2006-03-14 00:01:56

CVS versions must not to be used in production. Update from CVS to any other version may cause troubles.

megabrain · 2006-03-14 00:15:16

I know that.
But looking on structure of glpi_dropdown_locations, it is changed only by last column - comments. This table was upgraded ok. but it doesnt work. I am pretty confused now, because i really dont know what to do.

MoYo · 2006-03-14 00:17:06

I do not have your problem so I really dont knwo what to do too.

megabrain · 2006-03-14 00:21:17

I've just made a test:

Add a new location to database via glpi web interface.
In database I can see a new entry, but on web i can't see it ( dropdown fields are not filled with any data )

Strange

MoYo · 2006-03-14 00:23:07

you used the RC2 ?

megabrain · 2006-03-14 00:32:59

Yes, RC2.
One thing i've just managed :

in present versions of GLPI is implemented function like autofilter ( i hop you understand me ) - for example, when i trying to add a new computer, and in prducent field i'll type letter, this finction shwoed all producents with name started on this letter. Now it doesnt work (but it worked eariler).

Maby it is all my problem wyth dropdowns ? Question is how to fix it ?

Gee, why I always must broke some things ? ( and why all in one time )

Thanks for your replays though late hour

megabrain · 2006-03-14 01:00:14

Ok, i've got dropdowns and adding followups working again. Strange thing - reason was .htacces in main directory. Ill check it out tomorrow morning.

Still doesn't work contracts :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ITEM_7, glpi_contracts.ID AS ID FROM glpi_contracts LEFT JOIN glpi_dropdown_' at line 1

But I can see my contracts assigned to computers, I only can't open them.

OK, i run GLPI in debug mode, and I have an error at the top on red background :

PHP ERROR :
Notice: Undefined index: 9 in /var/www/localhost/htdocs/inwentura/glpi/glpi/common/functions_search.php on line 447

Any suggestion ?

Last edited by megabrain (2006-03-14 16:04:39)

gava · 2006-03-14 16:29:50

Hi,
with RC2 i have the same duplication of machine issues that I had RC1 and OCS.

There are no duplicates in OCS. If i delete the machines, after a couple of imports the machines appear again.

thanks,
Gavin

megabrain · 2006-03-14 16:37:27

I think my problem is a little different

gava · 2006-03-14 18:10:41

I know. I seem to be the only one having these problems with the latest versions of GLPI/OCS. Hopefully this "Testing 0.65 RC2" thread will help the hard working developer eliminate these bugs

cheers
Gavin

megabrain · 2006-03-14 21:01:08

ok, I've just think about it right after I wrote answer

megabrain · 2006-03-15 13:15:40

Below I paste SQL Request, I can see there is an error near AS ITEM 7

SELECT glpi_contracts.name AS ITEM_0, glpi_dropdown_contract_type.name AS ITEM_1, glpi_contracts.num AS ITEM_2, glpi_contracts.begin_date AS ITEM_3, glpi_contracts.duration AS ITEM_4, glpi_contracts.notice AS ITEM_5, glpi_contracts.cost AS ITEM_6, . AS ITEM_7, glpi_contracts.ID AS ID
FROM glpi_contracts
LEFT JOIN glpi_dropdown_contract_type ON (glpi_contracts.contract_type = glpi_dropdown_contract_type.ID)
WHERE glpi_contracts.deleted='N' GROUP BY ID
ORDER BY glpi_contracts.name ASC LIMIT 0, 50

Structure of table glpi_contracts is ok, I really dont know what is going on.

tsmr · 2006-03-15 14:36:40

in administration / setup / display search result list

you choose contract.

Do you have not a empty column ? if yes del it..

megabrain · 2006-03-15 14:43:48

Yes, it was all about table glpi_display. I have managed it after posted here.

Thanks for help ..

tsmr · 2006-03-15 14:44:44

Forum GLPI-Project

Announcement

#1 2006-03-13 23:00:33

Testing 0.65 RC2

#2 2006-03-13 23:38:07

Re: Testing 0.65 RC2

#3 2006-03-13 23:57:29

Re: Testing 0.65 RC2

#4 2006-03-14 00:01:56

Re: Testing 0.65 RC2

#5 2006-03-14 00:15:16

Re: Testing 0.65 RC2

#6 2006-03-14 00:17:06

Re: Testing 0.65 RC2

#7 2006-03-14 00:21:17

Re: Testing 0.65 RC2

#8 2006-03-14 00:23:07

Re: Testing 0.65 RC2

#9 2006-03-14 00:32:59

Re: Testing 0.65 RC2

#10 2006-03-14 01:00:14

Re: Testing 0.65 RC2

#11 2006-03-14 16:29:50

Re: Testing 0.65 RC2

#12 2006-03-14 16:37:27

Re: Testing 0.65 RC2

#13 2006-03-14 18:10:41

Re: Testing 0.65 RC2

#14 2006-03-14 21:01:08

Re: Testing 0.65 RC2

#15 2006-03-15 13:15:40

Re: Testing 0.65 RC2

#16 2006-03-15 14:36:40

Re: Testing 0.65 RC2

#17 2006-03-15 14:43:48

Re: Testing 0.65 RC2

#18 2006-03-15 14:44:44

Re: Testing 0.65 RC2

Board footer