Skip to content

Postgres doesn't like "" on line 140 of NChatHandle.php #16

@rayarachelian

Description

@rayarachelian

WHERE online_color <> ""',

If you're running SMF with postgres, it throws an error:
Database Error
ERROR: zero-length delimited identifier at or near """"
LINE 4: WHERE online_color <> ""
^
File: /var/www/html/NChat/NChatHandle.php
Line: 142

Changing line 140 to:
140 WHERE online_color <> \'\'',

fixes the issue. (I don't know whether mysql is fine with single quotes here, it might be.)

see: https://lisalist2.com/index.php/topic,35.0.html for more details.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions