Issue Details (XML | Word | Printable)

Key: CONTRIB-99
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Rajesh Dharmalingam
Reporter: Eloy Lafuente (stronk7)
Votes: 1
Watchers: 1
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Non-core contributed modules

Some wrong uses of the dimdim_users table...

Created: 07/Sep/07 05:38 AM   Updated: 26/Nov/09 12:25 AM
Component/s: Module: DimDim
Affects Version/s: 1.8.2, 1.9
Fix Version/s: 1.8.12

Database: Any
Participants: Doug Holton, Eloy Lafuente (stronk7) and Rajesh Dharmalingam
Security Level: None
Affected Branches: MOODLE_18_STABLE, MOODLE_19_STABLE
Fixed Branches: MOODLE_18_STABLE


 Description  « Hide
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?



 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
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()