Hello Daniel,

Did you previously installed any beta versions? Is it possible for you to provide us with the back end and FTP access to your site to check on this issue? You may store your site access at http://stackideas.com/dashboard/site so you don't have to provide these information all the time

I don't thing I've had a beta version of this installed. I put in the details for you, don't have FTP access though

Hi there,

It seems like you are requesting support for http://velihavn.no but your licensed domain is http://sjojakten.no . Please understand that Pro versions only entitles you to support for 1 domain only.

Should you require support for additional domains, please consider upgrading your license to the Unlimited version or purchase an additional subscription for this site. Please advice.

Yes aware of this. My plan was to change to this domain as soon as I have it working ;-)

The extension was not needed on the original domain, so I want to use it on my other site instead.
I actually went to change it now on the "Manage domains" choice, but can't seem to do it?

Hello Daniel,

Sure, i have already changed your support domain to http://velihavn.no for your EasyDiscuss license

Super! Thanks :-) Does it seem possible to fix the issue? :-)
I have local access (on the server via Sequel Pro - MacOS) to the database if that helps.

Hi there,

Super! Thanks :-) Does it seem possible to fix the issue? :-)

Actually, this is known issue and wee need to access your in order to solve this issues. Can you provide us with your credentials for us to access your database? You can put them on "optional Information" under your dashboard. Please advice.

The database is unfortunately not accessible over the interwebs. But I do have local access via Sequel Pro as mentioned.
Is it an easy fix you could guide me through perhaps?

Attached a screenshot to show what I'm seeing.

Hi there,

Actually, maybe got quite a few Query you need to run as it will kept on coming after one another but, maybe you can search all the query on this file .../administrator/components/com_easydiscuss/updates/3.2.0/... or .../administrator/components/com_easydiscuss/updates/4.0.0/... , search for the column and run them on your database.

For example:
You hit this error

Unknown column 'private' in 'where clause' SQL=SELECT COUNT(1) FROM `#__discuss_posts` WHERE `isresolve`='1' AND `published`='1' AND `parent_id`='0' AND `private`='0'

It key word is "private"
Search for "column" : "private" on path above, for example in .../administrator/components/com_easydiscuss/updates/3.2.0/posts.json
Then, copy and run the query below on your database

ALTER TABLE `#__discuss_posts` ADD `private` TINYINT(3) NOT NULL DEFAULT 0 COMMENT 'Determines if the discussion should be a private ticket or not.' , ADD INDEX (`private`) ;

and change #_ to your database name, example w562_discuss_posts

Hope this can helps

Phew, not to comfortable in the database app
I tried the command you wrote, but got this error message: Invalid default value for 'created'

Would there be a way to just clean out and start fresh with EasyDiscuss? I could do without the categories and such that I have, and recreate them.

Hi there,

Phew, not to comfortable in the database app

Would there be a way to just clean out and start fresh with EasyDiscuss? I could do without the categories and such that I have, and recreate them.

If you wanted to clean out and start a fresh i would advice you to delete all of your easydiscuss column on your database. For example w562_discuss_posts, and evertyhing with discuss append it, you have to delete, then go to Extension>Manage>Manage, search for easydiscuss and uninstall all easydiscuss component and re-install again your EasyDiscuss.

Note:
Maybe you can backup first your data on your database and remove your easydiscuss.

I thought I would try a bit more.

As far as I can tell I am doing the command you sent me right, even tried manually using the interface.
Whenever I try to create "private" it says the default value "0" is invalid. Any guesses to why this is?

Tried just for fun adding this to the discuss_post_types table without issues, but I can't add it to the discuss_post table.


The exact error message is this:
Invalid default value for 'created'

Perhaps this can tell you something, I exported the discuss_post_types table
SQL file zipped.

It works! But will there be more issues regarding this? Or is it safe to use now?

Yes

kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.