I just installed and configured Broken Anchor. When I enabled it I first got warning about Allow URL fopen not being enabled. I fixed that and then ran cron. I am now getting an SQL error:

user warning: 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 'match, match_type, checked, status, count) VALUES (2, 'broken_an query: INSERT INTO broken_anchor_errors (cid, module, match, match_type, checked, status, count) VALUES (2, 'broken_anchor_node', 'sharonestark@gmail.com', 1, 1231072113, 'Clear email address', 1) in /htdocs/test/includes/common.inc on line 3418.

I am on Drupal 6.8. Is this module dependent on a certain version of PHP?

Here is my php information:

Php version 4.4.6
Safe mode Disabled
Display errors 1
Memory limit default warning
Error reporting E_ERROR + E_WARNING + E_PARSE + E_NOTICE + E_CORE_ERROR + E_CORE_WARNING + E_COMPILE_ERROR + E_COMPILE_WARNING + E_USER_ERROR + E_USER_WARNING + E_USER_NOTICE + E_STRICT + E_RECOVERABLE_ERROR
Upload max filesize 8M
Magic quotes GPC Enabled
Magic quotes runtime Disabled
Precision 14
Register globals
Session cache limiter none
Session cookie domain
Session name
Session save handler user
GD version bundled (2.0.28 compatible)
FreeType support (Enabled), Jpg support (Enabled), Png support (Enabled)
CURL support Disabled
Multibyte support Enabled
Mbstring.func_overload disabled
XML support Enabled
Zip support Disabled
Zlib support Enabled

Comments

Steve Halleman’s picture

Steve Halleman commented

Hello, is anyone there?

Yoran’s picture

Yoran commented

Sorry for not answering. It seems that drupal.org rss stream on issues is broken. Do you have the same issue when running the query by itself ?
INSERT INTO broken_anchor_errors (cid, module, match, match_type, checked, status, count) VALUES (2, 'broken_anchor_node', 'sharonestark@gmail.com', 1, 1231072113, 'Clear email address', 1)

I'm a postgresql person and I don't have any MySQL installed rigth now, so I need your help to figure out what is wrong with this query.

Yoran’s picture

Yoran commented
Status: Active » Fixed

Well, I found the Mysql problem. This little thing seems to have problem with fields named 'match'. I fixed this in RC3.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.