Joomla Banner links stopped working

Posted on 2011-05-12
Last Modified: 2012-05-11
 My joomla banners suddenly stopped working, the display a white page when clicked. If i go into joomla backend and attempt to enable or disabe a particular link i get the message 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 '1305249949)' at line 2 SQL=INSERT INTO jos_ualog VALUES( NULL,'62','com_banners','unpublish','index.php?option=com_banners&task=edit&cid[]=19','{user} unpublished a banner: {link}',,1305249949)

This was an out of the box joomla install which worked fine until now. I did update to ver 1,5,23 but it didnt fix the issue. Any ideas. These are text links. Can be seen at on the left side of the front page.
Question by:bochaka
    LVL 7

    Expert Comment

    Need to look into the code
    LVL 2

    Author Comment

    And ?
    LVL 3

    Expert Comment

    i have just tried 3 of your banners and they are working?
    LVL 2

    Accepted Solution

    Yes, I just sollved it last night.
    LVL 2

    Author Closing Comment

    Solved it myself.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now