Magento 2 – Enabling Flat Catalog causes SQL error. Reading from “report” tables

When I enable the flat catalog in my Magento 2.2.5 installation, I get an error.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.name' in 'field list', query was: SELECT COUNT(report_table_views.event_id) AS `views`, `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`weight`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`url_key`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`tax_class_id`, `e`.`swatch_image`, `e`.`list_price`, `e`.`supplier_code`, `e`.`apparel_size`, `e`.`apparel_size_value`, `e`.`apparel_occasion`, `e`.`apparel_occasion_value`, `e`.`apparel_style`, `e`.`apparel_style_value`, `e`.`apparel_gender`, `e`.`apparel_gender_value`, `e`.`material`, `e`.`material_value`, `e`.`exh_size`, `e`.`exh_size_value`, `e`.`exh_adapter`, `e`.`exh_adapter_value`, `e`.`karmak_pn`, `e`.`freight_free`, `e`.`free_shipping`, `e`.`backorder_shipping_message`, `e`.`brands`, `e`.`brands_value`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `report_event` AS `report_table_views`  INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = report_table_views.object_id  INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0  INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2'  LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (report_table_views.event_type_id = 1) AND (logged_at >= '2018-08-13') AND (logged_at <= '2019-01-20') GROUP BY `e`.`entity_id` HAVING (COUNT(report_table_views.event_id) > 0) ORDER BY `views` DESC  LIMIT 12 

It looks like Magento is trying to read from report_event table and other “report” tables which seems odd for catalog data.

Any ideas on why this error is happening? Do I need certain settings turned on for each attribute? Any help is appreciated, thank you!

DSolve Recursion Limit Error

Cannot get DSolve, Simplify, or anything else to work. This is all the information our textbook gives us for the problem, but the second image is from an example problem from the book and I typed it all in exactly the same and I don’t get the same answer. Also, I am assuming the exact[x_] comes from solving the differential equation, I just don’t know how

Image of work so far on the problem

Example problem from the textbook that also doesn't work

Openstack Error: No valid host was found. There are not enough hosts available

As a purpose of testing, I am trying to spin up instances of large size, I mean of 8 vCPU’s and greater than 20 GB memory, with 50 GB storage. Physical host has 48 GB RAM and 16 CPU. But everytime receives the same error

Failed to perform requested operation on instance "TestBigVM", the instance has an error status: Please try again later [Error: No valid host was found. There are not enough hosts available.]. 

In nova compute log, this is the last entry, and can’t see any errors:

2019-01-20 22:39:46.447 16511 INFO nova.compute.resource_tracker [req-ded356b5-7a71-451d-a834-db9e696b07dd - - - - -] Final resource view: name=openstack.xxyyzz.com phys_ram=49139MB used_ram=512MB phys_disk=49GB used_disk=0GB total_vcpus=16 used_vcpus=0 pci_stats=[] 

Have googled so many links like https://ask.openstack.org/en/question/54326/cant-create-instance-no-valid-host-was-found-nova-compute-is-not-running/ and then also tried virt_type=kvm or qemu, but everything failed.

Is there any alternative or legitimate solution for this.? Stuck in between some task and this is very critical for the assigned task. Any help would really be appreciated.

Doctest error al intentar capturar Exception Value error

Os reporto un error de testing. Intento capturar el error de introducir un valor negativo en una raíz cuadrada.

Mi código:

import math   def listaraicescuadradas(Listanumeros):     """      la funcion devuelve una lista con la raiz cuadrada     de los elementos pasados en otra lista por argumentos.     >>> lista = []     >>> for i in [4, -9, 16]:     ... lista.append(i)     >>> listaraicescuadradas(lista)     Traceback (most recent call last):         ...     ValueError: math domain error       """     return [math.sqrt(n) for n in Listanumeros ]  import doctest  doctest.testmod() 

El error que me dispara es:

ValueError: line 12 of the docstring for __main__.listaraicescuadradas has inconsistent leading whitespace: 'ValueError: math domain error 

Gracias adelantadas.

memory error

hello

I face with this eror in whmcs client area :

Oops!
Something went wrong and we couldn’t process your request.
Please go back t… | Read the rest of http://www.webhostingtalk.com/showthread.php?t=1749145&goto=newpost

Me da error este codigo por que?

Quiero poner una condicion para que cambie la clase del html en funcion del valor de una variable pero no me funciona.

