Why pages aren’t Indexed on SEO Search Console Google

Google Search Console Errors List

If Google’s crawler, Googlebot, encounters an issue when it tries to crawl your site and doesn’t understand a page on your website, it’s going to give up and move on. This means your page will not be indexed and will not be visible to searchers, which greatly affects your search performance.

Here are some of those errors:

  • Server Error (5xx)
  • Redirect Error
  • Blocked by robots.txt
  • Marked ‘noindex’
  • Soft 404
  • Unauthorized request (401)
  • Not Found (404)
  • Crawl Issue

Crawled – currently not indexed:

The page was crawled by Google, but not indexed. It may or may not be indexed in the future; no need to resubmit this URL for crawling.

If you see this, take a good hard look at your content. Does it answer the searcher’s query? Is the content accurate? Are you offering a good experience for your users? Are you linking to reputable sources? Is anyone else linking to it?

Make sure to provide a detailed framework of all the page content that needs to be indexed through the use of structured data. This allows search engines to not only index your content but for it to come up in future queries and possible featured snippets.

Optimizing the page may increase the chances that Google chooses to index it the next time it is crawled.

Discovered – currently not indexed:

The page was found by Google, but not crawled yet.

Even though Google discovered the URL it did not feel it was important enough to spend time crawling. If you want this page to receive organic search traffic, consider linking to it more from within your own website. Be sure to promote this content to others with the hope that you can earn backlinks from external websites. External links to your content is a signal to Google that a page is valuable and considered to be trustworthy, which increases the odds of it being indexed.

Alternate page with proper canonical tag:

This page is a duplicate of a page that Google recognizes as canonical, and it correctly points to that canonical page, so nothing for you to do here!

Just as the tool says, there’s really nothing to do here. If it bothers you that the same page is accessible through more than one URL, see if there is a way to consolidate.

Duplicate without user-selected canonical::

This page has duplicates, none of which is marked canonical. We think this page is not the canonical one. You should explicitly mark the canonical for this page.

Google is guessing which page you want them to index. Don’t make it guess. You can explicitly tell Google which version of a page should be indexed using a canonical tag.

Duplicate non-HTML page:

A non-HTML page (for example, a PDF file) is a duplicate of another page that Google has marked as canonical.

Google discovered a PDF on your site that contained the same information as a normal HTML page, so they chose to only index the HTML version. Generally, this is what you want to happen, so no action should be necessary unless for some reason you prefer they use the PDF version instead.

Duplicate, Google chose different canonical than user:

This URL is marked as canonical for a set of pages, but Google thinks another URL makes a better canonical.

Google disagrees with you on which version of a page they should be indexing. The best thing you can do is make sure that you have canonical tags on all duplicate pages, that those canonicals are consistent, and that you’re only linking to your canonical internally. Try to avoid sending mixed signals.

We’ve seen this happen when a website specifies one version of a page as the canonical, but then redirects the user to a different version. Since Google cannot access the version you have specified, it assumes perhaps that you’ve made an error, and overrides your directive.

Soft 404:

The page request returns what we think is a soft 404 response.

In Google’s eyes, these pages are a shell of their former selves. The remnants of something useful that once existed, but no longer does. You should convert these into 404 pages, or start populating them with useful content.

Submitted URL dropped:

You submitted this page for indexing, but it was dropped from the index for an unspecified reason.

This issue ‘s description is pretty vague, so it’s hard to say with certainty what action you should take. Our best guess is that Google looked at your content, tried it out for a while, then decided to no longer include it.

Investigate the page and critique its overall quality. Is the page thin? Outdated? Inaccurate? Slow to load? Has it been neglected for years? Have your competitors put out something that’s infinitely better?

Try refreshing and improving the content, and secure a few new links to the page. It may lead to a re-indexation of the page.

Duplicate, Submitted URL not selected as canonical:

The URL is one of a set of duplicate URLs without an explicitly marked canonical page. You explicitly asked this URL to be indexed, but because it is a duplicate, and Google thinks that another URL is a better candidate for canonical, Google did not index this URL. Instead, we indexed the canonical that we selected.

Viewport not set

The page does not define a viewport property, which tells browsers how to adjust the page’s dimension and scaling to suit the screen size. Because visitors to your site use a variety of devices with varying screen sizes—from large desktop monitors, to tablets and small smartphones—your pages should specify a viewport using the meta viewport tag. 

The “viewport” is the technical way that your browser knows how to properly scale images and other elements of your website so that it looks great on all devices. Unless your HTML savvy, this will likely require the help of a developer. If you want to take a stab at it, this guide might be helpful.

Viewport not set to “device-width”

The page defines a fixed-width viewport property, which means that it can’t adjust for different screen sizes. To fix this error, adopt a responsive design for your site’s pages, and set the viewport to match the device’s width and scale accordingly.

In the early days of responsive-design, some developers preferred to tweak the website for mobile-experiences rather than making the website fully responsive. The fixed-width viewport is a great way to do this, but as more and more mobile devices enter the market, this solution is less appealing.

Google now favors responsive web experiences. If you’re seeing this issue, it’s likely that you’re frustrating some of your mobile users, and potentially losing out on some organic traffic. It may be time to call an agency or hire a developer to make your website responsive.

Content wider than screen

Horizontal scrolling is necessary to see words and images on the pageThis happens when pages use absolute values in CSS declarations, or use images designed to look best at a specific browser width (such as 980px). To fix this error, make sure the pages use relative width and position values for CSS elements, and make sure images can scale as well. 

