magento 1.9 – Catalog Search Database Problems – Cleaning Unnecessary Data

It is not uncommon for the search form to be spammed. In addition to random junk, you will often see SQLi and XSS attempts. I think they are clumsy robots. I do not think it's a legitimate attack vector (on an up-to-date Magento installation).

It is usually prudent to change the catalogsearch_query table in the database. catalogsearch_result is configured to remove lines related to catalogsearch_query by query_id.

truncation catalogsearch_query will eliminate unwanted data, but also all legitimate search terms, which appear as tips when users interact with the search form.

Most importantit will remove any custom search term redirection that may have been configured to return specific pages for certain searches, rather than search results. These contain a value in catalogsearch_query.redirect.

I think that a safe approach is to back up catalogsearch_query, then delete unwanted rows based on the templates you can find to identify them. For example. rows with catalogsearch_query.num_results = 0 maybe most of the time undesirable. catalogsearch_result should decrease in size accordingly.

Always safer, start by doing all this on a development site after importing your dynamic database.

FWIW, I tested the following query on a development site:

mysql> SELECT COUNT(*) FROM catalogsearch_query WHERE redirect IS NOT NULL;
| count(*) |
|      923 |
1 row in set (0.02 sec)

mysql> DELTE FROM catalogsearch_query WHERE redirect IS NULL;
Query OK, 44367 rows affected (5.45 sec)

mysql> SELECT COUNT(*) FROM catalogsearch_query;
| COUNT(*) |
|      923 |
1 row in set (0.00 sec)

The reindexing process works normally, and the redirect search terms appear as indices and work as expected.

Problems with Tkinter in python

I am very new to this field (I am still amazed at how I could do what I did) and I have a problem with some orders. I explain, I have this code:

import tkinter as tk
import sys

def oneclick():
  if True:
  sys.exit(). sys.exit()

def show_entry_fields():
    print("Email: %snPassword: %snRepeat: %snTime: %s" % (e1.get(), e2.get(), e3.get()))

master = tk.Tk()

e1 = tk.Entry(master)
e2 = tk.Entry(master)
e3 = tk.Entry(master)
e4 = tk.Entry(master)

e1.grid(row=0, column=1)
e2.grid(row=1, column=1)
e3.grid(row=2, column=1)
e4.grid(row=3, column=1)

Button = tk.Button()

master.title("Presearch by meganano202")

# Configuración de la raíz
def menubar():

  root = Tk()

  menubar = Menu(root)

  filemenu = Menu(menubar, tearoff=0)
  filemenu.add_command(label="Salir", command=root.quit)

  editmenu = Menu(menubar, tearoff=0)

  helpmenu = Menu(menubar, tearoff=0)
  helpmenu.add_command(label="Acerca de...")

  menubar.add_cascade(label="Archivo", menu=filemenu)
  menubar.add_cascade(label="Editar", menu=editmenu)
  menubar.add_cascade(label="Ayuda", menu=helpmenu)


from selenium import webdriver
import time

driver = webdriver.Chrome("C:\Users\meganano202\Desktop\bot\chromedriver.exe")
elem = driver.find_element_by_name ("email")
password_elem = driver.find_element_by_name("password")
for i in range(e3.get()):
    search_elem = driver.find_element_by_id("search").send_keys("meganano202")
    search_elem = driver.find_element_by_xpath("//button(@type='submit')").click()

And what I would like to do is when they do not press the "Start" button that the bot does not start, that is to say that when you press Start to start and close the sale automatically ( what I think I have already done) and when close the window manually so that the bot does not start, as you see, I try to do it with if and else But it did not work or I was wrong. I will be very grateful for your help

python – Python3 – Sum of the problems of precision between negative and positive number

I am a python class and a user asked a question that I found interesting.

It turns out that if we do the following in python

def suma(num1, num2):
    return num1 + num2

print(suma(4.2, 6))

