[TYPO3] Does the 1-2-3 install tool use DBAL?

Daniel Smedegaard Buus daniel at polyteknisk.it
Mon Oct 2 11:55:36 CEST 2006


Hey there...

Still struggling with this IIS/MSSQL/TYPO3 setup. I got most working I 
think, but doing "Compare" in the 1-2-3 install tool and trying to 
create the missing tables results in this error screen:

*Warning*: Variable passed to each() is not an array or object in 
*c:\Inetpub\wwwroot\t3t\typo3\sysext\dbal\class.ux_t3lib_db.php* on line 
*1660*

*Warning*: Variable passed to each() is not an array or object in 
*c:\Inetpub\wwwroot\t3t\typo3\sysext\dbal\class.ux_t3lib_db.php* on line 
*1660*
ERROR: Query could not be parsed: "SQL engine parse ERROR: No ) 
parenthesis in list: near "(199)) ) "". Query: "CREATE TABLE 
sys_refindex ( hash varchar(32) NOT NULL default '', tablename 
varchar(40) NOT NULL default '', recuid int(11) NOT NULL default '0', 
field varchar(40) NOT NULL default '', flexpointer tinytext NOT NULL, 
softref_key varchar(30) NOT NULL default '', softref_id varchar(40) NOT 
NULL default '', sorting int(11) NOT NULL default '0', deleted int(11) 
NOT NULL default '0', ref_table varchar(40) NOT NULL default '', ref_uid 
int(11) NOT NULL default '0', ref_string varchar(200) NOT NULL default 
'', PRIMARY KEY (hash), KEY lookup_rec (tablename,recuid), KEY 
lookup_uid (ref_table,ref_uid), KEY lookup_string 
(ref_table,ref_string(199)) );"

To me, all the CREATE statements look like I know them from working with 
MySQL. I would have expected them to look a bit different for MSSQL, 
knowing Microsoft's attitude towards standards. I'm thinking (read: 
fearing) that the install tool does not itself use the DBAL, meaning the 
installer is MySQL specific. Is this true? And, if so, how do I get it 
to install onto MSSQL?

Thanks for any help you might offer,
Daniel Buus



More information about the TYPO3-english mailing list