Needs an update

[Guest]

Hello Jack,

 

Just a quick thanks for all your contributions.

 

This one seem to be outdated I think.. I get this error on a few pages in admin

 

Click on links in admin

 

Warning: Division by zero in /home/pricelessweddings/admin/includes/classes/split_page_results.php on line 33
1064 - 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 '-0, MAX_LINKS_DISPLAY' at line 1

select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from links l left join links_description ld on l.links_id = ld.links_id where ld.links_title like '%%' or l.links_url like '%%' order by ld.links_title limit -0, MAX_LINKS_DISPLAY

 

submit owner information

 

1064 - 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 's Wholesale Priced Online Wedding Store. Buy Bonbonnieres, Favors At Wholesale' at line 1

update links_exchange set links_exchange_name = 'Priceless Weddings', links_exchange_description = 'Australia's Wholesale Priced Online Wedding Store. Buy Bonbonnieres, Favors At Wholesale Prices', links_exchange_url = 'http://www.pricelessweddings.com.au' where language_id = '1'

 

links status in admin

 

Warning: Division by zero in /home/pricelessweddings/admin/includes/classes/split_page_results.php on line 33
1064 - 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 '-0, MAX_LINKS_DISPLAY' at line 1

SELECT l.links_id, l.links_reciprocal_url, l.links_status, ld.links_title, lc.date_last_checked, lc.link_found, ls.links_status_name from links l LEFT JOIN links_description ld on l.links_id = ld.links_id left join links_check lc on l.links_id = lc.links_id left join links_status ls on l.links_status = ls.links_status_id and ls.language_id = '1' order by l.links_id DESC limit -0, MAX_LINKS_DISPLAY