Urgent - Database error after installing v3.4

[techtr]

Good day, v.3.4 PHP 8.1. I am receiving below error while running a process which was working perfectly fine previously. Can you please check below error and assist urgently? Thank you.

Database Error: 1054 - Unknown column 'e.id' in 'where clause'
Query: select * , ( (select count(*) from app_entity_33 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_4988 from app_entity_27 where id='1641'
Page: /index.php?module=items/processes&action=run&id=131&path=27-1641/33-209&redirect_to=items_info&token=FN6ychRHza
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select * , ( (s...')
#1 plugins/ext/classes/email_rules.php(559): db_query('select * , ( (s...')
#2 plugins/ext/classes/email_rules.php(619): email_rules->prepare_send_to(Array)
#3 plugins/ext/classes/processes/processes.php(1122): email_rules->send_edit_msg(Array)
#4 modules/items/actions/processes.php(39): processes->run(Array, 0)
#5 index.php(22): require('/home/smartf16/...')
#6 {main}

[support]

File from archive replace to plugins\ext\classes\
Let me know if it works ok now.

[dorupiroi]

And me i have this eror:
”
Database Error: 1146 - Table 'zutkdewk_ruko334.app_ext_report_page' doesn't exist
Query: select * from app_ext_report_page where id=''
Page: /index.php?module=dashboard/dashboard
#0 includes/functions/database.php(87): mysqli_query()
#1 modules/dashboard/components/sections_reports.php(123): db_query()
#2 modules/dashboard/components/sections.php(15): require('/home/zutkdewk/...')
#3 modules/dashboard/views/dashboard.php(26): require('/home/zutkdewk/...')
#4 template/layout.php(154): require('/home/zutkdewk/...')
#5 index.php(38): require('/home/zutkdewk/...')
#6 {main}
Any solution?

[support]

You did not update database. Follow instruction https://docs.rukovoditel.net/index.php?p=63

[techtr]

File from archive replace to plugins\ext\classes\
Let me know if it works ok now.

This worked. Thank you.

[Maicoul]

Hello Sergey, I did a fresh install after making an error in the update, after completing the new installation through softaculous and updating as instructed, the system returned this error:


Database Error: 1054 - Unknown column 'reminder_status' in 'where clause'
Query: select c.* from app_ext_calendar c, app_entities e where e.id=c.entities_id and reminder_status=1 and length(reminder_type)>0 order by c.name
Page: /index.php?module=dashboard/&action=update_user_notifications_report&token=w5NkVkIHo6
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select c.* from...')
#1 plugins/ext/classes/calendar/calendar_reminder.php(54): db_query('select c.* from...')
#2 plugins/ext/classes/calendar/calendar_reminder.php(17): calendar_reminder->get_reports()
#3 modules/dashboard/actions/dashboard.php(153): calendar_reminder->init()
#4 index.php(20): require('/home2/jobsdrip...')
#5 {main}

[Maicoul]

I reviewed everything, according to https://docs.rukovoditel.net/index.php?p=63 and it worked! I was updating as free.. duuu

[spartandev]

I am getting this exact error messaging (currently using free until our non-profit has enough to buy the Extension). Even after running the update script it is still there, but only for some users. I thought it was a user access group issue and copied one that wasn';t showing the error over, but the error is still there.

Database Error: 1146 - Table 'sparta58_ruko286.app_ext_report_page' doesn't exist
Query: select * from app_ext_report_page where id=''
Page: /whtm/index.php?module=dashboard/dashboard
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select * from a...')
#1 modules/dashboard/components/sections_reports.php(123): db_query('select * from a...')
#2 modules/dashboard/components/sections.php(15): require('/home/sparta58/...')
#3 modules/dashboard/views/dashboard.php(26): require('/home/sparta58/...')
#4 template/layout.php(154): require('/home/sparta58/...')
#5 index.php(38): require('/home/sparta58/...')
#6 {main}

[Edition Nehemia]

Did you also run the SQL update script for the extension? The letters "ext" in the table name indicate that you have tested the extension (which is good). It is possible that there are dependencies that are also loaded if you only load the basic component and the extension is not activated (please correct me if I am wrong).

So you should also update the extension, as well as the database.