Possible VServer Bug?? on V4MD
Ruslan Zasukhin
sunshine at public.kherson.ua
Tue Jul 20 22:27:16 CDT 2004
On 7/20/04 10:01 PM, "X Y" <xyzabc1010 at yahoo.com> wrote:
Hi,
1) check your UPDATE and INSERT query using viSQL or Valentina Studio again
LOCAL database.
Btw, using Valentina Studio you can do SQL query and immidiatly check result
using table browser.
2) if LOCAL version correctly do that queries then problem really in
client/server. I think will be good if you will send simple V4MD project
that do this 2 queries and show problem.
> Hi All,
> I have downloaded the latest version of VServer and
> have been running into the following situation.
> Everytime I insert a record the id of the newly
> inserted record is set to 0 instead of the parameter
> that I passed. In addition, Updates does not update
> for integers.
>
> Running in a Windows environment, everything works
> well; however. running in an OSX (where both client &
> server are OSX) I get the above error.
>
> I set the log to verbose and received no errors
> whatsoever. Here is the output log from the server:
>
> 14:51:52.181996 (2684358124): Database kernel inited
> 14:51:52.228586 (2684358124): Server started at 15432
> port
> 14:52:17.904112 (379600): Connection established with
> '10.250.8.159:49201' (13)
> 14:52:17.910929 (381280): (13) Database: <none>;
> User: sa: OK
> 14:52:17.915180 (381280): Closing connection (13)
> 14:52:23.462202 (379600): Connection established with
> '10.250.8.159:49202' (13)
> 14:52:23.587759 (380400): (13) Database:
> lexiadatamanager; User: sa: OK
> 14:52:31.157682 (380400): (13) SQL: select group_id
> from Group WHERE group_name = 'Phonics Based Reading'
> AND group_tag = 'PBR'; # of records: 0
> 14:52:38.685274 (380400): (13) SQL: select max_id
> from TableMaxID where table_name = 'Group'; # of
> records: 1
> 14:52:38.687287 (382080): (13) CURSOR(0xC5AF60):
> FirstRecord : OK
> 14:52:38.689383 (379600): (13) CURSOR(0xC5AF60):
> Updating record #1: OK
> 14:53:10.746429 (379600): (13) SQL: SELECT * FROM
> Group; # of records: 0
> 14:53:10.750093 (380400): (13) CURSOR(0xC5AF60):
> Adding record #1: OK
> 14:53:10.756437 (382080): (13) Flushing
> 'lexiadatamanager' database: OK
> 14:53:17.242184 (380400): (13) SQL: select recId,
> group_id, group_tag, group_name, serial_no from Group
> where Group.group_id = 24; # of records: 0
>
> Any help would be much appreciated.
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
More information about the Valentina
mailing list