trying to transfer cpt problems

(@bdempleos)

http://buscadordempleos.com/xml-files/xml-files.zip

Sure mike!!
in this links you can download the files. i use the wxr splitter (because the original file size its 135mb).

In the zip you can find some xml and the original xml file (130mb file)

thanks

Plugin Author

(@mikejolley)

woah how many jobs are there?

For a huge BD, and a clean migration, I’d probably export the posts, terms, postmeta tables etc via SQL and import them into another site. Thats assuming the new site doesn’t already have content.

The slowdown might not be data related – if there are a large number of jobs it could be server + memory.

Thread Starter

(@bdempleos)

almost 68k, i try to import the tables by ftp but it doesn’t load the theme jobify.

Plugin Author

(@mikejolley)

Well when you get to that point, check the server error logs – it will tell you if its memory related and then you can act accordingly.

Thread Starter

(@bdempleos)

in the log i found this error

[02-Feb-2014 17:07:24 America/Denver] PHP Parse error: syntax error, unexpected ‘define’ (T_STRING) in /home2/buscado2/public_html/test/wordpress/wp-config.php on line 48

Plugin Author

(@mikejolley)

Well, that would cause a white screen if you’ve not fixed it already… have you?

Thread Starter

(@bdempleos)

i don’t fixed because i don’t how to do this, sorry, im not developer 🙁

Plugin Author

(@mikejolley)

Look at the wp-config file line 48 and see whats there. You could post a small snippet of that file here if you wish, just ensure you take out any passwords and secret info.

Thread Starter

(@bdempleos)

mike, here you can see all the wp-config, i delete all the passwords and database name and user.

