Users quota not created

[clefranc]

Hi,
When using Bulk Accounts creation, users quota and other attributes are not created. I can't even enter value in the Users page, I click save and the values are erased. I'm using FirstSpot v5.1.0 on Windows 2003 and SQL 2005 Express.

What I'm doing wrong?

Thanks,
Christian

[alan]

Sorry, FirstSpot doesn't support SQL Express.

Either you use the default datasource, or use the exact version of MySQL or MS SQL stated in readme.rtf.
_________________
~ Patronsoft Limited ~

[clefranc]

Sorry, my mystake, I've installed MySQL and it work now. But I wonder what's missing in the Express version of SQL Server 2005?

Thanks,
Christian

[clefranc]

Ok, still my mystake, it doesn't work with MySQL and MSSQL. The test I did with MySQL was with a user created using the Users tab, I then created a batch of users with Bulk Accounts. When I try to modify any of them, the values are revert back to original, like MSSQL. Only with the default database, I can change values.

All this because I'm trying to use the TOTAL data transfer on Bulk Accounts, it doesn't copy from the plan I choose (even using the default database).

So now I'm back to square one with another problems : TOTAL data transfer not copied from Plans to Bulk Accounts.

Christian

[dominic]

Please download the patch file from the link shown below:

http://patronsoft.com/firstspot/download/patch/511/settingok.zip

Then, unzip it and put settingok.php into FirstSpot\cfgmgr directory. Remember to backup the original file before copying.

This problem will be fixed in the coming versions, starting from v5.1.1.

[clefranc]

Thanks Dominic,
The patch solved both problems. I've tested it with the default database and MySQL.

BTW, MSSQL Express works fine too (for the tests I've done so far), so can you tell what's the limitation or missing functionality of the Express edition vs the full one?

Christian

[alan]

We never test SQL Express, so we still don't recommend you to use it.
_________________
~ Patronsoft Limited ~

[clefranc]

When using MySQL I can't set "Account is active" to "Now" in the "Users" tab, it go back to "At the user's first login". Also, can you verify that "When it is created" option of the plan's attribute "Account is active" don't set "Now" for the user's attribute "Account is active" when using Bulk Accounts creation (still using MySQL). Default database is OK in both case.

Christian

[clefranc]

To solve this problem I've modified line 760 of ..\authserv\common_functions.php from "if ($smode)" to "if (!is_null($smode))". The code for the $smode variable now look like this:

[dominic]

Line 760 needs to be changed from