PDA

View Full Version : Recreate MySQL table


pauljtester
09-06-04, 06:02 AM
Somehow a single table in the dotproject database was deleted. I still have all the task, ticket, and other information, just the Project summary page is missing. When I click on the Project tab I get the following error:

Table 'dotproject.tasks_sum' doesn't exist

Additionally depending on what sub-tab under the Project tab I click on I get this error:

Warning: Invalid argument supplied for foreach() in /usr/local/src/dotproject/modules/projects/vw_idx_proposed.php on line 58.

So my question is, is it possible to recreate this summary table. It would seem possible because it is just using the information from the tasks of each project. I just don't know how to go about doing this though. Any help is appreciated.
Lata,
pjt

epieters
09-06-04, 08:08 AM
A similar problem is described in the installation forum. Have alook at http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=566