Domain creation issue

[Gian69]

When I create a new domain in plesk 7.6.1 the procedure seems to work smoothly...the domain is created but, clicking on the domains tab I get the following error message:

<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> The data conversion from char to datetime caused a datetime value outside the valid interval.

(MY TRANSLATION FROM ITALIAN, SORRY)

The plesk staff advised to try a repair of the psa database, which I did but without results...

Any advise on this?

Thanks
---------------------- Debug Info -------------------------------
0: C:\Programmi\SWsoft\Plesk\admin\plib\common_func.php3:249
com->execute(string 'SELECT sum(dt.http_in) + sum(dt.ftp_in) + sum(dt.smtp_in) + sum(dt.pop3_imap_in) + sum(dt.http_out) + sum(dt.ftp_out) + sum(dt.smtp_out) + sum(dt.pop3_imap_out) FROM DomainsTraffic dt WHERE (dt.date between '2006-10-01' and '2006-10-25') AND (dt.dom_id=3)', NULL null)
1: C:\Programmi\SWsoft\Plesk\admin\plib\common_func.php3:249
db_query(string 'SELECT sum(dt.http_in) + sum(dt.ftp_in) + sum(dt.smtp_in) + sum(dt.pop3_imap_in) + sum(dt.http_out) + sum(dt.ftp_out) + sum(dt.smtp_out) + sum(dt.pop3_imap_out) FROM DomainsTraffic dt WHERE (dt.date between '2006-10-01' and '2006-10-25') AND (dt.dom_id=3)')
2: C:\Programmi\SWsoft\Plesk\admin\plib\class.TrafficData.php:72
TrafficData->getDomainMonthTraffic(string '3')
3: C:\Programmi\SWsoft\Plesk\admin\plib\class.DomainsList.php3:276
DomainsList->fetchDomainsList()
4: C:\Programmi\SWsoft\Plesk\admin\plib\class.cList.php3:93
cList->fetchList()
5: C:\Programmi\SWsoft\Plesk\admin\plib\class.cList.php3:112
cList->init()
6: C:\Programmi\SWsoft\Plesk\admin\htdocs\domains\domains.php3:213

 

[Gian69]

Well, guys....

I have to say that this forum is pretty full with questions and issues and quite poor with answers...and not only in my case.

Anyway, I have some news that I wanted to share with the community. After a long email quarrel with swsoft's technical support staff (who wanted me to pay a per incident support fee obviously caused by some bug in their software) I finally got them to check the situation and provide a solution. Well, the solution was - guess what - leave the remote MSSQL db and use a psa MySQL db. They asked me not to use MSSQL until next release (either minor or minor) that's what they said... So? Plesk 7.6.1 doesn't support MSSQL database? Or the problem is in my italian version?

Anybody has a hint on that? Opinions? Experiences? Any other people thinking that this plesk software is a pain in the *** and it is poorly supported??