In system.install for system_update_181() there is an extra ";" that I don't believe is necessary:

$ret[] = update_sql("ALTER TABLE {profile_fields} ADD autocomplete TINYint NOT NULL AFTER visibility ;");

I suggest removing the second to last ";".

The reason why I'm submitting so many of these is because I'm going through the entire 5.2 (will update to 5.3 soon) and making it compatible with SQL Server 2000. Thus, I'm coming across a lot of these things and figured I should share my thoughts. I will submit an overall core patch for SQL Server compatibility soon.

CommentFileSizeAuthor
#4 system_install_1.patch648 byteshazexp
#3 system_install_0.patch648 byteshazexp
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

JirkaRybka’s picture

Patches are (as far as I know) only worth submitting for the -dev versions, and additionally 5.x only accepts bugfixes now.

Otherwise I confirm, that this extra semicolon exists also in 6.x-dev (no wonder, inside an old update), and I consider this a syntax-consistency minor bug (but not changing status, since pcorbett announced a 5.x patch coming).

patchnewbie’s picture

Assigned: Unassigned » patchnewbie
Priority: Normal » Minor

This would be a great patch for someone new to core development.

hazexp’s picture

FileSize
648 bytes

Here's the patch for 5.x-dev

hazexp’s picture

FileSize
648 bytes

I've also patched 6.x-dev for the same issue.

JirkaRybka’s picture

Status: Active » Reviewed & tested by the community

Really simple. Setting RTBC for both patches.

JirkaRybka’s picture

Version: 5.2 » 5.x-dev

But it's for the -dev versions, obviously.

drumm’s picture

Version: 5.x-dev » 6.x-dev

Committed to 5.x.

Gábor Hojtsy’s picture

Status: Reviewed & tested by the community » Fixed

Committed to 6.x.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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