Hi,

I am sorry that delay of this reply,

can you provide us with your Joomla backend and FTP access so we can help you check on this?

I would prefer not at this time as this is a production site. However I am working on getting a dev copy set up and can grant you access to that when it is available.

In the meantime, is their anything I should be checking? Or information I can provide you that might help?

Thank you.

Hey there,

We have never seen such issues before so we really can't tell you what are the possibilities here Perhaps once your dev site is ready, let us know and we'll try to check on your dev site?

Ok, I have finally gotten a dev site up for testing this issue. Site details should be below.

I don't have an easy way to give you FTP access without going through some hoops with my systems group.

Keep in mind this was part of a multisite install that didn't go smoothly.(http://stackideas.com/forums/sql-error-on-multisite-after-easyblog-5-install) This is most likely related.

Hi there,

Can you pass me your FTP access as well so we can check on the issue directly?

This would take some time unfortunately. However I installed the 'ProFiles' component which should allow you to see the needed files. Would there be any other reason for FTP access or will ProFiles work for you?

Hey there,

We need the ftp access because it is dangerous to modify files with an extension. If we have a typo when saving, your entire site will be inaccessible. We wouldn't want to take such risks and definitely it won't be good for you as well just in case anything happens?

Yes, that makes sense. I'll work on getting this.

Hi,

Sure. Keep us updated once you have access to your FTP.

I'm able to get you an ftp account but I need an IP address to tie your account to. Can you provide your IP addresses?

Thank you.

Hi there,

Hm. I'm not really sure if this will work well as our office ip address will always keep on changing and some of us are actually working at home and they have different ip address altogether. By the way our current ip address is 210.195.136.235 . Let's give it a shot.

Hi Ezrul,

We've added 210.195.136.235, connect via port 22. We can also add more address or a subnet if you would like.

Thank you for your time.

Hi there,

I am sorry but I am not seeing any FTP access details here . By the way our ip address now has changed to 121.121.31.217 . Please advise.

Oh wow, completely forgot to include the login details. The new IP has been added, but if it would be possible to get a static IP it may be the best way?

Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

I've checked in your database, it seems like this table #__easyblog_acl has no any data, I already help you updated, everything seems work fine now, can you give it a check now?

Hi Arlex,

Thanks for the help. Can you please walk me through the steps you took to fix this issue? The site you fixed was a dev copy and I need to make these changes to production.

Thank you.

You're welcome.

First, you need to double check with this table `#__easyblog_acl` is it got any data or not.

If there no any data exist, so you can export with your `#__easyblog_acl` from your dev database.

Then change the table prefix then copy this `Insert` sql query run in your live site database
-> screenshot : http://screencast.com/t/10OBOZMEbs

After you execute the sql query, then upload the latest launcher in your Joomla installer.

If install successfully, then go to backend > Easyblog > maintenance > click database > run script > after that click script > execute script

When you done everything above step, then open all of your user group from backend > Easyblog > acl > select each of your user group > re-save the settings.

Hope this help.

Hi Arlex,

Thanks for the instruction. Would you be able to provide a file with that Insert SQL written already? Then I could just change the prefix, thank you.

hey there,

I am really sorry that delay of this reply,

Try download my attached file then change the table prefix #_ to your current table prefix then import in this table `#__easyblog_acl`.

Then continuous with my instruction at above.

hey there,

I am really sorry that delay of this reply,

Try download my attached file then change the table prefix #_ to your current table prefix then import in this table `#__easyblog_acl`.

Then continuous with my instruction at above and see how it goes.

Thank you for the file Arlex. I'll be doing this update at 10am Central time next Wednesday(2nd). I hope all goes smoothly.

Is any live support available at all? I know we are in pretty different time zones, I was just curious about the possibility of talking with someone quickly if the update were to go bad.

Can you verify and answer the question on #4?

1. Check if _easyblog_acl has data(I checked it does not)
2. Export the data for the table from my dev site
3. Run the provided SQL update after replacing '#_' with my table prefix
4. Upload latest launcher(what does this mean?) Does this mean update to the latest version of EasyBlog? I am wary to do this as I had some issues updating last time.
5. If successful run the database script
6. From Easyblog > acl open each of the user groups and re-save.

Thanks again for all your help!

Hey there,

I am sorry that delay of this reply,

Regarding step 4, what I mean is download the latest launcher installer from http://stackideas.com/dashboard then upload through in your Joomla installer.

Before you process this step, you need to enable error_reporting to maximum, then open the browser console (screenshot : http://screencast.com/t/LcF1VqMGR )

If the installation get stuck on which percentage, I can see what error hitting this check from the console last ajax call.
Example : http://screencast.com/t/yeKlVgfA

Keep us updated then.

Arlex,

Doesn't this mean that my EasyBlog version will be updated? I am curious because on the dev site you fixed I did not see a version change yet the issue is fixed.

Thank you.

Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

Ah, yes it will update to latest version.

Actually I am not really sure why you wouldn't like to update to latest version?

If because of the customization file, perhaps you can skip this #4 step.

1. Check if _easyblog_acl has data(I checked it does not)
2. Export the data for the table from my dev site
3. Run the provided SQL update after replacing '#_' with my table prefix
4. Upload latest launcher(what does this mean?) Does this mean update to the latest version of EasyBlog? I am wary to do this as I had some issues updating last time.
5. If successful run the database script (check my screenshot : http://screencast.com/t/TSPosaUxs )
6. From Easyblog > acl open each of the user groups and re-save.
And see how it goes.

Hi Arlex,

I'm just trying to keep things consistent with what you did for me on the dev site. On the dev site you got things working and there was no change in version so I wanted to make sure I was preforming the same steps.

Hey there,

I am sorry that delay of this reply,

I would like to make sure 1 thing, if you access Easyblog backend page, is it can access?

if yes, you can try this few step :
#1. Run the provided SQL update after replacing '#_' with my table prefix
#2.From Easyblog > acl open each of the user groups and re-save.
And see how it goes.

You're welcome, keep us updated then.

The update worked and solved the issue. I just ran the SQL update and then resaved the ACL groups.

Thank you for your help.

You're welcome, glad to heard your issue resolved.