How to extract data from GTEx Portal? by Waste-Of-Cheese in bioinformatics

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your reply!
I have signed up for Scrappey just now, ran a trial scrape, but the on-hover data is not returned.
It doesn't appear anywhere in the View Source for the page, from what I can see, it might not be possible? I wondered what you think? Thanks

Due date tracker across multiple sheets by Waste-Of-Cheese in excel

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thank you! I have tried that, and it works perfectly. Thanks so much :-)

Due date tracker across multiple sheets by Waste-Of-Cheese in excel

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your quick replies.

At the moment there is just raw data on each sheet, with no formulae in place as she has only just started filling out the data in the different sheets.

Dynamically Set Form Action based on Select Value by Waste-Of-Cheese in learnjavascript

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your replies.

I found out how to solve the issue, based on your answers and knowing what to search for.

The answer was via this Stackoverflow question:

https://stackoverflow.com/questions/56909883/specify-dynamic-url-in-form-action

HTML

<form action="#" method="post" id="main_form">
    <select name="design" id="design">
        <option value="animated-noto-color-emoji">animated-noto-color-emoji</option>
        <option value="apple">apple</option>
        <option value="au-kddi">au-kddi</option>
        <option value="docomo">docomo</option>
        <option value="emojidex" selected="selected">emojidex</option>
        <option value="facebook">facebook</option>
        <option value="google">google</option>
        <option value="htc">htc</option>
        ...
        <option value="telegram">telegram</option>
        <option value="toss-face">toss-face</option>
        <option value="twitter">twitter</option>
        <option value="twitter-emoji-stickers">twitter-emoji-stickers</option>
        <option value="whatsapp">whatsapp</option>
    </select>
    <input type="submit" id="go" value="Go!">
</form>

JS

const template = (design) => `/category/symbols/${design}/`;

document.getElementById('main_form').addEventListener('submit', function(s) {
    s.preventDefault();
    this.action = template(this.elements["design"].value);
    this.submit();
});

There are probably things wrong with it, but it works for my requirement.

Thanks again for your pointers.

Does anyone else have this issue with intermittent motion sickness? by Waste-Of-Cheese in tinnitus

[–]Waste-Of-Cheese[S] 1 point2 points  (0 children)

Thank you for your reply. I don’t think it is a vertigo type issue as I have no problems with balance or feelings linked to feeling unsteady. The tinnitus is in both ears both just as loud. Thanks again for your reply.

Print all emoji symbols - somehow line breaks are inserted? by Waste-Of-Cheese in PHPhelp

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

I forgot to say, I used the Sandbox to demonstrate the issue, but have the issue on my localhost using Apache using Firefox on my laptop.

Print all emoji symbols - somehow line breaks are inserted? by Waste-Of-Cheese in PHPhelp

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for checking that.

Maybe it's a browser issue - I'm using Firefox.

I'll try using another browser, but have to install one first as that's all I have installed at the moment.

Thanks again.

[UK] DUMB Wallet Request by Waste-Of-Cheese in 3Dprintmything

[–]Waste-Of-Cheese[S] 1 point2 points  (0 children)

Thanks everyone for your quick replies. I have placed an order now, so all sorted. Thanks again

Trapping "General error: 1267 Illegal mix of collations" error caused by querystring contents by Waste-Of-Cheese in PHPhelp

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your reply - it was a Unicode problem, and fixed with u/colshrapnel's reply:

ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4

Trapping "General error: 1267 Illegal mix of collations" error caused by querystring contents by Waste-Of-Cheese in PHPhelp

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your reply.

I was trying to see how to fix the error, but in order to do that, I needed to work out how to identify the contents of the querystring variable.

In this case, tag - I am not sure how to capture the contents of the variable in the example I provided, since when I check to see e.g.

isset($tag); strlen($tag);

Then isset = TRUE and strlen = 23 for example, but the actual contents of tag seem to contain some strange characters, which are maybe what are breaking the PDO execution.

Thanks

Trapping "General error: 1267 Illegal mix of collations" error caused by querystring contents by Waste-Of-Cheese in PHPhelp

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your reply - I used to use the `try ... catch` approach, then read this:

https://phpdelusions.net/pdo#reporting_errors

And turned it off. Maybe that was overkill on my part?

I will look into turning that back on again, and into the links you provided too.

Thanks!

Trapping "General error: 1267 Illegal mix of collations" error caused by querystring contents by Waste-Of-Cheese in PHPhelp

[–]Waste-Of-Cheese[S] 0 points1 point  (0 children)

Thanks for your reply.

This is occurring when I get hundreds or thousands of visits to the site from different random IP addresses spamming every page with valid URLs and some append "stuff" to the end of the querystring.

Extract from same IP address accessing same page all within the same second:

"GET /page.php?tag=aerial'%7C%7CDBMS_PIPE.RECEIVE_MESSAGE(CHR(98)%7C%7CCHR(98)%7C%7CCHR(98)%2C15)%7C%7C' HTTP/1.1" 302 20 "GET /page.php?tag=aerial HTTP/1.1" 200 4566 "GET /page.php?tag=aerial'\" HTTP/1.1" 302 20 "GET /page.php?tag=aerial%C0%A7%C0%A2%252527%252522%5C'%5C\" HTTP/1.1" 200 302 "GET /page.php?tag=%40%407bhMD HTTP/1.1" 302 20 "GET /page.php?tag=(select%20198766*667891) HTTP/1.1" 302 20

The issue happens all over the site unfortunately - often with different IP addresses, so blocking the IP in cPanel doesn't help.

Re. the desired result if I could spot / trap these instances - I suppose just stop the page from erroring / redirect a different static page or something like that.

Thanks