avatar ciar4n
ciar4n
8 Feb 2017

Steps to reproduce the issue

Getting a table doesn't exist error when installing 3.0 Beta2 on a fresh Joomla! installation..

1146 Table 'joomla-cms.#__patchtester_pulls' doesn't exist

avatar ciar4n ciar4n - open - 8 Feb 2017
avatar mbabker
mbabker - comment - 11 Feb 2017

It gets reported on occasion but it's not something I've ever been able to duplicate.

FWIW I installed the package fresh on 4.0 right after tagging it and had no issue.

avatar brianteeman
brianteeman - comment - 16 May 2017

I can replicate it on all versions.

It only really happens in dev environments where you are reinstalling joomla

  1. Install patchtester and make sure it is all working
  2. Delete configuration.php and reinstall joomla
  3. Install pathctester again from the zip
  4. Now go to patchtester and you have the error
  5. uninstall patchtester and reinstall and its all good

So it is something to do with installing patchtester onto a filesystem that already has the files preventing the database creation step from completing

avatar mbabker
mbabker - comment - 16 May 2017

That sounds like an issue in the core component install adapter then, I'm not doing anything here to alter the install routine in a way to break that.

avatar brianteeman
brianteeman - comment - 16 May 2017

possibly but i havent seen it anywhere else

avatar mbabker mbabker - reference | e9c99d9 - 18 Jun 17
avatar mbabker
mbabker - comment - 18 Jun 2017

It is a core issue, but it can possibly be worked around. At least with the component adapter, if it detects that an extension already exists in the filesystem, it internally switches to the update path instead of install. The update path does not trigger the new install SQL file instructions but runs through all the updates instead. So this should parse through all of the SQL update files since it starts with a 0.0.0 dummy version if a schema record isn't found (which with that set of instructions, would be the case). I think by putting the right schema data into the base 2.0 schema version (done in e9c99d9) it should be able to create the tables in that scenario.

avatar kofaysi
kofaysi - comment - 17 Mar 2019

Experienced a similar issue, when restoring Joomla using Akeeba Kickstar. The following two errors:
image
image
Dropping the two #_patchtester SQL tables and deleting the line with "patchtester"
in #_extensions table did not help.

Uninstalling the plugin helped. (I did not expect it to be installed at all.)

avatar richard67
richard67 - comment - 19 May 2019

@kofaysi Could you test if PR #221 solves the problem you mentioned in your comment above?

avatar roland-d
roland-d - comment - 21 Mar 2020

@ciar4n Going to close this as Michael and Richard have made some changes to handle this. Feel free to reopen if the issue still happens.

avatar roland-d roland-d - change - 21 Mar 2020
Status New Closed
Closed_Date 0000-00-00 00:00:00 2020-03-21 09:36:13
Closed_By roland-d
avatar roland-d roland-d - close - 21 Mar 2020

Add a Comment

Login with GitHub to post a comment