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()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()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?