Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Article Manager v1.0


RobAnderson

Recommended Posts

on its own, it works 100% - but running with categories dynamenu it doesnt.

 

well yes i did a mistake on the file called

 

for the possibility to use 2 Treemenu box in the same page i think in dynamenu support thread i rea taht already, it about a variables taht need to not be called 2 times maybe you could have a look

 

good feature would be to have in the same menu, the categories and then the topics, cool design features.

 

also , in dinamenu tree menu categories , someone manage to show products, taht mean we could also do that for articles !

tell me if you wanna try

Edited by azer

MS2

Link to comment
Share on other sites

i installed vesion 1.5

then the breadcrumb improvement lildog 14 Aug 2007

 

and i ca nsee a bug in the name of the news in the breadcrumb , it show the english title if existing , if not nothing

 

:'(

any solution ?

MS2

Link to comment
Share on other sites

i will hav to look 2nite when i get home - at work atm... my files are at home on my pc - but will try and get the two navigations to work together.

 

i though that maybe if you duplicated the dynamenu folder and let the articles run of the duplicated folder instead of the main one - dont know if that will solve the problem...

 

i'm also thinking that perhaps i should take out the instances where it calls for the contents of dynamenu folder - so it will only call it once in the categories menu and not again in the articles menu

 

// Include required libraries based on menu type
require_once 'includes/functions/dynamenu/lib/PHPLIB.php';
require_once 'includes/functions/dynamenu/lib/layersmenu-common.inc.php';

 

there's more of this one - just to point out what i mean...

 

i dunno about adding the articles into the categories navigation - for my site its not required, and i didnt add in the breadcrumb feature either....

Link to comment
Share on other sites

wihtout a modification it seem to work with both menu, what is on your website the trouble when you use both, exepcet that it losse the opened tree shape from the other menu when you click on any link from the second one

MS2

Link to comment
Share on other sites

Ok.. so I ended up putting something together quickly myself. Uploaded it to the contribs as well. In case someone was looking for the similar feature.

 

Enjoy,

G

 

Anyone has an infoblock which would list latest articles from predefined topics with a short description for each article?

 

Thnx,

George

Link to comment
Share on other sites

azer - i tried both the methods i suggested earlier - didnt work - and yes, when both are open at same time it looses its tree shape when you click on one of them. for my site its not a big thing - as i have two seperate sections for my products and articles - so i'm not too worried about it - but i would prefer to have something that works right and not halfway if you know what i mean :)

Link to comment
Share on other sites

Hello,

 

After 2 days of reading, searching, and changing I am unable to get past these errors. In articles.php, the articles show up but at the end I get the following error. I have seen this errors in other posts, but no real solutions that worked.

 

Fatal error: Call to undefined function clean_html_comments() in C:\AppServ\www\catalog\includes\modules\article_listing.php on line 66

 

In articles_new.php I get the following error.

 

Fatal error: Call to undefined function clean_html_comments() in C:\AppServ\www\catalog\includes\article_header_tags.php on line 138

 

I have STS with HTC installed and have read through both threads, tried making all the changes with no success. I have gone over the install intructions 4 times now to the letter.

Link to comment
Share on other sites

i installed vesion 1.5

then the breadcrumb improvement lildog 14 Aug 2007

 

and i ca nsee a bug in the name of the news in the breadcrumb , it show the english title if existing , if not nothing

 

:'(

any solution ?

 

In application_top.php, change this :

 

// add the articles name to the breadcrumb trail
 if (isset($HTTP_GET_VARS['articles_id'])) {
   $article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "'");
   if (tep_db_num_rows($article_query)) {
     $article = tep_db_fetch_array($article_query);
     if (isset($HTTP_GET_VARS['authors_id'])) {
       $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
     } else {
       $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
     }
   }
 }

 

By this :

 

// add the articles name to the breadcrumb trail
 if (isset($HTTP_GET_VARS['articles_id'])) {
   $article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "' and language_id = '" . (int)$languages_id . "'");
   if (tep_db_num_rows($article_query)) {
     $article = tep_db_fetch_array($article_query);
     if (isset($HTTP_GET_VARS['authors_id'])) {
       $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
     } else {
       $breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
     }
   }
 }

