I have a records table

Username
Product
Code

on cook 1.5
I can edit records on admin page without any problem


on cook 2.0
once I edit the the record and save ... the username becomes admin as default even if you change it to another user once you save it it will be admin by default


Please check..
Thanks

Before Saving...

Cook Version 2.0
- Change the user
- Apply the changes

Then you can save as needed and the new user will stick

that is what I did ... but after save the user that I update goes back to admin

I update a record to
User: mickael
then save...
record still show user for that record is admin


kindly check please refer to
sandbox.cms25.j-cook.pro/administrator/i...odreg&layout=default

also tried to rebuild on 2.0 but with no luck


also if you ask me to change user in admin before editing my table record...
it would be not that easy since all my records are created by different user
I cannot change to their username before I edit each of their records....
just imagine if i have 1000+ records to edit with 50 records per user

also I cannot give admin permission to registered user

There is no problem with cook 1.5 same coding but when I save it to cook 2.0 this problem came

Any Updates about this issue?

jasonsevilla wrote: that is what I did ... but after save the user that I update goes back to admin

I update a record to
User: mickael
then save...
record still show user for that record is admin


kindly check please refer to
sandbox.cms25.j-cook.pro/administrator/i...odreg&layout=default

also tried to rebuild on 2.0 but with no luck


also if you ask me to change user in admin before editing my table record...
it would be not that easy since all my records are created by different user
I cannot change to their username before I edit each of their records....
just imagine if i have 1000+ records to edit with 50 records per user

also I cannot give admin permission to registered user

There is no problem with cook 1.5 same coding but when I save it to cook 2.0 this problem came

Good Day .. just want to ask if there is any updates regarding this issue?

jasonsevilla wrote: also tried to rebuild on 2.0 but with no luck ... There is no problem with cook 1.5 same coding but when I save it to cook 2.0 this problem came

OK, I think I know what's going on here... I believe that you've probably instanced an author wizard in the 1.5 version, right? If so, there are incompatibilities because of differences in the wizard to generate a J1.5 compatible version compared with that for a J2.5 version.

TODO:

1. Remove the authoring wizard and field by dragging to trash can
2. Confirm deletion for both items when prompted
3. Re add the author wizard & generate the field using the green '+' button
4. Re add the field to your grid, fly and form layouts
5. Re add the field to any filters you may have already defined for them
6. Regenerate by clicking sandbox

Hope this helps!

G

Done that instruction but got an error when i run the sandbox

JInstaller: :Install: Error SQL DB function failed with error number 1054
Unknown column '' in 'field list' SQL=INSERT INTO `[PREFIX]demo7291_userprodreg` (`id`,`params`,``,`product_name`,`product_code`,`date_created`,`date_modified`,`flavor_name`,`access`,`active`) VALUES (14,'',1,'','a990099','2012-12-19','2012-12-27',4,1,1) ,(12,'',10,'','123123','2012-12-19','2012-12-27',3,1,1) ,(11,'',10,'','1234567','2012-12-19','2012-12-20',1,1,1) ,(16,'',10,'','a1231234','2012-12-19','2012-12-27',3,1,1) ,(18,'',10,'','12321','2012-12-22','2012-12-27',3,1,1) ,(19,'',10,'','1112','2012-12-22','2012-12-27',4,1,1) ,(20,'',10,'','ghdfgdf','2012-12-22','2012-12-27',4,1,1) ,(21,'',9,'','998899','2012-12-27','2012-12-27',1,1,1) ,(22,'',9,'','11111','2012-12-27','2012-12-27',1,1,1) ,(23,'',9,'','222222','2012-12-27','2012-12-27',3,1,1) ,(24,'',9,'','333333','2012-12-27','2012-12-27',3,1,1) ,(25,'',9,'','321456987','2012-12-27','2012-12-27',1,1,1) ,(26,'',9,'','456456','2012-12-27','2012-12-27',1,1,1) ,(27,'',10,'','7896523','2012-12-27','2012-12-27',2,1,1);
SQL =