[please make sure to mark any posted codes, or better use the pastebin.com – http://codex.wordpress.org/Forum_Welcome#Posting_Code – parts of the code below might be broken]

<?php

/**
 * Configuración básica de WordPress.
 *
 * Este archivo contiene las siguientes configuraciones: ajustes de MySQL, prefijo de tablas,
 * claves secretas, idioma de WordPress y ABSPATH. Para obtener más información,
 * visita la página del Codex{@link http://codex.wordpress.org/Editing_wp-config.php Editing
 * wp-config.php} . Los ajustes de MySQL te los proporcionará tu proveedor de alojamiento web.
 *
 * This file is used by the wp-config.php creation script during the
 * installation. You don't have to use the web site, you can just copy this file
 * to "wp-config.php" and fill in the values.
 *
 * @package WordPress
 */

// ** Ajustes de MySQL. Solicita estos datos a tu proveedor de alojamiento web. ** //
/** El nombre de tu base de datos de WordPress */
define('DB_NAME', );

/** Tu nombre de usuario de MySQL */

/** Tu contraseña de MySQL */

/** Host de MySQL (es muy probable que no necesites cambiarlo) */
define('DB_HOST', );

/** Codificación de caracteres para la base de datos. */
define('DB_CHARSET', 'utf8');

/** Cotejamiento de la base de datos. No lo modifiques si tienes dudas. */
define('DB_COLLATE', '');

define('WP_MEMORY_LIMIT', '128m');

/**#@+
 * Claves únicas de autentificación.
 *
 * Define cada clave secreta con una frase aleatoria distinta.
 * Puedes generarlas usando el {@link https://api.wordpress.org/secret-key/1.1/salt/ servicio de claves secretas de WordPress}
 * Puedes cambiar las claves en cualquier momento para invalidar todas las cookies existentes. Esto forzará a todos los usuarios a volver a hacer login.
 *
 * @since 2.6.0
 */
define('AUTH_KEY', 'a!NQX-Tx ^E4x!uS[UDb+NZtm|e)Tk<rl?LAJ+e[G5|Kz;C,z=FcD$4gsY|%+kgL'); // Cambia esto por tu frase aleatoria.
define('SECURE_AUTH_KEY', 'VvNqJm)p9i{M#.!Gas?IHeK9xklN>1]dx=F|]Tn$0#UW2f+:Z+BE5.7cmRc+8hL>'); // Cambia esto por tu frase aleatoria.
define('LOGGED_IN_KEY', 'yE~lYBo+A|yl!e(^JGY.)_C+k6M3|D:QYAwI=nT}mj,?=7</+z3XH{H0mI:CSs0k'); // Cambia esto por tu frase aleatoria.
define('NONCE_KEY', ':6<code>l/pOw(V|7+*p!vLfvyq2aBM9kz9B%0yPlax=$&0pp/b>-Ig<G%EzDg~qJ=</code>IS'); // Cambia esto por tu frase aleatoria.
define('AUTH_SALT', '.wbxy]S:Eq7|^c4f1C(d02l?,;+x$rf+}-.8. ,C1N}hJ .Rr[VOfl+tB4RjdXCq'); // Cambia esto por tu frase aleatoria.
define('SECURE_AUTH_SALT', 'Pp_@qkx+|tJ+qiFfT]]~Y-5SU +dtMYrsQ$y#ql*#VBNG$T+;/jwCfKi=RSj[V

>’); // Cambia esto por tu frase aleatoria.
define(‘LOGGED_IN_SALT’, ‘G;U*[t9s&;5vKBh1*%l7M/5s3 yf*~zvN4Ahp.%tox4hU%q4#!v^-LN3U+ UU}’); // Cambia esto por tu frase aleatoria.
define(‘NONCE_SALT’, ‘O5 ^:gu+5;a!T11PWweox9R!HUj/(pz1+vzT^1pq>BkocZM,#9)8Gvc>y*oKR6T|’); // Cambia esto por tu frase aleatoria.

/**#@-*/

/**
* Prefijo de la base de datos de WordPress.
*
* Cambia el prefijo si deseas instalar multiples blogs en una sola base de datos.
* Emplea solo números, letras y guión bajo.
*/
$table_prefix = ‘wp_’;

/**
* Idioma de WordPress.
*
* Cambia lo siguiente para tener WordPress en tu idioma. El correspondiente archivo MO
* del lenguaje elegido debe encontrarse en wp-content/languages.
* Por ejemplo, instala ca_ES.mo copiándolo a wp-content/languages y define WPLANG como ‘ca_ES’
* para traducir WordPress al catalán.
*/
define(‘WPLANG’, ‘es_ES’);

/**
* Para desarrolladores: modo debug de WordPress.
*
* Cambia esto a true para activar la muestra de avisos durante el desarrollo.
* Se recomienda encarecidamente a los desarrolladores de temas y plugins que usen WP_DEBUG
* en sus entornos de desarrollo.
*/
define(‘WP_DEBUG’, false);

/* ¡Eso es todo, deja de editar! Feliz blogging */

/** WordPress absolute path to the WordPress directory. */
if ( !defined(‘ABSPATH’) )
define(‘ABSPATH’, dirname(__FILE__) . ‘/’);

/** Sets up WordPress vars and included files. */
require_once(ABSPATH . ‘wp-settings.php’);`

Plugin Author

(@mikejolley)

I don’t see anything obvious wrong there. Anything else in your logs besides that?

spletsplet33

(@spletsplet33)

Ok. I will join this conversation. Obviously bdempleos hired me to fix this problem. Yes there is a problem. I made a clean install and import the posts via sql import. It seems, that table wp_postmeta is making some trouble here. In the back-end all the posts are imported as they should be…but in front-end site just go white blank. If cleaning the wp_postmeta table site is back again…but of course job posts are without Job Listning Data. Any idea why? tnx.

Plugin Author

(@mikejolley)

@spletsplet33 No I don’t know why. But a blank site = fatal error so scour his logs some more. Look for anything related to memory and [fatal errors]. If its memory, you can increase it using WP_MEMORY_LIMIT constant.

spletsplet33

(@spletsplet33)

hm…maybe this:

[ Moderator Note: Please post code or markup snippets between backticks or use the code button. Or better still – use the pastebin. This included log data too. ]

[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_region', 'job_listing_tag', 'job_listing_category', 'job_listing_type') AND tr.object_id IN (82960, 82962, 82963, 82964, 82966, 82967, 82968, 82969, 82970, 83894) ORDER BY t.name ASC made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, _prime_post_caches, update_post_caches, update_object_term_cache, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (83894) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82966) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82967) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82968) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82969) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82970) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82960) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82962) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82963) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
[25-Feb-2014 06:55:47 UTC] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('job_listing_type') AND tr.object_id IN (82964) ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, jobify_job_archives, locate_template, load_template, require_once('/themes/jobify/taxonomy-job_listing_category.php'), get_job_manager_template_part, load_template, require('/plugins/wp-job-manager/templates/content-job_listing.php'), job_listing_class, get_job_listing_class, get_the_job_type, wp_get_post_terms, wp_get_object_terms, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

spletsplet33

(@spletsplet33)