Categories
Add a reply View Replies (43)

Resolved Errors installing RO Single Signon

  1. Anonymous User(Eddie Konczal)
  2. Pre-sale questions
  3. Thursday, 30 July 2020
  4.  Subscribe via email
When I attempt to install RO Single Sign On version 1.2.0, I get these errors:



Warning

JInstaller: :Install: Error SQL Invalid default value for '_expire'

Extension Install: SQL error processing query: DB function failed with error number 1067

Invalid default value for '_expire'

SQL =



CREATE TABLE IF NOT EXISTS `#__saml_LogoutStore`

(

    `_authSource`   varchar(191) NOT NULL,

    `_nameId`       varchar(40)  NOT NULL,

    `_sessionIndex` varchar(50)  NOT NULL,

    `_expire`       DATETIME    NOT NULL DEFAULT CURRENT_TIMESTAMP

        ON UPDATE CURRENT_TIMESTAMP,

    `_sessionId`    varchar(50)  NOT NULL,

    UNIQUE KEY `_authSource` (`_authSource`(191), `_nameId`, `_sessionIndex`),

    KEY `#__saml_LogoutStore_expire` (`_expire`),

    KEY `#__saml_LogoutStore_nameId` (`_authSource`(191), `_nameId`)

)

    ENGINE = InnoDB

    DEFAULT CHARSET = utf8;



Package Install: There was an error installing an extension: com_ro_sso_1.2.0.zip


Here is the system configuration:

PHP Built On Linux 4.12.14-197.45-default #1 SMP Thu Jun 4 11:06:04 UTC 2020 (2b6c749) x86_64
Database Type mysql
Database Version 5.5.39
Database Collation utf8_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 7.2.5
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.10.0-alpha1 Alpha [ Amani ] 23-July-2020 21:10 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Regards,
Eddie
0
Responses (43)
Laura Gordon
Laura Gordon
Accepted Answer Pending Moderation
Yes, Roland, is there a way we can get support on the installation so we can test this out?

thank you!!!


-- Laura & team (Eddie Konczal, Michelle Martel, Stephen Kujan)
  1. more than a month ago
  2. Pre-sale questions
  3. # 41
Edward Konczal
Edward Konczal
Accepted Answer Pending Moderation
Hi, Roland,



I work with Laura Gordon at Rutgers University. We are testing this extension to see if it will work with Rutgers’ central authentication server. I’m copying
Laura on my reply.



Regards,

Eddie





From: RolandD Cyber Produksi <support@rolandd.com>


Sent: Thursday, July 30, 2020 4:36 PM

To: Edward Konczal <konczal@sas.rutgers.edu>

Subject: [#63545]: Errors installing RO Single Signon (Reply)
  1. more than a month ago
  2. Pre-sale questions
  3. # 42
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eddie,

This is not a support section but a pre-sales section for asking questions about our products. Support is only given if you have an active membership and I don't see an active RO Single Sign On subscription in your name.

Since you don't have an active subscription I wonder how you came by our software. It is open source so no problem there but we cannot support non-members.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 43
  • Page :
  • 1
  • 2
  • 3


There are no replies made for this post yet.
Be one of the first to reply to this post!
Edward Konczal
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,jpeg,zip,rar,pdf,csv,txt,tsv,xml,docx,doc,xls,xlsx,ods,tgz
• Insert • Remove Upload Files (Maximum File Size: 4 MB)
Cite your Sources with a URL link to help readers verify facts or find more details.
Add Another Link
In this section you can provide your site details at here and it visible to the moderators only.