This usually occurs when there is a single image or element on your page that isn’t sizing correctly for mobile devices. In WordPress, this can commonly occur when an image is given a caption or a plug-in is used to generate an element that isn’t native to your theme.

The easy way to fix this issue is to simply remove the image or element that is not sizing correctly on mobile devices. The correct way to fix it is to modify your code to make the element responsive.

Text too small to read

The font size for the page is too small to be legible and would require mobile visitors to “pinch to zoom” in order to read. After specifying a viewport for your web pages, set your font sizes to scale properly within the viewport.

Simply put, your website is too hard to read on mobile devices. To experience this first-hand, simply load the page in question on a smartphone and experience it first hand.

According to Google, a good rule of thumb is to have the page display no more than 70 to 80 characters (about 8-10 words) per line on a mobile device. If you’re seeing more than this, you should hire an agency or developer to modify your code.

How To Fix A Server error (5xx):

Your server returned a 500-level error when the page was requested.

A 500 error means that something has gone wrong with a website’s server that prevented it from fulfilling your request. In this case, something with your server prevented Google from loading the page.

First, check the page in your browser and see if you’re able to load it. If you can, there’s a good chance the issue has resolved itself, but you’ll want to confirm.

Email your IT team or hosting company and ask if the server has experienced any outages in recent days, or if there’s a configuration that might be blocking Googlebot and other crawlers from accessing the site.

How To Fix A Redirect error:

The URL was a redirect error. Could be one of the following types: it was a redirect chain that was too long; it was a redirect loop; the redirect URL eventually exceeded the max URL length; there was a bad or empty URL in the redirect chain.

This basically means your redirect doesn’t work. Go fix it!

A common scenario is that your primary URL has changed a few times, so there are redirects that redirect to redirects. Example: http://yourdomain.com redirects to http://www.yourdomain.com which then redirects to https://www.yourdomain.com.

Google has to crawl a ton of content, so it doesn’t like wasting time and effort crawling these types of links. Solve this by ensuring your redirect goes directly to the final URL, eliminating all steps in the middle.

Submitted URL blocked by robots.txt:

You submitted this page for indexing, but the page is blocked by robots.txt. Try testing your page using the robots.txt tester.

There is a line of code in your robots.txt file that tells Google it’s not allowed to crawl this page, even though you’ve asked Google to do just that by submitting it to be indexed. If you do actually want it to be indexed, find and remove the line from your robots.txt file.

If you don’t, check your sitemap.xml file to see if the URL in question is listed there. If it is, remove it. Sometimes WordPress plugins will sneak pages into your sitemap file that don’t belong.

Submitted URL marked ‘noindex’:

You submitted this page for indexing, but the page has a ‘noindex’ directive either in a meta tag or HTTP response. If you want this page to be indexed, you must remove the tag or HTTP response.

Submitted URL seems to be a Soft 404:

You submitted this page for indexing, but the server returned what seems to be a soft 404.

These are pages that look like they are broken to Google, but aren’t properly showing a 404 Not Found response. These tend to bubble up in two ways:

  1. You have a category page with no content within that category. It’s like an empty shelf at a grocery store.
  2. Your website’s theme is automatically creating pages that shouldn’t exist.

You should either convert these pages to proper 404 pages, redirect them to their new location, or populate them with some real content.

For more on this issue, be sure to read our in-depth guide to fixing Soft 404 errors.

Submitted URL returns unauthorized request (401):

You submitted this page for indexing, but Google got a 401 (not authorized) response. Either remove authorization requirements for this page, or else allow Googlebot to access your pages by verifying its identity.

This warning is usually triggered when Google attempts to crawl a page that is only accessible to a logged-in user. You don’t want Google wasting resources attempting to crawl these URLs, so you should try to find the location on your website where Google discovered the link, and remove it.

For this to be “submitted”, it would need to be included in your sitemap, so check there first.

Submitted URL not found (404):

You submitted a non-existent URL for indexing.

If you remove a page from your website but forget to remove it from your sitemap, you’re likely to see this error. This can be prevented from regular maintenance of your sitemap file.

Deep Dive Guide: For a closer look at how to fix this error, read our article about how to fix 404 errors on your website.

Submitted URL has crawl issue:

You submitted this page for indexing, and Google encountered an unspecified crawling error that doesn’t fall into any of the other reasons. Try debugging your page using the URL Inspection tool.

Indexed, though blocked by robots.txt:

The page was indexed, despite being blocked by robots.txt

Your robots.txt file is sort of like a traffic cop for search engines. It allows some crawlers to go through your site and blocks others. You can block crawlers at the domain level or on a page by page basis.

Unfortunately, this specific warning is something we see all the time. It usually happens when someone attempts to block a bad bot and puts in an overly strict rule.

Below is an example of a local music venue that we noticed was blocking all crawlers from accessing the site, including Google. Don’t worry, we let them know about it.

Submitted and indexed:

You submitted the URL for indexing, and it was indexed.

You wanted the page indexed, so you told Google about it, and they totally dug it. You got what you wanted, so go pour yourself a glass of champagne and celebrate!

Indexed, not submitted in sitemap:

The URL was discovered by Google and indexed.

Google found these pages and decided to index them, but you didn’t make it as easy as you could have. Google and other search engines prefer that you tell them about the content you want to have indexed by including them in a sitemap. Doing so can potentially increase the frequency in which Google crawls your content, which may translate into higher rankings and more traffic.

Indexed; consider marking as canonical:

The URL was indexed. Because it has duplicate URLs, we recommend explicitly marking this URL as canonical.

A duplicate URL is an example of a page that is accessible through multiple variations even though it is the same page. Common examples include when a page is accessible both with and without a backslash, or with a file extension at the end. Something like yoursite.com/index.html and yoursite.com, which both lead to the same page.

These are bad for SEO because it dilutes any authority a page accumulates through external backlinks between the two versions. It also forces a search engine to waste its resources crawling multiple URLs for a single page and can make your analytics reporting pretty messy as well.

A canonical tag is a single line in your HTML that tells search engines which version of the URL they should prioritize, and consolidates all link signals to that version. They can be extremely beneficial to have and should be considered.

Google Search Console Excluded URLs

These are the pages that Google discovered, but chose to not index. For the most part, these will be pages that you explicitly told Google not to index. Others are pages that you might actually want to have indexed, but Google chose to ignore them because they weren’t found to be valuable enough.

Status Russo-Ukrainian War

The Russo-Ukrainian War has been ongoing between Russia and Ukraine since February 2014. Hostilities were initiated by Russia shortly after Ukraine’s Revolution of Dignity and were focused on the political status of Crimea and the Donbas, which remain internationally recognized as part of Ukraine.

  • On 10 November 2021, the United States reported an unusual movement of Russian troops near the borders of Ukraine.By 28 November, Ukraine had reported a build-up of 92,000 Russian troops.
  • On 7 December 2021, US President Joe Biden warned President of Russia, Vladimir Putin of “strong economic and other measures” if Russia attacked Ukraine.
  • On 17 December 2021, Putin proposed a prohibition on Ukraine ever joining NATO, which Ukraine rejected.
  • On 17 January 2022, Russian troops began arriving in Russia’s ally Belarus, ostensibly “for military exercises”.
  • On 19 January 2022, the US gave Ukraine $200 million in security aid.
  • On 19 January 2022, Biden stated in a press conference: “Russia will be held accountable if it invades. And it depends on what it does.” Many critics of the US president felt this left the door open for President of Russia Vladimir Putin to invade.
  • On 24 January 2022, NATO put troops on standby.
  • On 25 January 2022, Russian exercises involving 6,000 troops and 60 jets took place in Russia near Ukraine and Crimea.
  • February 2022
  • On 10 February 2022, Russia and Belarus began 10 days of military maneuvers.
  • On 17 February 2022, fighting escalated in separatist regions of eastern Ukraine.
  • 21 February
  • Putin announced Russian recognition of two pro-Russian breakaway regions in eastern Ukraine (the Donetsk People’s Republic and the Luhansk People’s Republic). This announcement led to the first round of economic sanctions from NATO countries the following day.

In his televised “address concerning the events in Ukraine” before the announcement, Putin stated his belief that Vladimir Lenin was the “author and architect” of Ukraine and labeled Ukrainians who have taken down Lenin’s monuments “ungrateful descendants”, saying “This is what they call decommunization. Do you want decommunization? Well, that suits us just fine. But it is unnecessary, as they say, to stop halfway. We are ready to show you what real decommunization means for Ukraine.”

References:

https://www.understandingwar.org/backgrounder/ukraine-conflict-updates

https://www.usip.org/current-situation-ukraine

https://gfsis.org.ge/russian-monitor/military-digest

https://news.google.com/search?q=Russia%20ukraine&hl=en-SG&gl=SG&ceid=SG%3Aen

Toapekong (Da Bo Gong / 大伯公)

Dewa Tua Pek Kong (Hanzi : 大伯公; pinyin : Dàbó Gōng) merupakan salah satu Dewa Taoisme dalam kepercayaan masyarakat Tionghoa perantauan di Malaysia dan Indonesia.

Namanya sendiri memiliki beragam sebutan. Orang Hakka menyebutnya Thai phak kong, orang Hokkian memanggilnya Tua peh kong, sementara orang Kanton mengejanya Daai baak gung.

Di Indonesia sendiri, masyarakat Tionghoa sering disebutnya sebagai Toa PekongToapekong, atau Topekong, yang secara harafiah berarti “Paman Agung”).

Dalam dialek Hokkian, Toa/Tua sendiri memiliki arti “yang paling besar, atau yang tertua”. Sementara Pek sendiri memiliki arti “paman, atau kakak“. Lalu Gong sendiri memiliki arti “kakek”.

Jadi, pengertian Da Bo Gong (atau Toa Pek Kong) secara keseluruhan adalah “Kakak Tertua dari Kakek, atau Paman Buyut”. Sebutan tersebut merupakan sebutan paling terhormat, karena kultur masyarakat Tiongkok sangat menghormati orang2 yang lebih tua.

Tua Pek Kong sendiri dianggap sebagai “Dewa Kemakmuran”. Menurut kisah hidupnya, beliau merupakan seorang pelaut dari wilayah Fujian Tiongkok, yang mengorbankan dirinya untuk umat manusia.

Beliau juga dipercaya sebagai reinkarnasi Dewa “Fu” dari trio Dewa Fu Lu Shou 福祿壽, yang mewakili “Kemakmuran, Keberuntungan, dan Umur Panjang”.

Berikut riwayat hidup Toa Pek Kong :

Terdapat beberapa versi sejarah tentang kehidupan Toa Pek Kong sebelum diangkat menjadi Dewa.

Versi pertama menyebutkan bahwa Beliau adalah seorang pelaut dari propinsi Fujian, yang memperoleh mimpi bahwa suatu ketika di tengah laut terdapat seseorang yang mengapung dalam kondisi keracunan. Ia menemukan orang tersebut, lalu menyedot racun dari mulut korban sehingga selamat, namun dirinya sendiri meninggal.

Masyarakat kemudian memujanya, untuk mengenang keberanian serta pengorbanannya.

Versi kedua menyebutkan bahwa Beliau adalah seorang pelajar Fujian yang lari ke wilayah Malaya (saat ini Malaysia) pada masa dinasti Qing, tepatnya pada pemerintahan Kaisar Qianlong 乾隆帝 (1736-1790). Ia digambarkan sebagai pria yang jujur, berbudi, ramah, dan memiliki jenggot yang panjang.

Tua Pek Kong adalah seorang pria bernama Zhang Li (张理) yang berasal dari suku Hakka. Suatu ketika hendak menuju wilayah Sumatra, perahunya dilanda angin yang kuat, dan secara tidak sengaja mendarat di pulau Penang di Malaysia, yang ketika itu baru dihuni sekitar puluhan penduduk saja.

Beliau diyakini telah tiba di pulau itu 40 tahun lebih awal dari Francis Light (seorang penjelajah dan pendiri koloni Inggris di Penang, pada tahun 1746). Pasca kematiannya, penduduk setempat mulai memujanya dan membangun Kuil Tua Pek Kong di sana.

Ia dimakamkan di belakang pulau Mutiara kuil Tua Pek Kong (Sea Pearl Island) di Tanjung Tokong. Kisah Tua Pek Kong pertama di Penang menunjukkan tradisi persaudaraan tersumpah, diantara sesama perantauan orang2 Tiongkok :

Zhang Li (张理) tinggal di komunitas nelayan kecil sebagai guru. Dia dikenal karena kebaikan dan keramahannya, sehingga penduduk desa setempat selalu mencarinya untuk meminta bantuan dan bimbingan ketika mereka memiliki masalah.

Menurut catatan, 2 orang yang menjadi saudara lelakinya yang disumpah, yakni Chiu Hsiao Ching, pembuat arang, dan Ma Fu Choon, seorang pandai besi.

Karena Ia adalah anak tertua, Ia biasa dipanggil oleh anak-anak muda di desa itu dengan sebutan Tua Pek (dialek Hokkian). Dalam dialek Hokkian, Toa/Tua sendiri memiliki arti “yang paling besar, atau yang tertua”. Sementara Pek sendiri memiliki arti “paman, atau kakak“.

Sebutan tersebut merupakan sebutan paling terhormat, karena kultur masyarakat Tiongkok menghormati orang2 yang lebih tua. Mereka ber-3 tampak sangat dekat satu sama lain. Ketika pekerjaan di hari itu selesai, mereka selalu bertemu satu sama lain di satu tempat favorit mereka di desa.

Suatu hari, Chiu dan Ma, seperti biasa pergi menemui saudara tertua yang mereka segani, tetapi terkejut ketika menemukan dia duduk tidak bergerak di samping batu besar. Mereka mencoba membangunkannya, tetapi kemudian segera menyadari, bahwa sesepuh yang mereka hormati itu telah meninggal dunia.

Perasaan sedih membanjiri seisi penghuni desa, yang kemudian ikut membantu menguburnya tak jauh dari batu besar itu. Lalu ketika Chiu dan Ma meninggal, mereka juga dimakamkan di sana, di samping saudara tertua mereka yang disumpah.

Saat ini, kuburan ketiganya masih dapat ditemukan tepat di belakang kuil Sea Pearl Island Tua Pek Kong, Penang, Malaysia.

Sejak saat itu, masyarakat kemudian membangun sebuah kuil untuknya, dan menyembahnya sebagai seorang Dewa oleh masyarakat Tionghoa peranakan di Malaysia. Kepercayaannya kemudian menyebar hingga ke wilayah timur Malaysia, Singapore dan Indonesia.

Kuil Pagoda Tua Pek Kong di Sibu, Malaysia

Beliau dipercaya sebagai Dewa yang melindungi keselamatan para pelaut dalam pelayaran, yang dikenal luas di wilayah Malaya dan Indonesia.

Beliau juga dipuja oleh para buruh imigran Tiongkok (dinasti Qing) yang bekerja di perkebunan lada di Semenanjung Malaya, sekitar awal tahun 1800-an, dikarenakan banyak yang meninggal akibat malaria serta penyakit iklim tropis lainnya.

Namun masyarakat Tionghoa sendiri juga menganggap Toa Pek Kong sebagai Dewa perdagangan dan kekayaan (rezeki). karena melindungi para pekerja dari sakit dan kecelakaan, sehingga mereka dapat fokus untuk bekerja mencari kekayaan; serta akan memberkahi orang2 yang berhati baik.

Di Sarawak – Malaysia Timur, ada sekitar 76 kuil Tua Pek Kong yang tersebar disana. Di Batam, Indonesia, Kuil Tua Pek Kong yang paling terkenal terletak di Nagoya (Lubuk Baja).

Menurut penulis, Dewa Tua Pek Kong sendiri dapat dianggap seperti “Dewa Lokalnya” masyarakat Tionghoa di wilayah Malaya (Malaysia). Ini halnya seperti Dewa Wong Tai Sin (黄大仙; Huang Daxian) di Hongkong.

Karena kesamaan fisiknya juga (visualisasi), masyarakat Tionghoa sendiri sering keliru dalam membedakan, antara Tua Pek Kong dan Tu Di Gong.

