Module installation problem

[dskanth]

Hai, I have a problem with the module installation. Iam trying to install CE Teams module using sql server as the backend.
First i tried the latest version 1.0.5 and the installation is done with some sql errors, and i find no link to the module in the 'Admin' page.

Then i tried version 1.0.4 and the installation went fine, with just one sql error, complaining the datatype issue. But when i create a team, its not shown in the Teams list,
and also when i try to select a team from the popup, i dont see any teams.
In both cases, I get sql error like:

SQL Error : An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.

[dskanth]

Here is the summary of what i have done:

I have been able to install the CE Teams module easily, using 1.0.4 version.Iam using mssql database and after the installation, it showed me this message:
Including: D:\XAMPP\htdocs\sugarms\cache\upload\upgrades\temp \37.tmp/scripts/post_install.php
SQL Error : 'NOW' is not a recognized built-in function name.Setting default team failed
Module Install Successful
(Hope we need to modify the query in the post_install.php file for 'NOW' field (for sql server))

But when i create a team, it is not shown in the team list, and i get this error:
SQL Error : An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.

Also, when i select a team while creating a Lead, i get an empty list in the popup, with the same error.


If iam using 1.0.5 version with sql server, the module is installed, with the above sql error, but the problem is, when i open the Studio page, i see some SQL
error, "SQL Error : Invalid object name 'ceteams_config'.The ceteams_config SELECT failed" at the top, and nothing else below that.

Also, more annoying, i dont see the link to the CE Teams module in the admin page. There is no label even, it just shows as LBL_CETEAMS_TITLE and LBL_CETEAMS_DESC.
Dont know what went wrong during the installation.

Can somebody help me with this?

[dskanth]

Ha.. finally i got the solution, its a mssql server database problem. It does not support the where syntax used in the module. In Teams module, where is initialises as ($where=1 and used in queries.
But i have modified it to ($where = 1=1); Then the boolean condition worked and i saw no errors.