KonaKart Community Forum

Installation / Configuration => Installation of KonaKart => Topic started by: gkrusty on February 22, 2010, 10:15:06 am

Title: instalation sql server
Post by: gkrusty on February 22, 2010, 10:15:06 am
I am installing konakart 4.2.0.1 (Windows) on SQL Server 7.00 and I get this error message during installation :

INSERT INTO kk_api_call (name, description, date_added) VALUES ('importDigitalDownload','', getdate())
DROP FUNCTION KK_IF
Message:   LĂ­nea 1: sintaxis incorrecta cerca de 'FUNCTION'.
SQLState:  37000
ErrorCode: 170
_____________________________________________________________
SQL execution failed.



What version of sqlserver is supported by Konakart?

How can I solve this problem?

Thanks. Best Regards.


Title: Re: instalation sql server
Post by: heidi on February 22, 2010, 12:07:33 pm
So it appears that SQL Server 7 doesn't support FUNCTION definitions.  You'll need a more recent version of SQL Server that supports those.  I'm not certain when they introduced support for FUNCTIONs..  but SQL Server 7 is pretty old now (? 1998).   I know that SQL Server 9 (SQL Server 2005) works fine so I expect that newer versions also work...   SQL Server 8 (SQL Server 2000) may also work, but I haevn't tried it myself.