Backup And Restore Database MySQL All Schema Data Routine Trigger Specific Database

It is necessary to make a backup of the database before reinstalling the server or just in case something unexpected happens. We can actually do backups through Phpmyadmin by exporting all databases. But what if we haven’t installed Phpmyadmin on the Server?

How to Backup All Databases

1. Backup Schema and Data

mysqldump -u username -p --all-databases > backup.sql
or
mysqldump -u username -p -A > backup.sql

2. Backup only the Schemas

mysqldump -u username -p --all-databases --no-data > backup_schema.sql
or
mysqldump -u username -p -A -d > backup_schema.sql

3. Backup by Remote Server

mysqldump -u root -h 128.168.1.1 -p -A > backup.sql

4. Backup Routines

mysqldump -u username -p db_name --routines > backup_routinetrigger.sql
or
mysqldump -u username -p db_name -R > backup_routinetrigger.sql

5. Backup Routines and Triggers

mysqldump -u username -p db_name --routines --triggers > backup_routinetrigger.sql

6. Backup Specific Database

mysqldump -u username -p --database db_name > backup_db_name.sql
or
mysqldump -u username -p db_name > backup_db_name.sql

7. Backup Specific Table in Specific Database

mysqldump -u username -p --database db_name table_name > backup_db_name_table_name.sql
or
mysqldump -u username -p db_name table_name > backup_db_name_table_name.sql

How To Restore Database

8. Restore all Databases

mysql -u username -p < backup.sql

9. Restore one database

mysql -u username -p db_name < backup_db_name.sql

10. Manual command line for mysql

man mysqldump
man mysql

11. References

https://dev.mysql.com/doc/refman/8.0/en/mysql.html

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

Thomas Shelby Business Money Supreme Tag

Peaky Blinders is a British period crime drama television series created by Steven Knight. Set in Birmingham, England, the series follows the exploits of the Shelby crime family in the direct aftermath of the First World War. The fictional family is loosely based on a real urban youth gang of the same name, who were active in the city from the 1890s to the early 20th century.

https://en.wikipedia.org/wiki/Peaky_Blinders_(TV_series)

Install PostgreSQL 14 and Remote on Ubuntu – Easy Install

Install PostgreSQL 14

1. Update Ubuntu and get PostgreSQL requirements

sudo apt update
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" | sudo tee /etc/apt/sources.list.d/postgresql-pgdg.list > /dev/null

sudo apt update

2. Get PostgreSQL 14 installed on your Ubuntu system

sudo apt install postgresql-14

3. PostgreSQL’s default port (5432) should not be held hostage by any other system process.

sudo ss -atnp | grep 5432

4. Next, restart, enable PostgreSQL so that it keeps running even after your Ubuntu system reboots, and check on the status of PostgreSQL to make sure it is running.

sudo systemctl restart postgresql
sudo systemctl enable postgresql
sudo systemctl status postgresql 

5. Connecting to PostgreSQL 14 Database in Ubuntu

sudo -u postgres psql

6. For example, to create a PostgreSQL admin superuser that has all the database user privileges, we would execute the following query.

CREATE ROLE <username> WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD  '<password>';

<username> : any usernames , <password> : any passwords

7. To confirm the existence of the PostgreSQL superuser, execute the following command.

\du

8. To exit PostgreSQL shell, run the command

exit;

Remote Configuration PostgreSQL 14

1. Edit the configuration file to allow remote access

vi /etc/postgresql/14/main/postgresql.conf

Look for this line in the file:

listen_addresses = 'localhost'

Uncomment, and change the value to '*', this will allow Postgres connections from anyone.

listen_addresses = '*'

2. Save and exit the file. Next, modify pg_hba.conf to also allow connections from everyone. Open the file with your preferred editor:

vi /etc/postgresql/14/main/pg_hba.conf

Modify this section:

# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256

To this:

# IPv4 local connections:
host    all             all             0.0.0.0/0            scram-sha-256

3. Allow PostgreSQL port from Firewall

sudo ufw allow 5432/tcp

4. Restart PostgreSQL

sudo systemctl restart postgresql

Cannot sudo apt update failed to update UBUNTU

1. Edit netplan File

sudo vi /etc/netplan50-cloud-init.yaml

2. Add Nameserver Google / Cloudflare or any, on nameserver

network:
    ethernets:
        [network-device]:
            ...
            nameservers:
                addresses:
                - 2001:4860:4860::8888
                - 2001:4860:4860::8844
                - 8.8.8.8
                - 8.8.4.4
                - 1.1.1.1

notes: don’t use tab on this file, only space allowed.

3. Apply and Test the Network

sudo netplan apply
systemd-resolve --status

Pajak Untuk Programmer Freelance

Lampiran II Peraturan Direktur Jenderal Pajak

Nomor : PER- 17 /PJ/2015 Tentang : Norma Penghitungan Penghasilan Neto

DAFTAR PERSENTASE NORMA PENGHITUNGAN PENGHASILAN NETO UNTUK WAJIB PAJAK ORANG PRIBADI YANG TERNYATA TIDAK ATAU TIDAK SEPENUHNYA MENYELENGGARAKAN PEMBUKUAN ATAU TIDAK BERSEDIA MEMPERLIHATKAN PEMBUKUANATAU PENCATATAN ATAU BUKTI-BUKTI PENDUKUNGNYA Kode KLU: 62010 (KEGIATAN PEMROGRAMAN KOMPUTER) Perhitungan 62,5% (semua kota)

