Installation Bug

nicolatag
nicolatag
Offline
0
I've installed component, but when I try to install the plugin_contentstats, it returns this error:
JDatabaseMySQL::query: 1060 - Duplicate column name 'location_id' SQL=ALTER TABLE `yrec_content_statistics` ADD `location_id` INT( 11 ) NOT NULL , ADD `country` VARCHAR( 15 ) NOT NULL , ADD `state` VARCHAR( 255 ) NOT NULL , ADD `city` VARCHAR( 255 ) NOT NULL , ADD INDEX ( `location_id` ) , ADD INDEX ( `country` )
Responses (6)
  • Accepted Answer

    Thursday, October 03 2013, 09:47 AM - #Permalink
    0
    was Content Statistics already installed in the system before?
    The reply is currently minimized Show
  • Accepted Answer

    nicolatag
    nicolatag
    Offline
    Thursday, October 03 2013, 09:47 AM - #Permalink
    0
    no.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, October 03 2013, 09:54 AM - #Permalink
    0
    this is very strange.. do you have access to your DB? can you see if the table #__content_statistics is created correctly?

    I could help you solve this but I would need FTP access to the site.. you can email it to me at support@ joomlathat.com
    The reply is currently minimized Show
  • Accepted Answer

    nicolatag
    nicolatag
    Offline
    Thursday, October 03 2013, 10:15 AM - #Permalink
    0
    Email sent from my assistant.
    The reply is currently minimized Show
  • Accepted Answer

    nicolatag
    nicolatag
    Offline
    Thursday, October 03 2013, 12:08 PM - #Permalink
    0
    Please let me know if you can fix the bug. Thx.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, October 06 2015, 11:57 AM - #Permalink
    0
    Hi, I installed component Content Statistics fine. But when I tried to install the plugin I received the same error:
    Duplicate column name 'location_id' SQL=ALTER TABLE `slg9r_content_statistics` ADD `location_id` INT( 11 ) NOT NULL , ADD `country` VARCHAR( 15 ) NOT NULL , ADD `state` VARCHAR( 255 ) NOT NULL , ADD `city` VARCHAR( 255 ) NOT NULL , ADD INDEX ( `location_id` ) , ADD INDEX ( `country` )
    my web site is www.poviedkovo.sk

    Could you please help? I can provide you access to admin if you need. Just PM
    Thank you very much
    Alexander
    • Germinal Camps
      more than a month ago
      sure, please send me access at support@ joomlathat.com
    The reply is currently minimized Show
Your Reply