All Questions
Tagged with database customization
111 questions
0
votes
0
answers
22
views
Can I log the searches that are returning 404 in the DB?
I would like to log every single search query for which one gets 404. For example, if I search Cat in the search box, but my website doesn't have any content as cats. I would like to log that "...
0
votes
0
answers
133
views
Advice how to connect custom database with Wordpress, change data in Wordpress and finaly use this data
Is it possible to create a page in WordPress that will allow logged-in users to create new or change existing content from the custom database?
So I think this task could be divided into three parts:
...
0
votes
1
answer
54
views
optimal taxonomy or custom post types
hi everyone on this community,
i've been researching this but everytime i think i'm getting somewhere, i hit a dead end and have to start again; so i thought i'd reach out to this community for some ...
0
votes
1
answer
810
views
Applying WP-cli Search & Replace to Static SQL Dump File
I have a wp db dump file inside my site directory. Can someone show me an example of how to use wp-cli search and replace command on the static sql file, not the active db to change my url from "...
- 153
0
votes
2
answers
1k
views
What is my error trying to create a new table in the database?
I tried creating the tables in different ways and I always get the same error:
"Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the ...
1
vote
1
answer
223
views
Adding a Table to the wordpress database
I am using the following script to add a table to the wordpress database, but nothing is happening. I am not sure what I am doing wrong.
Any advice would be much appreciated.
function ...
0
votes
0
answers
22
views
Migrating my site to a new domain does not keep any changes made in customizer
I have been making a wordpress site on my LAMP installation locally, modifying theme and uploading posts and whatnot.
So when it was time to finally upload it, I dumped the database, searched and ...
- 137
0
votes
1
answer
1k
views
Wordpress how do I echo SUM from a column of a MySQL table by user id AND type_operation
I have account funds table in wordpress database. Structure like this;
Id user_id fund_user type_operation
-----------------------------------------------------------
1 ...
- 1
0
votes
1
answer
47
views
New Page/Post Screen Opens an Existing Post
When I go to add a post or page to my WordPress site, the permalink and featured image are already populated with a 10 year old post, thus we are unable to create new content.
Recent changes done on ...
0
votes
0
answers
295
views
How to extend WP_query to a specific table?
I created a new table (named extrapage) in the wordpress database (named wpsite_db). I have added to this table some pages not published directly with wordpress and I want these pages to be considered ...
0
votes
1
answer
79
views
Advice on how to structure a custom plugin
I am attempting to create a custom plugin and would like some advice/ideas on how best to store the data.
Expected Posts ~ 1,000
Expected Users ~ 10,000
Each user will need to have at least one ...
- 31
0
votes
0
answers
151
views
How to have differents sites share the same tables of DB?
I want to have multiple versions of my site that share the same database.
I'm wondering if this is as simple as just cloning the site and then in the wp-config having them all use the same database?
...
0
votes
2
answers
2k
views
Search and Replace in database: How to replace data in SQL dump file on Windows?
Unlike with Joomla, one can't just search and replace a string in WordPress database because of serialized data. I am not sure what serialized data is, but it makes my life more complicated.
Is there ...
0
votes
0
answers
20
views
A WP dev site that displays content from a live site's database but cannot write to wp_posts?
Is there a way to setup a Wordpress site that uses another site's database but cannot write to specific tables (like wp_posts)?
Basically I'm trying to set up a testing site that I could use to test ...
- 128
1
vote
1
answer
1k
views
What's the proper way to use a custom table? [closed]
I manually added a table to my wordpress database using sql using CREATE TABLE. I want to add functions for adding, modifying, and removing the data from this table just like with wp_update_user().
...
- 345
1
vote
1
answer
879
views
database interactions using OOP
I'm developing wordpress plugin which store data in database. I tried to start OOP way for my plugin according to boilerplate from Best Practicies: https://github.com/DevinVinson/WordPress-Plugin-...
- 13
2
votes
2
answers
4k
views
Add search Value to wp_list_table pagination
I have a custom WordPress table using wp_list_table, with a search field: the search works well, but I am seeing that the search value isn't added to the pagination links when there are multiple pages ...
- 141
3
votes
2
answers
3k
views
Where is the "default attribute" values located in the phpMyAdmin in Woocommerce?
I'm looking to mass remove or clear the default attribute for variable products in Woocommerce.
Is there an easy way to mass clear this value? If not, would you be able to direct me on where I can ...
- 167
0
votes
1
answer
6k
views
How to implement content from external database into Wordpress text page? [closed]
What methods exist to implement data values from external database into a Wordpress text page? I think that there are two possible ways but maybe there are some more ways to realize this?
Maybe ...
- 147
0
votes
1
answer
345
views
Setup database structure with books, authors, languages etc. for publishing house [closed]
It was kind of hard to find a good title for my question.
What I'm trying to do is setting up a homepage for a publishing company.
The website should contain all of the companies books with ...
- 159
0
votes
1
answer
48
views
WPCLI search and replace in a particlar site dir effect another site-dir
In /var/www/html I have a site dir. I've duplicated that site's dir and db into a new site dir and db by the name of "test" (without quote marks), and changed wp-config.php accordingly.
I Navigated ...
0
votes
0
answers
225
views
Search Replace Database ONLY for posts of certain category?
I need to search/replace my database but limit the action to posts of certain categories.
Is this possible? I usually use https://github.com/interconnectit/Search-Replace-DB, but there is no way to ...
- 119
0
votes
2
answers
47
views
Replace dynamically content in a custom database table when a custom post is created
I use a third party plugin that saves events locations addresses as a custom locations post type in a separate table - wp_em_locations.
Because events are created by multiple authors, they write ...
- 1,131
0
votes
2
answers
625
views
Multiple Domains and Subdomains Using Multisite Installation
I have the following domains/subdomains. They are all related to each other, yet they must be on different domains/subdomains
example.com
www.example.com (redirects to example.com)
sub1.example.com
...
- 2,204
1
vote
1
answer
1k
views
Creating user relationships
I have a project where I feel I need to create relationships between users but since this is not natively implemented in wordpress as far as am concerned then I will need advice on how to do it.
One ...
- 97
1
vote
0
answers
768
views
$wpdb->replace: WHERE?
My plan is to upsert values in a custom meta table with $wpdb->replace.
This is what I try:
$up_meta = $wpdb->replace(
'spieldaten',
array(
'spiel_uid' => $uid,
'...
- 565
0
votes
1
answer
209
views
creating new field on mysql
I would like to add extra sections like "gender" on the WordPress user database. I would like to draw information from this information later. For example, let's say I want to attract gender. I ...
- 25
0
votes
1
answer
108
views
Custom Form Input not saving to Database
I have created a custom form using shortcode widget for my page sidebar, but the form input wasn't saving to may wordpress database.
Can anyone help me with this. Please see below my codes.
<?php
...
- 1
0
votes
1
answer
866
views
Merging development site with live site
Earlier this year I built a client a large website for their organization. After that site was finished and live on the web (not on our development server anymore) they wanted the company I work for ...
0
votes
1
answer
2k
views
Add table to WordPress database
I want to add an extra table on my WordPress database and I intend to
query it with a custom script that will be embedded to WordPress.
I'm worrying if this is a safe way to do it, or I should go ...
- 15
3
votes
1
answer
30
views
Suggestions for WPMU Migration (advanced)
We have a multisite network with a few hundred sites. We are currently merging with another company and migrating our sites. However we have a few clients who have decided to jump ship and are asking ...
- 638
1
vote
1
answer
169
views
Who is responsible for data sanitization in WordPress development?
I am studying how to write more secure WordPress code by implementing validation, sanitization and data escaping wherever necessary. Validation and escaping makes perfect sense, but I am a little ...
- 177
0
votes
2
answers
776
views
Cloning and syncing a WordPress website
I plan to bulid up a nice developer environment and for this I need to clone the actual running website to a 100% into a dev directory.
I've now uploaded the same version of wordpress as on my ...
- 435
0
votes
1
answer
827
views
Comment "like" problem - "users who like this" avatar linking to current user profile instead of "liker's" profile
This issue is with wp-ulike plugin. Support seems nonexistant for this plugin so I'm having to go in the files and try to figure out how to fix some things.
A more in depth description of what I'm ...
- 37
0
votes
1
answer
47
views
Clearing dummy data before launch
I have been developing my WordPress site on a development local server.
I would now like to move the site to my production server.
I don't need any of the dummy data that I have generated while ...
- 209
0
votes
0
answers
20
views
Accountless password generation
I want page1 to have a button/link. When the visitor clicks it, he gets a random password like "a84f20". And I want to save this password.
How to approach this? I can program but I don't know ...
- 101
2
votes
3
answers
2k
views
What actions affect files, DB, or both?
I'm looking into setting up a development -> staging -> production workflow, and the biggest issue so far is figuring out how to sync the databases.
To this end, I'm trying to figure out exactly ...
- 123
1
vote
0
answers
585
views
Localhost to Staging to Development Dynamic WP-CONFIG
I am trying to setup 3 environments: Localhost, Staging and Development.
The issue is that each environment has its own db.
We want to have ONE config file which will dynamically change the Db ...
- 117
1
vote
2
answers
127
views
Setup 3 Sites To Connect To 1 Database and Share Data
How do I setup 3 different Wordpress installations on 3 different servers, all of which connect to a single database and also share the same data?
I'd like to set up 3 different servers. One for ...
- 113
0
votes
1
answer
430
views
How to transfer one domain to another domain without losing theme options (customizer)?
I have developed the one wordpress site with custom theme,
Here I used the custom customizer options.
Then site completed on my local machine I mean localhost (http://127.0.0.1/wordpress).
Now the ...
- 103
0
votes
0
answers
71
views
One WP Database outside localhost and two connections
I would like to ask for help with this problem. I have two places where I have the same WP.
1) Test site - own domain, hosting and DB
- here is stored database, so siteurl is here, example: test.com ...
- 156
0
votes
1
answer
47
views
Associating special meaning with user id 0
I'm writing a plugin that creates a custom table holding data which is linked to a user account with a user_id field. Now if that users account would be deleted for any reason I would like to set that ...
- 111
0
votes
1
answer
1k
views
Why user_pass column in wp_users table is varchar(64)
while working on a project, I found that "user_pass" column in "wp_users" table is varchar(64). WordPress always stores user password in md5 which is a 32 char ASCII string. So why not store it in ...
- 574
1
vote
2
answers
235
views
Should non-WordPress data get its own DB?
I couldn't find anything on Google or on here about best practice for data that is not really Wordpress related.
Say we have a database of clients that we'll be accessing through PHP/SQL. Should I ...
- 135
0
votes
1
answer
50
views
Add several fields from different tables to post, fields per post are in same row of table
I like to add 4 or 5 extra fillout boxes to the adminpage of my post...
For example, under the actual page box, I would like to add the following fields:
Name
position
publications
freetext
Here ...
0
votes
1
answer
160
views
Wordpress as a frontend website for iOS app [closed]
I am developing a product for a local gym. The product comes in 2 parts :
- a smartphone app used by the client
- a website used by the coach
The coach uses the website to prepare the workout. So ...
- 101
2
votes
1
answer
24k
views
Retrieve and display data from custom db table in admin area?
So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/
Basically, my plugin ...
- 226
0
votes
0
answers
2k
views
Get id from database
I need this ID to delete users from table. My plugin crate new table in DB when he is activate. All this code is in main.php, and in second.php i have only form that display my results.. and i include ...
- 183
18
votes
6
answers
51k
views
Delete tables from database when deleting plugin
I created a plugin and want to add a function to delete my tables from the database when a user deletes my plugin. I created a function that deletes tables from the DB when a user deactivates my ...
- 183
0
votes
1
answer
24
views
Where should I put this custom data?
My client needs to store food nutrient data in his site's database. I have food name, calories, protein, fat, carb, fiber and other data to store for many food items.
I'm a developer but new to WP. ...
- 179