java.lang.long error displaying the user list

Classic Servoy
1

Hi,

We just upgraded our production server to 2.2.1 final. Checking out the Admin page, I noticed that there is still an error displaying the users on the User page.

In the Source of the page is the following:

<table border="0" width="100%">
<tr><td colspan="2"><b>Create new user</b>
<tr><td>Username:<td><input name="username" type="text" size="80">
<tr><td>Password:<td><input name="password1" type="password" size="80">
<tr><td>Password (again):<td><input name="password2" type="password" size="80">
<tr><td>

<input name="submit" type="submit" value="Create user">
<tr><td colspan="2">
<font color="red">java.lang.Long</font>
<tr><td colspan="2">

<b>User list</b>
<tr><td colspan="2">
<font color="red">Could not list users: java.lang.Long</font></td></tr>
</table>

As you can see, there are “java.lang.Long” messages, where the list of users ought to be.

Paul

Running on Linux RedHat and Oracle 9i

2

That problem comes and goes… ;-) Works in my latest build…

3

You make your own private builds?!?! :lol:

I can only say we always have this situation on our production environment…

4

I keep a history on builds… :lol:

5

Hi,

This was a bug and is fixed in the next release. It should not depend on the release though, but more on the backend database used for the repository. (The user_id column of the servoy_users table must be an integer, not a long integer).

6

Sebastiaan,

I’m now running Servoy 2.2.4 with an Oracle 9 Repository database and still get the errors on the users page of the ADMIn pages:

java.lang.Long

User list

Could not list users: java.lang.Long

I looked at the definition of the user_id column in the servoy_users table and it’s defined as number(10).

Is this correct? If so, then something is still wrong in the code, I think. If the definition of the field is wrong: What should it be then?

Paul