MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
13 views

add_blog_option blog ID

In multisite I run add_blog_option and look at the row in mysql wp_options. The record is there but I do not see a field for the blogID. How does the wp_options relate to the specific blog?
-1
votes
1answer
125 views

Importing Concrete5 content to WordPress

Are there any tools out there to convert content from a Concrete5 database to something WordPress can use? I have a client that may switch over, and would like to avoid manually copying content over ...
0
votes
1answer
215 views

How to import database table as custom post type and custom fields?

I have a sql table that contains vehicle information. When I import the database table to my WordPress website, I need the information to be imported as custom fields for a custom post type. For ...
1
vote
2answers
1k views

Is It Possible to Restore Accidentally Deleted Widgets?

I accidentally deleted the widgets without dragging it to the inactive widgets section. I have a backup of all the files and the database but i have changed many things on the site other than the ...
0
votes
4answers
205 views

database optimization and server errors

I've a self hosted wordpress blog. The server showing internal (500) server error and usually the system admins ask me to optimize my database. The database is relatively small in size and fits in few ...
0
votes
1answer
32 views

Restore Cforms II Form Presets

I have a client who had to reactivate the cforms II contact forms plugin. It refused and gave the following error: *Fatal error*: Cannot use string offset as an array in ...
0
votes
1answer
123 views

Second ezSQL initialization for MSSQL

We are trying to pull data from a second database into Wordpress. The secondary database is used internally to store data, and Wordpress (also only used internal) is partially used to display some of ...
3
votes
2answers
105 views

Query meta field using between

I'm trying to Query some lattitude and logitude and then I get some long numbers and apperently the Query dont like that. Let says I have these in the database Meta-key: lat Meta-value: 54.3415000 ...
4
votes
2answers
5k views

WooCommerce with thousands of products - site is very slow - optimize db queries?

So far I've got around 8,000 products in my WooCommerce and the product page on the front end takes several seconds to load, even after caching. My VPS host says that I should have multiple ...
0
votes
2answers
288 views

WordPress & MySQL , problem with use many array in meta_query

