how to create tables in mantisbt1.2.4

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
jnv.abhilasha
Posts: 4
Joined: 25 Feb 2011, 07:03

how to create tables in mantisbt1.2.4

Post by jnv.abhilasha »

Hi,
I want to install mantis on Windows 7.I have installed IIS7 server,Mysql server 6.0 and php5 successfully.I am able to access mysql tables from php.
Now i downloaded mantisbt-1.2.4, and kept it inside C:\inetpub\wwwroot\ now when i m entering http://localhost/mantis/index.php it is opening http://localhost/mantis/login_page.php and showing erro
rAPPLICATION ERROR #401

Database query failed. Error received from database was #1146: Table 'bugtracker.mantis_user_table' doesn't exist for the query: SELECT *
FROM mantis_user_table
WHERE username=?.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
.

I don't have sql folder for running script db_generate.sql.I tried to run db_generate.sql script of mantis-0.19.3.but it is showing errors
ERROR: Unknown command '\U'.
ERROR: Unknown command '\A'.
ERROR: Unknown command '\D'.
ERROR: Unknown command '\M'.
ERROR: Unknown command '\M'.
ERROR: Unknown command '\m'.
--------------
mysql Ver 14.15 Distrib 6.0.9-alpha, for Win32 (ia32)

Connection id: 83
Current database: bugtracker
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 6.0.9-alpha-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 19 hours 6 min 11 sec

Threads: 1 Questions: 482 Slow queries: 0 Opens: 18 Flush tables: 1 Open ta
bles: 0 Queries per second avg: 0.7
--------------

->





Help me out .
cas
Posts: 1768
Joined: 11 Mar 2006, 16:08
Contact:

Re: how to create tables in mantisbt1.2.4

Post by cas »

rename config_inc.php (found in the root of your mantis installation) to something else and start from scratch by running:
http://localhost/mantis/admin/install.php
All should be installed automatically
jnv.abhilasha
Posts: 4
Joined: 25 Feb 2011, 07:03

Re: how to create tables in mantisbt1.2.4

Post by jnv.abhilasha »

thank a lot.It worked
jnv.abhilasha
Posts: 4
Joined: 25 Feb 2011, 07:03

Re: how to create tables in mantisbt1.2.4

Post by jnv.abhilasha »

can you help me here.i m getting this exception in my_view_page.php
SYSTEM WARNING: date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Kolkata' for '5.5/no DST' instead.
jnv.abhilasha
Posts: 4
Joined: 25 Feb 2011, 07:03

Re: how to create tables in mantisbt1.2.4

Post by jnv.abhilasha »

it was a problem related to php conf_ini.php.Now it is solved
Post Reply