Hi,
After installing the 3.1 beta update i started receive the following error in the html email box page:
===
Database Error: 1146 - Table 'rukovoditel.app_ext_email_rules_blocks' doesn't exist
Query: select * from app_ext_email_rules_blocks order by name
Page: /index.php?module=ext/email_sending/blocks&entities_id=64
#0 /"mydomain.com"/includes/functions/database.php(95): mysqli_query(Object(mysqli), 'select * from a...')
#1 /"mydomain.com"/plugins/ext/modules/email_sending/views/blocks.php(21): db_query('select * from a...')
#2 /"mydomain.com"/template/layout.php(156): require('/"mydomain folder"...')
#3 /"mydomain.com"/index.php(32): require('/"mydomain folder"...')
#4 {main}
===
Any idea to solve it ?
[solved] Database error
[solved] Database error
Last edited by LPARO on 13 Apr 2022, 13:41, edited 1 time in total.
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Database error
You did not update database. Open in browser next url to update it
Code: Select all
http://[path your app]/install/ext_autoupdate/from_3.0_to_3.1.php
Re: Database error
Of course!support wrote: ↑13 Apr 2022, 10:22 You did not update database. Open in browser next url to update itCode: Select all
http://[path your app]/install/ext_autoupdate/from_3.0_to_3.1.php
My mistake, thank you !
- rennecke
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: [solved] Database error
I also missed to run "/install/ext_autoupdate/from_3.0_to_3.1.php" first.
After reading this post I did it, but with one of my systems i got this message: all other worked fine.
Did I something wrong? How to correct?
After reading this post I did it, but with one of my systems i got this message: all other worked fine.
Did I something wrong? How to correct?
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: [solved] Database error
It's because use already use feature save_attachments in templates.
In your case open phpmyadmin and run next query:
And update to 3.1 will be done.
In your case open phpmyadmin and run next query:
Code: Select all
CREATE TABLE IF NOT EXISTS `app_ext_email_rules_blocks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- rennecke
- Sponsor
- Posts: 214
- Joined: 14 Jan 2018, 12:55
- Name: Eberhard Rennecke
- Location: Switzerland Zurich
Re: [solved] Database error
Greate, thanks.