Category: Wordpress

Google Webmaster Tools Twitter

Last Time i tried  to integrate a Twitter Timeline into my blog but i found out that this ranked down my blog on Google Webmaster Tools cause Twitter sub connected Servers blocking Google Webmaster Bot from reading the timeline by own robots.txt so i stopped using Twitter Integration to fix.  No Webmaster want show non indexed Informations  and went back to the time of  stones.. Twitter fails..

WordPress: Useful Keyboard Shortcuts Editor

If you use WordPress you can speed up your blogging by using the WordPress Shortcuts: Visual Editor: Basics: Ctrl + b = Bold Ctrl + i = Italic Ctrl + c = Copy Ctrl + v = Paste Ctrl + x = Cut Ctrl + a = Select All Ctrl + z = Undo Ctrl + y = Redo Ctrl + [number] = Insert heading sizes, e.g. CTRL+1 = <h1>, CTRL+2 = <h2> Advanced: Alt + Shift + n = Check Spelling Alt + Shift + l = Align Left Alt + Shift + j = Justify Text Alt + […]

WordPress: Enable Distraction Write Mode Editor

If you use WordPress, you perhaps switched off some features long time ago, once i missed was the Editor Fullscreen Mode where the Posting Paper only was shown. To enable it again: Login as User with Editor Rights Enter on Browser Fullscreen (Firefox = F11) Open with the Mouse the “Screen Options” Menu on the top right There you find the switch to select on. Now a “Cross Button” appear on the tools bar See on the right site the “Cross Distraction Button”, click to cleanup the Editor.  The WordPress Borders are hidden.    

WordPress: Get URL of all Posts

On a lot of  Blogs, Forum and Howto Pages i have read the Question: “How to get the URL of all WordPress Posts?” If you dont want to use a external Plugin which can be a Security Hole in the CMS you can fix it with a small Workaround: Login into WordPress as Blog Admin Create a New cenral Categorie like “Howtos” Now go to the Posts Page where all Content Pages can be seen as list Here SELECT ALL and do Bulk Action “ADD” to the new Categorie “howto” that’s it.. now all Posts listet like.. https://www.linuxonlinehelp.eu/category/howto/ Remark: If […]

MYSQL: Default Basic Table Structure WordPress

If you use WordPress and have tested some plugins and removed them later, it is possible that you have much waste tables still inside your database. First do Database Backup with MySQL DUMP Then check it enter the mysql console as your mysql admin user and do: $mysql -u mysqladminusername -p mysql > use databasename; mysql > show tables; System echo: +—————————+ | Tables_in_wordpressdatab | +—————————+ | wp_commentmeta            | | wp_comments               | | wp_links                  | | wp_options                | | wp_postmeta               | | wp_posts                  | | wp_term_relationships     | | wp_term_taxonomy          | | wp_termmeta               | | wp_terms                  | | wp_usermeta               | | […]

WordPress: Prevent Copyright Violation

If you are a Hobby Blogger like me, you should ALWAYS take Snapshots for your Blog with your OWN Camera! For “non professional” use you can take the cheapest Camera or reuse old Smartphones of the Family. Resolution at VGA Mode (640×480/800×600 less 250kb) is more enough than you need. Faster you can’t save or earn Money, a Camera Snapshot needs less a second.. Don’t DO Rules: Don’t download and share Images from public sites Don’t take Snapshots on public Sites with a Snapshot Tool like gnome-screenshot Don’t take Parts of Images from public sites Don’t trust free Image Pools!! Most […]

WordPress: Secure Faster Effective Blogging

If you use WordPress or a other CMS for daily blogging, it’s useful to have a own User Acount on a PC. Advantages: Own Browser for Blogging with saved Passwords Own Link Bar for quick switching between the Social Media Platforms You won’t need to open Security Holes like API Software Interfaces for used Plugins Speeds up the WordPress Blog cause reduced Plugin loads You have the full control. cause most free API Plugins save your Passwords on foreign Servers One touch Bookmarks let you jump fast between the Social Media Platforms No Data are automatic transfered without your knowledge […]

WordPress: Change Word on all content sites with mysql