<?php if ($  score[1]>$  score[2]): ?> <h4 id="medio" class="victoria">VS</h4>  <?php if ($  score[2]>$  score[1]): ?> <h4 id="medio" class="derrota">VS</h4> <?php else: ?> <h4 id="medio" class="empate">VS</h4> <?php endif ?> 

Me podeis ayudar gracias.

Help! upgrade 2.x to 2.3 get error magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php on line 152

php bin/magento setup:upgrade Cache cleared successfully File system cleanup: /home/wwwroot/veaul/domain/veaul/web/generated/code/Composer /home/wwwroot/veaul/domain/veaul/web/generated/code/MSP /home/wwwroot/veaul/domain/veaul/web/generated/code/Magento /home/wwwroot/veaul/domain/veaul/web/generated/code/Mirasvit /home/wwwroot/veaul/domain/veaul/web/generated/code/Symfony /home/wwwroot/veaul/domain/veaul/web/generated/code/Veaul The directory '/home/wwwroot/veaul/domain/veaul/web/generated/metadata/' doesn't exist - skipping cleanup Updating modules: Schema creation/updates: Notice: Undefined index: checkout_agreement in /home/wwwroot/veaul/domain/veaul/web/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php on line 152 

[27759]: ERROR Failed to execute ban jail ‘sshd’ action in fail2ban log

On my Debian 8 server, I see lots of this error in fail2ban log.

 [27759]: ERROR   Failed to execute ban jail 'sshd' action 'iptables-multiport' info 'ActionInfo({'ip': '1.1.2.2', 'fam ily': 'inet4', 'ip-rev': '2.2.1.1.', 'ip-host': '210994.cloudwaysapps.com', 'fid': '1.1.2.2', 'failures': 3, 'time': 1547974803.0, 'matches': 'Jan 20 04:00:01  chat sshd[1326]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=1.1.2.2 \nJan 20 04:00:03 chat sshd[1326]: Failed password f or invalid user guest from 1.1.2.2 port 40633 ssh2', 'restored': 0, 'F-*': {'matches': ['Jan 20 04:00:01 chat sshd[1326]: pam_unix(sshd:auth): authentication failure;  logname= uid=0 euid=0 tty=ssh ruser= rhost=1.1.2.2 ', 'Jan 20 04:00:03 chat sshd[1326]: Failed password for invalid user guest from 1.1.2.2 port 40633 ssh2'] , 'failures': 3, 'mlfid': ' chat sshd[1326]: ', 'user': 'guest', 'ip4': '1.1.2.2'}, 'ipmatches': 'Jan 20 04:00:01 chat sshd[1326]: pam_unix(sshd:auth): authentication  failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=1.1.2.2 \nJan 20 04:00:03 chat sshd[1326]: Failed password for invalid user guest from 1.1.2.2 port 40633  ssh2', 'ipjailmatches': 'Jan 20 04:00:01 chat sshd[1326]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=1.1.2.2 \nJan 20 04 :00:03 chat sshd[1326]: Failed password for invalid user guest from 1.1.2.2 port 40633 ssh2', 'ipfailures': 3, 'ipjailfailures': 3})': Error banning 1.1.2.2 2019-01-20 04:01:24,018 fail2ban.actions   

I’m wondering what this error mean and how to fix it?

Error “Notice: Trying to get property ‘fetch_row’ of non-object in C:\xampp\htdocs\conexion\conexion3.php on line 28”

buenas noches. Estudio diseño y me dejaron de tarea programar en php una base de datos, el problema es que me sale “Notice: Trying to get property ‘fetch_row’ of non-object in C:\xampp\htdocs\conexion\conexion3.php on line 28” cuando lo abro en el navegador. Se refiere a la línea que tiene “$ filas=$ resultado->fetch_row;” No sé cómo solucionarlo pues según el formato así tiene que ser, yo sólo cambié la información de la base de datos. El código completo es éste:

connect_error) { die(“Error en la conexión”. $ myconexion->connect_error); } else{ echo ” Se ha establecido la conexión con éxito…”. $ myconexion->host_info .”

” ; } ?>

Ejemplo 2 de conexión

NombreNúmero de empleado

query(“select nombre,nempleado from auto_veloz”); $ filas=$ resultado->fetch_row; if ($ filas >=1){ while ($ fila = $ resultado->fetch_assoc()) { ?>

<tr bgcolor="#FFFFFF" onmouseover="this.style.background='#FFFFFF';" onmouseout="this.style.background='#FFFFFF';">    <td> <?php echo $  fila['nombre']; ?> </td>    <td> <?php echo $  fila['nempleado']; ?></td>     </tr> 
</table> 

close(); ?>