Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>POSSIBLE FIX 2</strong></p> <p>Look, I've seen this problem on other threads and on other websites and no one gave information that helped most of the people with this issue, so since I somehow got my broken site to work, perhaps it will help the others who did not get their problem solved.</p> <p>Here's a little background... I needed to move a wordpress site located on a dev server to the live server. They were different domain names of course. First of all, I should have followed <a href="http://codex.wordpress.org/Moving_WordPress" rel="nofollow">Moving Wordpress instructions</a> and updated the site url before I exported the database, but... I didn't because I'm obviously too cool for instructions.</p> <p>In order to transfer the site, I zipped up the files and transferred them to the new server and unzipped them. Then I edited wp-config and pointed it to the new database.</p> <p>I used phpmyadmin to export the old database and I imported it to the new database.</p> <p>Then I ran a query on the <code>wp_posts</code> table to do a string replace on the <code>guid</code> field and replace all instances of the old domain name with the new domain name.</p> <p>Then I checked in <code>wp_options</code> and changed 2 records to replace the old domain name with the new one. I think they were something like <code>siteurl</code> and <code>home</code>.</p> <p>Everything seemed to be working fine except the theme was mangling the img urls, prefixing them with the absolute filepath.</p> <p>I figured I must have missed some records in the database that give the print_thumbnail function whatever information it needs to output the right url for the img's src attribute.</p> <p>I thought if I could change a setting somewhere and change it back, maybe wordpress would automatically fix the issue for me, and I was lucky.</p> <p>I played around with several settings and what finally worked was:</p> <p>I went to <code>Media Settings</code> and I unchecked <code>Organize my uploads into month- and year-based folders</code> -- I don't know if this had much to do with the fix.</p> <p>I also changed the <code>Store uploads in this folder</code> to something like <code>wp-content/uploads2</code>. I never created that folder, but I just wanted to get it to overwrite whatever was controlling that value.</p> <p>I checked the site again and there was a change to the html source... now, it didn't even give the img tags a src value... it was just like <code>&lt;img src title="blah blah" /&gt;</code>, so I figured I was on the right track.</p> <p>So then I went back and changed <code>Store uploads in this folder</code> setting and left it <code>blank</code> as it was originally.</p> <p>After I did that, the img src values were correct.</p> <p>Hope this saves someone some time.</p> <p>Also, I should note, I played around with altering the file permissions for the wp-content directory. I wish I hadn't. I get the gist of file permissions, but I tend to try not to fool with them if I don't have to. Using Filezilla is a pain to change the file permissions because it takes forever. Unfortunately, as most clients, this one had a prior affiliation with their web host and refused to take my advice and host their site on a VPS that would be cheaper and allow me to use SSH and get work done much easier. I wonder if there's a fast way to chmod multiple files without ssh, I should look into that.</p> <p>Cheers,</p> <p>Will</p>
    singulars
    1. This table or related slice is empty.
    1. POwp print_thumbnail function is not working
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USWill
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload