Installation error Issue

2CEVENTS
2CEVENTS
Offline
0
Hello, i can't install your component;... an error appears :
JInstaller: :Install: erreur SQL Unknown column 'timeSpent' in 'CHECK'
Extension Installer : Erreur SQL de traitement de la requête : Fonction DB échouée avec le numéro d'erreur 1054
Unknown column 'timeSpent' in 'CHECK'
SQL =
CREATE TABLE IF NOT EXISTS `#__papershape_projects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text,
`date_start` DATE DEFAULT NULL,
`date_limit` DATE DEFAULT NULL,
`time_spent` bigint(15) NOT NULL default 0 CHECK (`timeSpent` > 0),
`completed` boolean NOT NULL default false,
`color` varchar(255),
`price` decimal(12,4) NOT NULL default 0,
`user_id` int(11) NOT NULL,
`default_task_category_id` INT(11) NOT NULL DEFAULT 0,
`contact_id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Thanks for help
Responses (11)
  • Accepted Answer

    Thursday, April 11 2019, 03:36 PM - #Permalink
    0
    hello

    could you send me admin access so I can try to see what's wrong?
    The reply is currently minimized Show
  • Accepted Answer

    2CEVENTS
    2CEVENTS
    Offline
    Thursday, April 11 2019, 03:42 PM - #Permalink
    0
    Wow great !

    Here are the infos :
    http://photoclubdurhin.fr/administrator/index.php?option=com_installer&view=update
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, April 11 2019, 03:53 PM - #Permalink
    0
    hello

    I solved the problem and installed PaperShape in your website.

    please check now.
    The reply is currently minimized Show
  • Accepted Answer

    2CEVENTS
    2CEVENTS
    Offline
    Thursday, April 11 2019, 03:55 PM - #Permalink
    0
    Perfect !! what was wrong ?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, April 11 2019, 03:56 PM - #Permalink
    0
    a small line in the installation file that could cause problems in some MySQL versions. I changed that and already uploaded the upgraded installation package to avoid this error in the future.
    The reply is currently minimized Show
  • Accepted Answer

    2CEVENTS
    2CEVENTS
    Offline
    Thursday, April 11 2019, 03:57 PM - #Permalink
    0
    Ok , do you have french and german translation for the component ? Thanks
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, April 11 2019, 04:00 PM - #Permalink
    0
    no, sorry, not at the moment
    you can create your own translations just by translating one file:
    /language/en-GB/en-GB.com_papershape.ini

    just duplicate it and place it in the FR or DE language folders, and translate its contents.
    The reply is currently minimized Show
  • Accepted Answer

    2CEVENTS
    2CEVENTS
    Offline
    Thursday, April 11 2019, 04:02 PM - #Permalink
    0
    Oh ok... Thanks for your help and have a nice day !
    The reply is currently minimized Show
  • Accepted Answer

    Winter
    Winter
    Offline
    Saturday, May 04 2019, 03:15 PM - #Permalink
    0
    I am having literally this exact same problem how can we address this issue. I am referring to the installation error not the translation to French.
    • Germinal Camps
      more than a month ago
      well, this is odd. We corrected this error and we uploaded the fixed version. I just downloaded it just to make sure, and the error is corrected.. so I can't figure out why you're getting the error.
      Did you download the installable package from your "my downloads" area?
    The reply is currently minimized Show
  • Accepted Answer

    Winter
    Winter
    Offline
    Saturday, May 04 2019, 08:09 PM - #Permalink
    0
    yes, I downloaded it directly from the download area on your site.

    I have another thread that is running it is here

    https://www.joomlathat.com/support/papershape/installation-error#reply-40812

    please respond on that thread as that is one i actually started and has my screenshots.

    but that withstanding how do we move forward.
    The reply is currently minimized Show
  • Accepted Answer

    Winter
    Winter
    Offline
    Sunday, May 05 2019, 06:24 AM - #Permalink
    0
    So are there any updates? any questions you may have for me to inquire about this I would really appreciate something, please


    -Thank you
    The reply is currently minimized Show
Your Reply