[#CONTRIB-99] Some wrong uses of the dimdim_users table... - Moodle Tracker

Details

Type: Bug
Status: Open
Priority: Minor
Resolution: Unresolved
Affects Version/s: 1.8.2, 1.9
Fix Version/s: 1.9.17
Component/s: Module: DimDim
Labels:
None

Database:

Any
Affected Branches:
MOODLE_18_STABLE, MOODLE_19_STABLE
Fixed Branches:
MOODLE_19_STABLE

Description

In current module version, there are some uses of the "dimdim_users" table (lib.php) and that table doesn't seem to exist in the module installation file at all.

The most noticeable one is the query in the dimdim_print_recent_activity(), that with debug enabled, displays the error.

Ciao

P.S.: I remember I saw that table in a previous release? Has it been dropped on purpose or by error?

Activity

Hide

Permalink

Doug Holton added a comment - 13/Jan/09 12:19 AM

I see the same error in the recent activity block.

Table 'mydatabase.mdl_dimdim_users' doesn't exist

SELECT u.id, cu.dimdimid, u.firstname, u.lastname FROM mdl_dimdim_users as cu, mdl_dimdim as ch, mdl_user as u WHERE cu.userid = u.id AND cu.dimdimid = ch.id AND cu.lastping > '1231773410' AND ch.course = '5' ORDER BY cu.dimdimid ASC

line 686 of lib/dmllib.php: call to debugging()
line 966 of lib/dmllib.php: call to get_recordset_sql()
line 219 of mod/dimdim/lib.php: call to get_records_sql()
line 942 of course/lib.php: call to dimdim_print_recent_activity()
line 27 of blocks/recent_activity/block_recent_activity.php: call to print_recent_activity()
line 317 of blocks/moodleblock.class.php: call to block_recent_activity->get_content()
line 341 of blocks/moodleblock.class.php: call to block_base->is_empty()
line 338 of lib/blocklib.php: call to block_base->_print_block()
line 276 of course/format/weeks/format.php: call to blocks_print_group()
line 227 of course/view.php: call to require()

Show

Doug Holton added a comment - 13/Jan/09 12:19 AM I see the same error in the recent activity block. Table 'mydatabase.mdl_dimdim_users' doesn't exist SELECT u.id, cu.dimdimid, u.firstname, u.lastname FROM mdl_dimdim_users as cu, mdl_dimdim as ch, mdl_user as u WHERE cu.userid = u.id AND cu.dimdimid = ch.id AND cu.lastping > '1231773410' AND ch.course = '5' ORDER BY cu.dimdimid ASC

line 686 of lib/dmllib.php: call to debugging()
line 966 of lib/dmllib.php: call to get_recordset_sql()
line 219 of mod/dimdim/lib.php: call to get_records_sql()
line 942 of course/lib.php: call to dimdim_print_recent_activity()
line 27 of blocks/recent_activity/block_recent_activity.php: call to print_recent_activity()
line 317 of blocks/moodleblock.class.php: call to block_recent_activity->get_content()
line 341 of blocks/moodleblock.class.php: call to block_base->is_empty()
line 338 of lib/blocklib.php: call to block_base->_print_block()
line 276 of course/format/weeks/format.php: call to blocks_print_group()
line 227 of course/view.php: call to require()

People

Assignee:

Rajesh Dharmalingam

Reporter:

Eloy Lafuente (stronk7)

Participants:

Doug Holton, Eloy Lafuente (stronk7), Rajesh Dharmalingam

Vote (1)

Watch (1)

Dates

Created:

07/Sep/07 5:38 AM

Updated:

08/Jan/12 9:33 AM

Non-core contributed modules

Some wrong uses of the dimdim_users table...

Details

Description

Activity

People

Dates