Fullscreen
Loading...
 
Skip to main content

Tracker Plugin fails with trackers with mirror tables

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Tracker Plugin fails with trackers with mirror tables
Version
1.9.x
Category
  • Error
Feature
Database MySQL (MyISAM)
~Trackers (mirror)
Wiki (page view, edit, history, rename, etc)
Wiki Plugin (extends basic syntax)
Resolution status
Won't Fix
Submitted by
Xavier de Pedro
Lastmod by
Marc Laporte
Rating
(0)
Description

Using 1.9.cvs

1st trial

Using a tracker plugin code within this page content:

Copy to clipboard
{MAKETOCBOX(float=>none)}{MAKETOCBOX}
!! Ofertes de recursos  o serveis

!!! Oferiments de transports
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Transport, exactvalue=>Transport, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments de recursos (materials)
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Recurs, exactvalue=>Recurs, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments de serveis (immaterials)
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Servei, exactvalue=>Servei, goIfOne=>n)}Com????{TRACKERLIST}

!!! Oferiments d'altres coses
{TRACKERLIST(trackerId=>2,fields=>5:6:7:17:8:11, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, sort_mode=>asc, max=>20, filterfield=>6, filtervalue=>Altres, exactvalue=>Altres, goIfOne=>n)}Com????{TRACKERLIST}

!! Insereix nous oferiments a la base de dades
{TRACKER(trackerId=>2, fields=>5:6:7:17:8:16:11, action=>Envia les dades del teu oferiment, showtitle=>n, showdesc=>n, showmandatory=>y, embedded=>y)}Oferiment enviat amb èxit! Pots continuar navegant per la web amb normalitat. {TRACKER}

Tracker 2 is this one:

[+]

And its fields are these:

[+]

I inserted this information:

Què ofereixes? *: Manual d'administració de Webs com aquesta
Tipus d'oferta *: Recurs
Descripció: En pdf..., i en català . tot i que la versió en anglès és més complerta.
Foto:
Demanda relacionada:
Persona que ho ofereix admin
submit button

(At this page: http://www.moviments.net/valldelcorb/OfertesQuestion )

I get this message after attempting to insert a new record:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='Ofertes' where `itemId`='13'' at line 1

2nd trial

I made another trial in another page just having the tracker plugin (http://moviments.net/valldelcorb/provaQuestion), with just this content in the page:

Copy to clipboard
{TRACKER(trackerId=>2, fields=>5:6:7:17:8:16:11, action=>Envia les dades del teu oferiment, showtitle=>n, showdesc=>n, showmandatory=>y, embedded=>y)}Oferiment enviat amb èxit! Pots continuar navegant per la web amb normalitat. {TRACKER}


I got this message:

Warning: mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='prova' where `itemId`='14'' at line 1 in query:

update tiki_trk_2 set =? where `itemId`=?


in /home/httpd/tiki19/lib/tikidblib.php on line 134

Solution
Mirror trackers have been deprecated.
Importance
1 low
Priority
5
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1055
Created
Monday 09 April, 2007 19:28:17 UTC
by Unknown
LastModif
Wednesday 18 April, 2012 14:19:52 UTC


Show PHP error messages