Rob Sked | 5 Feb 2008 09:36
Gravatar

Revision 6727 - New dashboard Firefox only?

Hadn't SVN'd up for a few days, and only just realised that the new 
dashboard is now working in Firefox  (2) but sill not IE 7.

Are we planning restricting the new dashboard to just Firefox?

I've done the usual clearing of the cache etc etc, but it's still only 
Firefox that's using the layout.

Rob
http://skeddy.net
Charles E. Frees-Melvin | 5 Feb 2008 14:19
Picon

Re: Revision 6727 - New dashboard Firefox only?

That and the shrink expand in the Write Post/Page is also not IE7 working
yet.

On Feb 5, 2008 4:36 AM, Rob Sked <rob@...> wrote:

> Hadn't SVN'd up for a few days, and only just realised that the new
> dashboard is now working in Firefox  (2) but sill not IE 7.
>
> Are we planning restricting the new dashboard to just Firefox?
>
> I've done the usual clearing of the cache etc etc, but it's still only
> Firefox that's using the layout.
>
> Rob
> http://skeddy.net
> _______________________________________________
> wp-testers mailing list
> wp-testers@...
> http://lists.automattic.com/mailman/listinfo/wp-testers
>

--

-- 
--------------------------------
Charles E. Frees-Melvin
charles.freesmelvin@...
www.cefm.ca
Justin Moore | 5 Feb 2008 14:19
Picon

incorrect post counts

I have post-new.php bookmarked, so I rarely see my Dashboard. However,
I clicked over to it this morning to see what has been happening with
it on trunk and was a bit confused when I saw this:

You have 1 posts, 1 page, 1 draft, contained within 28 categories and 27 tags.

In truth, I have nearly 1000 posts, a handful of pages, and four
drafts. I've been following trunk off and on for nearly a year (maybe
longer) so I have no idea if this is new behavior because of a bug in
trunk, or if something has gotten out-of-line in my database at some
point.

Anyone else seeing incorrect counts on trunk? If not - any ideas on
how I can get those to be accurate?

Currently running r6727.

--

-- 
Justin Moore
aka wantmoore
---------------------------------------
www.wantmoore.com
]V[orlock Zernebock | 5 Feb 2008 20:05
Picon

Re: incorrect post counts

Same here but with different numbers.

2008/2/5, Justin Moore <wantmoore@...>:
>
> I have post-new.php bookmarked, so I rarely see my Dashboard. However,
> I clicked over to it this morning to see what has been happening with
> it on trunk and was a bit confused when I saw this:
>
> You have 1 posts, 1 page, 1 draft, contained within 28 categories and 27
> tags.
>
> In truth, I have nearly 1000 posts, a handful of pages, and four
> drafts. I've been following trunk off and on for nearly a year (maybe
> longer) so I have no idea if this is new behavior because of a bug in
> trunk, or if something has gotten out-of-line in my database at some
> point.
>
> Anyone else seeing incorrect counts on trunk? If not - any ideas on
> how I can get those to be accurate?
>
> Currently running r6727.
>
> --
> Justin Moore
> aka wantmoore
> ---------------------------------------
> www.wantmoore.com
> _______________________________________________
> wp-testers mailing list
> wp-testers@...
(Continue reading)

Lloyd Budd | 5 Feb 2008 21:42
Picon

Re: incorrect post counts

If you take a quick peak at wp-admin/index.php you will see that
number is being generated using function wp_count_posts which is in
wp-includes/post.php . From there you should be able to determine the
query that is being run and why that doesn't include all your posts.

Please share with us the result,
Lloyd
spencerp | 5 Feb 2008 23:07
Picon
Gravatar

Re: latest svn revision, upgrade with errors..

And on blog index header.. I got this one..

WordPress database error: [Got error 12 from storage engine]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, 
count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND 
post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER 
BY post_date DESC
spencerp | 5 Feb 2008 23:05
Picon
Gravatar

