Phoca Forum

Hello forum,

I've just made an upgrade from Phoca Gallery 1.8.8 to 2.0 and after the proces there are the following messages:

Phoca Gallery not successfully upgraded:
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 13 SQL=CREATE TABLE IF NOT EXISTS `jos_phocagallery_votes` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, `date` datetime NOT NULL default '0000-00-00 00:00:00', `rating` 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 NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 14 SQL=CREATE TABLE IF NOT EXISTS `jos_phocagallery_comments` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(255) NOT NULL default '', `comment` text NOT NULL, `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 NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 7 SQL=CREATE TABLE IF NOT EXISTS `jos_phocagallery_votes_statistics` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `count` tinyint(11) NOT NULL default '0', `average` float(8,6) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 7 SQL=CREATE TABLE IF NOT EXISTS `jos_phocagallery_user_category` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, PRIMARY KEY (`id`), KEY `catid` (`catid`,`userid`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
Table 'vweb12325.jos_phocagallery_votes' doesn't exist SQL=SELECT * FROM `jos_phocagallery_votes` LIMIT 1;
Table 'vweb12325.jos_phocagallery_comments' doesn't exist SQL=SELECT * FROM `jos_phocagallery_comments` LIMIT 1;
Table 'vweb12325.jos_phocagallery_votes_statistics' doesn't exist SQL=SELECT * FROM `jos_phocagallery_votes_statistics` LIMIT 1;
Table 'vweb12325.jos_phocagallery_user_category' doesn't exist SQL=SELECT * FROM `jos_phocagallery_user_category` LIMIT 1


I've never had problems with installing extensions etc. before.

Joomla! 1.5.7 on Win XP SP2

thx
flashracer

Hi, it seems like your database has problem with:

DEFAULT CHARSET=utf8...

so you should take a look at install.bak file and delete all DEFAULT CHARSET=utf8 in SQL queries, change the #__ prefix to your prefix and run these sql queries e.g. through the phpmyadmin... but be aware, if you are upgrading Phoca Gallery, you should run only sql queries of tables which are not created in your database, so all except phocagallery and phocagallery_categories tables...

Jan

Hi Jan,

thank you for your quite fast answer.
I'll check this with my provider.

thx