WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

0
votes
2answers
103 views

Search and replace special characters (å,ä,ö) for image attachments only in database

I need to replace the special characters å,ä,ö (with a or o) in my WP database for all image attachments. How can I apply this search and replace only to affect these links? Edit: Solved
0
votes
1answer
43 views

Using custom post types WordPress network

Working on a project I am setting up a WordPress network containing sites/blogs for small shops. I would like to use 2 custom post types in the following way: A location post type; The blog admin can ...
0
votes
1answer
43 views

multiple wordpress installs w/shared user database but separate content databases

Is it possible to have two wordpress installs, one at the main address and one at a subdomain, with a shared user database but totally different/separate content databases? For example: ...
0
votes
1answer
33 views

Size article thumbnails and retrieve them directly from database

I've integrated the Wordpress database directly with my .NET application. What I want is to set the featured image of a post. This featured image must be maximum 800pixels wide, and automatically ...
0
votes
1answer
46 views

How to change images size after theme modification?

The images in the previous theme were using a height and width listed in the source html. The new theme will resize the images using percentages, so I need to remove all the height and width in the ...
0
votes
1answer
262 views

Images are not showing after moving Wordpress installation from server to localhost?

I moved my wordpress installation from server to localhost on my pc using the instructions in the following link ...
1
vote
1answer
33 views

How to disable (get rid of) home page main loop entirely?

I'm using a custom theme, the index page doesn't depend on the main loop for home (which by default get the latest 10 posts for example). How can I get rid of the home loop entirely, so the index ...
0
votes
0answers
35 views

Why does my WordPress front-end categories plugin gives me a database error with my SQL syntax?

A few years back I created a plugin based off of an answer here: How do I create a way for users to assign categories to a post from the frontend? Here's a pastebin of the modified plugin: ...
1
vote
2answers
36 views

WordPress Backup

I'm learning how to backup right now and I'd like some validation. From what I understood, to fully backup my Wordpress I need two things. One backup for my database and another for theme files. The ...
0
votes
0answers
35 views

Download user generated data from Wordpress

I have created a Wordpress site which I allow users to enter information about themselves such as name, age, sex and address etc. Now that I have this n formation I would like to know the steps I ...
1
vote
0answers
53 views

How to track a users progress through pages by inserting data into Wordpress Database?

My website users can learn British Sign Language through Video Tuts, Quizzes and games etc. I would like to track the users progress through the pages of the course and add that data to a Wordpress ...
-1
votes
1answer
24 views

how to add limit records in wordpress query

I have this query which is returning the all records from database whose type is equal to 'quote2'. No I want to know how to limit the record. I mean I just want to show last 10 records added in the ...
0
votes
1answer
27 views

Querying multiple meta_keys in Wordpress SQL query

Here's my Query... I'm looking to narrow this query down to users of one specific role ("meta_key = 'wp_capabilities' AND meta_value = 'employee'")...how do I add that additional conditional to this ...
0
votes
1answer
38 views

How to display data from db in select list [closed]

