Your issue is due to using an old version of MySQL that does not support the function. I have absolutely no knowledge about MySQL, so I did alot of research on web web to find the answer.
I changed all the code having to do with 'CURRENT_TIMESTAMP' to one that will work with the old MySQL, and have not had any problems with the functionality of this module.
I give an example;
CREATE TABLE `yogurt_tribes` (
`tribe_id` int(11) NOT NULL auto_increment,
`owner_uid` int(11) NOT NULL,
`tribe_title` varchar(255) NOT NULL,
`tribe_desc` tinytext NOT NULL,
`tribe_img` varchar(255) NOT NULL,
`datetime` timestamp NOT NULL default '',
PRIMARY KEY (`tribe_id`)
) ENGINE=MyISAM;
instead of
CREATE TABLE `yogurt_tribes` (
`tribe_id` int(11) NOT NULL auto_increment,
`owner_uid` int(11) NOT NULL,
`tribe_title` varchar(255) NOT NULL,
`tribe_desc` tinytext NOT NULL,
`tribe_img` varchar(255) NOT NULL,
`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`tribe_id`)
) ENGINE=MyISAM;
If you want, you could copy/paste my version of the mysql.sql to replace the one you find in the SQL directory of the module.
CREATE TABLE `yogurt_friendpetition` (
`friendpet_id` int(11) NOT NULL auto_increment,
`petitioner_uid` int(11) NOT NULL,
`petioned_uid` int(11) NOT NULL,
PRIMARY KEY (`friendpet_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_friendship` (
`friendship_id` int(11) NOT NULL auto_increment,
`friend1_uid` int(11) NOT NULL,
`friend2_uid` int(11) NOT NULL,
`level` int(11) NOT NULL,
`hot` tinyint(4) NOT NULL,
`trust` tinyint(4) NOT NULL,
`cool` tinyint(4) NOT NULL,
`fan` tinyint(4) NOT NULL,
PRIMARY KEY (`friendship_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_images` (
`cod_img` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`data_creation` date NOT NULL,
`data_update` date NOT NULL,
`uid_owner` varchar(50) NOT NULL,
`url` text NOT NULL,
`private` varchar(1) NOT NULL,
PRIMARY KEY (`cod_img`)
) TYPE=MyISAM ;
CREATE TABLE `yogurt_visitors` (
`cod_visit` int(11) NOT NULL auto_increment,
`uid_owner` int(11) NOT NULL,
`uid_visitor` int(11) NOT NULL,
`uname_visitor` varchar(30) NOT NULL,
PRIMARY KEY (`cod_visit`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_seutubo` (
`video_id` int(11) NOT NULL auto_increment,
`uid_owner` int(11) NOT NULL,
`video_desc` text NOT NULL,
`youtube_code` varchar(11) NOT NULL,
`main_video` varchar(1) NOT NULL,
PRIMARY KEY (`video_id`)
) TYPE=MyISAM;
CREATE TABLE `yogurt_reltribeuser` (
`rel_id` int(11) NOT NULL auto_increment,
`rel_tribe_id` int(11) NOT NULL,
`rel_user_uid` int(11) NOT NULL,
PRIMARY KEY (`rel_id`)
) ENGINE=MyISAM;
CREATE TABLE `yogurt_tribes` (
`tribe_id` int(11) NOT NULL auto_increment,
`owner_uid` int(11) NOT NULL,
`tribe_title` varchar(255) NOT NULL,
`tribe_desc` tinytext NOT NULL,
`tribe_img` varchar(255) NOT NULL,
`datetime` timestamp NOT NULL default '',
PRIMARY KEY (`tribe_id`)
) ENGINE=MyISAM;
CREATE TABLE `yogurt_scraps` (
`scrap_id` int(11) NOT NULL auto_increment,
`scrap_text` text NOT NULL,
`scrap_from` int(11) NOT NULL,
`scrap_to` int(11) NOT NULL,
`private` tinyint(1) NOT NULL,
`date` timestamp NOT NULL default '',
PRIMARY KEY (`scrap_id`)
) ENGINE=MyISAM;
CREATE TABLE `yogurt_configs` (
`config_id` int(11) NOT NULL auto_increment,
`config_uid` int(11) NOT NULL,
`pictures` tinyint(1) NOT NULL,
`videos` tinyint(1) NOT NULL,
`tribes` tinyint(1) NOT NULL,
`scraps` tinyint(1) NOT NULL,
`friends` tinyint(1) NOT NULL,
`profile_contact` tinyint(1) NOT NULL,
`profile_general` tinyint(1) NOT NULL,
`profile_stats` tinyint(1) NOT NULL,
`suspension` tinyint(1) NOT NULL,
`backup_password` varchar(255) NOT NULL,
`backup_email` varchar(255) NOT NULL,
`end_suspension` timestamp NOT NULL default '',
PRIMARY KEY (`config_id`),
KEY `config_uid` (`config_uid`)
) ENGINE=MyISAM ;
CREATE TABLE `yogurt_suspensions` (
`uid` int(11) NOT NULL,
`old_pass` varchar(32) NOT NULL,
`old_email` varchar(60) NOT NULL,
`old_signature` text NOT NULL,
`suspension_time` int(11) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM;
Hope it helps. This module have alot of promise, although a little buggy. I have no skills as an PHP programmer, but after this release, I have begun a little studying to be able to modify it to suit my needs and to fix a few of the more irritating bugs (fx. some users could not change their Avatar, while others could, so I added a new tab to solve the issue)
Good luck.
