Having a MySQL error. Please help

  • Resolved Eric Taylor

    (@erictaylor)


    17 years, 3 months ago

    Hi on my page eric-taylor.com I’m getting this error.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘GROUP BY year(post_date), month(post_date), dayofmonth(post_date)’ at line 1]
    SELECT DISTINCT post_date FROM GROUP BY year(post_date), month(post_date), dayofmonth(post_date)

    I have had it for along time, and seeing as how I haven’t had time to resolve the issue, I need some help and was wondering if anyone could point me in the right direction to fix this.

    Thanks

Viewing 1 replies (of 1 total)
  • Thread Starter Eric Taylor

    (@erictaylor)

    The problem is with the rolling arch. function, here is the php file that is being called.

    <?php
	$prefix = '';

	// Get Core WP Functions If Needed
	if (isset($_GET['rolling'])) {
		require (dirname(__FILE__)."/../../../wp-blog-header.php");
		$prefix = 'nested_';
	}
?>
<?php
	// Load Rolling Archives?
	if ( (get_option('k2rollingarchives') == 1) ) {
		$k2pagecount = k2countpages($wp_query->request);

		if ($k2pagecount > 1) {
?>
	<div id="<?php echo $prefix; ?>rollingarchives">
		<div id="<?php echo $prefix; ?>rollnavigation">
			<a href="#" id="<?php echo $prefix; ?>rollprevious"><span>&laquo;</span> <?php _e('Older','k2_domain'); ?></a>
			<a href="#" id="<?php echo $prefix; ?>rollhome"><img src="<?php bloginfo('template_directory'); ?>/images/house.png" alt="Home" /></a>

			<div id="<?php echo $prefix; ?>pagetrack"><div id="<?php echo $prefix; ?>pagetrackend"><div id="<?php echo $prefix; ?>pagehandle"></div></div></div>

			<span id="<?php echo $prefix; ?>rollload"><?php _e('Loading','k2_domain'); ?></span>
			<span id="<?php echo $prefix; ?>rollpages"></span>

			<a href="#" id="<?php echo $prefix; ?>rollnext"><?php _e('Newer','k2_domain'); ?> <span>&raquo;</span></a>
		</div>

		<div id="<?php echo $prefix; ?>rollnotices"></div>
	</div>
	<script type="text/javascript">
	// <![CDATA[
		var <?php echo $prefix; ?>rolling = new RollingArchives('<?php echo $prefix; ?>primarycontent', <?php k2info('js_url'); ?> + '/theloop.php', '<?php echo $wp_query->query; ?>', <?php echo $k2pagecount; ?>, '<?php echo $prefix; ?>');
	// ]]>
	</script>

<?php } } ?>
<div id="<?php echo $prefix; ?>primarycontent" class="hfeed">
	<?php include (TEMPLATEPATH . '/theloop.php'); ?>
</div><!-- #<?php echo $prefix; ?>primarycontent .hfeed -->
Viewing 1 replies (of 1 total)
  • The topic ‘Having a MySQL error. Please help’ is closed to new replies.