• Resolved Eric Taylor

    (@erictaylor)


    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.