By Timo Stubenrauch on Wednesday, 27 April 2016
Replies 9
Likes 0
Views 1.5K
Votes 0
Hi i use the Launcher for update and after there we get the database fail. Pls check the attachment.
Hello Timo,

Can you try to execute these SQL queries and see how it goes:

ALTER TABLE `jos_discuss_posts` ADD COLUMN `cluster_id` INT(11) NOT NULL default 0;
ALTER TABLE `jos_discuss_posts` ADD COLUMN `cluster_type` VARCHAR(255) NULL;
ALTER TABLE `jos_discuss_thread` ADD COLUMN `cluster_id` INT(11) NOT NULL default 0;
ALTER TABLE `jos_discuss_thread` ADD COLUMN `cluster_type` VARCHAR(255) NULL;

May I know which version are you updating from?
·
Wednesday, 27 April 2016 12:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

puh i have no idea about sql, you can change this settings? witch login dates you need?
i would update to the newest version 4.0.2.

greetings timo
·
Wednesday, 27 April 2016 16:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Timo,

Can you provide us with your database access so we can manually execute the sql command for you? If that is not possible, can we have the permission to install a sql extension called mijosql in your site so we can execute the query directly on your site?

Please advise.
·
Wednesday, 27 April 2016 16:56
·
0 Likes
·
0 Votes
·
0 Comments
·
hi you can login in phpmyadmin no problem:
-edited-
·
Wednesday, 27 April 2016 17:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Timo,

I have executed the sql queries for you and everything should display correctly now. Please have a look.
·
Wednesday, 27 April 2016 17:44
·
0 Likes
·
0 Votes
·
0 Comments
·
yes perfect it runs now. many thanks.
have a nice day
·
Wednesday, 27 April 2016 17:55
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Timo.
·
Wednesday, 27 April 2016 17:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

i get after posting in frontend and deleting a article in backend such fail massage looks like attachment.

Not running correctly. :-(
·
Thursday, 28 April 2016 12:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Timo,

It seems like your database is not updated correctly. I believe you update your EasyDiscuss from EasyDiscuss Alpha/Beta version previously? Nevertheless I've fixed this by running a database maintenance from your backend > easydiscuss > maintenance > database and I am able to create, update and delete the discussion correctly on your site.

Hope these help.
·
Thursday, 28 April 2016 12:23
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post