Skip to content

Magenaut

  • Home
  • Topics
    • Notes
    • Tutorial
    • Bug fixing
    • Extension
    • Server
  • Q&A
  • Privacy Policy
  • About

database

I’m designing a plugin to create database indexes. Suggestions?

August 5, 2022 by Magenaut

I’m starting a (totally open-source) little project to create a WordPress plugin that will add appropriate indexes to WP’s MySQL tables to improve performance. (Some wp tables, notably wp_postmeta and wp_usermeta, can use better indexing.)

Categories Q&A, Wordpress Tags database, optimization, performance, plugin-development Leave a comment

Switching among theme customizations

August 5, 2022 by Magenaut

I am developing a website that should switch between two looks (depending on the season) using different customizations of one WordPress theme. I mean all the changes are done on the wp-admin/customize.php page, without touching files, switching plugins, etc.

Categories Q&A, Wordpress Tags child-theme, database, theme-options, themes Leave a comment

How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?

August 5, 2022 by Magenaut

I’m getting a WordPress “table doesn’t exist” error in my debug.log, but unlike most errors it doesn’t give a full stack trace to help me isolate the code. Anyone know how to tell WordPress to dump a full stack trace for this error? Thanks!

Categories Q&A, Wordpress Tags database, debug, errors Leave a comment

Most commented posts by time period (last 12h, last 24h and etc)

August 5, 2022 by Magenaut

I have this code which works great.

Categories Q&A, Wordpress Tags database, mysql, php Leave a comment

Insert Custom Data into wpusers

August 5, 2022 by Magenaut

I add custom row at my wp_users table but the data in the row such as phone_no and ic_no. But when i try to add data, the data not pass in my table

Categories Q&A, Wordpress Tags database Leave a comment

Two prefixes in database? Which one is valid?

August 5, 2022 by Magenaut

I am trying to manually migrate an install and have come across this. My DB has some qfo_ prefixed rows and some wpaq_ prefixed rows. The qfo_ are all duplicates of the others (in other words, there is a qfo_commentmeta and a wpax_commentmeta, etc.).

Categories Q&A, Wordpress Tags database Leave a comment

Using AND and bracket grouping in SQL not working

August 5, 2022 by Magenaut

I am trying to combine two conditions in a query but it isn’t working. but running the conditions independently works.

Categories Q&A, Wordpress Tags database, mysql, plugin-development, sql Leave a comment

Upload media only to DB

August 5, 2022 by Magenaut

I’m using the latest WordPress (5.6) and from what I’ve found out there’s no visible setting for uploading media directly to a DB. Is there such an option somewhere hidden or does WordPress not support DB as a media storage instead of wp-content/uploads?

Categories Q&A, Wordpress Tags database, images, media, mysql, uploads Leave a comment

Some weird users in database

August 5, 2022 by Magenaut

I’ve noticed that I have some users that seem fraudulent in my database (in the wp_users column). And the curious thing is that they don’t appear in the users list in the admin panel.

Categories Q&A, Wordpress Tags database, users Leave a comment

Delete post revisions only for a single post

August 5, 2022 by Magenaut

How to delete post revisions only for a specific post identified by its ID using an SQL query?

Categories Q&A, Wordpress Tags database, posts, query, revisions Leave a comment
Older posts
Newer posts
← Previous Page1 … Page8 Page9 Page10 … Page17 Next →
  1. michealSmith07 on Is there a way to dynamically refresh the less command?August 21, 2022

    That is a very nice post. I like this post.

  2. anonymous on Fix libwacom9 dependency issue when upgrade DebianJune 27, 2022

    saved my day!! Thanks for the help…

  3. sreedhar on Fix libwacom9 dependency issue when upgrade DebianMay 10, 2022

    Thanks its working

  4. saintnick on Fix libwacom9 dependency issue when upgrade DebianMay 10, 2022

    remove libwacom2 worked for me as well

  5. ranafoul on Fix libwacom9 dependency issue when upgrade DebianApril 22, 2022

    apt remove libwacom2 helped on kali 2022.01. gr8

.net ajax asp.net asp.net-core asp.net-mvc asp.net-mvc-3 asp.net-mvc-4 asp.net-web-api bash c# command-line css custom-post-types custom-taxonomy dataframe dictionary django entity-framework functions gridview html iis javascript jquery json linux list matplotlib numpy pandas php plugin-development plugins posts python python-2.7 python-3.x security shell shell-script sql string vb.net webforms wp-query

© 2026 Magenaut • Built with GeneratePress