https://www.pajak.go.id/sites/default/files/2019-03/Lampiran%201_PER%20-%2017.PJ_.2015.pdf

Kelompok ini mencakup jasa konsultasi yang berkaitan dengan analisis, design dan pemrograman dari sistem yang siap pakai. Kegiatan ini biasanya menyangkut analisis kebutuhan pengguna komputer dan permasalahannya, pemecahan permasalahan, dan membuat piranti lunak berkaitan dengan pemecahan masalah tersebut. Termasuk pula penulisan program sederhana sesuai kebutuhan pengguna komputer. Perancangan struktur dan isi dari, dan/atau penulisan kode komputer yang diperlukan untuk membuat dan mengimplementasikan, seperti sistem piranti lunak (pemutahiran dan perbaikan), aplikasi piranti lunak (pemutahiran dan perbaikan), database dan halaman web. Termasuk penyesuaian piranti lunak, misalnya modifikasi dan Penyesuaian konfigurasi aplikasi yang sudah ada sehingga berfungsi dalam lingkungan sistem informasi klien. Kegiatan sejenis yang dilaksanakan sebagai bagian yang tak terpisahkan dari penjualan piranti lunak dimasukkan dalam subgolongan 47413.

2018

Programmer, Web Programmer, Web Designer (KLU : 62010) :

10 Ibukota propinsi : 50% (Medan, Palembang, Jakarta, Bandung, Semarang, Surabaya, Denpasar, Manado, Makassar, Pontianak)

Ibukota propinsi lainnya : 50%

Daerah lainnya : 50%

Jadi kalau penghasilan programmer jakarta setahun 250 juta maka penghasilan netnya :

Rumusnya : Penghasilan neto = Penghasilan bruto x Norma Penghitungan Penghasilan Neto (NPPN)

250.000.000 x 50% = 125.000.000

Jadi 125 juta ini yang akan dihitung pajaknya.

O iya masukan penghasilan kotor setahun di kolom PEREDARAN USAHA bagian PEKERJAAN BEBAS, kemudian masukkan jumlah Norma lalu isikan manual hasil netnya di kolom PENGHASILAN NETO. Masing-masing form diisi manual karena tidak bisa perhitungan otomatis.

Dan Norma ini dilaporkan tertulis ya pada saat kita ke kantor pajak untuk merubah data.

Bisa di download formnya di sini Form Laporan Penggunaan Norma

Contoh Pengisian Form Penggunaan Norma
Penghasilan kotor setahun dikali norma akan dapat penghasilan bersih

Setelah pengisian Formulir 1770-I Halaman 2 maka hasil perhitungannya otomatis akan masuk ke Formulir induk 1770. Di form induk ini jangan lupa centang Pencatatan di pojok kanan atas. Lalu Status Kewajiban Perpajakan dicentang KK (jomblo/udh nikah pilih ini). Dan yang paling penting di formulir ini adalah centang PTKP (Penghasilan Tidak Kena Pajak) yang bisa mengurangi jumlah penghasilan net sebelum dihitung pajaknya.

Untuk Jomblo pilih TK, yang udah nikah belom punya anak pilih K, nikah udah punya anak pilih K dan jumlah anak dibawahnya (maks. 3), yang nikah penghasilan suami istri digabung pilih K/I dan jumlah anaknya. Kalo nikah dan punya anak PTKPnya makin besar lumayan pajaknya bisa kecil.

Tarif PTKP 2018 :

PTKP 2018

Kasus di sini Wajib Pajak sudah menikah dengan tanggungan 2 anak, sehingga PTKP yang didapatkan sebesar 67.500.000

Jangan lupa centang yang diberi lingkaran merah

Nanti penghasilan net akan terhitung otomatis jumlah pajaknya.

Pajak akan terhitung otomatis

Jika penghasilan Net kita di atas PTKP maka pajak akan terhitung otomatis dan jumlah itulah yang harus kita bayarkan ke negara. Tapi jika penghasilan Net kita di bawah PTKP maka kita tidak berkewajiban membayar pajak tapi tetap wajib melaporkan SPT kita.

Dari kasus di atas dari pendapatan neto 80 juta maka setelah dikurangi PTKP 67,5 juta maka penghasilan yang wajib dibayar pajaknya adalah :

80.000.000–67.500.000 = 12.500.000

Jadi 12.500.000 ribu inilah yang akan kita hitung pajaknya.

Tarif PPh 21 dijelaskan pada Pasal 17 ayat (1) huruf a Peraturan Direktur Jenderal Pajak Nomor PER-32/PJ/2015. Tarif PPh 21 berikut ini berlaku pada Wajib Pajak (WP) yang memiliki Nomor Pokok Wajib Pajak (NPWP):

  • WP dengan penghasilan tahunan sampai dengan Rp 50 juta adalah 5%
  • WP dengan penghasilan tahunan di atas Rp 50 juta — Rp 250 juta adalah 15%
  • WP dengan penghasilan tahunan di atas Rp 250 juta — Rp 500 juta adalah 25%
  • WP dengan penghasilan tahunan di atas Rp 500 juta adalah 30%
  • Untuk Wajib Pajak yang tidak memiliki NPWP, dikenai tarif pph 21 sebesar 20% lebih tinggi dari mereka yang memiliki NPWP.

Berdasarkan tarif PPh 21 di atas maka penghasilan kita yang 12.500.000 masuk dalam penghasilan 50 juta dan tarif pajaknya adalah 5%. Jadi jumlah pajak yang harus bayar sebesar :

