Link Analysis Tool now works V1.2

  • 0
  • April 3, 2008

OK, the previous versions of the link analysis tool were pretty buggy and in a lot of cases didn’t work.

The latest version now has all the features working and is bug free (I hope). I’ve spent a lot of time deleting and reinstalling and it works perfectly.

Download the new version here.

To install:

  • Unzip
  • Edit the config file to include your database details and API key
  • Upload to a folder on your site
  • Go to the location you uploaded it to
  • Click the link to set up your database
Patrick Altoft

About Patrick Altoft

Patrick is the Director of Strategy at Branded3 and has spent the last 11 years working on the SEO strategies of some of the UK's largest brands. Patrick’s SEO knowledge and experience is highly regarded by many, and he’s regularly invited to speak at the world’s biggest search conferences and events.

  • Jonathan Ginsberg

    v. 1.1 was working. I upgraded to 1.2 and now I am getting an error “Column count doesn’t match value count at row 1”
    Should I delete the database and start over?

    • Patrick Altoft

      Yes, V1.1 didn’t set up the tables correctly so you need to delete the tables.

      • Jonathan Ginsberg

        I deleted the database and recreated it. Everything works fine. Thanks!

  • Tim Dineen

    Hi Patrick,

    Thanks for the tool – a great idea!

    I’m having issues using this latest release. Can you tell me if a specific version of MySQL is required?

  • Pingback: Open Source Link Analysis Tool « Internet Marketing Blog by NoonanNight()

  • Chris


    First off thank you! This is a powerful tool and I’m very excited to see how it will evolve as an open source offering.

    Everything is working fine for me except the “view link data for this url” link (magnifying class icon)a.k.a When I click on any of those links I get an empty table.

    I wish I was a programmer because I’d love to be able to build off of this tool.

    A couple ideas.

    1. Ability to provide a url to clients with all their data without giving them access to other client data if they go back to the root domain.

    2. The Ability to export to csv with rankings on all three engines included.

  • M4d3L

    hi. I have a big website with sitemap index and over 30 000 page. after running this tool, only 230 url was added to the database. What I did wrong?

  • Henry Lönnborg

    Hi Patrick

    I have installed the new version, deleted the database tables and installed the tables again with setup.php but still I get the error “Out of range value adjusted for column ‘id’ at row 1” when I try to submit a domain.

    What’s wrong?

    • Patrick Altoft

      Not sure really – perhaps an issue with how your database is set up?

  • Henry Lönnborg

    I have MySQL ver 5.0 and it works fine for other applications.
    I have reinstalled the application and build the database several times but still I get the error.
    How can I dtermine the version of the script?

    I’m not a php programmer but the error comes from the INSERT statemant in addsite.php

    if (mysql_query(“INSERT INTO linkanalysis_domains VALUES(”,’$domain’,’$pr’)”) or die(mysql_error())){

  • Alan


    I have the linkanalysis set up but whenever I add a domain name I get the message: “Cannot connect to Yahoo, you might have used more than 5000 queries today?” which of course I have not, any ideas?


Like what you see? Talk to an Expert