Forums | Mahara Community
Mahara/Moodle integration
/
New Integration
Account deleted
Posts: 2
02 March 2009, 11:07
Hi All,
Quite new to this but have managed to integrate moodle with mahara except when i click the mahara link in our moodle it comes up with this error:
Adding 4688 bytes would exceed the user's quota
Does anyone know how to sort this please?
thanks in advance 
Account deleted
Posts: 2
02 March 2009, 17:53
Hi All,
have managed to fix by setting authentication from internal.
Now have total transparency with authentication from Moodle to Mahara only problem is when the user enters Mahara and goes to the find friends in the Groups tab it just comes up with a page of code errors (see below) anyone have a clue?
[WAR]
d8 (lib/errors.php:654) Failed to get a recordset: mysql error: [1146:
Table 'mahara.view_access_group' doesn't exist] in EXECUTE("SELECT
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member='11'
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = 0)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < '2009-03-02 21:51:31' )
AND ( v.stopdate IS NULL OR v.stopdate > '2009-03-02 21:51:31' )
")
Command was: SELECT
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member=?
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = ?)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < ? )
AND ( v.stopdate IS NULL OR v.stopdate > ? )
and values was (11,0,2009-03-02 21:51:31,2009-03-02 21:51:31)
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member='11'
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = 0)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < '2009-03-02 21:51:31' )
AND ( v.stopdate IS NULL OR v.stopdate > '2009-03-02 21:51:31' )
")
Command was: SELECT
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member=?
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = ?)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < ? )
AND ( v.stopdate IS NULL OR v.stopdate > ? )
and values was (11,0,2009-03-02 21:51:31,2009-03-02 21:51:31)
![[X]](http://vle.bishopbarrington.net/mahara/theme/default/static/images/icon_close.gif){kind=icon}
Call stack (most recent first):
- log_message("Failed to get a recordset: mysql error: [1146: Tab...", 8, true, true) at /home/web/bbs/mahara101/lib/errors.php:90
- log_warn("Failed to get a recordset: mysql error: [1146: Tab...") at /home/web/bbs/mahara101/lib/errors.php:654
- SQLException->__construct("Failed to get a recordset: mysql error: [1146: Tab...") at /home/web/bbs/mahara101/lib/dml.php:428
- get_recordset_sql("SELECT
v.*,
UNIX_TIMESTAMP...", array(size 4), "", "") at /home/web/bbs/mahara101/lib/dml.php:610 - get_records_sql_array("SELECT
v.*,
UNIX_TIMESTAMP...", array(size 4)) at /home/web/bbs/mahara101/lib/mahara.php:1505 - get_views(array(size 8), null, null) at /home/web/bbs/mahara101/lib/user.php:866
- get_users_data("13,1,10,12,8,2,3,5") at /home/web/bbs/mahara101/user/find.php:43
[WAR]
d8 (lib/dml.php:428) Failed to get a recordset: mysql error: [1146:
Table 'mahara.view_access_group' doesn't exist] in EXECUTE("SELECT
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member='11'
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = 0)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < '2009-03-02 21:51:31' )
AND ( v.stopdate IS NULL OR v.stopdate > '2009-03-02 21:51:31' )
")
Command was: SELECT
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member=?
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = ?)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < ? )
AND ( v.stopdate IS NULL OR v.stopdate > ? )
and values was (11,0,2009-03-02 21:51:31,2009-03-02 21:51:31)
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member='11'
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = 0)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < '2009-03-02 21:51:31' )
AND ( v.stopdate IS NULL OR v.stopdate > '2009-03-02 21:51:31' )
")
Command was: SELECT
v.*,
UNIX_TIMESTAMP(v.atime) AS atime,
UNIX_TIMESTAMP(v.mtime) AS mtime,
UNIX_TIMESTAMP(v.ctime) AS ctime
FROM
"view" v
INNER JOIN "view_access_group" a ON v.id=a.view
INNER JOIN "group_member" m ON m.group=a.group AND m.member=?
INNER JOIN "group" g ON (g.id = a.group AND g.deleted = ?)
WHERE
v.owner IN ('1','2','3','5','8','10','12','13')
AND ( v.startdate IS NULL OR v.startdate < ? )
AND ( v.stopdate IS NULL OR v.stopdate > ? )
and values was (11,0,2009-03-02 21:51:31,2009-03-02 21:51:31)
Call stack (most recent first):
- get_recordset_sql("SELECT
v.*,
UNIX_TIMESTAMP...", array(size 4), "", "") at /home/web/bbs/mahara101/lib/dml.php:610 - get_records_sql_array("SELECT
v.*,
UNIX_TIMESTAMP...", array(size 4)) at /home/web/bbs/mahara101/lib/mahara.php:1505 - get_views(array(size 8), null, null) at /home/web/bbs/mahara101/lib/user.php:866
- get_users_data("13,1,10,12,8,2,3,5") at /home/web/bbs/mahara101/user/find.php:43
Account deleted
Posts: 1643
02 March 2009, 18:42
Hi - there's a weird error in the MySQL install process that means sometimes that table isn't created, but MySQL doesn't bother to tell us that it couldn't. You will need to create that table manually. See this thread for the SQL.3 results