Link to comment
Share on other sites

Please post any bugs and suggestions about Article Manager v1.0 in this topic. I will do my best to provide support.

 

Thanks ;-)

 

Rob Anderson

 

Hi Rob, Everyone

 

I would be very grateful for suggestions - to stop me going totallt bananas...

 

I have installed on a test system and the contribution works fine

 

Install it on the production version and everything works with the sole exception that the articles wont show on the page

 

Topics will show, admin works fine, articles in admin yup, but in the shop nada!

 

The only difference between the two is on the production version

  • Mysql 4 instead of 5
  • The shop runs in the root (ie no catalog)

Any guidance suggestions welcomed

 

Thank you

 

nossum

Link to comment
Share on other sites

Hi,

I've looked back at posts, and may have missed the answer to this one, so my apologies if that's the case.

I've just installed V1.5, and get this error when clicking on 'all articles'

 

Current Articles

1054 - Unknown column 'OScatalogue.au.articles_id' in 'on clause'

 

select count(*) as total from ((articles a) left join authors au using(authors_id)) left join articles_description ad using(articles_id), articles_to_topics a2t left join topics_description td using(topics_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and ad.language_id = '1' and td.language_id = '1'

 

I've installed the mysql5 fixes, and tried a few other things, but I can't seem to change the outcome, otherwise, everything works fine.

 

Any pointers or advice gratefully received.

Link to comment
Share on other sites

trouble to display all articles in catalog/articles.php with the topic sort_order

 

here is the sql query, as i see the table topics is not called so i can not use at the end the sort_order by topic

 

 $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.sort_order, a.articles_date_added desc, ad.articles_name";

 

it would need at the end :

order by t.sort_order ,  a.sort_order, a.articles_date_added desc, ad.articles_name";

 

by the way i added manually on the articles table a sort_order field so i give a number with php my admin and manage to get the articles sort by sort_order

but I hope someone can include this field in the admin editing of any articles :-"

MS2

Link to comment
Share on other sites

Rob,

 

Should be fairly easy to make. Just add another column to the articles table, and increment the value each time the article is hit. You'll have to set some type of a cookie of course so the number is updated only once per session. Then use something like my "articles_lastN.php" contribution, but modify it to sort descending by hits, limit 10

 

Good idea. Probably a bit beyond my skills at the moment unless I can find a good contribution to copy from (which is all I really do anyway!). Know of any like this?

Also, where would you see this being displayed. As a module to plonk anywhere?

Link to comment
Share on other sites

Hi Rob, Everyone

 

I would be very grateful for suggestions - to stop me going totally bananas...

 

Nossum

 

Hi folks no progress - the contribution works faultlessly on the admin side. On the catalog side it sees that there are articles (it displays the numbers in the column) and the Topic Information displays just no articles in the main screen. I have reinstalled all files, checked data tables, checked chcp etc but nothing

 

Rob, anyone any ideas on how to start tracking this problem down would be appreciated

 

Thank you Nossum

Link to comment
Share on other sites

  • 2 weeks later...

I've been reading through this post but haven't found an answer to my question.

 

I recognize that this contrib is located in the left or right column.

 

However, can this be placed on my main page somewhere? I'm looking for an RSS that can be placed on my main page, and I love this article manager concept.

 

Thanks.

Link to comment
Share on other sites

I recognize that this contrib is located in the left or right column.

 

However, can this be placed on my main page somewhere? I'm looking for an RSS that can be placed on my main page, and I love this article manager concept.

 

Haven´t tried to put the article box in the main content, but it shouldn´t be too much trouble.

 

But I don´t understand what you are writing about "looking for an RSS that can be be placed on my main page". Article Manager isn´t rss enabled, or have I missed something?

Link to comment
Share on other sites

I have in my database table 'hotcooki_p_os2.articles'. but i am recieving this error.

1146 - Table 'hotcooki_p_os2.ARTICLES' doesn't exist

 

select distinct ax.articles_id, ad.articles_name, a.articles_last_modified from articles_xsell ax LEFT JOIN ARTICLES a USING(articles_id) LEFT JOIN articles_description ad USING(articles_id) where ax.xsell_id = '71' and ad.language_id = '1' and a.articles_status = '1' order by a.articles_last_modified.

 

please help

 

jpcalkins

Link to comment
Share on other sites

Please post any bugs and suggestions about Article Manager v1.0 in this topic. I will do my best to provide support.

 

Thanks ;-)

 

