Database problems after migration from 2.5 to 3.5

[Spains]

Hi.

1. I uploaded my site from 2.5.28 to 3.5.1 Joomla v.
2. I installed com_pochagallery latest version for Joomla 3.5.
3. This is the result after update mod_pochagallery, too:
Table 'Sql478862_2.#__phocagallery_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM #__phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

- http://www.marcobranky.com/website/videos.html
Why? Thanks for support

[christine]

Hi,

Check this please: https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3

Kind regards, Christine

[Spains]

I follow all step. Why this error?

Name of table it's the same for me. Database of Joomla 2.5.28 with z7p09. Joomla 3 is the same: z7p09.

[Spains]

I used Jan's code for insert manually SQL table #_pochagallery_styles, but it doesn't function. Error is always the same. Please help me!

[Spains]

This is the table in Database, but doesn't function!!!
- http://postimg.org/image/s2bo5qluj/
- http://postimg.org/image/j9upi20pn/
- http://postimg.org/image/avrko5dzv/



I do not know what to do, I'm desperate.
I can give you the credentials you to solve?

[Jan]

Hi, on the first screenshot I see a typo error:

your tables looks:
some-prefix_table
and the styles table looks:
some-prefix__table (there are two underscores)

Just try to set only one underscore there.

Jan

[Spains]

Ok Jan but, I paste and copy your code:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocagallery_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `params` text,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 ;

INSERT INTO `#__phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*');

CREATE TABLE IF NOT EXISTS `#__phocagallery_styles`

Now Function with only one underscore #_pochagallery_styles

[Jan]

Hi, yes you have only one underscore, but # is not your database prefix, your database prefix is (see the screenshot): z7p09

So it should not be #_pochagallery_styles BUT z7p09_phocagallery_styles

Jan