Are there MySQL version compatibility issues with this module? I'm getting the following error when I try to use it on a server running 3.23.58:

user warning: You have an error in your SQL syntax near '(t.title AS BINARY) REGEXP 'staging'' at line 1 query: SELECT t.title as content, t.nid, n.title FROM node_revisions t INNER JOIN node n ON t.vid = n.vid WHERE CAST(t.title AS BINARY) REGEXP 'staging' in /home/virtual/site255/fst/var/www/html/includes/database.mysql.inc on line 172.

Comments

escoles’s picture

escoles commented

Just noticed that I'm also getting this error at the bottom of the error list, on this server: 

warning: Invalid argument supplied for foreach() in /home/virtual/site255/fst/var/www/html/modules/scanner/scanner.module on line 398.
aasarava’s picture

aasarava commented
Status: Active » Postponed (maintainer needs more info)

This MySQL manual page seems to indicate that the REGEXP statement was valid in MySQL 3.23:
http://dev.mysql.com/doc/refman/4.1/en/regexp.html

But note that MySQL 3 is quite old -- the current version is MySQL 5 and most hosts have upgraded.

In any case, if you're stuck with MySQL 3, can you try your search-and-replace queries again using version 5.x-2.0 of the Scanner module? Let us know if you're still running into the problem.

aasarava’s picture

aasarava commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

closed - no response from original poster, and no further reports.