__fabrik_joins' doesn't exist

[gluzapp]

Hello ,
I'm installing fabrik 3.9 ( zip file ) on Joomla 3.75 .

The problem I encountred was :
Table 'my_xxxxxx.#__fabrik_joins' doesn't exist

and the installation was stopped .

what can I do to proceed installation ?

thank you

 

[troester]

I just tested and can't replicate.
Try to download Fabrik again (in case your zip is corrupted) or install from web.
Make sure you don't hit php limits (memory, runtime...)-

 

[gluzapp]

Thank you for your answer.
The file zip is not corrupted .

Installing from web give error : "connection error server: 403 "
so seems the only way to install is to get the zip file .

 

[troester]

Both (installing the zip and installing from web) is working fine on my site.

What is Joomla3.75?
Recent Joomla is 3.9.15

 

[gluzapp]

Also trying installation from web I have the same error :


JInstaller: :Install: Errore SQL Table 'my_labdempart.#__fabrik_joins' doesn't exist
Estensione Aggiorna: richiesta di elaborazione degli errori di SQL: DB function fallita con errore numero 1146
Table 'my_labdempart.#__fabrik_joins' doesn't exist
SQL =
ALTER TABLE `#__fabrik_joins` CHANGE `table_id` `list_id` INT( 6 ) NOT NULL;
Pacchetto Installazione: si è verificato un errore nell'installazione di un'estensione: com_fabrik_3.9.zip

 

[troester]

Ok, so you are working with an old updated/upgraded installation where at some point Fabrik2 or Fabrik3.0 was installed?
Because it's trying to run some old sql file for updating DB structure.

You should really mention that you are trying close a big, big version gap.
Fabrik2.5 to Fabrik3.0 was a migration, no update. Same with Fabrik3.0 to Fabrik3.5, Joomla and Fabrik installer/updater have changed meanwhile.

Do you have still a Fabrik installation or did you uninstall Fabrik and there are some leftovers?

 

[lousyfool]

So, what is Joomla 3.75?
Four weeks ago you were already posting about installing a current Fabrik on an old Joomla and, if you're referring here to J! 3.7.5 or so, the answers are still the same.
Like @troester, I've also just installed the most recent Fabrik 3.9 on J! 3.9.15, and there were no issues at all during installation.

Edit: ooops, just seeing that @troester has replied as well...

 

[gluzapp]

Thanks Troaster and Lousyfool,

My problem is the previous Fabrik resident installation.
Do I have to physically uninstall the Fabrik's plugins, ( not only disable ) ?

 

[troester]

See your other thread.
You never said which was the exact last Fabrik version you were running on which Joomla version so nobody knows if your database structure has to be changed or not. This is essential.
You can't expect to skip about 4 years with just "updating". There have been migration tools and scripts but also these were related to the Fabrik and Joomla versions at their time.

Edit: I can suggest you what to try so that these old DB-change scripts are not run automatically - but this only makes sense if you give the necessary informations about your old versions.

 

[gluzapp]

What's is the best way to uninstall fabrik and reinstall it ?
I have a Joomla's version 3.9 site .
I've disabled the all the fabrik plugins (132 items ) ,
then inn the Extension menu I have Unistall all the Fabrik modules .

Do you think now I can reinstall last Fabrik version in "Install from Web " ?

thank you
best regards

 

[lousyfool]

1. In Extensions -> Manage -> Manage, search for, select and uninstall anything "fabrik".
2. In phpMyAdmin, drop (= delete) all remaining #_fabrik_*** tables.
3. Download and install Fabrik 3.9 from https://fabrikar.com/downloads
4. Eventually perform a full Github update: http://fabrikar.com/forums/index.php?wiki/update-from-github

 

[troester]

Keep in mind that this will remove all you Fabrik work.
You never told us which Fabrik version you were running before!! This is essential, in updated installations from very old Fabrik and Joomla versions there may be other left-overs in Joomla tables which will stop an installation.