cannot scrape any proxies (all fail from Scrapebox provided source)

Am I suppose to use a proxy when scraping proxies, all of them failed…cedSEOClub 

This is method I used. Nothing else And this is fresh install of Scrapebox

I went ahead an checked if my ip is blacklisted anywhere I don’t think it is.

Is there a way I can export these results to have you take a look?

Looking for a game, cannot remember the name of it [closed]

I am unsure it it’s actually an RPG game, but it’s kind of like Scrutinized, i am like 65% sure it has made by EA because i have a medium-strong memory of playing it through Origin. It has an abstract art style and is called something like Disgruntled or something, you are playing as a detective if remember correctly, and the game cover is blue abstract art with a man with a monocle (or whatever it’s called, glasses on only one eye). Does anybody have any idea which game this might be? Also sorry it this is not the right forum, i don’t know where else to ask this.

Cannot assign to function call when looping through and converting excel files [closed]

With this code:

 xls = pd.ExcelFile('test.xlsx') sn = xls.sheet_names for i,snlist in list(zip(range(1,13),sn)):     'df{}'.format(str(i)) =  pd.read_excel('test.xlsx',sheet_name=snlist, skiprows=range(6))  

I get this error:

‘df{}’.format(str(i)) = pd.read_excel(‘test.xlsx’,sheet_name=snlist, skiprows=range(6)) ^ SyntaxError: cannot assign to function call

df+str(i) also return error

i want to make result as: df1 = pd.read_excel.. list1… df2 = pd.read_excel… list2….

Cannot get aspect ration to 1 with simple Graphics

I am learning Mathematica and doing a simple animation project which animates the harmonic motion of a pendulum. For some reason, I cannot get the simplest thing to work — the aspect ratio for my pendulum graph will not go to 1. I have whittled my code down to something extremely simple that illustrates my problem:

Graphics[Line[{{0, 0}, {.5, -.5}}], Axes -> True, PlotRange -> {{-1.1, 1.1}, {-1.1, 0}}, AspectRatio -> 1]

Output of the code above

ERROR 1064 (42000): You have an error in your SQL syntax – Cannot understand what the error means

I’m trying to import an SQL db, exported from another place. I have the SQL create script. I am not sure what might be going wrong…

My mariadb version is

select version(); +----------------+ | version()      | +----------------+ | 10.5.8-MariaDB | +----------------+ 1 row in set (0.000 sec) 

Table create script:

-- phpMyAdmin SQL Dump -- version 5.0.4 -- -- -- Host: db -- Generation Time: Jan 04, 2021 at 05:59 PM -- Server version: 8.0.22 -- PHP Version: 7.4.11  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";   /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */;  -- -- Database: `mytestdb` -- CREATE DATABASE IF NOT EXISTS `mytestdb` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; USE `mytestdb`;  -- --------------------------------------------------------  -- -- Table structure for table `categories` --  DROP TABLE IF EXISTS `categories`; CREATE TABLE `categories` (   `id` int NOT NULL,   `category` varchar(100) GENERATED ALWAYS AS (json_unquote(json_extract(`json`,_utf8mb4'$  .category'))) VIRTUAL NOT NULL,   `popular` enum('true','false') GENERATED ALWAYS AS (json_unquote(json_extract(`json`,_utf8mb4'$  .popular'))) VIRTUAL NOT NULL,   `imageUrl` varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(`json`,_utf8mb4'$  .imageUrl'))) VIRTUAL NOT NULL,   `json` json NOT NULL,   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; 


