oakhill Posted September 10, 2004 Share Posted September 10, 2004 Hi Just installed the latest version of Article manager and although the admin seems to work fine, this is what I get when I click on a link on the site (I have disabled it at the moment until I can get it working...) Warning: Division by zero in /home/httpd/vhosts/oakhillnailspa.com.au/httpdocs/catalog/includes/classes/split_page_results.php on line 59 1064 - You have an error in your SQL syntax near 'MAX_ARTICLES_PER_PAGE' at line 1 select a.articles_id, a.authors_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_name, td.topics_name, a2t.topics_id from articles a, articles_description ad left join authors au on a.authors_id = au.authors_id, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '1' and td.language_id = '1' and a2t.topics_id = '1' order by a.articles_date_added desc, ad.articles_name limit -0, MAX_ARTICLES_PER_PAGE Has anyone else had this problem...the contibution seems perfect for what I need so it would be great if I can get this issue solved. I am not very good at SQL so not quite sure where I should look to fix! Knowing me, its probably something I have done!! Thanks! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.