phpmyadmin – MySQL INNER JOIN returns a row but from the front end,it shows no rows

I have this code as my SQL script

SELECT 
    lib_use_details.book_code,
    book_details.book_name,
    lib_use_details.date_out,
    lib_use_details.exp_date_in
FROM
    lib_use_details
        INNER JOIN
    book_details ON lib_use_details.book_code = book_details.book_code
WHERE
    lib_use_details.stu_details = 0001

When I execute this code directly on the database, it returns a 1 row as shown by this image
 showing database result

However my front-end displays nothing as shown by this
image of the front end

Why is this result conveyed from the db to the frontend?
Thanks

magento2 – Shipping method no longer shows after update

Magento ver. 2.2.6

The store has been operational for some time with several shipping methods. Most of these were disabled for covid, with the remaining one having its name and price changed.

Have tried refreshing page and config caches and even flushing the magento cache but the remaining method still doesn’t appear in checkout.enter image description here

The module is a basic flat rate type that just returns the price when it’s active

enter image description here

mac osx – centos7 most commands in terminal shows blank screen form macbook

I do an ssh to a fresh install of Centos7 server from a mac Osx with terminal. When i try to execute a command like env, or top the screen blancs and i have to close the terminal window to exit. I am not a sysadmin so probably i am missing something.

I have tried to export the TERM environment vairable to

export TERM=xterm

bot the problem remain the same.

It works ok from non Osx environments.

magento2 – Image’s don’t upload on product page and shows spinner icon

I’m attempting to add product images when adding a new product but I’m having a problem. The image uploads, but the spinner remains. As shown below:

enter image description here

I’ve done some digging. If I open the inspector window I see the following error:

Uncaught TypeError: Cannot read property 'value' of undefined
at product-gallery.js:138
at Function.grep (jquery.js:471)
at $.<computed>.<computed>.setBase (product-gallery.js:133)
at $.<computed>.<computed>.setBase (jquery-ui-1.9.2.js:432)
at $.<computed>.<computed>._addItem (product-gallery.js:217)
at $.<computed>.<computed>._addItem (jquery-ui-1.9.2.js:432)
at HTMLDivElement.handlerProxy (jquery-ui-1.9.2.js:739)
at HTMLDivElement.dispatch (jquery.js:5232)
at HTMLDivElement.elemData.handle (jquery.js:4884)
at Object.trigger (jquery.js:5136)

Which leads to the following code:

enter image description here

I put a breakpoint there and .value is null.

The image uploads, but only to the products/tmp directory. I’ve checked all error files in var/log and nginx and php logs. There’s no errors.

Anyone know why this might be happening? All permissions are correct (755 for media/* directory). Can’t understand what would cause this. Also happens if I switch back to Luma from my current theme.

The theme I’m using has no adminhtml that’s overriding anything.

Any advice?

openSSL shows a revoked certificate as secure

I downloaded a revoked certificate from the website https://www.ssl.com/sample-valid-revoked-and-expired-ssl-tls-certificates/. Specifically, the revoked certificate of the site https://revoked-rsa-ev.ssl.com/.

To check the verification result in OpenSSL, I downloaded the CRL and ran the command :

openssl verify -untrusted 'SSL.com EV SSL Intermediate CA RSA R3.pem' -CRLfile SSLcom-SubCA-EV-SSL-RSA-4096-R3.crl.pem -show_chain revoked-rsa-ev.ssl.com.pem

However, instead of showing it as revoked, it successfully verifies the certificate. This is the output :

revoked-rsa-ev.ssl.com.pem: OK
Chain:
depth=0: C = US, ST = Texas, L = Houston, O = SSL Corp, serialNumber = NV20081614243, CN = revoked-rsa-ev.ssl.com, postalCode = 77098, businessCategory = Private Organization, street = 3100 Richmond Ave, jurisdictionST = Nevada, jurisdictionC = US (untrusted)
depth=1: C = US, ST = Texas, L = Houston, O = SSL Corp, CN = SSL.com EV SSL Intermediate CA RSA R3 (untrusted)
depth=2: C = US, ST = Texas, L = Houston, O = SSL Corporation, CN = SSL.com EV Root Certification Authority RSA R2

Have I used the incorrect command? Moreover, even Chrome shows the certificate as trusted but not Firefox. Why is this happening?

security – Apache2 Logs – Single user agent shows as an escaped string

first time caller long time listener.

I’ve been playing around with hosting my own web server via Apache on an Ubuntu VM. I’ve been reviewing the access.log file, and noticed a discrepancy I can’t find any information for. See attached image:

Screenshot of importing the data into LibreOffice Calc

This request appears to have been escaped in quotes, it is the only one.

I don’t know what this means, nor can I find any information about it.

Is there any setting I can change on my end to make sure the log file does not keep the ‘”‘?

Also, would this indicate it is a fraudulent user agent and that IP should be blacklisted?

Thank you,
Mike

For Hire – TV Shows Poster/Uploader | Proxies-free

Hi. Welcome to my thread.

Need your TV Shows website updated with working links? Need someone to do the tedious task of posting new episodes or episodes of previous seasons? I’d be gladly to help you with that, for a fee of course!

I have about 60,000 episodes of mostly popular TV shows. Complete seasons of Grey’s Anatomy, Supernatural, The Big Bang Theory, even E.R. or Star Trek series. All these links guaranteed working in hosts like mixdrop, upstream, doodstream, vidlox and clipwatching.

Service would be:

$5/1000 episodes of 1 host
$7/1000 episodes of 2 hosts
$10/1200 episodes of 3 hosts

I will post these episodes on your website, turnaround time will be within 24 hours.

I only accept payments thru paypal or btc.

Thanks for checking out my thread and looking forward to work with you

-dashez

 

usa – If a US citizen shows up at the US border with no US passport, are immigration officials obligated to help them prove their identity?

(Note: this is US-specific but if other countries have similar laws it would be interesting to hear the analogous situations as well)

I know that the law states that US citizens have the right to enter the US based on their status as a citizen alone, not on on their possession of a passport; that is, it is illegal to deny entry to a US citizen simply because they don’t have their passport.

So for example, if an American shows up to a US border without their passport but with a driver’s license or some other form of ID, it might be a more laborious process, but they will be let in once their identity can be proved.

However, what if hypothetically, someone who claims to be a US citizen shows up with nothing at all? Are immigration officials obligated to do everything they possibly can (e.g. going to that person’s house to get their ID, summoning their acquaintances for interview; I’m honestly not sure what else …) to help the person prove their identity, or in that case are they allowed to turn them away?

usa – If a US citizen shows up at the border with nothing at all, are immigration officials obligated to help them prove their identity?

(Note: this is US-specific but if other countries have similar laws it would be interesting to hear the analogous situations as well)

I know that the law states that US citizens have the right to enter the US based on their status as a citizen alone, not on on their possession of a passport; that is, it is illegal to deny entry to a US citizen simply because they don’t have their passport.

So for example, if an American shows up to a US border without their passport but with a driver’s license or some other form of ID, it might be a more laborious process, but they will be let in once their identity can be proved.

However, what if hypothetically, someone who claims to be a US citizen shows up with nothing at all? Are immigration officials obligated to do everything they possibly can (e.g. going to that person’s house to get their ID, summoning their acquaintances for interview; I’m honestly not sure what else …) to help the person prove their identity, or in that case are they allowed to turn them away?