Forum Replies Created

Viewing 15 replies - 1 through 15 (of 16 total)
  • Yes, run duplicator and when it gives you a warning that certain files are too large, it gives you the option of filtering some of the files — you just gives it the path and start again, and it should do it thing without complaining again. I once I had site with lots of photography and videos, so I just excluded the path to the wordpress’s content/uploads (instead of picking specific files out of there) and added the whole upload directory manually to my localhost site — the end result was the same as if sites were just text and small photos. Hope this helps.

    I’ve been there, done that, and all I can say is that Duplicator would be faster and more efficient than search and replace. I don’t have shares or a stake in the plugin. Just my 2 cents

    I can’t see how a single site’s database could be 1.5GB. It shouldn’t be much larger than 1MB, it’s just text. There must be something else there that’s got nothing to do with the site. And no, you can’t use Duplicator with something this big — it would give you an error message –even with large media files, you may have to move those manually (though the links are preserved so it’s not a problem).

    If you can’t pry out the database just for that site, I’d consider exporting an xml file from the dashboard (tools > export), then import it into a blank installation — of course you’d have to redo some aspects of the site, it’s not as seamless as with Duplicator, but if you’re overhauling it anyway, it’s probably not a big problem.

    In an ordinary setup, yes, non wordpress tables are probably created by plugins, which is fine — duplicator would copy everything.

    The best simplest way IMO is to create a “Duplicator” package (Duplicator is a wordpress plugin, there is a free version) from your website and follow Duplicator’s directions — the advantage of this method is that all your links get converted for you from whatever http://www.mywebsite.com to localhost/mywebsite (the folder name on your computer). When you’re ready to upload it back, you just create a new duplicator package and do the same thing in the opposite direction, and all your local host links get converted to the website’s links. (You will need to create a blank/new database on your localhost or web host for Duplicator to populate the tables, but the package will bring along the entire wordpress installation.)

    Hope this helps.

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    The gist of it (sorry, I can’t see how to edit prior messages) is that the mod security worked fine previously, and I only disabled it to upgrade, I still got the failed to query error, but since the site worked fine, I went and put the mod security back on,and that’s when I got the 406 error and that’s when I contacted the web host.
    Thanks again

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    sorry about the URL. Should be
    http://www.webhostinghub.com/
    Thanks

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    Web hosting Hub <https://secure.webhostinghub.com/&gt; — that’s all the guy I talked to could offer. I went there twice, but it was the same guy both times.

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    Well, my web host said they have to do it for me but they said they don’t see any such error
    — they say “probably mysql query packet warning which is nothing serious has to do with mysql…”

    BUT NOW I’m having problems with their mod security — I basically have white site, a 406 error — unless I disable it.
    [:error] [pid 621229:tid 139929469646592] [client 67.86.245.55] ModSecurity: Access denied with code 406 (phase 1). Found 1 byte(s) in REQUEST_HEADERS:Cookie outside range: 1-255. [file “/usr/local/apache/conf/modsec-imh/01_base_rules.conf”] [line “28”] [id “960015”] [msg “Request Missing an Accept Header”] [severity “CRITICAL”]

    I’d appreciate any insight you may have

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    How do I check my site’s error logs? I don’t know where they might be. Never had to in the past.
    Thanks

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    That’s just totally impossible, it’s a complex theme with an awful lot of function customizations and switching it would entail taking the site down. I am just trying to get the wording of an error notification. It popped in and out during installation but there must be some record of it somewhere? Thanks.

    Forum: Fixing WordPress
    In reply to: 4.6.1 installation
    Thread Starter 72brb

    (@72brb)

    Thanks, but I would like to find out the wording of the notification as it seems to happen only on sites running a certain theme, so I could run it by the theme authors.

    Thread Starter 72brb

    (@72brb)

    It seems I solved at least part of it. This is my replacement code (in my child theme’s content.php):

    <?php if ( in_array( 'category', get_object_taxonomies( get_post_type() ) ) && twentyfourteen_categorized_blog() ) ;
    	if ( is_single() ) : ?>
    		<div class="entry-meta">
    		<span class="cat-links"><?php echo get_the_category_list( _x( ', ', 'Used between list items, there is a space after the comma.', 'twentyfourteen' ) ); ?></span>
    		</div>
    	<?php the_title( '<h1 class="entry-title">', '</h1>' ); 
    
    			else :
    				the_title( '<h1 class="entry-title"><a href="' . esc_url( get_permalink() ) . '" rel="bookmark">', '</a></h1>' );
    			endif;
    		?>

    Forum: Fixing WordPress
    In reply to: Database problems
    Thread Starter 72brb

    (@72brb)

    This worked: A new database from the SQL backup. I basically got it up and running, then exported it to a clean install of WordPress to get rid of those weird tables. (Oddly, I tried a new database before posting here but I was probably not doing it right, didn’t have a clear idea of what I was trying to achieve.)

    Thank you very much.

    Forum: Fixing WordPress
    In reply to: Database problems
    Thread Starter 72brb

    (@72brb)

    Thanks, I’ll have to give it a shot tomorrow, it’s late where I am. I would prefer xml, because I’d rather lose those weird tables, but I’m not imagining it — I made a point to select xml in the export page on phpmyadmin, and wordpress did not recognize it as a file it could import.

    Forum: Fixing WordPress
    In reply to: Database problems
    Thread Starter 72brb

    (@72brb)

    Thanks for this, but I’m beginning to think that the problem is I was working from a Duplicator “clone” from a site originally on Godaddy, and for whatever reason Godaddy added 3 tables that don’t exist in a standard WordPress installation (with some added gibberish in the names. (wp_njfrfkmccp_cfs_sessions, wp_njfrfkmccp_cfs_values and wp_njfrfkmccp_cms2cms_options– all the tables are named that way), so when I tried to upload the sql backup to the empty database, I got an error in the SQL query that the first one (cfs_sessions) doesn’t exist.

    This is a SQL backup of this particular database, why would anything not exist?

    And if they don’t exist, why do they persist in the listing on the left panel of phpmyadmin? They’re still there after I deleted all the tables per your advice, the 3 non-standard one and the wp_njfrfkmccp_options.

    Is there a way to delete the “listing” of those non-existent tables from the left panel/from the database so it doesn’t go searching for them?

    I also tried to export the database as an xml file and importing it to a new installation of wordpress, but wordpress didn’t recognize it as an xml file, it thought it was something else (I can’t remember the extension it thought it was). Seems like it’s not the same as importing an export that was created from within the dashboard.

    Just wondering (sigh).

Viewing 15 replies - 1 through 15 (of 16 total)