ERROR 1064 (42000) at line 33: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,   `popular` enum('true','false') GENERATED ALWAYS AS (json_unquote(...' at line 3 

Cannot SUM the value of a field

I wonder if someone can help me with this SQL 2016 query.

I have two tables with following data

TblSalesRep This is the table holding the history of the territories that the sales rep looked after and the date range that they looked after it.

TerritoryId SalesRep FromDate ToDate 15 Anne 2020-01-01 2020-06-02 15 Dave 2020-06-03 2020-06-16 15 Anne 2020-06-17 2020-06-22 18 Anne 2020-06-23 2999-12-31

This is the table that holds the sales made by territory

tblSales TerritoryId TransactionId TransactionDate ProductCode Amount 15 1 2020-04-15 Bags 50 15 1 2020-04-15 Bags 50 15 2 2020-06-02 Bag 25 15 3 2020-06-03 Shoes 60 15 4 2020-06-07 Shoes 10 15 5 2020-06-17 Bags 15 15 6 2020-06-18 Bags 25 15 7 2020-06-25 Coat 100 18 8 2020-06-27 Bags 20

I’m trying to produce a report that displays the SalesRep and the total sold between two dates for a given SalesRep.

For example, if I provided a SalesRep = ‘Anne’ and a date range of ‘1 Jun 2020’ to ‘30 Jun 2020’ I would expect a result back of :

SalesRep Sum Anne 185

This is because it should exclude any business sold between 3 Jun 2020 – 16 Jun 2020 as the territory was looked after by Dave for a couple weeks and he sold that business between those dates.

I’ve tried using SUM function whilst joining to TblSalesRep but the figures are not what I’m expecting.

Could someone please assist.

Cannot connect to MariaDB Columnstore database on Docker

I’m running MariaDB 10.5 Columnstore on Docker as described here. This works fine when I connect to the database starting a command line in the container itself. I can connect and create a database and tables.

But when I try to connect with an SQL Client (such as DBeaver) from localhost on port 3306, I get the following error:

Host '_gateway' is not allowed to connect to this MariaDB server 

I tried to fixed that changing the /etc/my.sql.d/server.cnf file. I tried all the options below but the container always fails after restart, no matter the option.

How to make a MariaDB Columnstore container accept connections from localhost and/or other IP addresses?

These are the options that didn’t work:

[server] bind-address = ::  [mysqld] skip-networking bind-address =  [mysqld] bind-address = ::   [mysqld] skip-networking bind-address = ::   [mysqld] skip-networking=0 skip-bind-address 

Post slug cannot be edited after add add_rewrite_rule

Because I wanted to add a blog reference to the slug of each post, I add a add_rewrite_rule. But now the slug can not be edited on the dashboard. How can I make the slug editable? my dashbord: enter image description here

my code:

 // Add /blog/ to all blog pages. class BlogPage{      const SLUG_BLOG = 'blog';      public static function init() {         self::wpa_fix_blog_pagination();     }      public static function wpa_fix_blog_pagination(){          // Fix pagination         add_rewrite_rule(             'blog/page/([0-9]+)/?$  ',             'index.php?pagename=blog&paged=$  matches[1]',             'top'         );           // Change the default 'post' and add /blog/ to permalink.         add_rewrite_rule(             self::SLUG_BLOG.'/([^/]*)$  ',             'index.php?name=$  matches[1]',             'top'         );         add_rewrite_tag('%'.self::SLUG_BLOG.'%','([^/]*)');            // Change the default permalink structure of tags and categories         global $  wp_rewrite;         $  wp_rewrite->extra_permastructs['category']['struct'] = '/' . self::SLUG_BLOG .'/category/%category%';         $  wp_rewrite->extra_permastructs['post_tag']['struct'] = '/' . self::SLUG_BLOG .'/tag/%post_tag%';          // Change the default permalink structure of authors         $  wp_rewrite->author_base = 'blog/author';         $  wp_rewrite->author_structure = '/' . $  wp_rewrite->author_base . '/%author%';         add_rewrite_rule(self::SLUG_BLOG .'/author/([^/]+)/?$  ', 'index.php?author_name=$  matches[1]', 'top');           add_filter( 'post_link', array(__CLASS__,'change_post_link'), 10, 3 );     }       public static function change_post_link($  url, $  post, $  leavename){         if ( $  post->post_type == 'post' ) {             $  url = home_url( user_trailingslashit( self::SLUG_BLOG . '/' . $  post->post_name ) );         }         return $  url;     }  } // Init Blog Class add_action("init",function(){     BlogPage::init(); });   function fix_guid( $  guid ) {     $  guid = get_permalink( get_the_ID() );     return $  guid; } add_filter( 'get_the_guid', 'fix_guid' );  // redirect_posts_to_newblogurl if the post not starts with /blog/ add_action('template_redirect', function() {     $  lang = $  _COOKIE["wp-wpml_current_language"];      if (is_singular('post') && $  lang == 'en') {         if (substr( $  _SERVER['REQUEST_URI'], 0, 6 ) !== "/blog/") {             wp_redirect( get_the_permalink(), 301 );             exit;         }      } });