I wonder what it's wrong in my code. I can't get all of data in column "adres". In result I only have the lest record. Thanks for help. global $wpdb; $result = $wpdb->get_results ("SELECT ...
0
votes
0answers
26 views

How do I authenticate/turn off a plugin remotely for plugin SaaS like functionality?

I have a client whom we created a custom plugin for. We are charging monthly for access to this plugin but the only way we have to disable it is manually in the Wordpress admin. How would I go about ...
0
votes
0answers
33 views

Broken Images After DB Name Change

I have a problem I have been unsuccessful in troubleshooting or finding other questions and answers for. My site was displaying fine. I changed the name of my database from "mydomain_beta" to ...
0
votes
1answer
47 views

Getting data from a table using a query

I’m starting with WordPress and I have a lot of problems and doubts. I’m trying to display on a page data stored in a table of my database. I have a table named Customers (id, name, surname, phone). ...
0
votes
0answers
27 views

Customize wordpress search query

Would this method parse_query of the WP_Query class allow a custom search query to a custom table? WP_Query I ask because the Codex says " To customize the query append additional arguments to ...
1
vote
0answers
203 views

How to populate custom field dropdown box based on prior selection?

I have two dropdown boxes for a search that uses custom fields and I need the second dropbown box to be populated depending on the results of the first box. So far I have: <form role="search" ...
0
votes
1answer
28 views

Should I use custom taxonomies or not?

I'm building a plugin which features an custom post type Events. Now I would like to add functionality to support venues. I think a custom taxonomy could do, but I'm not so sure, because I would like ...
0
votes
1answer
49 views

Given two custom post types: Automatically add meta fields from one custom post type to another

Custom post type "Company" has: Restaurant name field Restaurant description field ..and other more fields Custom post type "Restaurant" has: Restaurant name field Restaurant description field ...
0
votes
1answer
102 views

Posts and Pages not showing on admin, but showing in theme

I've just transferred a WordPress install over from and old IIS server set up by our client, to our new Lunix based VPS. Whether that is relevant or not, i'm not sure. I've changed all the usual ...
0
votes
0answers
79 views

help in applying pagination retrieve the data from database

I'm following the tutorial here http://wpengineer.com/2426/ on how to apply pagination in wordpress. Now he said "As pointed out in the comment the array_slice is only necessary because we use sample ...
0
votes
1answer
18 views

custom post type for custom talbe

Where would I start if I want to have a custom post created each time data was submitted from a form on the front page for non-logged in users? I have the script set up to send the data to a custom ...
0
votes
0answers
117 views

insert data from form to custom table

I have a custom form set up on a custom page template. I need the submitted data to be saved in custom table. What am I missing since this isn't send the data? The code I'm using: ...
0
votes
2answers
47 views

How do I use update_option to give me a new option name each time a form is submitted? [duplicate]

How do I use update_option to give me a new option name each time a form is submitted? The code I'm using now overwrites the database value. Instead I need to have a new address saved each time. The ...
0
votes
1answer
92 views

save new data to wp_options non-post form

I have a form on my front-page. It sends the entered address to Google API and returns the JSON to wp_options. That works fine. I am using update_option to do that, so it rewrites the meta_key each ...
1
vote
1answer
39 views

Wordpress not reflecting changed of the database

my problems started when I moved my website to another folder (from /dev/ to /). I have gone through the whole database in order to change all the hardcoded /dev/ into / but I still notice that ...
0
votes
1answer
64 views

access JSON results from wordpress database with wpdb

I have JSON results from Google API added to to wp_options table. At this point I just need to echo the specific elements. Namely, the coordinates. The option_name I have is py_menu_item. One of the ...
0
votes
1answer
200 views

How to delete all records from or empty a custom database table?

I can't seem to find a simple reliable way to do this - perhaps?: // delete row ## global $wpdb; $delete = $wpdb->query( $wpdb->prepare( "DELETE * FROM `wp_table_name`" ) ); ...
0
votes
1answer
85 views

How to fetch records from database WordPress

index.php: <?php $new=$wpdb->query("select * from wp_posts where post_title='Auto Draft'"); $new1=mysql_fetch_row($new); echo $new1[0]; ?> How to fetch record from database? How ...
0
votes
0answers
47 views

Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet

Why do developers make it so darn hard to use the tools they develop? Don't answer, I already know :) Have had some success using this: https://github.com/bainternet/Admin-Page-Class ...to develop a ...
2
votes
1answer
304 views

wp_users user_status field

I have found an answer to my question here but it's 7 years old. I simply want to know if I can use this column for my own purposes. I'm planning to use the user_activation_key column to store a ...
0
votes
1answer
93 views

Weird characters in title if it contain “ ”

If my post title contain “ ” all the title stored in the database title column in weird characters like this ...
0
votes
0answers
15 views

Any harm in pointing my dev Wordpress installation to my production database?

I have a dev instance of a public website that I maintain, and while they are very similar, there are differences between the site structure of the development instance and the production website. ...
0
votes
1answer
84 views

Get content from other database table based on an ID and rewrite URL

I am currently using WordPress with SEO friendly permalinks. One page of my website is a special one though, let's call it http://example.org/locales. It is using a custom page template that loads ...
1
vote
4answers
606 views

Converting WordPress into Android or iPhone app

I've had a request from my client to convert their WordPress website into an App for Android and iPhone. I've looked around at a number of options and it seems doable especially for just the blog ...
0
votes
0answers
55 views

Why are my WordPress post queries so slow?

I'm working on a larger WordPress site and trying to troubleshoot why my site is so slow. I've installed W3 Total Cache and have run multiple page speed and plugin tests with no luck. What's strange ...
0
votes
1answer
57 views

Sub-domain or 2nd, temporary different domain?

I'm developing a Wordpress site for a website that already exists (that's not currently using Wordpress). The current website cannot be taken down until the new Wordpress site is ready to replace it. ...
1
vote
0answers
58 views

MS Access to manage WordPress Database

Now I don't believe this is practical or possible without a large amount of development. My client's old site used MS Access to manage the user's profiles on his old website. His new site uses ...
0
votes
2answers
555 views

Synchronizing Two WordPress Sites Content

I've googled a lot, and I do have found answers at WordPress SE and at stackoverflow.com. However, the answers are somewhat incomplete or doesn't work at all. Here I'll explain my problem in detail, ...
1
vote
1answer
307 views

Can I use MariaDB instead of MySQL in wordpress?

Is it possible to use MariaDB instead of MySQL in Wordpress installation? If possible: how do I do that? Is there any drawback or complexities?
0
votes
1answer
51 views

/var/run/mysqld/mysqld.sock

I'm using Wordpress v.3.4.2 and today I've tried to update to the v.3.7.1 using all possible ways but in all of them I got the following error "Can't estabilish database connection", and since I was ...
0
votes
1answer
115 views

How WordPress attaches its Featured Images with posts?

I'm working on a WP_Query(), where I'm trying to fetch all the images using 'post_type' => attachment and 'post_parent_in' => array( 1688 )(I want to pass some more post_ids) along with other ...
2
votes
1answer
463 views

Ajax with jQuery UI dialog not working

I am trying to update my custom database table when changes are made in a dialog box. The script for the dialog box and ajax call is as follows - jQuery(document).ready(function($){ $("td > ...
0
votes
1answer
71 views

How long is “as long as possible” in wp_cache_set()?

The documentation for wp_cache_set() says that if you pass in 0 for $expire (which is also the default), then it is cached for "as long as possible". How long is this? What determines it? Are we ...
0
votes
2answers
44 views

Do WordPress Permalinks Refer to a Lookup Table in the Database?

I'm trying to figure out how to rewrite URLs while dropping the original parameter (whether it's a number or text); basically exactly what WP does with it's clean permalinks Does a database lookup ...
1
vote
1answer
98 views

How to recover Wordpress on GoDaddy hosting after reseting database password?

I did reset my database password, so I could enter the phpMyAdmin, but now my Wordpress installation can't connect to the database. I tried to access the "wp-config.php" (should be at ...
0
votes
0answers
18 views

Plugins folder broken-No website functionality

After some plugin updates caused me to receive a database error, I was unable to access my dashboard. I changed the name of the plugins folder in FTP and it came back online. I then deleted my ...
0
votes
0answers
23 views

Get posts, terms and custom fields in array

I have a multisite and want all posts from post type products I want to query through the database to get all posts belonging to post type "products" i have accomplished this with the following code ...