Hi,

I'm receiving an Error 1054 Unknown column after Install of com_community_pro_3.1.1 and com_community_std_3.2_RC3
1054 Unknown column 'a.repeat' in 'where clause' SQL=SELECT a.* FROM `gavg_community_events` AS a WHERE 1 AND (( a.`repeat`='' || a.`repeat` IS NULL) OR (a.`parent`!= '0' && a.`published` != '3' && a.`repeat` IS NOT NULL)) ORDER BY a.title

This is a Joomla 3x test site. It was upgraded from Joomla 1.5
Any help would be appreciated.

D. Ashley

Hi D,

please try this solution. execute this query at your PHPmyadmin / Database manager (depend with your hosting)

 ALTER TABLE `gavg_community_events` ADD `repeat` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'null,daily,weekly,monthly';

Hi Albertus,

I reinstalled com_community_pro_3.1.1, then ran the SQL query you offered. I am still receiving an error message, though a different one: 1054 Unknown column 'a.parent' in 'where clause' SQL=SELECT a.* FROM `gavg_community_events` AS a WHERE 1 AND (( a.`repeat`='' || a.`repeat` IS NULL) OR (a.`parent`!= '0' && a.`published` != '3' && a.`repeat` IS NOT NULL)) ORDER BY a.title

I have left the install on the site. So now you should be able to see the component when you log on .

Thank you,
D. Ashley

Hi D.

what about your database privilege? please make your the database has full privilege
or could you provide me your cpanel access detail to, I will installing it for you.

Regards,
Albert

Hi,

this post has been edited by me, because containing credential information.
the content moved to Misc Info at Site Info.

Hi D.

That link redirected me to cpanel login. could you please provide me cpanel access detail?
by editing your first post at this topic, you will see Site Info form

Regards,
Albert

Hi D,

Please check it. I added community_events table manually at your DB. I can't changing your DB privileges, seem restriction by your hosting provider.

now Jomsocial 3.1.1 can running. you can upgrade to RC version by your self.

Regards,
Albert

Hi Albert,

Your DB work helped greatly and I have update Jomsocial successfully.

Currently I have another question. When I migrated to Joomla 3.0 the community users migrated but none of the attributes came with the users, ie. Avatars, comments etc. I have access to the previous DB_1. Is there some way I can import the old users table, with all of the atrributes into the new DB_4?

Thanks, D. Ashley

Hi D,

To upgrade your joomla version we have the doc:
documentation.jomsocial.com/wiki/Migrate..._and_JomSocial_3.0.x

basically the step are same if using same jomsocial version but using new joomla version. the database must same, not using new one. Joomla and jomsocial will upgrade DB structures also at installation process .

If you using Joomla 3.3 and got problem with session/login at jomsocial. please appply this patch. extract it and copy it at your joomla directory.

Hi Albert ,

I did upgrade to 3.2.3... I think that's it now. However, my members avatars are still not showing up. The link to the avatars is available in the DB (see attached image) and the old avatars are available on the server, but they are not showing in the profile page (see attached image).

Any ideas?
D. Ashley

Hi D.

please open new topic about this.

Regards,
Albert

Hi D,

We have not received any response back from you in over 7 days, and would like to know if you consider this issue to be resolved. If you have any further questions, simply reply to this post.

Regards,
Albert