Doesn't like to import MS SQL tables that have autoincrement fields starting from 0. Best to take off MSSQL increment from field, import, then establish increment again.

Affects: setup, user_type tables which have record_id=0.

setup/Page_Type_fields.cfm query rewritten:

<CFQUERY Name="Field_Names" DATASOURCE = "#request.server.datasource#" username="#request.server.sql_user#" password="#request.server.sql_password#" >

SELECT DISTINCT page_type.PAGE_TYPE, f.field_name as name, f.Context, f.search_indexes, f.text_languages

FROM page_type, Form, Page_Links, Field as f

WHERE Form.Group_ID = page_type.Form_ID

AND Page_Links.Parent_ID = Form.Group_ID

AND Page_Links.Child_ID = f.Group_ID

AND f.field_name > ''

AND page_type.Form_ID > 0

ORDER BY Page_Type

</CFQUERY>

init_application.cfm:

DELETE FROM

<CFIF request.server.sql_type is 2>

user

<CFELSE>

[user]

</cfif>

WHERE ((Password = '' Or (Password) Is Null)

AND (Dedicated_IP = '' Or (Dedicated_IP) Is Null)

AND (logon_Time_Stamp < #dateadd('d',-1, now())#))

<!--- 'n',-(request.site.timeout) -1,--->

init_paths.cfm: MySQL doesn't like backslashes

UPDATE Home_Page

SET file_path = <CFQUERYParam value="#request.site.file_path#" cfsqltype="CF_SQL_VARCHAR">

WHERE file_path is null

<- ->