Forums | Mahara Community
Support
/
broken page
Account deleted
Posts: 15
24 February 2009, 11:14
I have some problem with my mahara. When user wants too search friends or view his group i have a broken page and this is come out at the error log in console. Anyone have a idea?
[WAR] 11 (lib/errors.php:654) Failed to get a recordset: mysql error: [1146: Table 'mahara.view_access_group' doesn't exist] in EXECUTE(", referer: http://xxxxxxxxxxx.hr/mahara/group/view.php?id=1
Account deleted
Posts: 15
24 February 2009, 11:23
in my phpadmin i have 94 tables i base but that table does not exist
Account deleted
Posts: 1643
24 February 2009, 17:59
Hi - sounds like you might have to create it manually, though I can't think of why it wouldn't have been created.
Here's some SQL for it:
CREATE TABLE `view_access_group` (
`view` bigint(10) NOT NULL,
`group` bigint(10) NOT NULL,
`tutoronly` tinyint(1) NOT NULL default '0',
`startdate` datetime default NULL,
`stopdate` datetime default NULL,
KEY `viewaccegrou_vie_ix` (`view`),
KEY `viewaccegrou_gro_ix` (`group`),
CONSTRAINT `viewaccegrou_gro_fk` FOREIGN KEY (`group`) REFERENCES `group` (`id`),
CONSTRAINT `viewaccegrou_vie_fk` FOREIGN KEY (`view`) REFERENCES `view` (`id`)
) ENGINE=InnoDB;
Account deleted
Posts: 15
25 February 2009, 5:28
Eh, now that works, but i have some other errors, i will try to reinstall my mahara. I think that something goes wrong during the installation.4 results