12.500.000 x 5% = 625.000

Dari penghasilan Rp 250 juta setahun ternyata pajaknya cuma Rp 625.000 setahun.

Nah ternyata pajaknya gak sebesar yang dibayangkan kan? Itu karena sebenarnya banyak variabel yang bisa dijadikan sebagai pengurang penghasilan kotor kita di mana kita tidak mengetahui info ini.

Setelah semua form selesai terisi dan dirasa tidak ada yang salah maka klik tombol Submit di atas form untuk pengiriman online. Form pajak kita juga bisa diprint dengan memencet Ikon Printer di bawah. Jangan lupa masukan token yang sebelumnya sudah dikirimkan melalui email lalu klik tombol Submit.

Masukkan toke untuk pengiriman SPT online

Kalau pengiriman berhasil maka akan dikirimkan tanda terima melalui email.Tanda

Tanda terima akan dikirim melalui email

Dan form yang kita kirim otomatis akan masuk ke Daftar SPT online kita.

Eform langsung update

Jadi sebenarnya mudah kan buat laporan SPT tidak susah seperti yang dibayangkan? Apalagi yang sudah punya NPWP maka kamu wajib lapor kalau gak diurus maka akan susah ke depannya untuk urusan misalnya pembelian properti (rumah,ruko) karena notaris akan mengecek NPWP kita (untuk urusan pajak jual beli), jika kita tidak pernah melaporkan SPT sebelumnya maka NPWP kita otomatis akan di nonaktifkan plus gak bisa balik nama dan untuk mengaktifkannya harus melapor SPT 2 tahun terakhir plus dendanya. Jadi repotkan?

Makanya sebelum terlambat silahkan urus laporan SPT kamu bagi yang sudah punya NPWP. Terakhir lapor tanggal 31 maret 2018 loh!

Sumber :

https://medium.com/@rianrahardi/graphic-designer-freelancer-punya-npwp-udah-lapor-pajak-belum-b1e1c3357efd

https://www.online-pajak.com/id/tarif-pajak-pph-21

https://www.pajak.go.id/sites/default/files/2019-03/Lampiran%201_PER%20-%2017.PJ_.2015.pdf

https://www.pajakbro.com/2016/04/cara-menghitung-ptkp-dan-contohnya.html

https://www.pajakbro.com/2016/06/ptkp-2016-terbaru-pdf.html

https://www.pajak.go.id/id/surat-pemberitahuan-penggunaan-norma-penghitungan-penghasilan-neto

Temporary ad serving limit placed on your AdMob account | Google Admob

As a result, Google may sometimes place a limit on the number of ads your AdMob account can show. This might be a temporary ad serving limit to evaluate your traffic quality, or it might be because we’ve identified invalid traffic concerns in your AdMob account.

Admob offers popular ad formats such as native banners, transition ads, and award-winning video ads, as well as harmonization tools that help publishers get the most out of every impression. Unity Ads, on the other hand, is a popular mobile device advertising network specially created for game developers. The network has links to some of the biggest brands and advertisers looking for game inventory.

Unity Ads has been hugely popular and known for its highest eCPM for award-winning video ads. In this Unity Ads vs Admob article, we will discuss the topic of Google Admob and Unity Ads. If you own a mobile app or a game and haven’t decided which advertising company to use, you’re in the right place!

Unity Ads vs Admob: Ad units

Admob

  1. Banner Ad: A rectangular ad unit can be added to the upper, lower right, or left of the game and application. It automatically renews within an optional period of time after a specified time. Compared to Admob’s other ad units, banner ad earnings are low.
  2. Interstitial Ad: Leveling up is a full-page ad unit that is displayed at the click of a button or during any transition. It is the most profitable ad unit considering some policy violations. Admob users generally increase their earnings thanks to interstitials. An interstitial ad is known to earn 5 to 10 times more than a banner ad.
  3. Award-winning ad: A full-page term ad unit that rewards users who choose to view an ad. Unlike rewarded interstitials, users should choose to view the ad. If abuse occurs and no rewards are awarded, your Admob account may be banned temporarily or even permanently. In terms of earnings, you get high impressions and good earnings per click.
  4. Native advanced Ad: The native advanced ad unit is the native advanced Admob ad unit, which is often used for news apps, VPN, and other apps. Android games are also not recommended. In terms of earnings, it is known to earn 2 times more than banner ads.
  5. With the application open: It is a newly added ad unit with good impressions per thousand. It is a native advanced ad unit that comes out full screen the moment the app or game is open and the return is made to the app again.
  6. Award-winning interstitial (BETA): This ad unit is the new ad unit that is equivalent to an interstitial ad unit, and in some cases even offers high eCPM values. It offers high values in terms of gain. The problem is that it is highly annoying for the user.

Unity Ads

  1. Banner Ad: It is a rectangular banner ad unit that is not used much on Unity Ads. It is known to be extremely low in terms of gain.
  2. Interstitial Ad: The interstitial ad unit is the frequently used and preferred ad unit over-unity ads. Compared to the banner ad unit used in Unity Ads, the interstitial ad is 10 times more profitable.
  3. Award-winning Ad: Since Unity Ads does not have strict rules, some cases have been seen by those who frequently use award-winning ads. Award-winning advertising earnings are only preferred for the Application (Game). According to the known, the ad content consists of 60% or more game content.

Unity Ads vs AdMob: Google Admob Earnings