The result is 1.79999999999999999998

it's not 1.8 as it should be, so it arrives with all decimals of 4 except for 4.5

I find it very strange because with 4.5 the result is correct 5.5

A logical explanation about this?

opengl – Depth test problems with LWJGL3 (GLFW)

I know: similar questions were asked – but I did not find a solution.

So, in the beginning, the basic problem: it seems that the convex models (currently, I load them from .obj files) give good results, but the concave models seem to present a kind of depth problem:

1: The right ear of the ape-mixer "shines through"
2: Should be a hollow cylinder

The inside of the cylinder makes good (?!).
So, I guess there is code:

public static Matrix4f createProjectionMatrix(float fov, float far, float near){
    Matrix4f projectionMatrix = new Matrix4f();
    float aspectRatio = StaticVars.ratio;
    float y_scale = (float) ((1f / Math.tan(Math.toRadians(fov / 2f))));
    float x_scale = y_scale / aspectRatio;
    float frustum_length = far - near;

    projectionMatrix.setValue(x_scale, 0, 0);   
    projectionMatrix.setValue(y_scale, 1, 1);
    projectionMatrix.setValue(-((far + near) / frustum_length), 2, 2);
    projectionMatrix.setValue(-1, 2, 3);
    projectionMatrix.setValue(-((2 * near * far) / frustum_length), 3, 2);
    projectionMatrix.setValue(0, 3, 3);
    return projectionMatrix;

(called with:

Euklid.createProjectionMatrix(90, 0.1f, 1000);

) When rendering, I activated the depth and culling tests with:


In GLSL, I calculate the position in the vertex shader with:

gl_Position = projection*transform*vec4(vertices, 1.0);

If you need additional code, just write what you need.
I'm used to developing with LWJGL 2 and I just converted my engine to LWJGL 3.

Thanks a lot for your help!!

Dimension of matrices and problems

Find the vector space dimension of all symmetric matrices of order n?

Here, I know that the dim of the symmetric matrices is n. (N + 1) / 2.
But this trace is 0.
So I do not understand how to calculate it ..

film – Problems in development, perhaps with the JOBO development tank?

I've been developing my own movie for quite some time, right now in a Patterson tank and no problem. Recently, I had a tank JOBO-2236 Club of opportunity … I used it a little, but I had a lot more development problems (uneven development, etc. .) with the JOBO tank that I've never had in the Patterson. Strangely, when developing two rolls in the JOBO, often only one roll is affected.
Does anyone have any idea of ​​what could be causing this? Can a tank (which is light-proof) have any other problems? Can reels have a problem?

Or does anyone have an idea of ​​what could have caused this?

I have attached a sample, the photos were taken on a roll of 120 Rollei RPX25 and developed into 1:50 Rodinal for 11 minutes. All my previous RPX25s (developed in Paterson) looked great … oddly enough, the second RPX25 roll in the same development process is more or less good.
The problems on Pancro 400 in my other post are also in this tank …

Thank you!

Unedited scan:
enter the description of the image here
Converted images:
enter the description of the image here
enter the description of the image here

7 – D7: Problems when deleting a block of content

I am working on a former D7 site and have been asked to delete a block from a particular page.

The first thing I tried was to go to the page in question, click on the gear icon next to the block and select Configure Block. I then added the alias of the page to the list of excluded pages ("All pages except those listed").

I saved, cleared the cache, but it had no effect – the block remains on the page.

I then went to see if I could remove the block from his area, so I went to admin/structure/block/ and found my block – but the problem is that it's not assigned. This is in the disabled category.

Can someone know what's going on here and how can I remove the blocking of a single given alias?

Thank you very much.

ntp – VM derives: ntpd problems

Query shows a very obsolete reftime. Also I noticespike_detect".

# ntpq -pcrv
     remote           refid      st t when poll reach   delay   offset  jitter
*         2 u  672 1024  377    0.307  -1353.3   0.919
associd=0 status=0613 leap_none, sync_ntp, 1 event, spike_detect,
version="ntpd 4.2.8p10@1.3728-o Tue Mar 28 09:22:06 UTC 2017 (1)",
processor="x86_64", system="Linux/3.0.101-108.35-default", leap=00,
stratum=3, precision=-22, rootdelay=27.855, rootdisp=1111.732,
reftime=e12c625a.f5448322  Wed, Sep 18 2019  9:59:22.958, *********************************
clock=e12cbb2f.db3adf3a  Wed, Sep 18 2019 16:18:23.856, peer=35646,
tc=10, mintc=3, offset=-88.245182, frequency=33.476, sys_jitter=1.582982,
clk_jitter=28.790, clk_wander=2.526

The configuration is as follows:

disable monitor
tinker panic 0
server iburst burst prefer
restrict default kod nopeer nomodify noquery notrap

It does not work in scan mode, the command line is:

/usr/sbin/ntpd -p /var/run/ntp/ -g -u ntp:ntp -c /etc/ntp.conf

The drift file exists and seems to be updated regularly:

-rw-r--r-- 1 ntp ntp 7 Sep 18 08:40 /var/lib/ntp/drift/ntp.drift

However, the only real synchronization is the restart of NTPd. I believe him should be able to correct any step by simply setting the clock, but that does not do it.

Why could this be? I did not find anything unusual in the newspapers.

Olympiad problems of MGL

On the sides AB and AC of the triangle ABC, there are respectively points D and C such that EC = BC = DB. P is an interesting point of BE and DC. The circle circumscribes the triangle EPC and DBP intersect at the point M. (M and P are the two points in common circumferential circles). Show that M is the center of the circle circumscribed to the triangle ABC.

windows 7 – Problems with Velleman PCSU200 drivers, "The required section was not found in the INF file"

I have a Velleman oscilloscope (PCSU200). Used about a year ago, then stuck a drawer until I should need it again.

When I recovered it again about a month ago, the PcLab200 software could not detect the hardware, but the oscilloscope appeared in the device manager. The details for the driver, however, seemed a little weird (see photo).

When I delete the old driver, the computer usually installs one when the oscilloscope is plugged into the USB port, but the driver properties do not look good (see illustration) and PcLab software can not find the oscilloscope.

Trick already tried:

  • I just updated the devmgmt drivers, but Windows thought that the version I had was the best alternative.

  • Download the PcLab200-setup from the manufacturer's homepage ( to get the latest and greatest drivers, unplug the # 39, oscilloscope, delete the old software PcLab200 (the drivers) are provided with this software) and reinstalled PcLab200. No chance.

  • Uninstall the old drivers and try to install the new ones that I got from the Velleman home page. Now, the computer is complaining that it was missing a required section in the inf file.

  • Remove the PcLab software, delete the regedit entry for the PC oscilloscope, and then reinstall the PcLab software. It looks like the same thing, I do not see any problem of objection, the problem persists.

  • Uninstall the driver, restart the computer, reinstall the driver. Stil same result

  • Run chkinf on the inf file. It gives two warnings ((W22.1.2212) No copyright information found, and (W22.1.2215) The CustomUSBDevice class (ClassGUID {a503e2d3-a031-49dc-b684-c99085dbfe92}) is not recognized, but I doubt that this is the problem.The GUID can be found in the registry.
    I tried to paste the report, but maybe the question was too long?

  • I also called the seller, posted the producer and posted on the producers forum. There was a good person on the forum who tried to help but who did not go very far. The producer responded to my mail a week later, with a pretty standardized message: "Have you tried downloading the software from the homepage and have it installed correctly" (j & rsquo; Had explained that I had already tried in my first post). I sent them several times by mail, but they do not seem very interested in support.

Driver properties (according to devmgmt), error message when attempting to update the driver properties and the inf file