Webmaster2020.com

you can also use:

echo ${STRING: -1}

Just remember that the last character can sometimes be a whitespace ( space, newline ...)

You can work with a sub-query an UNION:

Code: Select all

SELECT table1.id,union_table.name FROM table1 LEFT JOIN 
   (SELECT id,name FROM table2 UNION SELECT id,title AS name FROM table3) 
   AS union_table ON table1.other_id=union_table.id;

The error is because MYSQL is in strict mode (default)

You can Check MYSQL mode
SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session

You change it with the following query;
SET sql_mode = '';
or
SET GLOBAL sql_mode = '';
Using the keyword GLOBAL requires super privileges and it ...

There are several ways to run a script on startup/reboot on linux.

My favorite : Crontab

sudo crontab -e
@reboot /home/me/scripts/this.sh

Another way to do it,
local.d scripts at boot time, add its init.d script to the default runlevel.
Enable local.d Scripts
rc-service local start
and then ...

MYSQL has changed it type of password (since Mysql 8 ?)
Anyway the easiest solution, is execute the following SQL command on MYSQL

Code: Select all

ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';

It should solve your problem.

Are you sure you are sending it to the right account?

sometimes you need to also add the domain name (even if it is not a public domain).

Code: Select all

sendmail user@host.domain.com

are you sending to a user on the server.
Do a test from the client:

Code: Select all

sendmail user@host

and check the logs on the client and on the server.

You can follow the tutorial :
https://www.inmotionhosting.com/support/website/wordpress-plugins/hiding-your-wordpress-admin-url-with-ithemes-security

But for you new login page, I think it is best to manual make a copy of wp-login.php to newlogin.php .

It is really good to rename wp-login.php ...

Be careful to which email-address you forward.
For example;
if you forward an email coming from gmail to gmail,
It will probably be flagged as spam. Because gmail knows that your server should not send email coming from gmail
(or any other known email-providers).

To prevent this you could do it ...

It is a complicated process.
Moving the files from subdir to the root,
is the first step, but some additional steps are needed.

Actual the first step should always be tot do a backup of your files and of the database.

Preparation

Backup the files and the database!
Remove any old site files ...

Webmaster2020.com

Search found 212 matches

Re: Bash last char of a string

Re: Join 1 table on 2 different tables

Re: Incorrect date value: '0000-00-00' for column

Re: Linux startup script

Re: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]

Re: postfix not mail from other hosts

Re: postfix not mail from other hosts

Re: Wordpress change login page

Re: postfix forward mail to multiple recipients

Re: Move wordpress site to directory