I have been using Admob frequently lately. And I recommend it! If you have a problem-free Gmail account and an Adsense/Admob account with a pin, you should choose Admob without thinking.

As you can see in the chart, earnings from Google Admob, not Unity ads! If you are getting frequent impressions from developed countries, it is a good idea to use the Admob interstitial ad unit. Unity Ads Vs Admob.

Admob vs Unity Ads Result:

In short, when Unity ads vs Admob revenue are called priority, we need to find out for what reason we need to choose. As you know, Unity Ads can be used temporarily because AdMob policy and installation are very difficult. But if you have a Google AdMob account (PIN), you can choose Google AdMob. This is exactly the result of Unity Ads Vs Admob.

Unity Ads Vs AdMob is generally compared to earnings-oriented. I certainly let’s not forget that! To use Unity Ads, it must certainly be used to appeal to developed countries. 1,000 impressions from economically worthless countries are worth $0.00 CPM. You can be careful about that.

It is possible to see the Unity ads vs Admob revenue values at the top. The winner of this is Google AdMob. Any kind of Unity Ads vs AdMob Revenue encounter is discussed, but as you know, Unity Ads advertising is very easy to install and does not have very strict rules in terms of the policy.

Google AdMob, on the other hand, has annoying strict rules. Also, for a beginner, installing AdMob is very difficult. Here’s your answer: what might be the most logical decision for you when it comes to Unity Ads vs AdMob Revenue?

Unity Ads vs AdMob: Account Confirmation Process And Withdrawals

With Unity Ads and Google AdMob, one of the monetization platforms, you may need detailed account confirmations and withdrawals before you can monetize your mobile apps.

Unity Ads

From games developed with Unity 3D, you can add ads and start earning instantly. Although unity ad mediation is hardly recommended, it is generally recommended to use the Rewarded Ads format. You can choose Unity Ads because Unity Ads does not have strict and strict rules. Another important issue that most interests app developers are that the minimum shooting starts at $100.

Google AdMob

Google AdMob, one of the most important advertising platforms for app advertising, has become available for apps and games. You can opt for AdMob to monetize your app. AdMob is strongly recommended for advertising mediation. Mobile ad networks have millions in AdMob advertising. So What are Google AdMob’s strict rules? If you click on your ads even 1 time, you will instantly get a ban. Also, the biggest other problem is that New AdMob users need to enter home addresses for account verification. A 6-digit pin code (envelope) is sent to the home address you enter. If the code in this envelope is not entered, you will not be able to request payment in any way. Minimum shooting amounts vary depending on all countries. It ranges from $40 to $100 Dec. (General)

FaQs; Unity Ads vs AdMob? Brief Tips On.

What is Unity Ads vs Admob Revenue?

It is possible to see the Unity ads vs Admob revenue values at the top. The winner of this is Google AdMob. Any kind of Unity Ads vs AdMob Revenue encounter is discussed, but as you know, Unity Ads advertising is very easy to install and does not have very strict rules in terms of the policy.

Unity Ads vs Admob Which Earns More?

In short, when Unity ads vs Admob revenue are called priority, we need to find out for what reason we need to choose. As you know, Unity Ads can be used temporarily because AdMob policy and installation are very difficult. But if you have a Google AdMob account (PIN), you can choose Google AdMob. This is exactly the result of Unity Ads Vs Admob.

What is Unity Ads Ad Earnings?

Unity Ads, Likewise, the banner ad in the fight game was $0.67 per thousand impressions, while the interstitial ad was $9.8. These data were calculated based on US-weighted ad impressions. So this means that if you are targeting advertisements from developed countries, you should consider such possibilities.

Unity Ads or Google Admob?

It is possible to see the Unity ads vs Admob revenue values at the top. The winner of this is Google AdMob. Any kind of Unity Ads vs AdMob Revenue encounter is discussed, but as you know, Unity Ads advertising is very easy to install and does not have very strict rules in terms of the policy.
Google AdMob, on the other hand, has annoying strict rules. Also, for a beginner, installing AdMob is very difficult. Here’s your answer: what might be the most logical decision for you when it comes to Unity Ads vs AdMob Revenue?

Does Unity Ads or Admob earn more?

There are a lot of ad networks on the market, but none as big as Admob. There are many ad units in AdMob that your application needs. You can increase your earnings with Banner, migration, award-winning, and locally advanced ad units. On the other hand, Unity Ads is an extremely popular advertising network created especially for Game Developers. Unity ad has ad units(Bannertransitionawardwinning) like AdMob. The installation of two advertising services is very simple.

Daily Unity Ads Revenues

you can earn $0.01 as your ad has been shown 1000 times. 622 views can also earn $2.19.

Daily Admob Revenues

Banner ads on the Admob network are more profitable because they work efficiently. Based on the earnings without including Banner ads, it earned about $45 in 19k impressions. 1K impressions were calculated at $2.34. Along with Banner ads, it earned $52.

How To Enter Singapore in 2022

Requirements:


This SG Arrival Card is only valid for one time use on the expected date of your arrival in Singapore indicated above. Please note that the SG Arrival Card is not a visa. The use of the SG Arrival Card e-Service is free of charge. Click here for more information regarding entry visa requirements.

Thank you for using the SG Arrival Card! We wish you a pleasant visit to Singapore.

References:

Immigration & Checkpoints Authority (ICA)
Website: www.ica.gov.sg
Facebook: fb.com/Immigration.Checkpoints.Authority

Exit mobile version