URGENT: The Joomla portion of my site is now crashed.
I just upgraded and now receive this message. During the install I received warnings about time out settings. I use GoDaddy with a shared Linux account. Do I need to modify the settings? Will they even allow the change? From the error this seems more database related. I have been researching the Forum and it is obvious that my situation is NOT unique. After reading about 200 forum posts I do not know what direction to head towards resolution.
Here is the error message:
500 - An error has occurred.
DB function failed with error number 1054 <br /><span style="color: red;">Unknown column 'a.events' in 'field list' SQL=SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `jos_community_users` as a LEFT JOIN `jos_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `jos_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='42'</span>

Hi Mike,

What is your website URL? because if I check this URL indagators.com/index.php?option=com_community I couldnt see the jomsocial component there.

thank you

I provided all of the information for you. The JomSocial component is only accessible after you log in. It is restricted for registered users. I have it set up where you click on the "Member Area" and that takes you from a normal HTML site to the Joomla.

www.Indagators.com

Currently this portion of the site is crashed after you login. Please rush your attempts to help resolve the issue as my members cannot communicate online.

Michael Leavitt * This email address is being protected from spambots. You need JavaScript enabled to view it. * www.TheHomeInspector.com * 801-636-6816

Is there a reason why this is not getting priority attention? Your upgrade crashed the site and I cannot get into it to make any changes.

HI Michael,

Support is very limited on the weekend but i have had a look at your issue and have found the following

1. which site has the problem is it /pros?
2. When i log into the site i see the error you report
3. When i go to /administrator and log in i get another SQL error. So admin is not accessible either
4. I then logged in using your FTP access provided and looked at the configuration.php file to get the name of the database used for the site
5. I then logged in to your php admin to look for the database but cannot find the database specified for that site. I only see one database and it has no tables in it.

Either i am looking logging in to the wrong areas you have given us access to or i am missing something. Can you please edit your first post and confirm that the path to the site is correct. We have an area for test site info. Can you also login to the database using the phpadmin information you supplied and tell me what you see.

Without being able to see any database or log into /administrator of the site there isn't much else we can do. Please advise

Please note that support on the weekend is limited. Once we have the correct information this may need to be looked at by our database staff and they are Monday to Friday only

Oops! I provided a trial database access information. How do I share it here in private without all forum users from seeing the access link, user name, and password? There is no private window... I guess I have to submit a new issue... That is odd. There has got to be a way to send this database information privately. Nope... This is just plain crazy.

Hi, Michael.

Run this SQL query in PhpMyAdmin:

ALTER TABLE `_community_users` ADD `events` TEXT NOT NULL AFTER `groups` ;

I ran the query and received the error message that no table exists. See screen shot. You have permission to access via the info I provided and do whatever it takes to get it going.
Thanks in advance!

Hi, Michael.

Yup... you probably haven't noticed what I wrote:

Remember to add table suffix before _community_users.

Okay, a little update. I made the mistake of providing you with a 15 character password and I am only allowed 14 characters for the database password. I removed the last character and can now access the database through the PHPMyAdmin panel. I also changed the password in my Joomla config file, so I am back to square one, but making progress.

In your last message to me you stated...
"Remember to add table suffix before _community_users.
You don't have table called "_community_users" butsomething like this "xyz_community_users". Just add suffix and run it again."

I was so close to the trees that I could not see the forest when I read your instructions. Not being a SQL wizard, I did not understand what you meant by adding a suffix. I beat my head against the wall and then realized what you were trying to get me to do.

SOLUTION: I went to my database and realized that my _community_user was actually called jos_community_user. The "jos" is the subject that you were trying to get me to figure out. From there I copied and pasted the query you provided and added the jos to the copied and pasted command. I rand the query and my site is up and running.
Now the fun begins to see what I need to do with the newest upgrade features.
Thanks again for the help.