Two things, at least: It looks like you need to declare the global $wpdb and you’re using $wpdb->insert() incorrectly. The insert() method doesn’t take your SQL query but a list of variables. It then create the SQL for you. See here You can execute SQL directly but it’s a different process.
As discussed in the comments, your database prefix settings are off-kilter. Check the database prefix actually in use in your database, and make sure it’s the same as the one in wp-config.php. Also make sure all of your WordPress-related tables have the same prefix. You’ll also need to search through your database, particularly in the … Read more
I’ve checked and WordPress does, by default, retrieve & cache all post meta along with the main query’s posts, so you’re perfectly fine storing a product’s additional fields as standard post meta. You might want to store Brands (merchants? manufacturers?) as a custom taxonomy so that you can take advantage of built-in templates and queries … Read more
Fixing this through the database is the best way to regain access to your Dashboard. Since it sounds like that you only changed the site URL and nothing else, do the following: In your database (via phpMyAdmin) go to the wp_options table and you’ll find the site and home rows You should see http://web.site/home/home in … Read more
You’ve posted some serialized arrays. The first entry, a:1:{s:13:”administrator”;s:1;} is corrupted – that’s not a valid serialized array. The second entry, a:1:{s:13:”administrator”;s:1:”1″;} looks like this when unserialized: array ( ‘administrator’ => ‘1’, ) The third entry, a:1:{s:13:”administrator”;b:1;} looks like this when unserialized: array ( ‘administrator’ => true, ) In my setup, capabilities are stored like … Read more
Have you looked at the server log files (MySQL and PHP)? It could be several things: A MySQL permission issue on the db and/or table Table is named differently than stated in your code MySQL and/or WordPress are using older versions that don’t support certain syntax
I googled a lot the last days and a few times i´ve seen postings that say that the $wpdb->update function doens´t support multiple updates and that this is not well documented. -> Sorry i don´t have links anymore… I think that this is true because i couldn´t get it to work and i found not … Read more
You really should dive in more yourself. I’m not sure how good of a programmer you are, but you almost certain have to start to write a script that extracts all the information you want from the database and put this in an array. Once you’ve done that, you can use this data to create … Read more
Try this code <?php $args = array( ‘s’ => $_REQUEST[ ‘search’ ], ‘cat’ => ‘category_id’, ‘paged’ => $paged ); // The Query $the_query = new WP_Query( $args ); // The Loop while ( $the_query->have_posts() ) : $the_query->the_post(); //inside the loop the_title(); the_content(); endwhile; // Reset Post Data wp_reset_postdata(); ?> Hope this help
The SQL used to create the default tables is located in wp-admin/includes/schema.php inside wp_get_db_schema(): /** * Retrieve the SQL for creating database tables. * * @since 3.3.0 * * @global wpdb $wpdb WordPress database abstraction object. * * @param string $scope Optional. The tables for which to retrieve SQL. Can be all, global, ms_global, or … Read more