Hi,

I am sorry for the late reply.

I am not sure how can I replicate this. However, it seems to be a missing column in the database. Perhaps, you can try run this sql in the database since we added this column in EasyBlog5.

alter table #_easyblog_users add column `custom_css` text;

If the issue is still persist, perhaps you can provide us the backend access and FTP access to your site so that we can inspect this issue directly.
Please advise.

I appreciate the reply. I now have a different error

Unknown column 'state' in 'where clause' SQL=SELECT COUNT(1) FROM `ssc_easyblog_post` WHERE `published`!='9' AND `state`='0' 

This is when I try to access EasyBlog from the admin panel.

Any ideas? Thanks.

Is there a way to run the new Maintenance -> Database tool on my multisites? I can't get to the admin panel on those sites, but it seems like the issue is that those tables haven't been updated.

Hey there,

Hm, how was the update done? I am not really sure how multi-sites is rendering the installer but we have actually split our SQL queries into multiple files to avoid issues with "mysql timing out". You can find it under the folder /administrator/components/com_easyblog/updates/

The update was done by downloading the EasyBlog Launcher to my local machine and uploading to my Joomla install on what I consider the 'main' multisite.

The launcher ran successfully without errors, however only that site has a working EasyBlog install. My other sites give the SQL error in my earlier posts.

I'll take a look at the easy_blog/updates folder to see if that helps. Maybe running the sql updates by hand will work.

Mark,

I am only seeing one file named posts.json at /administrator/components/com_easyblog/updates/

Am I missing something?

Hey,

Hm, you should be seeing these folders, http://screencast.com/t/Ti42bI15s

Ah, yes I do see the folder just as in your screen shot.

In the 5.0.16 folder I only see posts.json. I assumed the other were for older versions, but perhaps I am mistaken?

Hey,

If you are upgrading from 3.x, anything above it up till 5.0.16 will need to be executed

What is the best way to execute these files? Is there a script that will go through them all?

Any advice is welcome, thanks

Hey,

Hm, you could try running the script below,

EB::db()->sync('3.9.xxx');

Replace the version that you are upgrading from.

How would I specify the table prefixes with that method? I'm assuming that if this works I would need to run this for each multisite.

Thanks.

The table prefixes are inherited from your configuration.php file.

Hi Mark,

I'm sure my ignorance is to blame, but how exactly do I run the command? I've tried putting it in a php file and running from command line. But I just get a class 'EB' not found error.

I'm pretty sure I need to include some Joomla libraries or something so PHP knows what EB is. I'll keep digging, I know it's late where you are.

Hey,

Hm, I think you should place these codes in /administrator/components/com_easyblog/easyblog.php so that when you access the back end, it'll run immediately

Alright, while this does appear to be doing something...I'm still not able to get things working. I tried several things just in case I misunderstood what the intention was.

If I run the code with EB::db()->sync('3.7.13964'); which is the version of easyblog I was on. I get the following error

1146 Table 'wdev2.ssc_easyblog_post_templates' doesn't exist SQL=SHOW FIELDS FROM `ssc_easyblog_post_templates` 

Then I tried just the version I was on
EB::db()->sync('5.0.16');

But got this error

1146 Table 'wdev2.ssc_easyblog_revisions' doesn't exist SQL=SELECT MAX(`ordering`) FROM `ssc_easyblog_revisions` WHERE `post_id`='3702' 

Then I thought maybe I needed to run all the versions up to 5.0.16 so I tried
EB::db()->sync('3.9');
EB::db()->sync('5.0.1');
EB::db()->sync('5.0.14');
EB::db()->sync('5.0.15');
EB::db()->sync('5.0.16');
But got this error

1146 Table 'wdev2.ssc_easyblog_post_templates' doesn't exist SQL=SHOW FIELDS FROM `ssc_easyblog_post_templates` 

From the front end of this multisite I get the attached screenshot when trying to access the blog

Hey there,

Ah, looks like the missing tables need to be created. The /updates/ folder only updates existing database tables on the site. You would also need to run the queries in the folder /queries/ which is the "initialization" of missing tables.

Maybe it's because I haven't had my morning coffee yet, but where is this queries folder? I'm not seeing it in administrator/components/com_easyblog or in componenents/com_easyblog.

Then I'm assuming I would edit the queries to include my table prefix and run them for each multisite.

Edit: I did find install.mysql.utf8.sql.backup which contains some SQL. I may try that on a dev site.
Edit 2: install.mysql.utf8.sql.backup doesn't seem to conatain anything about '_easyblog_post_templates' so this doesnt seem like it would help. I'll keep looking for a queries folder.
Edit 3: Ah, I think I found what you are referring too. If I unzip the installer from my local machine I can see a queries folder.

Ok, progress is being made. But not quite there yet.

I ran all of the SQL found in the /queries folder.
Then I ran the EB::db()->sync('3.7.13964');

Now I do not get any SQL errors, but on my Frontpage view I get the message 'There are no blog posts available yet currently'.
On the backend things look ok, until I try to edit a post. See attached screenshot, there is no formatting being applied.

Any ideas? It seems so close to working again. Your help is greatly appreciated, unfortunately I am approaching the time where I may need to go back to a previous site backup. I have users unhappy that their blogs are down

Ok, I think I have finally worked this out.

For each multisite I ran the scripts from the queries folder.(changing the table prefix each time)
Then I made sure to go to Extension Manager -> Discover and Install everything
Then Extension Manager -> Database -> Fix
Then I edited easyblog.php to run the updates

EB::db()->sync('3.7.13964');

EB::db()->sync('3.9');

EB::db()->sync('5.0.1');

EB::db()->sync('5.0.14');

EB::db()->sync('5.0.15');

EB::db()->sync('5.0.16');

After that I went into the EasyBlog admin panel to Maintenance and ran all of the possible scripts. I also ran the database tool there as well.

The last issue I cam across what that the 'Archive' module is broken. If enabled the page just goes all white with a broken '2015' link. For now I have just disabled the archive module. I may open a new forum topic to address this, but for now I'm fine with it disabled.

I sincerely appreciate all of your help. Thank you.

Hey there,

Can I know what errors are being generated when you turn on the Archive module?

Well, I can't seem to replicate the Archive issue on my dev site. So it must be something wrong with my production. I'll investigate further. This may be over a week before I can work on this again, taking a vacation

Edit:

Took a quick look with firebug. I get the following error when the archive module is attempting to load on a page. It is a blank white screen with '2015', none of the site loads.
ReferenceError: EasyBlog is not defined
EasyBlog.ready(function($) {

Hey,

Hm, there could be a possibility that this archive module is from an older version. Try deleting the module and creating it again under Module manager and see if that helps?