Syntax error, or simply wrong version?

[hopfrog@…]

Hi, we installed WikiReplacePlugin 1.1.1 on our 0.12.3 TRAC system and got the following error when trying a replace from the Administration web page:

Trac detected an internal error:

ProgrammingError: syntax error at or near "glob"
LINE 1: ... w2.max_version AND w1.name = w2.name AND w1.name glob E'Wik... ^

Is there a way of getting the plugin to work with 0.12.3?

[Ryan J Ollos]

What were your find/replace/wiki pages terms?

[hopfrog@…]

Find: 'Locate' Replace with: 'Find' Page: 'WikiStart'

I entered these without the quotation marks, of course.

[hopfrog@…]

Python trackback & system information

[hopfrog@…]

Tried again using S='Quest' - R='Pest' - P='Shareplex'

same error, attaching Python traceback & system information

[Gasler Radu]

Hi,

I commited a fix attempt for your problem. It might be an sql case sensitivity issue.

Please try again.

[Ryan J Ollos]

I'm not sure what to do with GLOB, or if it will even cause a problem, but ​t:TracDev/DatabaseApi#GuidelinesforSQLStatements described how LIKE should be handled for cross-db compatibility:

It would look something like this (or perhaps exactly like this if I haven't made a stupid error typing this out) :

sql = 'SELECT w1.version,w1.name,w1.text' + sqlbase + 'AND w1.name GLOB %%s AND w1.text %s %%s' % db.like()

[Jun Omae]

GLOB operator is available only on SQLite and case-sensitive. LIKE operator on SQLite is case-insensitve.

Also, the db.like() method generates case-insensitive LIKE clause on all database backends. e.g. ​http://trac.edgewall.org/browser/trunk/trac/db/postgres_backend.py#L241.

[Gasler Radu]

Thank you all for the suggestions!

I've just committed this fix: [12617]

Can you please check again?

[Gasler Radu]

Fixed with [12617].

[hopfrog@…]

Tested successfully - thank you very much!

[hopfrog@…]

Hi, as this has now been tested successfully with TRAC 0.12.3 and PostgreSQL 8.3.3.64, wouldn't it be a good idea to tag this with a new version number...? Thanks again for the fix!