Loading...
 
Skip to main content

Fresh install of v3.2 fails with plugin approval

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Fresh install of v3.2 fails with plugin approval
Version
3.x
Category
  • Error
  • Usability
Feature
Database MySQL (MyISAM)
Others
Wiki Plugin (extends basic syntax)
Submitted by
joerg
Lastmod by
Pascal St-Jean
Rating
(0)
Description

Made a new install of Tiki v3.2 on a Ubuntu 8.04.3 system as server (includes MySQL in version 5.0.51a-3ubuntu5.4).
Surfing at tiki-plugins.php produces the following error message:

Copy to clipboard
<div class="cbox-data"><br>
<div class="simplebox error">
<div class="simplebox"><b>An error occured in a database query!</b></div><br>
<table class="form">
<tbody><tr class="heading"><td colspan="2">Context:</td></tr>
<tr class="formcolor"><td>File</td><td>tiki-plugins.php</td></tr>
<tr class="formcolor"><td>Url</td><td>tiki-plugins.php</td></tr>
<tr class="heading"><td colspan="2">Query:</td></tr>
<tr class="formcolor"><td colspan="2">
<tt>SELECT fingerprint, added_by, last_update, last_objectType, last_objectId FROM tiki_plugin_security WHERE status = 'pending' ORDER BY last_update DESC</tt>
</td></tr>
<tr class="heading"><td colspan="2">Values:</td></tr>
<tr class="heading"><td colspan="2">Message:</td></tr>
<tr class="formcolor"><td colspan="2"></td></tr>

<tr class="heading"><td colspan="2">Built query was probably:</td></tr>
<tr class="formcolor"><td colspan="2">SELECT fingerprint, added_by, last_update, last_objectType, last_objectId FROM tiki_plugin_security WHERE status = 'pending' ORDER BY last_update DESC</td></tr>
</tbody></table>
</div>
<br><br>
</div>

edit: Sorry, forgot to mention that this bug also affects the using of plugins. Using a plugin in a wiki page that needs approval produces the same error message. (Saw someone in the irc log with this problem, which is also this bug, so I edit to clarify it.)

Solution

Had a further look with phpmyadmin and discoverd that the tiki_plugin_security table is missing the added_by entry, which should be made by installer/schema/20090913_plugin_security_addedby_tiki.sql.

Don't know why the instruction from this schema file wasn't executed, but after manually doing it the plugin approval system works as it is supposed to.

Importance
4
Priority
20
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2777
Created
Friday 02 October, 2009 16:54:40 UTC
by Unknown
LastModif
Thursday 21 November, 2013 17:35:18 UTC


Show PHP error messages