Hi Allen,
I get a similar problem. When I tried to import the given .sql file in phpMyadmin I got the following error-
SQL query:
CREATE VIEW `my_workspaces` AS select `lifetech_jsgantt`.`og_projects`.`id` AS `pID`,replace(`lifetech_jsgantt`.`og_projects`.`name`,'&','and') AS `pName`,NULL AS `pStart`,NULL AS `pEnd`,`lifetech_jsgantt`.`og_projects`.`color` AS `pColor`,0 AS `pMile`,NULL AS `pRes`,NULL AS `pEmail`,'0' AS `pComp`,1 AS `pGroup`,(case `lifetech_jsgantt`.`og_projects`.`id` when `lifetech_jsgantt`.`og_projects`.`p1` then 0 when `lifetech_jsgantt`.`og_projects`.`p2` then `lifetech_jsgantt`.`og_projects`.`p1` when `lifetech_jsgantt`.`og_projects`.`p3` then `lifetech_jsgantt`.`og_projects`.`p2` when `lifetech_jsgantt`.`og_projects`.`p4` then `lifetech_jsgantt`.`og_projects`.`p3` when `lifetech_jsgantt`.`og_projects`.`p5` then `lifetech_jsgantt`.`og_projects`.`p4` when `lifetech_jsgantt`.`og_projects`.`p6` then `lifetech_jsgantt`.`og_projects`.`p5` when `lifetech_jsgantt`.`og_projects`.`p7` then `lifetech_jsgantt`.`og_projects`.`p6` when `lifetech_jsgantt`.`og_projects`.`p8` then `lifetech_jsgantt`.`og_proj[...]
MySQL said:
#1146 - Table 'lifetech_jsgantt.og_projects' doesn't exist
When I open the tab in Firefox, I get empty workspaces frame. When I go to View frame source I find the following error-
<td style="width: 465px; height: 144px;">
<select multiple="multiple" size="10" name="selWorkspaces[]" style="width: 250px">
Table 'lifetech_jsgantt.my_workspaces' doesn't exist
Pls help me out.
Thanks in advance,
Raghav