Search found 169 matches

by mister_v
Thu Apr 23, 2020 9:46 am
Forum: SQL
Topic: Solved: Incorrect date value: '0000-00-00' for column
Replies: 2
Views: 481

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

Thanks that solved it
by mister_v
Wed Apr 22, 2020 7:18 pm
Forum: SQL
Topic: Solved: Incorrect date value: '0000-00-00' for column
Replies: 2
Views: 481

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

Hi,

somehow there are is a "bad" date in the table ( 0000-00-00' ),
It tried to update it to another value
but each time I get the error-message:

Code: Select all

Incorrect date value: '0000-00-00' for column 
Even delete doesn't work:

Code: Select all

DELETE FROM table WHERE start_date='0000-00-00';
How do I fix this?
by mister_v
Fri Mar 20, 2020 9:15 pm
Forum: MySQL
Topic: php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
Replies: 1
Views: 488

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

Hi,

I get the following error whe I tried to connect with php to MySQL server.
mysqli::__construct(): The server requested authentication method unknown to the client

How can I fix this?
I use standard login function:
$dbconn=new mysqli('127.0.0.1','user','passwd','database');
by mister_v
Mon Mar 16, 2020 8:01 pm
Forum: Servers
Topic: Linux startup script
Replies: 1
Views: 376

Linux startup script

Hi,

How do I make sure that a script is run when a server is started of restarted ?

/home/me/scripts/this.sh
by mister_v
Sun Feb 16, 2020 9:05 pm
Forum: Postfix
Topic: postfix not mail from other hosts
Replies: 4
Views: 1125

Re: postfix not mail from other hosts

thanks, that was indeed the problem.
When I add the domain name,
the mail is delivered.

I thought that before, the hostname was enough?
by mister_v
Sun Feb 16, 2020 9:01 pm
Forum: Postfix
Topic: postfix not mail from other hosts
Replies: 4
Views: 1125

Re: postfix not mail from other hosts

The mail leaves the client to the server,
but it is not delivered.
by mister_v
Sun Feb 16, 2020 1:05 pm
Forum: Postfix
Topic: postfix not mail from other hosts
Replies: 4
Views: 1125

postfix not mail from other hosts

my mail server is not accepting from other server on the same network.
But i did set it to subnet in main.cf

Code: Select all

mynetworks_style = subnet
anyone has any ideas ?
by mister_v
Sun Oct 13, 2019 7:01 pm
Forum: WordPress
Topic: Wordpress change login page
Replies: 1
Views: 16830

Wordpress change login page

Hello,

I tried to rename the login page of my Wordpress site,
I did it with iThemes Security, but the "new" login page does work.
by mister_v
Sat Jun 29, 2019 6:22 pm
Forum: WordPress
Topic: Move wordpress site to directory
Replies: 1
Views: 23139

Move wordpress site to directory

Hi,

I created a wordpress site on directory of my main site (www.website.com/subdir).
Now I want to move it to the root directory as the main site (www.website.com)

I tried just to copie the files, but that didn't work.
So how do I do it properly ?

Kind regards
by mister_v
Wed Jun 19, 2019 4:50 pm
Forum: WordPress
Topic: Wordpress auto-update
Replies: 1
Views: 15840

Wordpress auto-update

Hi, I have a wordpress site, and it is working good. But it suddenly did a automatic update (not plugins, wordpress itself). It didn't break anything, but I don't want it to do that. I wan't to personally launch the update process. I have been looking around, but couldn't find a option to turn it of...