This option worked for me.brizola wrote:There is a simple solution, though an adhoc one: just disable the remember me plugin, make the update and enable the plugin again.
Thanks for the info brizola
Moderator: General Support Moderators
This option worked for me.brizola wrote:There is a simple solution, though an adhoc one: just disable the remember me plugin, make the update and enable the plugin again.
petersw wrote:I had the same problem. I couldn't fix the database. So, if you get the error on the "Fix" database option you should create the table "xxxx_content_types" in your database (mySQL) by the following SQL query:
CREATE TABLE IF NOT EXISTS `xxxx_content_types` (
`id` int(11) NOT NULL,
`content_history_options` varchar(5120) NOT NULL COMMENT 'JSON string for com_contenthistory options'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
where xxxx is your dbprefix in your database, e.g. 'd3hrs_'. You must change xxxx to your dbprefix!!!
After that the "Fix" database option should work!
This is right and I have test it with my system, but when you doing these kind of configurations please back up every thing before you do any changes, and clear your browser cash memory in each step.. and also you can close and open your browser on each step... don't angry with joomla .. this is good product.. and also remember this is world most valuable open source product that we ever see..Hazzaa wrote:Here is my solution
Rename your file remember.php to rememberBAK.php so it looks like this
/plugins/system/remember/rememberBAK.php
Find a copy of Joomla 3.1.15 and make a copy of the remember.php
FTP the file to your folder
/plugins/system/remember/remember.php
Now access your admin panel
Go to Extensions -> Extension Manage -> Database
Click Fix
Now go to ftp, delete the remember.php that you uploaded and rename the original one to it's correct state
Joomla updates do not update the database and this needs to be done manually.
For not developers, the above method is the simplest and quickest way
Good luck
Code: Select all
CREATE TABLE IF NOT EXISTS `xxxx(replaced with my db#)_content_types` (
`id` int(11) NOT NULL,
`content_history_options` varchar(5120) NOT NULL COMMENT 'JSON string for com_contenthistory options'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Code: Select all
CREATE TABLE IF NOT EXISTS `XXXX_content_types` (
`type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type_title` varchar(255) NOT NULL DEFAULT '',
`type_alias` varchar(255) NOT NULL DEFAULT '',
`table` varchar(255) NOT NULL DEFAULT '',
`rules` text NOT NULL,
`field_mappings` text NOT NULL,
`router` varchar(255) NOT NULL DEFAULT '',
`content_history_options` varchar(5120) COMMENT 'JSON string for com_contenthistory options',
PRIMARY KEY (`type_id`),
KEY `idx_alias` (`type_alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10000;
Code: Select all
$this->input->set('view', 'login');
Hazzaa,Hazzaa wrote:Here is my solution
Rename your file remember.php to rememberBAK.php so it looks like this
/plugins/system/remember/rememberBAK.php
Find a copy of Joomla 3.1.15 and make a copy of the remember.php
FTP the file to your folder
/plugins/system/remember/remember.php
Now access your admin panel
Go to Extensions -> Extension Manage -> Database
Click Fix
Now go to ftp, delete the remember.php that you uploaded and rename the original one to it's correct state
Joomla updates do not update the database and this needs to be done manually.
For not developers, the above method is the simplest and quickest way
Good luck
its work for mebonez wrote:This option worked for me.brizola wrote:There is a simple solution, though an adhoc one: just disable the remember me plugin, make the update and enable the plugin again.
Thanks for the info brizola
Code: Select all
$this->app = JFactory::getApplication();
Surely the lesson learned is always keep a backup before making significant changes. Even if Joomla did update OK there is always the possibility of something going wrong. Not to mention the possibility of being hacked. You get hacked and your backup will be needed.pepe53 wrote:... Needless to say I will NOT be doing anymore upgrades.
Lots of posts about this in Forums. It is a reporting error rather than a database error and it will be fixed in the next update. There is nothing actually wrong with your site or database and no need to do anything.birdeye wrote:Followed the steps but now i have this error "Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3)."
I accept what you are saying, but this "Proper" fix is not retrospective is it?sovainfo wrote:For those that still don't understand solution provided by @Hazzaa is bad:
...
As mentioned by many in the thread restore your backup, disable plugin "Remember me", do the update and enable plugin "Remember me" ...
I'll know for next time ;-)oxygen wrote: ... I didn't know there would be an issue with the upgrade so I couldn't disable the "Remember me" plugin could I?