I use this code for display custom posts : $args = array( 'category__in' => $bookcat, 'meta_query' => array( 'relation' => 'OR', array('key' => ...
1
vote
2answers
254 views

how to refresh wordpress permalink settings? (without admin panel)

I changed permalinks in wp_options table in database and I'm getting 404 on every post. Everything works fine after I log in into the panel and click "save settings" on permalinks options page. How ...
1
vote
3answers
657 views

WordPress Custom Query

I have posts that use a custom field for start date and end date. query_posts returns an array of posts that exist in the category I'm filtering. How do I query posts using this custom field that has ...
0
votes
0answers
56 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
2answers
4k views

Scanning Database for malicious Data

After a site of a friend has been hacked I told him he should just clean up the mess and restart from scratch so he know that no file has been altered. I could scan the site for him with tools like ...
1
vote
1answer
321 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
2answers
7k views

Using Dynamic Data Pulled from a MySQL Table in a WordPress Page

I'd like to pull data from a mySQL database and put it in some tables in a WP page. I'm using WP 3.1.1. Imagine that I've got a table of sales figures that I want to pull from a mySQL database and ...
0
votes
1answer
159 views

Unique Post Meta Values

I want to use Unique IDs like YouTube video IDs and WordPress post IDs in a custom field 'youtube_id'. I just created a front-end add post page and want to check if 'youtube_id' used or not used in a ...
0
votes
0answers
37 views

Display image in descending order from database table

I have used woo commerce plugin ,I am trying to display images in descending order by order_id in word press dashboard on orders tab.I tried lot's but not getting any idea how to do that.Bellow is my ...
0
votes
2answers
38 views

Let users register weight each day and save it in DB

I need a way that lets my users register they're weight (kg) and maybe % of bodyfat and save that information on each user in the DB. Then i need a way to output that number again on the logged in ...
0
votes
0answers
32 views

Wordpress Update Links

I just need a little help in WordPress query or a plugin which can update all internal links used as hyper link or directly with pages to WordPress normal url i.e ?page_id=69 I have created a website ...
0
votes
1answer
57 views

Get data from 3rd table

I have 3 tables: wp_posts wp_metadata users When I get my query from wp_posts I'm using LEFT JOIN to get the data from the wp_metadata, but how can I get a value from the 3rd table users? ...
0
votes
1answer
53 views

How to stop $wpdb from prepending database name

When I run an UPDATE query using $wpdb, WP prepends the database name associated with the WP installation to whatever is passed in the table name argument. This isn't desirable as my app passes the ...
0
votes
1answer
35 views

SQL database export-import

I develop websites containing WordPress blogs as well as other PHP pages I design. When I make changes to sites locally on my test server I do a SQL database dump using myPHPAdmin. How can I avoid ...
0
votes
0answers
18 views

Display Title by tags ( mysql )

I want to display in a sepparated page all the titles ( with link ) and a short description ( first 30-40 words from an article ) by a specific tag. For example, i use a "SPECIFIC TAG" on all my ...
0
votes
0answers
85 views

Export One Gravity Form Entry to Multiple Rows

I have a Gravity Form to register for a class. One submission could register multiple people. Gravity Forms, itself, displays and exports this as one entry with multiple columns for the different ...
0
votes
1answer
103 views

Insert two row in wordpress database

Hello I am working on a template where I have to grab some value and insert them in my own created table in wordpress database. Now as I dont know how to insert record in wordpress database , so i am ...
0
votes
0answers
66 views

why is $wpdb->update() causing a DB error from within wp_set_password()

I have a page-template for my custom theme that enables the user to reset their password from the front-end. I'm calling wp_set_password() and everything runs but the password is not changed in the ...
0
votes
1answer
525 views

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]

after wordpress update to 3.5+ i get error in this plugin. I do not understand how to fix it. If anyone can help me with these problem or give me an example of how to fix it here is the full code of ...
1
vote
1answer
64 views

Separate DB by yearly archive of Wordpress

I have large DB of blog post I already export it by year and wanted to make archive by year doing it on subdomain, like 2012.mysite.com I stack looking for solution on internet, I wondering if their ...
0
votes
1answer
179 views

after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()

after wordpress update to 3.5+ i get many errors in this plugin. i found that the reason is: http://make.wordpress.org/core/2012/12/12/php-warning-missing-argument-2-for-wpdb-prepare/ I do not ...
0
votes
0answers
55 views

How to reconnect to the wordpress database after the connection has timed out

I am writing a plugin that uses the database a lot to store product details from the Amazon Product API and I'm getting a lot of MySQL Server has gone away errors. The server that I'm working on is ...
0
votes
0answers
8 views

External app Login using Wordpress login credentials [duplicate]

I am building a php application for which user needs to login first and those login credentials will be same as wordpress login credentials I am trying to connect the application with wordpress ...
0
votes
0answers
148 views

Custom Post Type or Custom Tables?

I am trying to build an application that takes 2 pieces of input from a user and saves it to the database. This is how users enter these two pieces of input; this form will be displayed using ...
0
votes
0answers
199 views

Insert & Upload image into data base in wordpress without using media library & plugin?

Here i am trying to insert image into WordPress database with custom code but i am not able to insert and uplode i am very new to wordpress any body have any idea how to do it?Bellow is my code with ...
0
votes
1answer
470 views

Select User by Joining Multiple Meta Value Results

( I would ask this in the general stack exchange forum but I think it is more relevant here. I'm intentionally using direct queries to the database here. ) I'm trying to select a group of users that ...
6
votes
3answers
3k views

How can I find the source of slow queries in Wordpress?

I have a WordPress site with more than 8000 posts and everytime I add a new one the site becomes unresponsive. I checked the MySQL slow queries log and found out that it is performing a select that ...
0
votes
1answer
83 views

MySql Query for Wordpress

I need to count the number of value 1 from wp_ul_locked on wp_usermeta i try this code $wpdb->get_var("SELECT COUNT(*) WHERE 'meta_key' LIKE 'wp_ul_locked'"); or $wpdb->get_var("SELECT ...
0
votes
0answers
34 views

Unable to access MySQL in Powweb

I wanted to retrieve my data in powweb's mysql but I get an error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'snursing'@'walcustweb1601.int.bizland.net' (using ...
4
votes
3answers
6k views

What are the recommended database permissions for WordPress?

I just got WP running on my own server. I am not trying to lock things down more. What permissions should the db user have to my WP db?
1
vote
0answers
275 views

$wpdb->insert() does not Insert record in a table

I'm trying to understand and get hold of the $wpdb global object but can't seem to make it work. Basically, I'm trying to insert a single record into a custom table in wordpress DB. Instead of ...
0
votes
0answers
46 views

Delete junk text from all the post using my sql command

Because of an autoblog plugin, my site has got junk text in every post! The text format is as below .. funny-pictures/funny-pictures-of-the-day-30-pics/attachment/funny-pictures-41-2/" ...
1
vote
2answers
3k views

How to validate WordPress generated password in DB using PHP?

I am working with site that is done with WordPress, and I need to add some parts that are outside WP, and to check user login, Logging users outside WP. I tried with md5 of password but it's not... ...
0
votes
2answers
451 views

Running Wordpress from MySQL Cluster with HAPRoxy

I'm trying to install a wordpress installation where the DB will sit on a MySQL cluster (Galera/Percona XtraDB Cluster) and connected through HAProxy. Everything outside of the Wordpress install ...
0
votes
1answer
46 views

Internal error (500) on local & Fatal error on live when trying to access post type edit screen

I'm building a CMS for a company that has 60,000+ static pages which have been converted into posts. 30,000 of these are a particular post type. When I try to access the edit screen in the admin area ...
0
votes
1answer
193 views

How to permanently delete a taxonomy

I want to delete a taxonomy (both form wordpress and database) created long time ago and now no more used. How to do it? I found this function but I think it will delete all my taxonomies... and I ...
0
votes
1answer
64 views

Copy url from post_content to custom field

I'm new to MySQL so I don't know if this is even possible. I would like to copy a url that's in post_content to a custom field. The url is variable and it looks like this: ...
2
votes
1answer
116 views

Ordering Post 2 Post admin meta box by meta from CPT

I've just started using Posts 2 Posts (brilliant plugin by the way) in combination with a custom post type called "Artist" and the WP Event Manager Plugin. My aim is to use P2P to link Artists to ...
3
votes
2answers
923 views

How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?

Normally, a MySQL database can be exported and imported using these simple SSH commands: Export: mysqldump -u USERNAME -p DATABASE_NAME > filename.sql Import: mysql -u USERNAME -p ...
0
votes
1answer
62 views

wpdb_prepare with multiple or condition

I want to execute a query like this: $wpdb->prepare( "SELECT * ... from ... WHERE ( post_title LIKE '%%%s%%' or post_content LIKE '%%%s%%' )..., $string ); If I do the query with only one ...
0
votes
0answers
85 views

featured image not showing up with mysql_connect

i noticed a certain problem with the featured image issue, i had everything work nicely until i added a mysql connection to another database to retrieve certain information, the featured image stop ...