[TYPO3] Typo3 / DBAL / ADODB / MSSQL: Violation of primary Key

[Tristan Knapp]

The first thing I would look at is the connection information. What does 
your connection string look like?

I will be trying this in the next couple of days, I will fill you in if I 
run into the same problem...

"SassoNet - Stefan Gruendel" <info at sassonet.de> schrieb im Newsbeitrag 
news:mailman.656.1149689961.17090.typo3-english at lists.netfielders.de...
> Hi,
>
> I am struggling with the combination of Typo3, DBAL, ADODB and MSSQL,
> running on an IIS server for some days now.
>
> After setting up everything and defining a new page from fresh (which all
> works without major problems), I am getting the following messages once I 
> am
> viewing the new page:
>
> Warning: mssql_query(): message: Violation of PRIMARY KEY constraint
> 'PK__cache_hash__37A5467C'. Cannot insert duplicate key in object
> 'cache_hash'. (severity 14) in
> C:\...\typo3\typo3conf\ext\adodb\adodb\drivers\adodb-mssql.inc.php on line
> 701
>
> Warning: mssql_query(): Query failed in
> C:\...\typo3\typo3conf\ext\adodb\adodb\drivers\adodb-mssql.inc.php on line
> 701
>
> These are the facts of the installation:
> OS: MS Windows Server 2003 Std Edition (NT 5.2 - 3790)
> MSSQL: SQL Server Std Edition Version 9.00.194 (RTM), English MS Internet
> Information Services 6.0 PHP 4.4.1 MS Internet Explorer 6.0
>
>
> To give you the complete picture, I have done the following steps before:
>
> 1 - Installation of Typo3 4.0 package, with Dummy
> 2 - Copy DBAL & ADODB extensions in /typo3conf/ext
> 3 - Configure DBAL localconf.php (dbal/handlerCfg) according to DBAL
> documentation (part 1.4): DBAL Type = "adodb" / Driver = "mssql"
> 4 - Change /typo3/install/index.php (inactivate row which prevents install
> script to be executed)
> 5 - Create new MSSQL database with name "typo"
> 6 - With MSSQL Enterprise Manager change properties of new database 
> "typo":
> Set options to "Use quoted identifiers" and "ANSI NULL default"
> 7 - Create new MSSQL user with name "typo"; give all access rights on the
> new database to this user
> 8 - Run typo3 installation script from browser (/typo3/install/index.php)
> 9 - Enter "Basic Configuration", enter username, password and host (MSSQL
> pipe) for database, confirm with "update localconf.php"
> 10 - Back to "Basic Configuration", all databases on host are shown in 
> drop
> down list, database "typo" is selected
> 11 - Enter Database Analyzer, it says "connected to SQL database
> successfully, database typo has 0 tables". Click on "COMPARE" to update
> required tables, a lot of "CREATE TABLE" statements are displayed,
> automatically ticked and confirmed with "Write to database"
> 12 - "Changing fields" is proposed, but not done as I think this might be 
> a
> problem between typo3 and MSSQL
> 13 - Database Analyzer: Select "IMPORT" on Dump static data; select tick 
> box
> "Import the whole file CURRENT_STATIC directly", confirm with "Write to
> database"
> 14 - Database Analyzer: Create admin user (message: "User created")
> 15 - Login to backend of typo3 with freshly created admin user (working
> fine)
> 16 - Create new page (using wizard) and new page content on that page
> (regular text element)
> 17 - Select "Template", typo3 says "No Template"; select "template;
> BUSINESS" from drop down list, confirm with "Create template for a new
> site". "Are you sure.?" is confirmed with OK, next page is confirmed with
> update
> 18 - Select "View", getting the mentioned error messages.
>
>
> Maybe anyone has encountered the same and solved this or can see any hint 
> of
> what's going wrong?
>
> Thanks in advance
> Stefan
>
>
>