Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No package list since update to 2.4.1 #404

Closed
Blank-Vcf opened this issue Apr 11, 2018 · 4 comments
Closed

No package list since update to 2.4.1 #404

Blank-Vcf opened this issue Apr 11, 2018 · 4 comments
Assignees
Labels
bug
Milestone

Comments

@Blank-Vcf
Copy link

@Blank-Vcf Blank-Vcf commented Apr 11, 2018

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system :

Server installation method ( Only one choice )

  • RPM Package
  • [X ] Install SH
  • Manual installation

Server informations

Php version : 5.6.33
Mysql / Mariadb / Percona version : mysql Ver 14.14 Distrib 5.5.59,
Apache version : 2.4.10

OCS Inventory informations

Ocsreports version : 2.4.1

Problem's description

Since update 2.4.1 no package are listing on activate page, deleted package are ok
query in db show all packages if i go on a computer or a group i can see available package.

Back to 2.4 and everything ok, in debug on 2.4.1 this query is not executed:

SELECT SQL_CALC_FOUND_ROWS FILEID, from_unixtime(FILEID), NAME, PRIORITY, FRAGMENTS, round(SIZE/1024,2), OSNAME, COMMENT from download_available where (comment not like '[PACK REDISTRIBUTION%' or comment is null or comment = '') and DELETED = 0 and comment not like '%[VISIBLE=0]%' order by NAME asc limit 0 , 500

@TiVince

This comment has been minimized.

Copy link

@TiVince TiVince commented Apr 12, 2018

@Blank-Vcf same here.
the problems seems to come from this line in plugins/main_sections/ms_teledeploy/ms_tele_activate.php introduced in #334

$l->g(593) => 'CAST(from_unixtime(FILEID) AS DATETIME(0))',

you can revert it back to 2.4.0 version

$l->g(593) => 'from_unixtime(FILEID)',

or just remove (0) at the end :

$l->g(593) => 'CAST(from_unixtime(FILEID) AS DATETIME)',
it seems to work too

(note: I'm using a rather old mysql 5.1.173 version on CentOS)

@Blank-Vcf

This comment has been minimized.

Copy link
Author

@Blank-Vcf Blank-Vcf commented Apr 13, 2018

@TiVince
USe: $l->g(593) => 'CAST(from_unixtime(FILEID) AS DATETIME)',
Working for me.

@charleneauger charleneauger added the bug label Apr 20, 2018
@charleneauger charleneauger self-assigned this Apr 20, 2018
@charleneauger charleneauger mentioned this issue Apr 23, 2018
1 of 2 tasks complete
gillesdubois added a commit that referenced this issue Apr 27, 2018
Fix #404
@mester1202

This comment has been minimized.

Copy link

@mester1202 mester1202 commented Aug 25, 2018

I'm using OCS Inventory 2.5 on Debian 8 but I still has this problem. Maybe it's because the server uses hungarian Date/Time format?

@daCaPo

This comment has been minimized.

Copy link

@daCaPo daCaPo commented May 14, 2019

Same issue here (OCS 2.6 on Ubuntu 18.04.2 LTS). Should I open a new report, or will someone reopen this one?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
6 participants
You can’t perform that action at this time.