ISSUE SUMMARY:
Today I test to upgrade my multilanguage site(J2.5+JS 4.0.3+joomfish 2.51) from J2.5.8 to J3.4.1(J3.4.1+JS4.0.3+laternfish1.3.7.1). Well, before I upgrade the site, I can open community-groups(list)-a certain group detailed page. But after I upgraded, I can open groups(list) page but can't open any group detailed page.

The testing site issue:

www.brandsight.cn/test/index.php?option=...s&Itemid=737&lang=en , can open.

www.brandsight.cn/test/index.php?option=...7&Itemid=737&lang=en , can't open.

you can open in J2.5: www.mandarinlearn.com/index.php?option=c...7&Itemid=737&lang=en .

Please help me and thanks a lot！

My best regards,

Fran


STEPS TO REPLICATE:
1
2
3
4
5
RESULT
EXPECTED RESULT
BROWSER

Hi Fazk,

Would you mind provide me the super user access, please? so I can inspect this issue further.

thank you

Dear Dimas,

You have that super user accout from thread I used this "fazk" account post in photo&video category.

This is fatal error what I get :

Fatal error: Uncaught exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT `new_url`,`header`,`published` FROM `loumc_redirect_links` WHERE `old_url` = 'http://www.brandsight.cn/test/index.php?option=com_community&view=groups&task=viewgroup&groupid=37&Itemid=737&lang=en' LIMIT 0, 1' in /home/brandsight/www/www/test/libraries/joomla/database/driver/mysqli.php:610 Stack trace: #0 /home/brandsight/www/www/test/plugins/system/jfdatabase/intercept.jdatabasemysqli.php(371): JDatabaseDriverMysqli->execute() #1 /home/brandsight/www/www/test/plugins/system/jfdatabase/jfdatabase_inherit.php(813): interceptDB->execute() #2 /home/brandsight/www/www/test/plugins/system/jfdatabase/intercept.jdatabasemysqli.php(150): JFDatabase->execute() #3 /home/brandsight/www/www/test/plugins/system/jfdatabase/jfdatabase_inherit.php(452): interceptDB->loadObjectList('', 'stdClass', true, NULL) #4 /home/brandsight/www/www/test/plugins/system/redirect/redirect.php(86): JFDatabase->loadObject() #5 [internal funct in /home/brandsight/www/www/test/libraries/joomla/database/driver/mysqli.php on line 610

Dear Dimas,

Thank you very much for your quick reply and can you tell me how to write this sql language, as I know nothing about sql.
what I did was:
1. Just now, I created a new group"test" in back-end while, in front-end we may visit group lists page, but click "test group" the result is blank page.
2. I created a field "header"after "new url", choose options like "var...""255"...
3. Back to the front page and click "test group", the result shows "1054 - Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM `loumc_community_files` WHERE `groupid` = '38'", ---what coursed this error?

Looking forward to your kindly answers and thanks a lot!

Hi,

OK, please provide me access to your cpanel / phpmyadmin, I will do it by myself :)

thank you

Dear Dimas,

Thank you for your reply and it was very interesting, I upgraded the formal site to J3.4.1 (also testing site back to J2.5.28), just turned off the system plugin "remember me" and check the database tale after upgrading finished, "header" is there! I don't know why. Well, I thought that was those referer links problem coused that 1054 balabalabal., I clean that table, in front-end I may visit those groups details page again:)

Thank you for your guideline again!

Fran

Sorry, still stuck in this issue and today I double check, still www.mandarinlearn.com , Community--Groups--any group detailed page shows 1054 error. I searched the web found a discussion on this issue: issues.joomla.org/tracker/joomla-cms/6333?lang=zh-CN .

Why the error pages only show in related group detailed pages, while other pages are showing normal? The issue comes from Joomla 3.4 or, jomsocial?

I really need your help and thank you very much.

this is another issue :

1054 - Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM `loumc_community_files` WHERE `groupid` = '37'

Thank you Dimas, your guideline works and the group detailed page appears normally.