MySQL Archives - IT Nursery

MySQL, Programming

IT Nursery

On Duplicate Key Update same as insert

I’ve searched around but didn’t find if it’s possible. I’ve this MySQL query: INSERT INTO table (id,a,b,c,d,e,f,g) VALUES (1,2,3,4,5,6,7,8) Field id has a ...

June 4, 2022
0 Comments

WordPress

IT Nursery

Delete post revisions on post publish

Is it possible to delete post/page revisions from the database when a post/page is published? 11/05/12 Answer: See the plugin below by bueltge ...

June 4, 2022
0 Comments

WordPress

IT Nursery

Migrating database / content of non-CMS site to WordPress

I have a non-CMS website which is fully build with PHP with a lot of content in it. I don’t want to add ...

June 4, 2022
0 Comments

MySQL, Programming

IT Nursery

How to fix “Incorrect string value” errors?

After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched many text columns ...

June 4, 2022
0 Comments

WordPress

IT Nursery

mysqli_real_connect() – authentication method unknown to the client Warnings

I keep getting the following warnings in my debug log: PHP Warning: mysqli_real_connect(): The server requested authentication method unknown to the client...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL date format DD/MM/YYYY select query?

I’m a bit confused on how to order by date formats. For the format YYYY-MM-DD you would do this: ...ORDER BY date DESC... ...

June 3, 2022
0 Comments

WordPress

IT Nursery

Is the outdated PHP mysql extension a requirement for WordPress 4.6?

I’m a bit puzzled when I after some time did another WordPress install. I’m using a standard Apache + PHP 7 combination (even ...

June 3, 2022
0 Comments

WordPress

IT Nursery

register_activation_hook isn’t adding table to DB

I’ve started my first plugin and I need to store values returned from an API call to a database. But before I do ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

Throw an error preventing a table update in a MySQL trigger

If I have a trigger before the update on a table, how can I throw an error that prevents the update on that ...

June 3, 2022
0 Comments

WordPress

IT Nursery

Using Echo in ShortCode – Stuck

After about 3 days of searching and tinkering, I’m stuck. I’m not a coder, but I like to try. I have a short ...

June 3, 2022
0 Comments