id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 6189,Bug - Macro doesn't work anyway,tom@…,David Francos Cuartero,"The Plungin doesn't work as I installed it. [[BR]] I got this Error: {{{ Error: Macro TicketBackLinks(##ticket nr##) failed 1146Table '####db name#####.WIKI' doesn't exist }}} I didn't use it anymore - after about a month I looked back at the code and found this bug: You wrote - starting with Line 44: {{{ sql = 'SELECT w1.name FROM wiki w1, ' + \ '(SELECT name, MAX(version) AS VERSION FROM WIKI GROUP BY NAME) w2 ' + \ 'WHERE w1.version = w2.version AND w1.name = w2.name ' sql += 'AND ( w1.text LIKE \'%%[ticket:%s]%%\' ' % thispage sql += 'OR w1.text LIKE \'%%#%s %%\' )' % thispage }}} correct: {{{ sql = 'SELECT w1.name FROM wiki w1, ' + \ '(SELECT name, MAX(version) AS VERSION FROM wiki GROUP BY NAME) w2 ' + \ 'WHERE w1.version = w2.version AND w1.name = w2.name ' sql += 'AND ( w1.text LIKE \'%%[ticket:%s]%%\' ' % thispage sql += 'OR w1.text LIKE \'%%#%s %%\' )' % thispage }}} There is two times the Table - wiki - but once in small the second time in big letters. == To make the Plugin work == 1. edit macro.py on line 45 to {{{ '(SELECT name, MAX(version) AS VERSION FROM wiki GROUP BY NAME) w2 ' + \ }}} 2. cd to the directory with the setup.py and >python setup.py install[[BR]] 3. restart your webserver[[BR]] 4. activate the plugin in your admin or config if you haven't allready.[[BR]] kind regards ToM",defect,closed,high,TicketBackLinksMacro,normal,fixed,,,0.11