INSERT INTO `vs4go_demo7291_userprodreg` (`id`,`params`,``,`product_name`,`product_code`,`date_created`,`date_modified`,`flavor_name`,`access`,`active`)
VALUES
(14,'',1,'','a990099','2012-12-19','2012-12-27',4,1,1)
,(12,'',10,'','123123','2012-12-19','2012-12-27',3,1,1)
,(11,'',10,'','1234567','2012-12-19','2012-12-20',1,1,1)
,(16,'',10,'','a1231234','2012-12-19','2012-12-27',3,1,1)
,(18,'',10,'','12321','2012-12-22','2012-12-27',3,1,1)
,(19,'',10,'','1112','2012-12-22','2012-12-27',4,1,1)
,(20,'',10,'','ghdfgdf','2012-12-22','2012-12-27',4,1,1)
,(21,'',9,'','998899','2012-12-27','2012-12-27',1,1,1)
,(22,'',9,'','11111','2012-12-27','2012-12-27',1,1,1)
,(23,'',9,'','222222','2012-12-27','2012-12-27',3,1,1)
,(24,'',9,'','333333','2012-12-27','2012-12-27',3,1,1)
,(25,'',9,'','321456987','2012-12-27','2012-12-27',1,1,1)
,(26,'',9,'','456456','2012-12-27','2012-12-27',1,1,1)
,(27,'',10,'','7896523','2012-12-27','2012-12-27',2,1,1);

Component Install: SQL error file DB function failed with error number 1054
Unknown column '' in 'field list' SQL=INSERT INTO `[PREFIX]demo7291_userprodreg` (`id`,`params`,``,`product_name`,`product_code`,`date_created`,`date_modified`,`flavor_name`,`access`,`active`) VALUES (14,'',1,'','a990099','2012-12-19','2012-12-27',4,1,1) ,(12,'',10,'','123123','2012-12-19','2012-12-27',3,1,1) ,(11,'',10,'','1234567','2012-12-19','2012-12-20',1,1,1) ,(16,'',10,'','a1231234','2012-12-19','2012-12-27',3,1,1) ,(18,'',10,'','12321','2012-12-22','2012-12-27',3,1,1) ,(19,'',10,'','1112','2012-12-22','2012-12-27',4,1,1) ,(20,'',10,'','ghdfgdf','2012-12-22','2012-12-27',4,1,1) ,(21,'',9,'','998899','2012-12-27','2012-12-27',1,1,1) ,(22,'',9,'','11111','2012-12-27','2012-12-27',1,1,1) ,(23,'',9,'','222222','2012-12-27','2012-12-27',3,1,1) ,(24,'',9,'','333333','2012-12-27','2012-12-27',3,1,1) ,(25,'',9,'','321456987','2012-12-27','2012-12-27',1,1,1) ,(26,'',9,'','456456','2012-12-27','2012-12-27',1,1,1) ,(27,'',10,'','7896523','2012-12-27','2012-12-27',2,1,1);
SQL =

INSERT INTO `vs4go_demo7291_userprodreg` (`id`,`params`,``,`product_name`,`product_code`,`date_created`,`date_modified`,`flavor_name`,`access`,`active`)
VALUES
(14,'',1,'','a990099','2012-12-19','2012-12-27',4,1,1)
,(12,'',10,'','123123','2012-12-19','2012-12-27',3,1,1)
,(11,'',10,'','1234567','2012-12-19','2012-12-20',1,1,1)
,(16,'',10,'','a1231234','2012-12-19','2012-12-27',3,1,1)
,(18,'',10,'','12321','2012-12-22','2012-12-27',3,1,1)
,(19,'',10,'','1112','2012-12-22','2012-12-27',4,1,1)
,(20,'',10,'','ghdfgdf','2012-12-22','2012-12-27',4,1,1)
,(21,'',9,'','998899','2012-12-27','2012-12-27',1,1,1)
,(22,'',9,'','11111','2012-12-27','2012-12-27',1,1,1)
,(23,'',9,'','222222','2012-12-27','2012-12-27',3,1,1)
,(24,'',9,'','333333','2012-12-27','2012-12-27',3,1,1)
,(25,'',9,'','321456987','2012-12-27','2012-12-27',1,1,1)
,(26,'',9,'','456456','2012-12-27','2012-12-27',1,1,1)
,(27,'',10,'','7896523','2012-12-27','2012-12-27',2,1,1);

There was an error installing the package

Try flushing data set and retry... I think it's because the fields themselves have changed datatype when wizards have been updated.

G

it works thanks Problem Fixed

Great!