Thank you. That helped. Can you tell me exactly what you did because this was a backup site and I need to do it for the active site as well as other sites that I maintain. Please be specific and step-by-step as I explained the link you referenced did not help me.

Also, I have had to make some adjustments to settings as I compare the front end of the active site (with 3.9) to the backup site (with 5). is there a way to avoid this ? Things like showing or hiding the Author's name, Category, etc. Not a big deal, but just curious.

Also, and it is a big deal. The new layout does not show a comment box or Trackback URL like the 3.9 version. Is there a setting I am missing?

Hey Ellen,

I believe what Arlex did was executed the query below on your site replacing the #__ with your table prefix.

ALTER TABLE `#__easyblog_acl` ADD `group` varchar(255) NOT NULL;

ALTER TABLE `#__easyblog_post` ADD `state` int(1) unsigned NOT NULL;

ALTER TABLE `#__easyblog_post` ADD `locked` tinyint(3) NOT NULL;

ALTER TABLE `#__easyblog_post` ADD `doctype` varchar(255) NOT NULL;

ALTER TABLE `#__easyblog_post` ADD `revision_id` bigint(20) DEFAULT '0';

ALTER TABLE `#__easyblog_users` ADD `custom_css` text null;

This is actually a known issue and we will be addressing this in 5.0.21 soon.

Can you tell me HOW to execute the code? When i tried it in phpAdmin it said the table does not exist. Please give me a step by step How to execute the code.

Also, The new layout does not show a comment box or Trackback URL like the 3.9 version. Is there a setting I am missing?

When I click on SEO in Dashboard (not Settings), I get this error:
An error has occurred.

1060 Duplicate column name 'title' SQL=SELECT * FROM ( (SELECT m.*, p.title AS title FROM `joom_easyblog_meta` AS m INNER JOIN `joom_easyblog_post` AS p ON m.content_id = p.id AND p.`published`!='9' WHERE m.`type` = 'post') UNION (SELECT m.*, p.title AS title FROM `joom_easyblog_meta` AS m LEFT JOIN `joom_easyblog_team` AS p ON m.content_id = p.id WHERE m.`type` = 'team') UNION (SELECT m.*, p.name AS title FROM `joom_easyblog_meta` AS m LEFT JOIN `joom_users` AS p ON m.content_id = p.id WHERE m.`type` = 'blogger') UNION (SELECT m.*, '' AS title FROM `joom_easyblog_meta` AS m WHERE m.`type` = 'view') UNION (SELECT m.*, p.title AS title FROM `joom_easyblog_meta` AS m LEFT JOIN `joom_easyblog_category` AS p ON m.content_id = p.id WHERE m.`type` = 'category')) AS x LIMIT 0, 20

Hi Ellen,

For the SQL error message you can refer to this thread here for the fix, http://stackideas.com/forums/seo-option-renders-a-sql-error .

Can you tell me HOW to execute the code? When i tried it in phpAdmin it said the table does not exist. Please give me a step by step How to execute the code.

You need to replace #_ prefix for each table queries above with your own database prefix in order for the queries to work properly. Refer my example below:

// I will replace #_ with oasq9 to match with my own database prefix.

ALTER TABLE `oasq9_easyblog_acl` ADD `group` varchar(255) NOT NULL;

ALTER TABLE `oasq9_easyblog_post` ADD `state` int(1) unsigned NOT NULL;

ALTER TABLE `oasq9_easyblog_post` ADD `locked` tinyint(3) NOT NULL;

ALTER TABLE `oasq9_easyblog_post` ADD `doctype` varchar(255) NOT NULL;

ALTER TABLE `oasq9_easyblog_post` ADD `revision_id` bigint(20) DEFAULT '0';

ALTER TABLE `oasq9_easyblog_users` ADD `custom_css` text null;

Hope these help.

Hi There,
I have the same issue(s).
When do you think you will launch the update 5.0.21, so maybe we can wait, a couple days
Regards Takao.

hey tmstms,

I believe I already replied on your original thread

http://stackideas.com/forums/upgrade-from-3-9-to-5-0-21-cant-get-through-45

please have a check.

I see so many threads about the difficulty upgrading from 3.9 to the latest 5.0 version, that I'm afraid to do so. That the system times out at 45% etc. Why is this? Please ensure that your upgrade process is smooth. Has this problem been fixed in 5.0.21?

Hey there,

I am sorry that delay of this reply,

One of the issue why stuck at 45% is the update process can't install new columns properly in Easyblog 5, this already fix in 5.0.21 version.

Another possibility issue is this table `#_easyblog_acl_group` got huge data e.g. 100000 records, so it will hitting timeout issue in installation process.

Before you update try run this query in your database :

// Replace #_ with your table prefix

SELECT COUNT( 1 ) FROM  `#__easyblog_acl_group`

If the record over 100000, so you have to run this query truncate all the data in this table

// Replace #_ with your table prefix

TRUNCATE TABLE  `#__easyblog_acl_group`

After you done that, download the latest launcher installer from http://stackideas.com/dashboard then upload through in your Joomla installer.

Final step, go to your backend > Easyblog > ACL > select each of your user group > re-save

Hope this help.

Hi Arlex,
you allready answered and solved my problem in my tread I opened after rtrying to install version 5.0.21.
THX

Hey tmstms,

You're welcome, I already replied on your original thread
http://stackideas.com/forums/upgrade-from-3-9-to-5-0-21-cant-get-through-45#reply-217338