Loading...
 
Skip to main content

Admin modules: Assign user module links broken

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Admin modules: Assign user module links broken
Category
  • Error
  • Regression
Feature
Administration
Modules
Resolution status
Fixed or Solved
Submitted by
Philippe Cloutier
Volunteered to solve
sylvieg
Lastmod by
Ushindi Gedeon
Rating
(0)
Description

When clicking the Assign white plus sign on green background icon in Admin modules User modules tab, PostgreSQL fails complaining:

The following error message was returned:

ERROR: invalid input syntax for integer: "mnu_application_menu"

The query was:
select * from "tiki_modules" where "moduleId"=?

Values:

1. mnu_application_menu

The built query was likely:
select * from "tiki_modules" where "moduleId"='mnu_application_menu'

Stacktrace:

  • /var/www/tiki/trunk/tiki-admin_modules.php : 0 -> {main}(array ( ))
  • /var/www/tiki/trunk/tiki-admin_modules.php : 63 -> get_assigned_module(array ( 'moduleId' => '\'mnu_application_menu\'', ))
  • /var/www/tiki/trunk/lib/modules/modlib.php : 60 -> query(array ( 'query' => '\'select * from `tiki_modules` where `moduleId`=?\, 'values' => 'array (0 => \'mnu_application_menu\')', 'numrows' => , 'offset' => , 'reporterrors' => , ))

...


Indeed, the query would expect an integer argument, not a string. This is a regression from r8873, which changed modlib's interface. get_assigned_module() now expects its first argument to be a moduleId, not a module name.

Solution
Workaround
Importance
4
Priority
20
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2805
Created
Monday 12 October, 2009 02:02:14 UTC
by Unknown
LastModif
Monday 01 June, 2026 15:01:57 UTC


Show PHP error messages