View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006021 | mantisbt | installation | public | 2005-07-26 15:29 | 2005-09-11 08:12 |
| Reporter | aviru | Assigned To | thraxisp | ||
| Priority | normal | Severity | block | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 1.0.0rc2 | ||||
| Summary | 0006021: Mantis installation issues under sql server | ||||
| Description | Intent: To setup tables in the SQL Server database. Session returns ado_mssql or odbc_mssql whereas the case does not have this entry (it has only mssql). Modifying the switch-case as follows seemed to solve the tables-installation problem. switch ($f_db_type) { This installs the tables but the insert of initialization data fails. SQL 1:-- here I set the fields to be inserted in, removed first field as its an IDENTITY field, also set cookie string to '' INSERT INTO mantis_user_table(username, realname, email, password, date_created, last_visit, enabled, protected, access_level, login_count, lost_password_request_count, failed_login_count, cookie_string) VALUES ( 'administrator', '', 'user@domain.com', '63a9f0ea7bb98050796b649e85481845', '2003-02-16 02:03:48', '2004-07-08 23:59:22', 1, 1, 90, 3, 0, 0, ''); GO SQL 2:-- here I replace 51 with '51' as value is a text field not an integer. INSERT INTO mantis_config_table ( value, type, access_reqd, config_id, project_id, user_id ) VALUES ('51', 1, 90, 'database_version', 20, 0 ); | ||||
| Steps To Reproduce |
| ||||
| Tags | No tags attached. | ||||
|
Issue 0 -> is already fixed in CVS Issue 1 -> I believe still needs addressing. The PHP needs to generate the cookie as opposed to the DB. |
|
|
I've fixed issue 2, but I cannot find where issue 1 is generated. All of the inserts in that table have the value quoted. Are you looking at the actual queries sent to the database, or inspecting the code? |
|
|
Fix for issue 2 submitted to CVS. admin/install.php -> 1.16 |
|
|
NOW() --> should be db_now() (or whatever api call is ) too |
|
|
Fixed in CVS. The second SQL issue is in a display statement shown is one chooses to install the database manually. admin/install.php -> 1.18 |
|