Tracker Plugin fails with trackers with mirror tables
- Status
- Closed
- Subject
- Tracker Plugin fails with trackers with mirror tables
- Version
- 1.9.x
- Category
- Error
- Feature
- Database MySQL (MyISAM)
Wiki (page view, edit, history, rename, etc)
Wiki Plugin (extends basic syntax)
~Trackers (mirror) - Resolution status
- Won't Fix
- Submitted by
- Xavier de Pedro
- Lastmod by
- Marc Laporte
- Rating
- Description
Table of contents
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/Ofertes )
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/prova), 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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1055
- Created
- Monday 09 April, 2007 19:28:17 GMT-0000
by Unknown - LastModif
- Wednesday 18 April, 2012 14:19:52 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Structures, Wiki pages; It should not be possible to create a page through structure with an "illegal" name
- Daily build zip file for Tiki26 is not available (404)
- htaccess.sh is gone from Tiki26 and after the installation you may need to create the symlink manually
- Create new Group function does not work Tiki V26.0 Clean install brand new database
- Manticore install and configuration
;){kind=link}
;){kind=link}