Error 1054, column "approved"

[Mapan]

Hello,
I am relativly new to Joomla and have to migrate an old 1.5 to an 3.3.
With the help of "MigrateMe" it almost worked fine.

But I have a little issue with Phoca Gallery 4.1.2 which I today installed new on Joomla 3.3.
It seems to be installed properly, and I can see that MigrateMe moved all phocagallery from the 1.5 mysql to the new installation. Also I manually already copied the complete images folder.

So now the problem:
When I click in Joomlas 3.3 Phoca Control Panel onto "Images" I get the Error 1054:

Code: Select all

1054 Unknown column 'approved' in 'where clause' SQL=SELECT COUNT(a.id) AS count FROM jos_phocagallery AS a WHERE approved = 0 LIMIT 0, 1

if I click "Categories" I geht Error 1054:

Code: Select all

Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM `jos_phocagallery_categories` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

I already learned that some new columns like date, extlink1 and extlink2 have came up with newer phoca versions. But that columns are already there. So know I don't know what to do to avoid these errors.

Any suggestions for me?

Thanks in advance!


PS: In my jos_phocagallery there are 16 columns yet in the mysql-structure.

[Mapan]

What I can tell additionally is:
The old Phoca Gallery in Joomla 1.5 is a Version 2.2.4,
the actual one seems to be 2.8.1

(I tried to upgrade, but when I want to install/upload 2.8.1 Joomla says Error 500 Unable to load archive)

[Mapan]

So, oki. I backupped and gave something a try.

I read about the "install.bak" and extracted the columns that are missing in my mysql.
Then I learned from the install.bak how the sql-injection commands should look like and was brave enough to
give following code into my myphpadmin:

Code: Select all

ALTER TABLE `jos_phocagallery` ADD `latitude` varchar(20) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `longitude` varchar(20) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `zoom` int(3) NOT NULL default '0';
ALTER TABLE `jos_phocagallery` ADD `geotitle` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `userid` int(11) NOT NULL Default '0';
ALTER TABLE `jos_phocagallery` ADD `videocode` text;
ALTER TABLE `jos_phocagallery` ADD `vmproductid` int(11) NOT NULL default '0';
ALTER TABLE `jos_phocagallery` ADD `imgorigsize` int(11) NOT NULL default '0';
ALTER TABLE `jos_phocagallery` ADD `approved` tinyint(1) NOT NULL default '0';
ALTER TABLE `jos_phocagallery` ADD `metakey` text;
ALTER TABLE `jos_phocagallery` ADD `metadesc` text;
ALTER TABLE `jos_phocagallery` ADD `extid` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `extl` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `extm` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `exts` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `exto` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `extw` varchar(255) NOT NULL default '';
ALTER TABLE `jos_phocagallery` ADD `exth` varchar(255) NOT NULL default '';