tcal

yep, I know the code for the date thanks.

But I still can’t get this ‘X posts so far today’ to work.

It should be just a case of running a SQL query where it shows all published posts from wp_posts where the date = the day passed in from the loop.

I’ve searched for a plugin but can’t find any.

Any help appreciated!

SELECT COUNT(*) FROM wp_posts where post_date = CURRENT_DATE()

if i can get that query to work i can do it. But my MySQL is very week, trying to work out how i can get the post_date or post_date_gmt to equal a MYSQL variable for todays date.

Any help appreciated!

same result. can’t get the upload feature to insert the original, and the various options don’t seem to help.

Success! I used phpmyadmin to search the entire database for anything with 0000-00-00 00:00:00 in it. And indeed, one item in wp-posts had a date: 0000-00-00 00:00:00 1969-12-31 23:59:59

Deleted that, and the 0 is gone. Thanks a million to everyone who helped, I know this was a small thing but it was bugging the hell out of me and now it’s fixed. ??

I have looked through the dates as above, but i have 1000+ posts in my db so it’s pretty hard to spot the problem ones.

Even just from January (pretty sure thats when the problem appeared, jan 2005) I have about 200 or so posts to look at and just cant find anything obviously wrong like a 1969 date. I also never ported over posts from another cms or anything like that.

Any chance you can rack your brains Jerry and think about what it might have been that fixed it?

I know it’s a small thing, but I’m on the verge of a relaunch for the site with a brand new layout and all sorts of features etc. and I’d like to get this little niggle out of the way if at all possible.

Currently active plugins:

Brians Latest comments
https://meidell/latestcomments/

Spam Stopgap Extreme
https://elliottback.com/wp/archives/2004/11/29/spam-stopgap-extreme/

StatTraq
https://www.randypeterman.com/StatTraq/

Just some random thoughts too:
I sometimes edit timestamp posts – is it possible i entered some bizarre date incorrectly and wordpress let it go into the db.

I’m quite comfortable using phpmyAdmin to run sql queries, but i just have no idea what i’m looking to find.

https://pastebin.ca/4499

I had a look myself, but i’m not up to the standard where I’d be confident that there’s nothing wrong with it so i’ve pasted the entire thing like you asked. [expires in 1 week.]

thanks for the help, anyone else got any suggestions, keep em coming!

Thanks for the replies. Here’s the code I have in index.php:
<ul>
<li id="archives"><?php _e(''); ?>
<ul>
<?php wp_get_archives('type=monthly'); ?>
</ul>

</li>

</ul>

I don’t see anything wrong with that?
I have phpadmin on hand here, if anyone has _any_ ideas I’d really appreciate it – it’s doing my head in.