Review TYPO3_4-5 Merged

8901[BUGFIX] Invalid "unequal"-statement and string-quoting in SQL

Xavier Perseguers CR +2 V +2 Normal +66 −65 updated 06/03/13, 20:49

Commit message

There are multiple "!=" in SQL statements. They should be "<>".
MySQL understands "!=" for the compatibility with early versions
but it is not a standard SQL and should not be used.

Strings should be enclosed in single-quotes. Some systems use
double-quotes to mark identifiers in contrast to literals.

(Added some small fullQuote-calls along the way for
completeness or dropped quotes where uid is clearly just
an intval.)

Review

  • Code review CR +2

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V +2

    Imported before Forger kept the single votes, the next import adds them.

Issues 1

Files 31

Show 11 more files