A PHP Error was encountered

Severity: Warning

Message: pg_query(): Query failed: ERROR: column "viewer" does not exist LINE 10: ORDER BY "viewer" DESC, "pp"."post_date" DESC ^ HINT: Perhaps you meant to reference the column "pp.viewed".

Filename: postgre/postgre_driver.php

Line Number: 234

Backtrace:

File: /home/www/satukanegeri/satukan_negeri/models/Postgre_post_model.php
Line: 163
Function: get

File: /home/www/satukanegeri/satukan_negeri/models/Postgre_post_model.php
Line: 234
Function: getParent

File: /home/www/satukanegeri/satukan_negeri/controllers/Tag.php
Line: 100
Function: getFamily

File: /home/www/satukanegeri/satukan_negeri/libraries/REST_Controller.php
Line: 794
Function: index_get

File: /home/www/satukanegeri/public_html/index.php
Line: 336
Function: require_once

Database Error

A Database Error Occurred

Error Number:

ERROR: column "viewer" does not exist LINE 10: ORDER BY "viewer" DESC, "pp"."post_date" DESC ^ HINT: Perhaps you meant to reference the column "pp.viewed".

SELECT "pp"."last_child_id", "pp"."post_id", "post_date", "pp"."post_author", "pp"."post_type", "viewed", "comment_count", "suka", "tidak_suka", "pu"."user_login", "pu"."user_nicename", "pu"."image" "image_profile", "satwil_id", "satwil_name" FROM "posts" "pp" JOIN "users" "pu" ON "pu"."id"="pp"."post_author" JOIN "list_satwil" ON "satwil_id"="wilayah_id" WHERE "pp"."post_parent" =0 AND "pp"."post_status" = 'publish' AND "pp"."post_type" = 'a' AND 1 = any(pp.jalur_distribusi) AND 'Bendungan' = any(pp.tag) ORDER BY "viewer" DESC, "pp"."post_date" DESC LIMIT 4

Filename: models/Postgre_post_model.php

Line Number: 163