Page 1 of 1

database query dont deliver result

PostPosted:Thu Jan 26, 2012 10:17 am
by Towo
in the admin area i i go to the database query.
there i put the query "SELECT * FROM OKM_USER;" and select the type jdbc.

if i click at send
i dont get the list of the user.

yesterday i change the openkm.war from 5.1.7 to 5.1.8
before i got results. is there any known problem with queries?

i need this to work because i have to create a lot of users and want to do this with db-queries because i dont found a webservice like creating documents

Re: database query dont deliver result

PostPosted:Sat Jan 28, 2012 9:13 am
by jllort
Which database are you using ? it's really strange because you'll not be able to login if okm_user table is empty, there's some error in server.log when you're doing it, could you capture some screenshot to watch it ?

query SELECT * FROM OKM_USER; should be running, sure ( could be some problem in administration query panel, but not on DBMS ... for it I would like to ensure there's no error in server.log.