Phoca Forum

Hi
I have installed the version 1.8.8 and it works fine. Now I downloaded the version 2.0.0 and the upgrading fails with an error. I receive the same error if I deinstall the 1.8.8 and I install the version 2.0.0.

Now the error:
Phoca Gallery not successfully installed:
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 `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 `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 `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 `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;

Heading.php: This file was not copied. Please copy the file from source to destination .....

Hi, first problem, your database does not take the:

'DEFAULT CHARSET=utf8' parameter

Copy the SQL queries from install.bak, remove this parameter and add the sql queries through e.g. phpMyAdmin

Second problem: heading.php cannot be copied... Then copy the file from source to destination file...

And it should work... please let me know

Jan

It works! Thank you

great to hear it, Jan

Jan wrote:Hi, first problem, your database does not take the:

'DEFAULT CHARSET=utf8' parameter

Copy the SQL queries from install.bak, remove this parameter and add the sql queries through e.g. phpMyAdmin

Second problem: heading.php cannot be copied... Then copy the file from source to destination file...

And it should work... please let me know

Jan

Sorry dear, i have the same problem but i didnt understand what u said! could u plz say it more clearly and explain it ??