bug?

[johan]

Hi,

I often get this error

An error has occurred on site 'db/reg'
Error Reference: 5637246
SQL

INSERT INTO zzsys_variable (zzsys_variable_id, sva_id, sva_expiry_date, sva_session_id, sva_name, sva_value, sys_added) VALUES ;
Transaction

No Transaction.
Error

This is since a few builds ago. I don't know what's wrong and it does'nt happen every time.

Johan

[admin]

Johan,

I'll need more info..

Steven

[johan]

Steven,

I was afraid for that. Problem is that I don't know when it happens. I think it's got to do something with the reports. I got several databases running and it happens in a few of them.

Since I can't upload pdf, you can get the complete report in my dropbox https://dl.dropbox.com/u/57568813/report.pdf

Johan

[admin]

johan,

Sorry, this didn't help.

Let me know when you can reproduce it.

BTW you probably know you can attach anything if its zipped up.

Steven

[johan]

Steven,

I let you know when I can reproduce the error.

BTW what is zzsys_variable used for? I see that column sva_table is empty and not in the query.

INSERT INTO zzsys_variable (zzsys_variable_id, sva_id, sva_expiry_date, sva_session_id, sva_name, sva_value, sys_added) VALUES ;

Johan

[admin]

Johan,

Empty zzsys_variable and open an Edit Form. Then go back and look what zzsys_variable has in it.

It keeps client side object values on the server.

For Reports etc.

Steven

[johan]

Steven,

I see that every object, value,... of the edit form is in it, only sva_table stays empty (null). Is it used?

Johan

[admin]

Johan,


Its used for storing Listbox Object data.

Steven

[johan]

Steven,

The error comes when I click on a record in the browse screen to open the edit screen. It does'nt happen every time and I'm afraid it got something to do with the internet connection on some locations (to slow?).

Other problem is when I delete a record of a subform (using browseform in a editform) I get a white screen.
This happens also with save and close.

Johan

[admin]

johan,

It is a bug.

It will be fixed in the next update..

Steven