Hi support,
I have a peculiar problem I don´t understand and hoping for some enlightenment from you (or anyone else that knows the answer). I try to connect to an external database using a MySQL auto-incremented number field as primary key and I get the error message "Value for primary key meta_id is not defined." which isn´t correct (the meta_id is auto-incremented and all rows are populated).
Aware settings:
DB field settings:
Thanks in advance
Value for primary key is not defined?
Value for primary key is not defined?
Henrik (V8 Developer Ed. - Windows)
Unsigned culprit
Update:
The problem seems to be that the field use the "unsigned" setting for the field, I removed it and then all works as it should. Is this a bug or can´t Aware handle unsigned? The problem is not just with the primary key thing, Aware can´t read unsigned fields at all (all unsigned fields are displayed as empty in Aware queries).
Thanks
The problem seems to be that the field use the "unsigned" setting for the field, I removed it and then all works as it should. Is this a bug or can´t Aware handle unsigned? The problem is not just with the primary key thing, Aware can´t read unsigned fields at all (all unsigned fields are displayed as empty in Aware queries).
Thanks
Henrik (V8 Developer Ed. - Windows)
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Value for primary key is not defined?
Sounds like a bug. We'll check it out
Aware IM Support Team
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Value for primary key is not defined?
Not sure what you are testing etc. but the bug is if the DB field has "unsigned" enabled for the primary key field/column. If it has, Aware does not display the value in the primary key field in Aware queries etc. and it also not possible to change stuff. In your tests, do you see the value of the primary key field in Aware? Can you change stuff? Is the field set with unsigned enabled in the DB?
Henrik (V8 Developer Ed. - Windows)
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Value for primary key is not defined?
I have created an integer column in MySQL with the UNSIGNED attribute. When discovering attributes for the table I have specified this column to be the primary key. Then I have defined a query that shows values of this table and the Edit operation with records.
The query works fine and I can also edit and change records (not the primary key, though)
The query works fine and I can also edit and change records (not the primary key, though)
Aware IM Support Team
Re: Value for primary key is not defined?
Strange, sounds right and same as my setup and does not work for me. I am on v8.2 b2565.aware_support wrote:I have created an integer column in MySQL with the UNSIGNED attribute. When discovering attributes for the table I have specified this column to be the primary key. Then I have defined a query that shows values of this table and the Edit operation with records.
The query works fine and I can also edit and change records (not the primary key, though)
Henrik (V8 Developer Ed. - Windows)
Re: Value for primary key is not defined?
This problem still exists today. I was trying to connect to a WP DB and had the same exact issue + solution. I am on Aware 8.5 (build 2830).
Henrik (V8 Developer Ed. - Windows)