Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

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

1
vote
1answer
7 views

Error establishing a database connection; After importing DB & Theme

I'm doing some work on a client's wordpress so to not touch the live I imported what I thought I needed from their FTP into my xampp to reproduce their environment. Their website is hosted on bluehost,...
-1
votes
1answer
17 views

How can I rebuild my websites while I don't have databases?

Years ago, I had made multiple WP sites and now I see some of them as WP folders on my local disk. I want to make them as working websites. How can I do that?
0
votes
1answer
20 views

Malware in old website - how to migrate?

I was hired to build a new website for a company who's old website has turned into a dumpster fire. I was then asked to migrate over 1000 blog posts from the old website to the new website. This has ...
0
votes
0answers
5 views

WordPress, WooCommerce wp-admin BackEnd work speed of response issue

Product Uploading: Limited by uploading 1000 products per instance, if more the process is freezing. The more uploaded products a vendor has the slower new products uploading speed. Product Uploading ...
-1
votes
0answers
19 views

Site is redirecting automatically [on hold]

[17-Apr-2019 10:13:58 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at ...
-1
votes
0answers
20 views

How do I add data from a MSSQL database to a Vehicle Listing Plugins DB?

How do I add data from a MSSQL database to a Vehicle Listing Plugins DB? I would like to find out how can I push data from my MSSQL database to a vehicle listing plugins database to keep the listing ...
0
votes
1answer
30 views

How to get a list of WordPress default database tables?

Is there any solution to get a list of default database tables in WordPress? I have used $wpdb->tables() but even with blog argument, it returns a list that includes other tables too. (I have some ...
1
vote
2answers
133 views

Create Pages from Database

i've recently decided to create a website with wordpress. My goal is to a visualize data stored in a MySQL database. Each id in the database should represent one page on the website. From what i've ...
0
votes
0answers
16 views

How to Generate a Lot of Pages from a Database in Wordpress?

I have a page template that I have to use for hundreds of different products. I don't intend to create all those pages manually, and I want to know how to generate them automatically from a database ...
0
votes
0answers
13 views

allow multisite in the installation process

So I want basically to automate wordpress installation for multisite, I looked a bit and found that I can do that using the drop-in plugin wp-content/install.php, It obviously works for normal ...
1
vote
1answer
20 views

Is there a smart way to obtain a list of only some selected user meta data?

I have a case where, if I had written the DB and queries myself, I would just do something like SELECT name, firstname, email FROM users WHERE .... Returning me a list/collection/array, I mean, not ...
0
votes
1answer
23 views

Free version of Relevanssi doesn't show ACF fields

I understand the Premium version of Relevanssi has support for ACF fields built in but I have the free version. I'm working on a way to grab the information from the database and then spit it out on ...
0
votes
0answers
23 views

Can someoene please help with customization of a post?

I turned WP posts into web forms, which write user data into the database. Now, I want to insert the username of logged in user into the database - automatically. I attempted $current_user = ...
1
vote
0answers
20 views

How can I save unique user data on my site? [on hold]

I am trying to find a way to allow registered users on my site create lists of data and save them. I'm having trouble finding a way to save the list they create to the database of my site. I am ...
0
votes
1answer
19 views

I would like some help wth an SQL query to link posts with categories

I am extracting data from my Wordpress database to analyse site structure. Works pretty good so far but I would like to include the posts main category in the table to enable further analysis. This is ...
0
votes
0answers
24 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? ...
-1
votes
1answer
17 views

How do join in query with wordpress

i need do join 2 tables of booking in worpress, $wpdb->get_results("SELECT * FROM $db",ARRAY_A); for example SELECT b.*, GROUP_CONCAT(ba.NamePack SEPARATOR "<br />") Extras, (SUM(...
-2
votes
0answers
37 views

How to store large amounts of data in a custom field

This question has been similarly asked before without any real conclusion. The LONGTEXT max for MySQL is 4,294,967,295 characters. But wordpress is refusing to save custom meta that is 2,000,000 ...
1
vote
0answers
33 views

Why does importing copies of the database dump and the document root make WordPress data inconsistent?

I'm experiencing the following problem: I have a local copy of my WordPress site and a corresponding live version on my server. I added some new blog categories on my local version and created some ...
0
votes
0answers
18 views

how to insert/ import wp custom post type data manually into database

I have created a custom post type with a few custom fields in WordPress. I need to insert this custom post type data manually insert/ import into database table from my another table. My custom post ...
-1
votes
1answer
22 views

User register hook can't access form request

I'm trying to add a few custom field to the registration form using the code below. After registrations customs fields with keys are created but they don't have any value. I think that my $_POST['...
0
votes
0answers
14 views

Version control and database issues with intertwined data

I was looking into VersionPress and It looks really good pretty much exactly what I wanted but it explicitly says on their website Currently, VersionPress is a Developer Preview and should not be used ...
0
votes
1answer
25 views

Inserting PHP before a menu element, while using the inbuilt menu function wp_nav_menu()

This is tricky to word so bear with me please. I have generated a wp_nav_menu, menu-1, as the main-menu. The menu is quite complex compared to a basic b**** one. Whereby you can show and hide parts ...
-1
votes
2answers
23 views

Problem of encoding characters (apostrophes) in my posts publications

I currently have a big apostrophes problem when my articles are published on my website, because for an example of a word like "l'associé", my article is published with characters that replace the ...
0
votes
1answer
17 views

Communication in between WordPress database and another (not WordPress) database

I have a WordPress site running and I am making a data entry portal for our data entry operators to speed up their work (we need data entry portal to make sure we don't have duplicate entries). I have ...
0
votes
2answers
17 views

How do I loop/iterate through posts to edit all img tags?

Heads up, I'm pretty new to Wordpress... But I need to loop through multiple posts and change all 'data-src' attributes to 'src' so my images will display. What's the way/best way to go about doing ...
0
votes
0answers
17 views

Is it possible to separate databases in WordPress site - one for orders and the other for all non-orders related

I am new to WP but already encountered a rogue plugin which completely messed parts of my database ( it was a media library folders management plugin). I would happily restore the site back to before ...
0
votes
0answers
13 views

Survey plugin recommendation with symbol pictures?

I would like to ask this question again, and ask if maybe since 2012 there is change of plugin recommendation. What is a good plugin to do surveys for wordpress? Explanation: I have received many ...
0
votes
1answer
24 views

Error establishing a database connection in wordpress

I know this is self explanatory but why can't I connect to my database? I have a live website that I wanted to update by first doing development in my local computer. I exported the db to my local pc ...
0
votes
1answer
23 views

Order by custom table and multiplication

I want to order posts by multiplying values from a custom table. +---------+------+------+------+------+------+ | post_id | a | b | c | d | e | +---------+------+------+------+------+--...
0
votes
1answer
20 views

Error establishing a database connection after moving local wordpressmultisite from one directory to another

Good day together, as the title mentions, i want to clone a local wordpressmultisite(i use xampp) to another directory. the first existing mutlisite runs under xampp on http://localhost/Wordpress. the ...
0
votes
1answer
31 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 ...
1
vote
0answers
16 views

How can i customize the export personal data file?

I want to know is there a way to customize the export personal data page? If you go to wp dashboard > tools > export personal data, you can download an html file which contains your personal data. Is ...
0
votes
1answer
25 views

Connecting to a different database

In my site I'd like to pull in data from another table, without having to create an API from the other site. I have seen that you can do something like this: $wpdbtest_otherdb = new wpdb('...
1
vote
1answer
55 views

WordPress Shortcode show database row

Good day, I was wondering if can do a shortcode that gets all the fields in a row stored in a database, with the difference that I do not want to do many shortcodes for the speed of the site. The ...
0
votes
2answers
26 views

Where is the HTML-handler part in the wpdb class?

I'm trying to understand how datas are being handled when saving to the database in the wpdb class. I have searched for where HTML string datas are handled and found a method in the $this->query() ...
0
votes
1answer
22 views

Will resetting my database affect other sites on my multisite Wordpress install?

I am using the Bridge theme and after installing a theme I would now like to change to a different demo theme. In the instruction video provided by Qode it advises that I use a plugin called wordpress ...
0
votes
0answers
11 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 ...
1
vote
1answer
21 views

Bulk activate a theme on multisite

I have a multisite and a new theme that needs to be activated across all subsites. I found an answer by fuxia from 2012 and would like to know (1) if there have been changes in WordPress since that ...
0
votes
1answer
23 views

Specifying meta field's column type in Database using add_post_meta

In my code, I enhance one of my content types by following code: add_post_meta( $post->ID, 'favourite_fruit_code', $value ) All goes well, but I would like to have power over specifying what a ...
0
votes
4answers
47 views

Remove a shortcode from all Wordpress posts

I changed a wordpress theme on an old site and removed all plugins which were unnecessary. All went well except for a shortcode that was used by the earlier author shows up on every post. For ...
0
votes
1answer
17 views

Exporting Post ID, Post Title, Primary Category and Primary Category ID

Trying to export the following data from WordPress or directory through MYSQL query. Post ID | Post Title | Post Content | Post Excerpt | Post Primary Category | Primary Category Term ID | Post ...
0
votes
1answer
45 views

wpdb Cannot Update column in Database

In the custom table, I try to update a specific column with using $wpdb->update class and using HTML form for updating one column that has same id (in here dlname Is ID of data ). The problem is this ...
0
votes
1answer
19 views

Export only a part of the database for migration

I have to migrate a very large WordPress Installation, and the majority of the data is (too) old and not needed. I was looking for a possibility or plugin to exoort only a part of the database: only ...
0
votes
0answers
21 views

WordPress Multisite IIS domain name bindings - error 404 and 503 - database issue?

I have two sites setup in my multisite setup, besides the main site, that are working with no problems. Each site is setup with a separate domain that I setup in the bindings in IIS. If I setup the ...
0
votes
0answers
20 views

Featured image from custom to Wordpress database

I want to adapt my old custom website database (composed of only one table) to Wordpress database. All data has been correctly imported in both tables (wp_posts and wp_postmeta) with a php code that ...
0
votes
1answer
10 views

Options on how to Display member specific data from a MS SQL database

I am in the conceptual stage still but I want to create a word press database that will do the following in the following scenario: Lets say i have 10 sales people in my store. I want them to be ...
0
votes
2answers
25 views

Code is providing a row of data but not formatting it as table

I am using the following code: function seconddb() { global $seconddb; $seconddb = new wpdb('username','password','g3boat5_G3_Genba','localhost'); } add_action('init','seconddb'); // add the ...
0
votes
1answer
59 views

Display Data in Table from External Database in WP using Shortcodes

I have successfully coded a secondary database connection for my wordpress site in the functions.php file in wordpress. I have used the following to create shortcode and run the data to my table where ...
2
votes
1answer
75 views

Connect Second Database to Wordpress

I am trying to connect a second database to my wordpress site so that I may ask for data from it and display it in a table on my site. I have tried multiple ways of doing so. I have tried to use php ...