Rob Anderson

 

I guess this is where I'm supposed to ask this question...

 

My articles are appearing with the text centered and I want them to appear left aligned.

 

How can I fix that?

 

Does this work with HTC?

 

Thanks,

 

Sherry

Link to comment
Share on other sites

howdy,

 

i've just installed article manager 1.5sp1, with the updates available up to nov 07, and all works fine except the x-sell page in the admin section. when i navigate to xsell, this is what appears on the page:

 

ID Article Name Associated Products Cross-Sell Actions

if (!$add_related_article_ID) if ($_POST && !$sort) { if ($_POST[run_update]==true) { $query ="DELETE FROM " . TABLE_ARTICLES_XSELL . " WHERE articles_id = '".$_POST[add_related_article_ID]."'"; if (!tep_db_query($query)) exit(TEXT_NO_DELETE); } if ($_POST[xsell_id]) foreach ($_POST[xsell_id] as $temp) { $query = "INSERT INTO " . TABLE_ARTICLES_XSELL . " VALUES ('',$_POST[add_related_article_ID],$temp,1)"; if (!tep_db_query($query)) exit(TEXT_NO_INSERT); } ?>

The database has been updated.

 

Click here to sort the products associated with this article.

Note: this needs to be done every time a product is added or deleted.

 

Click here to go back to the main page.

 

 

the server is apache 2 with mysql5 and php5.

 

any clues?

 

regards,

 

stuart

A crash reduces your expensive computer to a simple stone.

Link to comment
Share on other sites

by the way anyone worked on a way to order the topics and articles as we can do in the categories and products ?

 

 

Just tried to merge boxed/articles.php with my boxes/categories.php that is modified by Great Categories v2.1 contribution to make both look and function the same. No errors but also no result. All topics are missed.

 

articles.jpg

 

Generated html code:

<!-- topics //-->
	  <tr>
		<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
<td height="14" class="infoBoxHeading"><img src="images/infobox/corner_left.gif" width="11" height="14" border="0" alt=""></td>
<td width="100%" height="14" class="infoBoxHeading">Articles</td>

<td height="14" class="infoBoxHeading" nowrap><img src="images/pixel_trans.gif" width="11" height="14" border="0" alt=""></td>
 </tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox">
 <tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="3" class="infoBoxContents">
 <tr>
<td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td>
 </tr>
 <tr>

<td align="left" class="boxText"><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><br><img src="images/pixel_ltgray.gif" border="0" alt="" width="100%" height="1"><br><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><table class="categ"><tr><td class="categ" nowrap><img src="images/categories/arrow_right.gif" width="9" height="9" border="0" alt=""> </td><td class="categ"><a href="http://...../..../articles.php?cPath="> </a></td></tr></table></td>
 </tr>
 <tr>
<td><img src="images/pixel_trans.gif" width="100%" height="1" border="0" alt=""></td>
 </tr>
</table>
</td>
 </tr>
</table>
		</td>

	  </tr>
<!-- topics_eof //-->

 

Any professional help here to check and improve the code?

 

 

modified boxed/articles.php

<?php
/*
 $id: Great Categories v2.1 2005/07/09 14:00:00  + articles.php, v1.0 2003/12/04 willross Exp $
 http://www.palaia.com/ujp/ - [email protected]
 *** For use with standard install of osCommerce 2.2MS2+

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2005 osCommerce

 Released under the GNU General Public License
*/

 function tep_show_topic($counter) {
global $tree, $topics_string, $cPath_array, $aa;

for ($a=0; $a<$tree[$counter]['level']; $a++) {
//	  $topics_string .= "  ";
}

//category start
  if ($tree[$counter]['level'] == 0)
	{
			if ($aa == 1)
			{
  $topics_string .= '<img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2"><br><img src="images/pixel_ltgray.gif" border="0" alt="" width="100%" height="1"><br><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="2">';
		}
			else
			{$aa=1;}

	}


// display category name
if (tep_has_topic_subtopics($counter) || $tree[$counter]['level'] == 0) {
	if ( ($cPath_array) && (@in_array($counter, $cPath_array)) ) {
	$topics_string .= '<table class="categ"><tr><td class="categ" nowrap>' . tep_image(DIR_WS_IMAGES . 'categories/arrow_down.gif', '', '9', '9') . " </td>";
	} else {
	$topics_string .= '<table class="categ"><tr><td class="categ" nowrap>' .tep_image(DIR_WS_IMAGES . 'categories/arrow_right.gif', '', '9', '9') . " </td>";
	}
} else {
$topics_string .= '<table class="categ"><tr><td class="categ" nowrap>  ' .tep_image(DIR_WS_IMAGES . 'categories/arrow_bullet.gif', 'nokta', '9', '9') . "</td>";
}


$topics_string .= '<td class="categ"><a href="';

if ($tree[$counter]['parent'] == 0) {
  $cPath_new = 'cPath=' . $counter;
} else {
  $cPath_new = 'cPath=' . $tree[$counter]['path'];
}

$topics_string .= tep_href_link(FILENAME_ARTICLES, $cPath_new);
$topics_string .= '">';

if ( ($cPath_array) && (@in_array($counter, $cPath_array)) ) {
  $topics_string .= '<b>';
}

//display topic name
$topics_string .= $tree[$counter]['name'];



if ( ($cPath_array) && (@in_array($counter, $cPath_array)) ) {
  $topics_string .= '</b>';
}

if (tep_has_topic_subtopics($counter)) {
  $topics_string .= ' ';
}

$topics_string .= '</a>';

if (SHOW_ARTICLE_COUNTS == 'true') {
  $articles_in_topic = tep_count_articles_in_topic($counter);
  if ($articles_in_topic > 0) {
	$topics_string .= ' (' . $articles_in_topic . ')';
  }
}

  // $topics_string .= '<br>';
  $topics_string .= '</td></tr></table>';

if ($tree[$counter]['next_id']) {
  tep_show_topic($tree[$counter]['next_id']);
}
 }
?>
<!-- topics //-->
	  <tr>
		<td>
<?php
 $info_box_contents = array();
 $info_box_contents[] = array('align' => 'left',
						   'text'  => BOX_HEADING_ARTICLES);

 new infoBoxHeading($info_box_contents, true, false);

 $topics_string = '';

 $topics_query = tep_db_query("select t.topics_id, td.topics_name, t.parent_id from " . TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.parent_id = '0' and t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' order by sort_order, td.topics_name");
 while ($topics = tep_db_fetch_array($topics_query))  {
$tree[$topics['topics_id']] = array('name' => $topics['topics_name'],
									'parent' => $topics['parent_id'],
									'level' => 0,
									'path' => $topics['topics_id'],
									'next_id' => false);

if (isset($parent_id)) {
  $tree[$parent_id]['next_id'] = $topics['topics_id'];
}

$parent_id = $topics['topics_id'];

if (!isset($first_element)) {
  $first_topic_element = $topics['topics_id'];
}
 }

 //------------------------
 if ($cPath) {
$cPath_array = split('_', $cPath);
reset($cPath_array);
while (list($key, $value) = each($cPath_array)) {
  $new_path .= $value;
  unset($parent_id);
  unset($first_id);
  $topics_query = tep_db_query("select t.topics_id, td.topics_name, t.parent_id from " . TABLE_TOPICS . " t, " . TABLE_TOPICS_DESCRIPTION . " td where t.parent_id = '" . (int)$value . "' and t.topics_id = td.topics_id and td.language_id = '" . (int)$languages_id . "' order by sort_order, td.topics_name");
  $topic_check = tep_db_num_rows($topics_query);
  while ($row = tep_db_fetch_array($topics_query)) {
	$tree[$row['topics_id']] = array(
										'name' => $row['topics_name'],
										'parent' => $row['parent_id'],
										'level' => $key+1,
										'path' => $new_path . '_' . $row['topics_id'],
										'next_id' => false
									   );

	if (isset($parent_id)) {
	  $tree[$parent_id]['next_id'] = $row['topics_id'];
	}

	$parent_id = $row['topics_id'];

	if (!isset($first_id)) {
	  $first_id = $row['topics_id'];
	}

	$last_id = $row['topics_id'];
  }
  if ($topic_check != 0) {
	$tree[$last_id]['next_id'] = $tree[$value]['next_id'];
	$tree[$value]['next_id'] = $first_id;
  }

		 $new_path .= '_';
}
 }

 tep_show_topic($first_topic_element);

 $info_box_contents = array();
 $new_articles_string = '';
 $all_articles_string = '';

 if (DISPLAY_NEW_ARTICLES=='true') {
if (SHOW_ARTICLE_COUNTS == 'true') {
//originale
//	  $articles_new_query = tep_db_query("select a.articles_id from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where ((a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY))");

	$articles_new_query = tep_db_query("SELECT a.articles_id from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_TOPICS_DESCRIPTION . " td, " . TABLE_AUTHORS . " au, " . TABLE_ARTICLES_DESCRIPTION . " ad where a.authors_id = au.authors_id and a2t.topics_id = td.topics_id and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY)");
  $articles_new_count = '';
}

if (strstr($_SERVER['PHP_SELF'],FILENAME_ARTICLES_NEW) or strstr($PHP_SELF,FILENAME_ARTICLES_NEW)) {
  $new_articles_string = '<b>';
}

$new_articles_string .= '<a href="' . tep_href_link(FILENAME_ARTICLES_NEW, '', 'NONSSL') . '">' . BOX_NEW_ARTICLES . '</a>';

if (strstr($_SERVER['PHP_SELF'],FILENAME_ARTICLES_NEW) or strstr($PHP_SELF,FILENAME_ARTICLES_NEW)) {
  $new_articles_string .= '</b>';
}

$new_articles_string .= $articles_new_count . '<br>';

 }

 if (DISPLAY_ALL_ARTICLES=='true') {
if (SHOW_ARTICLE_COUNTS == 'true') {
//	  $articles_all_query = tep_db_query("select a.articles_id from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where ((a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "')");
	$articles_new_query = tep_db_query("SELECT a.articles_id from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_TOPICS_DESCRIPTION . " td, " . TABLE_AUTHORS . " au, " . TABLE_ARTICLES_DESCRIPTION . " ad where a.authors_id = au.authors_id and a2t.topics_id = td.topics_id and (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "'");
} else {
  $articles_all_count = '';
}

if ($topic_depth == 'top') {
  $all_articles_string = '<b>';
}

$all_articles_string .= '<a href="' . tep_href_link(FILENAME_ARTICLES, '', 'NONSSL') . '">' . BOX_ALL_ARTICLES . '</a>';

if ($topic_depth == 'top') {
  $all_articles_string .= '</b>';
}

$all_articles_string .= $articles_all_count . '<br>';

 }
 $info_box_contents[] = array('align' => 'left',
						   'text'  => $new_articles_string . $all_articles_string . $topics_string);

 new infoBox($info_box_contents);
?>
		</td>
	  </tr>
<!-- topics_eof //-->

Edited by leveera
Link to comment
Share on other sites

Hi Rob,

 

I have uploaded the 2 php 5 files, and it all works great except for getting the following error when viewing all articles:

 

All Articles
Current Articles
1054 - Unknown column 'overallb_pos1.au.articles_id' in 'on clause'

select count(*) as total from ((articles a) left join authors au using(authors_id)) left join articles_description ad using(articles_id), articles_to_topics a2t left join topics_description td using(topics_id) where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and ad.language_id = '1' and td.language_id = '1'

[TEP STOP]

 

Anything I can do to get rid of this?

 

Thanks,

 

Griz

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...