If you run a WordPress Blog or other CMS with MySQL Backend you can easy change one same word or expression on all content sites on the fly Do a mysqldump at first of the current database $ mysqldump -u username -p dbname > dbbackup.sql Login to the MySQL server Console Switch to the Database mysql> use dbname; run command for tests, lists touched posts mysql> SELECT * FROM wp_posts WHERE (post_content LIKE '%expression%'); Run Replace code to pre, cause i use preformat text plugin for the copy & paste boxes mysql> UPDATE wp_posts SET post_content = REPLACE ( post_content, […]

WordPress: Monitor the Size of the MYSQL Database

If you use WordPress or a other Blog Software with a MySQL Database over years it is useful to do some things regularly: Check the Database Size weekly, that no Skript Kid has found a Backdoor and fills up the Database silent Purge Database Caches with default maintenance tools of the Software Dont forget to create a MySQL Dump Backup weekly with cron To Check the Size login on mysql command prompt do: $mysql -u dbuser -p #Enter Password mysql > use dbwordpress mysql > SELECT table_schema "Data Base Name", sum( data_length + index_length) / 1024 / 1024 "Data Base […]

WordPress: Why less plugins is more?

WordPress is a well known Blogging Platform to publish your Content to the world. But after some years of analysing of my Webserver Logs i remarked that a lot of used plugins produces more errors on inside linking than i would like to have. I could not explain why the Search Engines run into Errors or dead ends if they scan via the bots the Content. I didn’t realize that the plugins were the bad factor. If you see same problems you can start up analyse your Blog for free with these steps: Go Plugins disable all uneeded Plugins like […]

WordPress: Change User Password manual on mysql prompt

If you don’t want to use Passwords generated by wordpress itself, you can do it manual on a MYSQL Console howto: Login to your Webserver with the Database via encrypted SSH!! Login to the MYSQL Server Conssole with $ mysql -u username -p Enter Password, and change database with mysql>use database-name-of-blog Now Set Password for the User mysql>UPDATE wp_users SET user_pass = MD5('NEWPASSWORD-16-DIGITS') WHERE user_login = "THEUSERNAME"; System shows Echo: mysql> ok.. Changed 1 Row.. Quit mysql> exit Logout of SSH

WordPress: SEO Ranking bad after setting “read more” tags

After some weeks of cleaning up my blog, i remarked a very bad ranking from under the first 10 on google to nirvana What did i change? saved wp-login with htaccess to non-public set post content with “read more” buttons Background: Search engine like google wasn’t able to pull content of posts which are cut by “more” Search engine wasn’t able to pull relinks over the wp-admin url by the internal wordpress feeds I was forced to turn back my settings and wait for better ranking.. not safe but must be..

WordPress: Replace or Purge Text on all Posts by mysql

If you have to remove a link, text or else on all wordpress posts pages with same signs like the “read more” tag do: mysql -u dbadmin -p – enter password – change database by: use databasename – run change command(SET “more-tag-source-html-pre” WordPress reformat the output here! ): mysql > UPDATE wp_posts SET post_content = REPLACE (post_content,'<!!–more–>',''); – System Echo’s: Query OK, 88 rows affected (0.01 sec) Rows matched: 706 Changed: 88 Warnings: 0

WordPress: Move Blog to new URL Domain HTTP HTTPS on the MYSQL Console

Info: Today most Search Engines prefer Blogs who are offering “HTTPS” at the URL for secure direct connects to the Websites but this results a lot of headaches to the Website Developers. To be effective you should know: You have to offer HTTPS beside HTTP You should use a validated Domain Certificate, most Domain Resellers offer them for FREE You should know that NOT every FREE Certificate is TRUSTED by every Browser (green closed lock symbol at the adressbar) You have to Develop Websites WITH variable Format output ( PC, Tablet, Smartphone, Smart-TV, Infoboxes,) Design Websites and test 3:2, 4:3, […]

Impressum Datenschutz-DSGVO-GDPR

www.linuxonlinehelp.eu - Nonprofit Linux PC & Server Support since 2004 Tags: Linux Online Help, Linuxonlinehelp, Linux Support, Linux Hilfe