We run multiple sites in a php 7.2.9, joomla 3.9 framework. About half of our websites upgraded to DT 4.0.5 no problem, but the other half are throwing a warning and an error.
"Warning: Incorrect table definition; there can be only one auto column and it must be defined as a key"
"Error: Error installing component"

I feel like i have exhausted my options to try and find what's causing this. Do you have any tips/hints/etc on how to identify and remedy the situation.

    smanders Hi

    Can you add your admin and ftp details in edit fields in order for us to take closer look.
    For reference, You can follow thread post (5 point) procedure.

    Also, Kindly confirm if you have taken backup of the site in which you are facing the relative error so that we can attempt to try and update at our end and troubleshoot if error persists as mentioned

        smanders
        Hi,

        I guess that you're mentioning DT Register component, right?

        I can't access your site now. May I know how did you update this component?

        Pls take a backup of your site > download latest version 4.0.5 and install it into your site. Or you can clone your live site to a staging / test site and update there first, check if everything goes fine, then apply to the live site. It'll be better.

            saguaros

            Yes, DT Register.

            I tried to run your update by extensions/manage/install. It throws a warning and an error on our live site. It doesn't actually install the new files, DT Register continues to take registrations/payments. Again, about half of our website updated fine, the other half won't.

              I too am having sites fail to upgrade from 4.0.4 to 4.0.5. Each time it seems that it is the dtregister_images table it hangs up on. Once I add this table manually to the database, things seem to install and work.

              Here's my sql script to create the table. You will need to change ixn1e to your db prefix:

              CREATE TABLE `ixn1e_dtregister_images` (
  `id` bigint(11) NOT NULL,
  `event_id` bigint(11) DEFAULT NULL,
  `path` text,
  `mime` varchar(255) DEFAULT NULL,
  `thumb` text,
  `title` varchar(255) DEFAULT NULL,
  `description` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


ALTER TABLE `ixn1e_dtregister_images`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `ixn1e_dtregister_images`
  MODIFY `id` bigint(11) NOT NULL AUTO_INCREMENT;
COMMIT;

              Thanks Paul! I did create my own table, based off of another site that update correctly, but it still will not complete the installation!

                smanders

                Could you check the credentials of your site again? as I can't access it now

                And take a backup of your site, I will try to install the new version for you.

                    saguaros I had no issues logging in with the provided username and password. The site is backed up and ready for your help 🙂

                      As an aside, none of our websites actually updated fully to this release, and the problem manifested itself by adding pricing to events that had no previous pricing, changing field selections between the registration page and the confirmation page, and possibly other problems. We reverted back to 4.0.4. on all the sites to preserve the functionality of the forms.

                        smanders
                        Do you have any staging / test site with 4.0.5 version? We will try to check it there first.

                            6 days later

                            saguaros

                            I updated the post information with the new test/staging site URL. Let me know if you need more from me!

                                5 days later

                                I am having this same issue with both 4.0.5 and I just tried 4.0.6 with the same result. I am trying to update with the JA Extensions Manager if that makes a difference. I will try adding the table as suggested above (thank you smanders for the layout info). Just tried it on my test site so far. I would like to hear if there are any other suggestions or solutions for this.

                                  cageman Hi

                                  If post-installation issue for DT Register still persists, Please start a new topic/discussion as this parent discussion has been started by another member

                                  Thanks for understanding as this would also avoid multiplicity and confusion making seamlessly easier for us to address your individual topic

                                  Thereon, You can kindly add details as per thread post (5 point) procedure in new forum post started enabling us to take closer look and assist thereon

                                    saguaros

                                    This uploaded to my site without errors, although no "New Gallery" function was noted. As this uploaded, seemingly fine, I tried to upload to 4.0.6 to see if that would include the gallery. It did not, and additionally, I needed to install the JA Payment plugin - which I cannot see an Authorize.net Accept hosted payment option. If there's no option, we're still at a place where this is not functional for us...

                                        5 days later
                                        Write a Reply...
                                        You need to Login to view replies.