latest svn revision, upgrade with errors..

After doing a SVN UP on the VB blog, then hitting upgrade link.. I got 
these errors...

WordPress database error: [Got error 12 from storage engine]
SHOW TABLES;

WordPress database error: [Table 'wp_terms' already exists]
CREATE TABLE wp_terms ( term_id bigint(20) NOT NULL auto_increment, name 
varchar(55) NOT NULL default '', slug varchar(200) NOT NULL default '', 
term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE 
KEY slug (slug) ) DEFAULT CHARACTER SET utf8

WordPress database error: [Table 'wp_term_taxonomy' already exists]
CREATE TABLE wp_term_taxonomy ( term_taxonomy_id bigint(20) NOT NULL 
auto_increment, term_id bigint(20) NOT NULL default 0, taxonomy 
varchar(32) NOT NULL default '', description longtext NOT NULL, parent 
bigint(20) NOT NULL default 0, count bigint(20) NOT NULL default 0, 
PRIMARY KEY (term_taxonomy_id), UNIQUE KEY term_id_taxonomy 
(term_id,taxonomy) ) DEFAULT CHARACTER SET utf8

WordPress database error: [Table 'wp_term_relationships' already exists]
CREATE TABLE wp_term_relationships ( object_id bigint(20) NOT NULL 
default 0, term_taxonomy_id bigint(20) NOT NULL default 0, PRIMARY KEY 
(object_id,term_taxonomy_id), KEY term_taxonomy_id (term_taxonomy_id) ) 
DEFAULT CHARACTER SET utf8

WordPress database error: [Table 'wp_comments' already exists]
CREATE TABLE wp_comments ( comment_ID bigint(20) unsigned NOT NULL 
auto_increment, comment_post_ID int(11) NOT NULL default '0', 
comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT 
(Continue reading)

]V[orlock Zernebock | 5 Feb 2008 23:18
Picon

Re: incorrect post counts

Maybe I'm too noob in PHP but I searched for "wp_count_posts" function
inside "wp-includes/post.php" and I didn't find it.

2008/2/5, Lloyd Budd <lloydomattic@...>:
>
> If you take a quick peak at wp-admin/index.php you will see that
> number is being generated using function wp_count_posts which is in
> wp-includes/post.php . From there you should be able to determine the
> query that is being run and why that doesn't include all your posts.
>
> Please share with us the result,
> Lloyd
> _______________________________________________
> wp-testers mailing list
> wp-testers@...
> http://lists.automattic.com/mailman/listinfo/wp-testers
>
Ryan Boren | 5 Feb 2008 23:52
Picon
Favicon
Gravatar

Re: latest svn revision, upgrade with errors..

On Tue, Feb 5, 2008 at 2:05 PM, spencerp <spencerp1@...> wrote:
> After doing a SVN UP on the VB blog, then hitting upgrade link.. I got
>  these errors...
>
>
>
>  WordPress database error: [Got error 12 from storage engine]
>  SHOW TABLES;

Error 12 means mysql couldn't allocate memory.  Since SHOW TABLES
returned nothing due to the error, install thinks your tables aren't
there and tries to create them.  This results in the already exists
errors.  Everything stems from the error 12.  MySQL doesn't have
enough memory.
Ryan Boren | 5 Feb 2008 23:56
Picon
Favicon
Gravatar

Re: incorrect post counts

On Tue, Feb 5, 2008 at 2:18 PM, ]V[orlock Zernebock
<morlockz@...> wrote:
> Maybe I'm too noob in PHP but I searched for "wp_count_posts" function
>  inside "wp-includes/post.php" and I didn't find it.

svn update to get it.  It's new.

function wp_count_posts( $type = 'post', $status = 'publish' ) {
	global $wpdb;

	return $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM
$wpdb->posts WHERE post_type = %s AND post_status = %s", $type,
$status) );
}

Gmane