http://mu.wordpress.org/forums/ WordPress MU Forums Tag: database en Wed, 25 Nov 2009 19:49:58 +0000 http://mu.wordpress.org/forums/topic/15553#post-89072 Fri, 20 Nov 2009 23:15:31 +0000 andrea_r 89072@http://mu.wordpress.org/forums/ <p>friggin' rain borkin' my internet... </p> http://mu.wordpress.org/forums/topic/15553#post-89070 Fri, 20 Nov 2009 23:12:37 +0000 andrea_r 89070@http://mu.wordpress.org/forums/ <p>Well, I'm just glad that worked. :D </p> http://mu.wordpress.org/forums/topic/15553#post-89067 Fri, 20 Nov 2009 22:04:12 +0000 r-a-y 89067@http://mu.wordpress.org/forums/ <p>Okay I've resolved this issue by exporting the posts from the WP admin area, deleting all taxonomies (categories, tags, link categories, custom taxonomies) and then used WP's import function.</p> <p>Just have to re-adjust a few things due to category ID changes, but everything appears well with the WPMU cosmos again!</p> <p>---</p> <p>Word of warning for those importing regular WP blogs via PHPMyAdmin / mySQL. Watch out for the wp_sitecategories table!</p> <p>Best to use Ron's <a href="http://wordpress.org/extend/plugins/advanced-export-for-wp-wpmu/">Advanced Export plugin</a> and re-import in the Wordpress admin area. </p> http://mu.wordpress.org/forums/topic/15553#post-88892 Wed, 18 Nov 2009 23:05:29 +0000 r-a-y 88892@http://mu.wordpress.org/forums/ <p>I'm just going to add some additional thoughts.</p> <p>Is there a reason MU looks at the wp_sitecategories table for tags, link categories and custom taxonomies instead of the wp_x_terms table?</p> <p>Should this be reported as a bug on Trac? </p> http://mu.wordpress.org/forums/topic/15553#post-88890 Wed, 18 Nov 2009 23:03:32 +0000 r-a-y 88890@http://mu.wordpress.org/forums/ <p>Okay I think I figured this out.</p> <p>Take a look at this screenshot again:<br /> <a href="http://i49.tinypic.com/xct9qs.jpg" rel="nofollow">http://i49.tinypic.com/xct9qs.jpg</a></p> <p>We did some digging and found out that the circled term_id's are actually the <em>cat_ID</em> from the wp_sitecategories table, instead of the <em>term_id</em> from the <strong>wp_1_terms</strong> table.</p> <p>So I was trying to figure out why the wp_sitecategories table was out of sync with the wp_1_terms table.</p> <p>---</p> <p>Here's another part of the puzzle:</p> <p>The root blog is an imported blog from a regular Wordpress install done via PHPMyAdmin. I'm guessing MU never detected these terms, which is why our wp_sitecategories table is out of whack!</p> <p>---</p> <p>Then I read this thread:<br /> <a href="http://mu.wordpress.org/forums/topic/4102" rel="nofollow">http://mu.wordpress.org/forums/topic/4102</a></p> <p>Which had a similar problem to ours. He basically exported his posts in the Wordpress admin area, purged his current posts and reimported them, which correctly repopulated his wp_sitecategories table.</p> <p>I'm about to do the same, but was wondering if there was a better way for MU to detect the missing terms? </p> http://mu.wordpress.org/forums/topic/15553#post-88872 Wed, 18 Nov 2009 19:59:46 +0000 andrea_r 88872@http://mu.wordpress.org/forums/ <p>I would be more inclined to just recreate those tables within the database, not drop them all.</p> <p>you could, in theory, just drop the wp_1_whatever tables and not affect the rest of the install, but it's only the tags &amp; categories affected.</p> <p>you can backup just those tables:<br /> wp_1_terms<br /> wp_1_term_taxonomies<br /> wp_1_term_relationships</p> <p>Then drop 'em. </p> <p>A nifty feature in phpmyadmin is the ability to copy tables as well, so make a test blog that's empty, then go in phpmyadmin and select the first terms table there, and under the Operations tab, tell it to copy it. It will ask for the table name of the new copy and just make it have _1_ in there.</p> <p>Standard disclaimers apply: I have no idea if this will work, but it may help clean something up. You'd have to recreate your tags &amp; categories. You may only need to do the term_taxonomy table. PLEASE backup the entire db before you do anything else, just in case you click the delete all button by accident.</p> <p>It's definitely a puzzling issue though. </p> http://mu.wordpress.org/forums/topic/15553#post-88864 Wed, 18 Nov 2009 19:05:59 +0000 r-a-y 88864@http://mu.wordpress.org/forums/ <p>I've had an issue with term_id's and taxonomies for a while now.</p> <p>To read about my problem, see here:<br /> <a href="http://wordpress.org/support/topic/333023" rel="nofollow">http://wordpress.org/support/topic/333023</a></p> <p>MichaelH over on the Wordpress forums suggested I drop the tables and reinstall the blog.</p> <p>The caveat is this problem only occurs on one of the blogs, which would be the root blog.</p> <p>How do I go about recreating these tables without reinstalling the rest of the blogs on my MU install?</p> <p>Is this even possible? If there's a better course of action for my problem (read the link I posted above), please let me know.</p> <p>Thanks for reading. </p> http://mu.wordpress.org/forums/topic/15528#post-88837 Wed, 18 Nov 2009 14:35:26 +0000 pipstar 88837@http://mu.wordpress.org/forums/ <p>Cheers Andrea! Thanks for the response... </p> http://mu.wordpress.org/forums/topic/15528#post-88745 Tue, 17 Nov 2009 18:25:00 +0000 andrea_r 88745@http://mu.wordpress.org/forums/ <p>That menu item just runs any db changes against each blog. Since you already uploaded the new files, all blogs will have them. Any needed changes should get applied when the user logs in to the backend of their blog.</p> <p>Quick check: visit a user blog in the backend. there, it's done.</p> <p>I can't recall any db changes (other than minor), so you should be good. </p> http://mu.wordpress.org/forums/topic/15528#post-88739 Tue, 17 Nov 2009 18:12:29 +0000 pipstar 88739@http://mu.wordpress.org/forums/ <p>I appear to have been successful in my upgrading my files to 2.8.5.2, and the version number in the footer confirms my success at that level. The admin section and the blogs still seem to run successfully.</p> <p>So far, so good.</p> <p>However, when I try to Upgrade the blogs found under Site Admin &gt; Upgrade, the page loads for a while and then stops loading at all leaving menus but blank content. (/wp-admin/wpmu-upgrade-site.php?action=upgrade)</p> <p>I've looked at the page source and the page consistently appears to stop loading at the "Themes" section of the side menu. </p> <p><code>...&lt;div class=&#39;wp-menu-image&#39;&gt;&lt;a href=&#39;themes.php&#39;&gt;&lt;br /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;wp-menu-toggle&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;a href=&#39;themes.php&#39; class=&quot;wp-has-submenu menu-top menu-to</code></p> <p>like above.</p> <p>Is there a way to run the blog upgrades individually and manually? And how can I check if the tables have been modified?</p> <p>Thanks for any help. My site's working, but I don't want to leave any security holes. </p> http://mu.wordpress.org/forums/topic/15410#post-88348 Wed, 11 Nov 2009 19:45:14 +0000 tmoorewp 88348@http://mu.wordpress.org/forums/ <p>There's a serialized array stored in the wp_sitemeta table. Look for meta_key = 'update_core'. It checks the data in that serialized array against what is available at mu.wordpress.org twice a day, by default. </p> http://mu.wordpress.org/forums/topic/15410#post-88346 Wed, 11 Nov 2009 19:12:45 +0000 davidctaylor 88346@http://mu.wordpress.org/forums/ <p>So can we tell what version a blog is on based on some field in the database? How does the upgrade code know whether a not a blog should be upgraded? </p> http://mu.wordpress.org/forums/topic/15410#post-88340 Wed, 11 Nov 2009 17:36:36 +0000 andrea_r 88340@http://mu.wordpress.org/forums/ <p>The number not being updated doesn't correspond with the blog being updated. I have some in my own install that are 3458, yet when I check the backend, they are clearly running the latest version. </p> http://mu.wordpress.org/forums/topic/15410#post-88336 Wed, 11 Nov 2009 16:38:18 +0000 davidctaylor 88336@http://mu.wordpress.org/forums/ <p>"If the number n the db is the same as new version, then it won't upgrade that blog. "</p> <p>Ok, that is what I assumed. However, NONE of our blogs are the same as the new version yet we believe those people who have logged in are upgraded--or appear to be upgraded. The version number in the database is from 2.7 which we went to back in April. If some of those blogs have been updated (and we know they have) then why aren't at least SOME of the version numbers more current? I don't understand. </p> <p>If it works like you said it should work and since all of our blog version numbers correspond to 2.7, shouldn't EVERYONE be upgraded EVERYTIME they've logged in since April? I just don't think I follow... </p> http://mu.wordpress.org/forums/topic/15410#post-88332 Wed, 11 Nov 2009 16:07:59 +0000 andrea_r 88332@http://mu.wordpress.org/forums/ <p>I went and checked one of my installs, and they don't even all have the same number.</p> <p>MU just looks at it to compare against the current version when it does an upgrade. If the number n the db is the same as new version, then it won't upgrade that blog. If it's lower, it will.</p> <p>The actual number is almost irrelevant, as a previous issue (blogs showing they needed upgrading when they in fact did not) was fixed when we manually went in and changed this number to something arbitrary. Subsequent upgrades after that were fine. </p> http://mu.wordpress.org/forums/topic/15410#post-88327 Wed, 11 Nov 2009 14:30:16 +0000 LanceGrigsby 88327@http://mu.wordpress.org/forums/ <p>Andrea, our biggest concern is that we want to make sure we're testing upgrades from 2.8.4 to 2.8.5.2 and not something like from 2.7.1 to 2.8.5.2. Trying to avoid unexpected problems when we upgrade our production server, and if we can't clearly determine which version are users are actually on ... anyway, I suppose the widgets look right--they're drag 'n drop, if that helps. Here's a similar thread about this problem: <a href="http://mu.wordpress.org/forums/topic/9259?replies=5">http://mu.wordpress.org/forums/topic/9259?replies=5</a>. </p> http://mu.wordpress.org/forums/topic/15410#post-88326 Wed, 11 Nov 2009 13:54:25 +0000 davidctaylor 88326@http://mu.wordpress.org/forums/ <p>I work with Lance, so let me follow-up.</p> <p>Assuming he is upgraded, what problems will this incorrect version number in the database cause for future upgrades? Surely some process uses this when doing upgrades, right?</p> <p>Has anyone else experienced this bug? It appears that the last time this field was updated was when he upgraded all blogs. Once we went to the new process of upgrading as users log in, it seems that this field was never updated again. </p> http://mu.wordpress.org/forums/topic/15410#post-88298 Tue, 10 Nov 2009 23:14:54 +0000 andrea_r 88298@http://mu.wordpress.org/forums/ <p>Easiest way to check so the numbers don't confuse:</p> <p>- go to a user blog<br /> - login to the backend<br /> - look at the widgets page</p> <p>If it's the newer widgets, then yes. You are upgraded. </p> http://mu.wordpress.org/forums/topic/15410#post-88290 Tue, 10 Nov 2009 21:22:57 +0000 LanceGrigsby 88290@http://mu.wordpress.org/forums/ <p>I've got the latest MU version on my test server (2.8.5.2), and I notice that in the <code>wp_blog_versions</code> table, the <code>db_version</code> value is 11548--which is consistent with what regular WordPress db version is (at least, according to <a href="http://codex.wordpress.org/FAQ_Installation">http://codex.wordpress.org/FAQ_Installation</a>. I did a SQL query to see what my 2.8.4a production instance would show, and it's listing db_version for ALL my blogs as 9842, which according to the aforementioned link is what the verison is for 2.7. </p> <p>So that begs the question ... did my blogs ever get updated going from 2.7 to 2.8? I used the upgrade site option when we rolled out 2.7 but didn't do so when going to 2.8 because it was explained to me that all blogs would be updated when users next logged in. And didn't the upgrade site feature disappear from 2.7.1 to 2.8 and again reappear from 2.8.4a to 2.8.5? Is this because the "user login" upgrade method never worked?</p> <p>I'm confused. In any case, if someone can explain what the db_version table is used for, that would be great. I assume this is what gets checked when the application gets flagged for an upgrade ... </p> http://mu.wordpress.org/forums/topic/15335#post-87978 Fri, 06 Nov 2009 11:20:56 +0000 takuya 87978@http://mu.wordpress.org/forums/ <p>Copied the missing tables from wpmu1 solved. Still need testing... </p> http://mu.wordpress.org/forums/topic/15335#post-87974 Fri, 06 Nov 2009 10:33:38 +0000 takuya 87974@http://mu.wordpress.org/forums/ <p>Has any wpmu user had successufully setup two or more installs sharing the same user database by using the following method?</p> <pre><code>define(&#39;CUSTOM_USER_TABLE&#39;, &#39;wp_users&#39;); define(&#39;CUSTOM_USER_META_TABLE&#39;, &#39;wp_usermeta&#39;);</code></pre> <p>I have test sites named wpmu1.localhost and wpmu2.localhost (using xampp). So far I've managed to setup wpmu2.localhost on the same database as wpmu1.localhost and ran the install script after configuring wpmu2's config.php to use different database prefix, etc.</p> <p>Installation gone well, database (user blogs) created, but I see this error that some tables are missing.</p> <p>wp2_blogs<br /> wp2_users<br /> wp2_usermeta<br /> wp2_site<br /> wp2_sitemeta<br /> wp2_sitecategories</p> <p>I've found some blog posts, indicating they have successfully setup shared user table environment on wpmu, but they don't provide how-to unfortunately.</p> <p>I know this was originally for single version, but I'd like to make it work with wpmu. </p> http://mu.wordpress.org/forums/topic/15314#post-87901 Thu, 05 Nov 2009 15:07:51 +0000 SteveAtty 87901@http://mu.wordpress.org/forums/ <p>If you change core files then every time a release comes out you are going to have to remember what you changed and where you changed it.</p> <p>I guess what I'm trying to say is why are you altering core WP tables and code? Also as its WPMU then each time a blog is created the column will need adding unless you also modify the script that creates the new tables on blog creation. </p> http://mu.wordpress.org/forums/topic/15314#post-87900 Thu, 05 Nov 2009 14:46:56 +0000 futuro 87900@http://mu.wordpress.org/forums/ <p>hi, i have question, i insert in to table wp_post column name sur and i need show on web posts where is sur = 1. So i need to know where is function which selecting posts from database and change the SQL query. Thanks and sorry for my very bad english... </p> http://mu.wordpress.org/forums/topic/15298#post-87843 Wed, 04 Nov 2009 16:44:49 +0000 stuxstu 87843@http://mu.wordpress.org/forums/ <p>I am going to migrate 5 WP blogs to WPMU, as it is difficult to manage that many different blogs (updates, maintenance, ect..) and I have several more that I may be managing in the near future. I am new to WPMU and have a questions about how to make sure all the register users of the blogs get imported into WPMU.</p> <p>Note: This is really only an issue with two existing blogs (others are low volume sites).</p> <p>Going through the XML export of one of the blogs, I can not see how register users are "imported" into the db. Is there some way to import the registered users? I don't want to ask several hundred users to "re-register".</p> <p>Could this be done with multiple DBs or is there an "advanced" import function I am just not finding? Documentation would be worderful, if it exists. </p> http://mu.wordpress.org/forums/topic/15119#post-86995 Mon, 26 Oct 2009 12:22:26 +0000 andrea_r 86995@http://mu.wordpress.org/forums/ <p>It needs tables in the database becasue that's where it stores the data. Even if the settings are the same. </p> http://mu.wordpress.org/forums/topic/15119#post-86985 Mon, 26 Oct 2009 12:10:20 +0000 tmoorewp 86985@http://mu.wordpress.org/forums/ <p>By default, no. Each blog is designed to have its own database in order to keep things separate. </p> http://mu.wordpress.org/forums/topic/15119#post-86976 Mon, 26 Oct 2009 08:49:24 +0000 futuro 86976@http://mu.wordpress.org/forums/ <p>Hi,<br /> Can i create a new blog, which don't create new tables in the database, but the blog settings and other tables added to the table of first blog, which was created during the installation Wordpress?</p> <p>Thak you and sorry for my bad english. </p> http://mu.wordpress.org/forums/topic/14782#post-86907 Sun, 25 Oct 2009 08:50:21 +0000 pivey 86907@http://mu.wordpress.org/forums/ <p>errors solved.<br /> It was related to PHP 5.3 i used<br /> As soon as i downgraded to 5.2.11, the installation is smooth.<br /> Hope this helps </p> http://mu.wordpress.org/forums/topic/14782#post-86877 Sat, 24 Oct 2009 19:03:59 +0000 pivey 86877@http://mu.wordpress.org/forums/ <p>the tz... of course ! :-) You are my man!<br /> I defined the date.timezone="Europe/Berlin" and the timezone errors are gone.</p> <p>But!.... 'PHP Warnings still there.<br /> After installation, PHP warnings show up<br /> &gt; password is mailed OK<br /> &gt; i refresh my page and log in<br /> &gt; now when hitting "date related" content like "pages" or "blogs"<br /> are not returning errors... workflow is OK</p> <p>Any idea what is causing the PHP Warnings ?</p> <p>These are the full warnings :<br /> PHP Notice: Constant DB_NAME already defined in C:\Inetpub\wwwroot\travelians.com\wp-config.php on line 23 PHP Notice: Constant DB_USER already defined in C:\Inetpub\wwwroot\travelians.com\wp-config.php on line 26 PHP Notice: Constant DB_PASSWORD already defined in C:\Inetpub\wwwroot\travelians.com\wp-config.php on line 29 PHP Notice: Constant DB_HOST already defined in C:\Inetpub\wwwroot\travelians.com\wp-config.php on line 32 PHP Notice: Constant VHOST already defined in C:\Inetpub\wwwroot\travelians.com\wp-config.php on line 39 WordPress database error Table 'travelians.wp_blogs' doesn't exist for query SELECT * FROM wp_blogs WHERE domain = 'travelians.com' made by require, include, include_once, require_once, require_once WordPress database error Table 'travelians.wp_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE site_id = 1 AND meta_key = 'site_name' made by require, include, include_once, require_once, require_once, get_current_site_name WordPress database error Table 'travelians.wp_blogs' doesn't exist for query SELECT blog_id FROM wp_blogs LIMIT 0,1 made by require, include, include_once, require_once, require_once WordPress database error Table 'travelians.wp_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'wpmu_sitewide_plugins' AND site_id = 1 made by require, include, include_once, require_once, get_site_option </p> <p>THANK YOU SO FAR! </p> http://mu.wordpress.org/forums/topic/14782#post-86875 Sat, 24 Oct 2009 18:33:34 +0000 SteveAtty 86875@http://mu.wordpress.org/forums/ <p>Have you set a proper default tz for your server in your php.ini file? </p>