Cannot login to konakart admin under Oracle

[clinton]

We believe there is an error with the Oracle update script: konakart/databases/Oracle/upgrade_2.2.0.6_to_2.2.0.7.sql

The error prevents anyone from logging in to the admin app.  A sample of the error is:

  INSERT INTO kk_role_to_panel (role_id, panel_id, can_edit, can_insert, can_delete, date_added) VALUES (kk_role_seq.nextval,  1, 1,1,1,sysdate);

Since kk_role_seq.nextval is used, this results in an ascending no. of role_id's, whereas there are only 4 roles defined. The MySQL update script shows the real intent:

  INSERT INTO kk_role_to_panel (role_id, panel_id, can_edit, can_insert, can_delete, date_added) VALUES (1, 1, 1,1,1,now());

Many thanks to my colleague Tim for helping fix this problem and for creating the attached ammended upgrade script, which allowed us to login using the admin@konakart.com user.

Some extra doco on this subject would have been helpful, unless I missed it?

- Clinton

[Brian]

Hi Clinton,

We generate all the database scripts from the MySQL ones and we have incorrectly converted the literal roleIds to kk_role_seq.nextval for the kk_role_to_panel which clearly makes no sense for that table.

We'll fix this for the next version.

Regards,
Brian

[paolo]

Hi Clinton,

We've added some documentation to the configuration FAQ and as always, the Admin App has online help for each of the panels which guides you through the process of creating and configuring roles. There probably isn't the detailed level of information that you were looking for in order to figure out this problem, but well done to you (and Tim) for figuring it out.

Cheers,

Paolo