Phoca Forum

I attempted to update phocagallery before the migration, but go errors.

I then migrated joomla. Then noticed this error....
1146 - Table 'pawpaw5_jo151.#__phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM #__phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

I then did some reading and found that this is an issue and there seems to be a pre-migration thing I was supposed to do. Oops...

Well, I'm luck in that I don't have that many files, pictures etc... I did make a full back up before the migration.

Question. Since I messed it up, I can't follow most of the help that is being offered.

Can I uninstall Phocagallery 4.3.1 and phocadownload 3.1.2. Then install them and start over, making new menus, categories, uploading the imgages, data and files.

Do I need to do anything else? I can recreate what I did in a few days.

Dennis

Hi,
use this migration guide: https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3

BTW:

Migrated Joomla 2.5 to 3.5.1

The current Joomla! version is 3.6.2 https://www.joomla.org/

Kind regards

yes, thanks saw that. However, I've already completed the migration. Can I do that AFTER the fact? I have a full back up in a zip file and can use those files, right?

Do I just start at the importing steps?

I've since upgraded to 3.6.2 since I posted this.

Dennis

Hi, just add only this table to database and then you will see if it is OK or something is still not OK.

Jan

I'm sorry, I don't follow you.

I ran this: TRUNCATE TABLE `jos_phocadownload_layout`;

and got this error: #1046 - No database selected

Do I need to change the jos_prefix to notjos_prefix in phocagallery.sql or phocadownload.sql ??? Where are these files?

Thank you for the help thus far, but I have no idea what I'm doing. I need a little more explanation, is there someplace that describes some of the steps?

Thank you so much....


Is it easier to just delete the components and just start over?



Dennis

Hi Dennis,

claven123 wrote:and got this error: #1046 - No database selected

did you follow the procedure from Benno?

Do I need to change the jos_prefix to notjos_prefix in phocagallery.sql or phocadownload.sql ???

You have to replace to your YOUR prefix (see your 1st post)

Where are these files?

Just open the phocagallery.sql or phocadownload.sql file and replace the prefix by the table names.
Only one underscore > _ should be used.

Kind regards, Christine

claven123 wrote:
and got this error: #1046 - No database selected
did you follow the procedure from Benno?

*** No/yes, was not sure what part to follow as per my previous post. I already migrated to 3.6.2, so I'm not sure how to follow the steps.


Do I need to change the jos_prefix to notjos_prefix in phocagallery.sql or phocadownload.sql ???
You have to replace to your YOUR prefix (see your 1st post)

I can't find those files. Do you mean I need to change the prefixes to notjos_

Where are these files?
Just open the phocagallery.sql or phocadownload.sql file and replace the prefix by the table names.
Only one underscore > _ should be used.

Am I looking in the backup files or on the server of the live files ie html_public? What folder will I find them?


I'm generally lost with this. I'll follow directions, if I could have someone point me to what steps I should start with?

Dennis

Hi Dennis,

claven123 wrote:claven123 wrote:*** No/yes, was not sure what part to follow as per my previous post. I already migrated to 3.6.2, so I'm not sure how to follow the steps.

Before migrating database to J 3 you made already following steps?:
J 2.5 exporting site
Exporting files J 2.5
Exporting data J 2.5
see here: https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3
After this, see:
Joomla! 3.x (importing site)
Importing files (Joomla! 3)
Importing data (Joomla! 3)

All import actions must be done directly after installation of Phoca Gallery (Phoca Download) in Joomla! 3. All Phoca Gallery (Phoca Download) database tables must be empty before importing data from backup file.

Login to your phpMyAdmin application, select Joomla! 3 database.

claven123 wrote:I can't find those files. Do you mean I need to change the prefixes to notjos_

File:
a) administrator/components/com_phocagallery/install/sql/mysql
> install.utf8.sql

b) open the file with e.g. Notepad++

c) the first line will show you:
CREATE TABLE IF NOT EXISTS `#__phocagallery` (

d) Change all prefixes #__ to prefix which is set in your Joomla! site [see explanation above of the sql file).

e) Example: CREATE TABLE IF NOT EXISTS `jo151_phocagallery` (

Assuming: jo151 is your prefix (?)
Kind regards, Christine

No, I had no idea upgrading from 2.x to 3.x was so complicated in regards to phoca. I did upgrade the phoca gallery and download prior to the migration and it seemed to work ok, so I went ahead and migrated. Then after the migration phoca does not work. Now, I'm trying to fix it. I wish I would have known there was an issue, I would have followed those directions.

So, what steps do I take? Scrap it and start over? Or, pick up at some point in those directions you provide?

Thanks so far, i'm very appreciative,

D

Hi, if you have the files and data from 2.5 for Phoca Gallery, just copy the files, export the database tables. Uninstall the component in Joomla! and follow then the guide (export form 2.5, import to 3)


The prefix names are only examples:

if your prefix is the same for 2.5 and 3, don't change any prefix, if it is different, change the prefix from exported data to prefix which is used in Joomla! 3

Jan