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 'ORDER BY cr_date DESC LIMIT 0, 30' at line 1
SELECT tbl.afv_owner_uid AS "owner_uid", tbl.afv_contact_id AS "contact_id", tbl.avf_obj_status AS "obj_status", tbl.avf_cr_date AS "cr_date", tbl.avf_cr_uid AS "cr_uid", tbl.avf_lu_date AS "lu_date", tbl.avf_lu_uid AS "lu_uid" , a.aco_name_last AS name_last , b.aco_name_first AS name_first , c.aco_company_id AS company_id , d.aco_branch_id AS branch_id , e.aco_addr_country AS addr_country , f.aco_addr_city AS addr_city , g.aco_addr_phone1 AS addr_phone1 , h.aco_addr_email1 AS addr_email1 , i.aco_pending_status AS pending_status FROM os_core_v4b_addressbook_favourite AS tbl LEFT JOIN os_core_v4b_addressbook_contact a ON a.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact b ON b.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact c ON c.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact d ON d.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact e ON e.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact f ON f.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact g ON g.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact h ON h.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact i ON i.aco_id = tbl.afv_contact_id WHERE afv_owner_uid = ORDER BY cr_date DESC LIMIT 0, 30
  1. (array) 0:
    1. (string) file = /home5/thailan8/public_html/includes/v4blib/DBUtil.class.php
    2. (integer) line = 75
    3. (string) function = v4b_exit
    4. (array) args:
      1. (string) 0 = Exiting after SQL-error
  2. (array) 1:
    1. (string) file = /home5/thailan8/public_html/includes/v4blib/DBUtil.class.php
    2. (integer) line = 1112
    3. (string) function = executeSQL
    4. (string) class = DBUtil
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = SELECT tbl.afv_owner_uid AS "owner_uid", tbl.afv_contact_id AS "contact_id", tbl.avf_obj_status AS "obj_status", tbl.avf_cr_date AS "cr_date", tbl.avf_cr_uid AS "cr_uid", tbl.avf_lu_date AS "lu_date", tbl.avf_lu_uid AS "lu_uid" , a.aco_name_last AS name_last , b.aco_name_first AS name_first , c.aco_company_id AS company_id , d.aco_branch_id AS branch_id , e.aco_addr_country AS addr_country , f.aco_addr_city AS addr_city , g.aco_addr_phone1 AS addr_phone1 , h.aco_addr_email1 AS addr_email1 , i.aco_pending_status AS pending_status FROM os_core_v4b_addressbook_favourite AS tbl LEFT JOIN os_core_v4b_addressbook_contact a ON a.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact b ON b.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact c ON c.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact d ON d.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact e ON e.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact f ON f.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact g ON g.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact h ON h.aco_id = tbl.afv_contact_id LEFT JOIN os_core_v4b_addressbook_contact i ON i.aco_id = tbl.afv_contact_id WHERE afv_owner_uid = ORDER BY cr_date DESC LIMIT 0, 30
  3. (array) 2:
    1. (string) file = /home5/thailan8/public_html/includes/v4blib/V4BObjectArray.class.php
    2. (integer) line = 190
    3. (string) function = selectExpandedObjectArray
    4. (string) class = DBUtil
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = v4b_addressbook_favourite
      2. (array) 1:
        1. (array) 0:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = name_last
          3. (string) object_field_name = name_last
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        2. (array) 1:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = name_first
          3. (string) object_field_name = name_first
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        3. (array) 2:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = company_id
          3. (string) object_field_name = company_id
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        4. (array) 3:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = branch_id
          3. (string) object_field_name = branch_id
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        5. (array) 4:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = addr_country
          3. (string) object_field_name = addr_country
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        6. (array) 5:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = addr_city
          3. (string) object_field_name = addr_city
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        7. (array) 6:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = addr_phone1
          3. (string) object_field_name = addr_phone1
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        8. (array) 7:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = addr_email1
          3. (string) object_field_name = addr_email1
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
        9. (array) 8:
          1. (string) join_table = v4b_addressbook_contact
          2. (string) join_field = pending_status
          3. (string) object_field_name = pending_status
          4. (string) compare_field_table = contact_id
          5. (string) compare_field_join = id
      3. (string) 2 = afv_owner_uid =
      4. (string) 3 = cr_date DESC
      5. (integer) 4 = 0
      6. (string) 5 = 30
      7. (NULL) 6 = (none)
      8. (NULL) 7 = (none)
  4. (array) 3:
    1. (string) file = /home5/thailan8/public_html/includes/v4blib/V4BObjectArray.class.php
    2. (integer) line = 154
    3. (string) function = select
    4. (string) class = V4BObjectArray
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = afv_owner_uid =
      2. (string) 1 = cr_date DESC
      3. (integer) 2 = 0
      4. (string) 3 = 30
      5. (NULL) 4 = (none)
      6. (boolean) 5 =
  5. (array) 4:
    1. (string) file = /home5/thailan8/public_html/modules/v4bAddressBook/classes/V4BFavouriteArray.class.php
    2. (integer) line = 92
    3. (string) function = get
    4. (string) class = V4BObjectArray
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = afv_owner_uid =
      2. (string) 1 = cr_date DESC
      3. (integer) 2 = 0
      4. (string) 3 = 30
      5. (NULL) 4 = (none)
      6. (boolean) 5 =
  6. (array) 5:
    1. (string) file = /home5/thailan8/public_html/modules/v4bAddressBook/pnuser.php
    2. (integer) line = 237
    3. (string) function = get
    4. (string) class = V4BFavouriteArray
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = afv_owner_uid =
      2. (string) 1 = cr_date DESC
      3. (integer) 2 = 0
      4. (string) 3 = 30
  7. (array) 6:
    1. (string) file = /home5/thailan8/public_html/includes/pnMod.php
    2. (integer) line = 735
    3. (string) function = v4bAddressBook_user_view
    4. (array) args:
      1. (array) 0: (empty)
  8. (array) 7:
    1. (string) file = /home5/thailan8/public_html/index.php
    2. (integer) line = 141
    3. (string) function = pnModFunc
    4. (array) args:
      1. (string) 0 = v4bAddressBook
      2. (string) 1 = user
      3. (string) 2 = view
      4. (array) 3: (empty)
Exit-Handler: Exiting after SQL-error