Installation - IIS6 & MSSQL2005 problems

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
rekabis
Registered User
Posts: 8
Joined: Sat Nov 10, 2007 7:50 am
Location: Kelowna, British Columbia, Canada
Contact:

Installation - IIS6 & MSSQL2005 problems

Post by rekabis »

Greetings,

My system:
Windows Server 2003 SP2
IIS 6
MSSQL 2005 (NOT Express!)

When installing, I come across one big problem and one annoying problem.

First, the very big one. At the very last step, when I move to the “Final Stage” of the install, I get this error message:

Code: Select all

General Error
SQL ERROR [ mssql_odbc ]

[Microsoft][SQL Native Client][SQL Server]Unclosed quotation mark after the character string '3.00'. [37000]

SQL

UPDATE phpbb_users SET group_id = 6, user_colour = '9E8DA7', user_rank = 0 WHERE user_id = '3.00�'

BACKTRACE

FILE: ncludes/db/mssql_odbc.php
LINE: 149
CALL: dbal->sql_error()

FILE: ncludes/functions_user.php
LINE: 3097
CALL: dbal_mssql_odbc->sql_query()

FILE: ncludes/functions_user.php
LINE: 270
CALL: group_set_user_default()

FILE: nstall/install_install.php
LINE: 1827
CALL: user_add()

FILE: nstall/install_install.php
LINE: 111
CALL: install_install->add_bots()

FILE: nstall/index.php
LINE: 402
CALL: install_install->main()

FILE: nstall/index.php
LINE: 274
CALL: module->load()
Backing up and trying again (or reloading the page) only gets me this error message:

Code: Select all

General Error
SQL ERROR [ mssql_odbc ]

[Microsoft][SQL Native Client][SQL Server]Cannot insert duplicate key row in object 'dbo.phpbb_users' with unique index 'username_clean'. [23000]

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_allow_pm, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('AdsBot [Google]', 'adsbot [google]', '', 0, '', '00', 6, 2, '', 0, 'D M d, Y g:i a', 'en', 1, 1, '', '', 1194681407, 1194681407, 895, 0, 0, 1194681407, 0, 0, '', 0, 0, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 0, '', '', '', '49c59b49d53fb855')

BACKTRACE

FILE: ncludes/db/mssql_odbc.php
LINE: 149
CALL: dbal->sql_error()

FILE: ncludes/functions_user.php
LINE: 242
CALL: dbal_mssql_odbc->sql_query()

FILE: nstall/install_install.php
LINE: 1827
CALL: user_add()

FILE: nstall/install_install.php
LINE: 111
CALL: install_install->add_bots()

FILE: nstall/index.php
LINE: 402
CALL: install_install->main()

FILE: nstall/index.php
LINE: 274
CALL: module->load()
So it is clear that there is a problem with an unclosed quotation mark, or an issue with a quotation mark itself somewhere in the installation script.

My second (annoying, but not show-stopping) problem is that the tables that are created ARE NOT WHERE THEY ARE SUPPOSED TO BE!!

When I set up the site, I used the SQL Server Management Studio to create a database just for this site. Problem is, this database remains unpopulated, despite naming it explicitly within the install of PHPBB3. Instead, all the tables are created inside the System Databases / master database.

Or, in other words, WTF?!

I specified by name the database I wanted to use. And instead, another database entirely was used.... the master database for SQL Server 2005.

Could anyone help me over these two problems? Or, at the very least, explain why this is happening in the first place?
Locked

Return to “[3.0.x] Support Forum”