Error when displaying info page

Ask your questions here.
Post Reply
shandybt
Posts: 53
Joined: 29 Jul 2016, 12:31
Name: Shandy Banyutresna
Location: Indonesia, Jakarta
Company Name: PT. Kimia Farma
Contact:

Error when displaying info page

Post by shandybt »

dear Sergey,

I have a problem when showing info page its write :
Database Error: 1054 - Unknown column 'Array' in 'where clause'
Query: select configuration from app_fields where entities_id='63' and id in (799,Array) and type='fieldtype_text_pattern'
Page: /index.php?module=items/info&path=25-1461
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select configur...')
#1 includes/classes/fieldstypes/fieldtype_formula.php(259): db_query('select configur...')
#2 includes/classes/fieldstypes/fieldtype_formula.php(332): fieldtype_formula::check_formula_query_needed('814', '63', Array)
#3 includes/classes/fieldstypes/fieldtype_entity.php(374): fieldtype_formula::prepare_query_select('63', '', false, Array)
#4 includes/classes/fields_types.php(1012): fieldtype_entity->output(Array)
#5 includes/classes/items/items.php(815): fields_types::output(Array)
#6 modules/items/views/info.php(200): items::render_info_box(25, 1461, false, ','fieldtype_rel...')
#7 template/layout.php(156): require('/home/nonf8111/...')
#8 index.php(38): require('/home/nonf8111/...')
#9 {main}
Screenshot 2023-09-20 at 11.49.47.png
field entity 63 is my member database and field 799 is the heading field

do you have any idea?
Screenshot 2023-09-19 at 14.07.34.png
Screenshot 2023-09-19 at 14.07.47.png
Screenshot 2023-09-19 at 14.08.09.png
Screenshot 2023-09-19 at 14.08.26.png
User avatar
support
Site Admin
Posts: 6221
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error when displaying info page

Post by support »

Strange. Can't reproduce it. Can you reproduce in personal demo, please?
https://www.rukovoditel.net/demo.php
shandybt
Posts: 53
Joined: 29 Jul 2016, 12:31
Name: Shandy Banyutresna
Location: Indonesia, Jakarta
Company Name: PT. Kimia Farma
Contact:

Re: Error when displaying info page

Post by shandybt »

I've upload my backup to the demo link
but its become error
Screenshot 2023-09-21 191759.png
can you check link below

Code: Select all

 https://pdemo.rukovoditel.pro/3.4/index.php?module=users/login&demo_id=2555
User avatar
support
Site Admin
Posts: 6221
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error when displaying info page

Post by support »

Looks like backup is not loaded. Probably conflict with encoding. Can you send backup file to support email, please. I will check it.
https://www.rukovoditel.net/contact_us.php
shandybt
Posts: 53
Joined: 29 Jul 2016, 12:31
Name: Shandy Banyutresna
Location: Indonesia, Jakarta
Company Name: PT. Kimia Farma
Contact:

Re: Error when displaying info page

Post by shandybt »

I send the backup file by PM

thanks
Post Reply