[solved] Database error

[LPARO]

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 ?

[support]

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

[LPARO]

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

Of course!

My mistake, thank you !

[rennecke]

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?

[support]

It's because use already use feature save_attachments in templates.

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;

And update to 3.1 will be done.

[rennecke]

Greate, thanks.