Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (4)

Error when updating to 3.1.1 from 3.1.0 Issue

General
Thursday, April 12 2018, 07:20 PM
Charles Steiner
Charles Steiner
Offline
0
Please advise

-----
Database Type mysql
Database Version 5.5.57
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.0.29
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.8.6 Stable [ Amani ] 13-March-2018 14:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
----

Warning
JInstaller: :Install: Error SQL Duplicate column name 'city'
Extension Update: SQL error processing query: DB function failed with error number 1060
Duplicate column name 'city'
SQL =

ALTER TABLE `#__invoices_contacts` ADD `city` varchar(255) NOT NULL,
ADD `state` varchar(255) NOT NULL,
ADD `country` varchar(255) NOT NULL,
ADD `vatid` varchar(255) NOT NULL,
ADD `zipcode` varchar(255) NOT NULL ;
Responses (4)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Friday, April 13 2018, 10:34 AM - #Permalink
    0
    that's weird..it is like it's trying to upgrade the DB when it's already updated. you didn't have any problems before?
    The reply is currently minimized Show

  • Accepted Answer

    Charles Steiner
    Charles Steiner
    Offline
    Friday, April 13 2018, 02:09 PM - #Permalink
    0
    It's a recent install, this is the first attempt at an update.

    I am using a JMS multisites https://www.jms2win.com/ but this problem appears on the master

    I'm thinking about uninstalling, reinstalling 3.1.0 and then attempting the update again.
    The reply is currently minimized Show

  • Accepted Answer

    Charles Steiner
    Charles Steiner
    Offline
    Friday, April 13 2018, 02:44 PM - #Permalink
    0
    after uninstalling and attempting to reinstall I get this error

    Warning
    JInstaller: :Install: Error SQL Duplicate entry '1' for key 'PRIMARY'
    Extension Install: SQL error processing query: DB function failed with error number 1062
    Duplicate entry '1' for key 'PRIMARY'
    SQL =
    The reply is currently minimized Show

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Friday, April 13 2018, 02:50 PM - #Permalink
    0
    well, it's basically the same error, it is trying to re-create some DB tables that are already there.

    if you have access to the DB, maybe the best way will be to delete this table for example (currencies table) and try to reinstall

    if you need help, I can help you but today I'm out of the office already, so it would have to be on Monday...
    The reply is currently minimized Show
Your Reply