log_id not incrementing

Classic Servoy
1

Environment

  1. Backend is Postgres 8.2.1. (Fedora Core 6 Linux os)
  2. Servoy Developer 3.1.4

I have set up a postgres database for the log table. Had Servoy build the log table. And now it only keeps the first log.

The log_id is 0 and not incrementing. When I go into the database and turn off the unique identifier limitation on the log_id all entries are logged correctly except for the log_id.

So… everything is working great except for the log_id. Is this a postgres issue or Servoy? And how would I go about fixing this? I have tried deleting the log database and reinstalling… just about everything. Please let me know if you have an answer to this problem of mine.

Thanks

Hope the following insert looks correct on the post…

log_id server_name table_name column_name log_action pk_data old_data new_data event_time user_name
0 test qwerty type_here 3 2.41; d 2007-05-07 06:37:44.79 5
0 test qwerty type_here 3 2.41; fsdafa fs 2007-05-07 07:30:20.77 5
0 test qwerty type_here 3 2.42; ssdfssdas ssd 2007-05-07 07:30:26.598 5
0 test qwerty type_here 3 2.43; f fhbsdjfshdk 2007-05-07 07:30:28.974 5
0 test qwerty type_here 3 2.44; d dlksjd 2007-05-07 07:30:31.96 5
0 test qwerty type_here 3 2.41; fs asjhdlsaiw 2007-05-07 07:30:35.297 5
0 test qwerty type_here 3 2.43; fhbsdjfshdk fh 2007-05-07 07:30:39.792 5
0 test qwerty type_here 3 2.44; dlksjd dl 2007-05-07 07:30:42.416 5
0 test qwerty type_here 3 2.45; s sdshahsd 2007-05-07 07:30:45.024 5
0 test qwerty type_here 3 2.43; fh fhjhdsfkjshd 2007-05-07 07:30:50.419 5

2

Hi,

Getting the same thing today turning on logging first time. I found it on an old post here too: http://forum.servoy.com/viewtopic.php?t=6819

I deleted tables, changed databases etc and restarted , everything, can’t get it working past the first one.

I get it using Mysql or Sybase, doesn’t matter.

Servoy Developer
Version 3.1.4-build 408
Java version 1.6.0_01-b06 (Windows XP)

3

I got it working.

It looks like when it auto creates the table it doesn’t give log_id a sequence. I just used Servoy Define Dataproviders and used Servoy “Sequence” to set it. Worked after that. Default was “Value”.

4

This might be related to this issue:
http://forum.servoy.com/viewtopic.php?t=7815

DomTom

I hope this will help you.

5

Thanks for the help.

Thanks JapanDev for the fix I used.

Here is my noob explanation of my fix… for noobs/by noobs

Opened a solution in Developer and went to Tools-Designer.
Then went to Tools-Dataproviders–
and chose the log_server then the log ‘table’ in the log_server
Open the properties for log_id
Select sequence… servoy seq.

Save all changes and rock-and-roll.

Thanks for the help… now bring on the next challenge.
:wink: :wink: :wink:

6

Hi,

This will be fixed in Servoy 3.1.5, when the log table is created by servoy, the id column will become a servoy-sequenced one automatically.

Rob