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 'AND jjo_permission IN ('A') ORDER BY cr_date DESC LIMIT 0, 25' at line 1
SELECT tbl.jjo_id AS "id", tbl.jjo_title AS "title", tbl.jjo_bodytext AS "bodytext", tbl.jjo_mood AS "mood", tbl.jjo_status AS "status", tbl.jjo_owner_uid AS "owner_uid", tbl.jjo_image AS "image", tbl.jjo_image_position AS "image_position", tbl.jjo_image_size_x AS "image_size_x", tbl.jjo_image_size_y AS "image_size_y", tbl.jjo_lu_uid AS "lu_uid", tbl.jjo_lu_date AS "lu_date", tbl.jjo_cr_date AS "cr_date", tbl.jjo_permission AS "permission" , a.pn_uname AS username FROM pn_v4b_journal_journal AS tbl LEFT JOIN pn_users a ON a.pn_uid = tbl.jjo_owner_uid WHERE jjo_owner_uid= AND jjo_permission IN ('A') ORDER BY cr_date DESC LIMIT 0, 25
- (array) 0:
- (string) file = /hsphere/local/home/londal/braingain.dk/includes/v4blib/DBUtil.class.php
- (integer) line = 75
- (string) function = v4b_exit
- (array) args:
- (string) 0 = Exiting after SQL-error
- (array) 1:
- (string) file = /hsphere/local/home/londal/braingain.dk/includes/v4blib/DBUtil.class.php
- (integer) line = 1112
- (string) function = executesql
- (string) class = dbutil
- (string) type = ::
- (array) args:
- (string) 0 = SELECT tbl.jjo_id AS "id", tbl.jjo_title AS "title", tbl.jjo_bodytext AS "bodytext", tbl.jjo_mood AS "mood", tbl.jjo_status AS "status", tbl.jjo_owner_uid AS "owner_uid", tbl.jjo_image AS "image", tbl.jjo_image_position AS "image_position", tbl.jjo_image_size_x AS "image_size_x", tbl.jjo_image_size_y AS "image_size_y", tbl.jjo_lu_uid AS "lu_uid", tbl.jjo_lu_date AS "lu_date", tbl.jjo_cr_date AS "cr_date", tbl.jjo_permission AS "permission" , a.pn_uname AS username FROM pn_v4b_journal_journal AS tbl LEFT JOIN pn_users a ON a.pn_uid = tbl.jjo_owner_uid WHERE jjo_owner_uid= AND jjo_permission IN ('A') ORDER BY cr_date DESC LIMIT 0, 25
- (array) 2:
- (string) file = /hsphere/local/home/londal/braingain.dk/includes/v4blib/V4BObjectArray.class.php
- (integer) line = 190
- (string) function = selectexpandedobjectarray
- (string) class = dbutil
- (string) type = ::
- (array) args:
- (string) 0 = v4b_journal_journal
- (array) 1:
- (array) 0:
- (string) join_table = users
- (string) join_field = uname
- (string) object_field_name = username
- (string) compare_field_table = owner_uid
- (string) compare_field_join = uid
- (string) 2 = WHERE jjo_owner_uid= AND jjo_permission IN ('A')
- (string) 3 = ORDER BY cr_date DESC
- (integer) 4 = 0
- (string) 5 = 25
- (NULL) 6 = (none)
- (NULL) 7 = (none)
- (array) 3:
- (string) file = /hsphere/local/home/londal/braingain.dk/includes/v4blib/V4BObjectArray.class.php
- (integer) line = 154
- (string) function = select
- (string) class = v4bjournalarray
- (string) type = ->
- (array) args:
- (string) 0 = WHERE jjo_owner_uid= AND jjo_permission IN ('A')
- (string) 1 = ORDER BY cr_date DESC
- (integer) 2 = 0
- (string) 3 = 25
- (NULL) 4 = (none)
- (boolean) 5 =
- (array) 4:
- (string) file = /hsphere/local/home/londal/braingain.dk/modules/v4bJournal/classes/JournalUtil.class.php
- (integer) line = 84
- (string) function = get
- (string) class = v4bjournalarray
- (string) type = ->
- (array) args:
- (string) 0 = WHERE jjo_owner_uid= AND jjo_permission IN ('A')
- (string) 1 = ORDER BY cr_date DESC
- (integer) 2 = 0
- (string) 3 = 25
- (array) 5:
- (string) file = /hsphere/local/home/londal/braingain.dk/modules/v4bJournal/classes/V4BJournalEntryArray.class.php
- (integer) line = 49
- (string) function = getjournalentries
- (string) class = journalutil
- (string) type = ::
- (array) args:
- (integer) 0 = 0
- (string) 1 = cr_date DESC
- (integer) 2 = 0
- (string) 3 = 25
- (array) 6:
- (string) file = /hsphere/local/home/londal/braingain.dk/modules/v4bJournal/pnuser.php
- (integer) line = 76
- (string) function = getjournaldata
- (string) class = v4bjournalentryarray
- (string) type = ->
- (array) args:
- (array) 0:
- (integer) uid = 0
- (string) sort = cr_date
- (string) mode = list
- (integer) 1 = 0
- (string) 2 = 25
- (array) 7:
- (string) file = /hsphere/local/home/londal/braingain.dk/includes/pnMod.php
- (integer) line = 735
- (string) function = v4bjournal_user_view
- (array) args:
- (array) 0:
(empty)
- (array) 8:
- (string) file = /hsphere/local/home/londal/braingain.dk/index.php
- (integer) line = 109
- (string) function = pnmodfunc
- (array) args:
- (string) 0 = v4bJournal
- (string) 1 = user
- (string) 2 = view
- (array) 3:
(empty)
Exit-Handler: Exiting after SQL-error