Messages

Hi kate,

thank you for your trouble. I didn't understand it, too.

I'm also accustom that the database convert this automatically...

But thank you, that you take the changes regardless.

Best Regards,
Christoph

Hello,

i'm trying to install konakart with the installer under linux.
But it coundn't complete the database installation.
Out database is an oracle express edition (v2.1.0.00.39).

In the database/Oracle/konakart_demo.sql file was an error
in line 1160 and 1161 which stops the installation with an SQL error.

As workaround you can start the installation (select an installation folder and so on),
and modify the extracted SQL files befor the installation programm try to push them into the database.

In both lines the single quote (') around the value colum (around 1.0000 and 1.1036) must be removed.

Instead of:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2','1.0000', sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2','1.1036', sysdate);

It must be:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2',1.0000, sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2',1.1036, sysdate);


I hope the KonaKart team will fix this in a later version. ;-)


Best regards,
Christoph Jerolimov