Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

1054 - Unknown column 'sectionid'

11 years 3 weeks ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi
Busy developing this site but I get the following error when I am trying to login:
1054 - Unknown column 'sectionid' in 'where clause' SQL=SELECT * FROM `yrtsq_content` WHERE `created_by` = '374' AND `state`='1' AND `sectionid` IN (2) AND ( ( `publish_up` <= '' AND `publish_down` >= '' ) OR `publish_down` = '0000-00-00 00:00:00' ) ORDER BY `created` DESC LIMIT 0,3

My members get the error: "404 - sorry user id not found"

I use J-import & K2 with Jomsocial
Please help!
Dirk

Attachments:
11 years 3 weeks ago
Licenses:

Hi, Dirk.

Please, make a safe copy of your site and provide us access to your db via PhPMyAdmin.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
11 years 3 weeks ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Backup made and saved on PC.
Do i give you the access details here?

11 years 3 weeks ago
Licenses:

Hi, Dirk.

Edit your first post and add it to Miscellaneous field.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
11 years 3 weeks ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi Michal

Just checking - were you able to solve the issue?

Dirk

11 years 3 weeks ago
Licenses:

Hi, Dirk.

I asked access to data base via PhpMyAdmin... you haven't provide it yet.
You could provide access to your cpanel if you can't do for db.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
11 years 3 weeks ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi Michal

I did exactly and immediately as you said and provided the info in Miscellaneous. I checked and it is there.

11 years 3 weeks ago
Licenses:

Hi, Dirk.

I'm sorry I missed that.

SQL error apply to table _content which is Joomla! core table not JomSocials. This table is empty... it should contain articles.
Also column 'sectionid' is deprecated in Joomla 3.2 as it doesn't contain sections anymore.

You try to load something from _content table on JomSocial profile page (using old SQL query).

So I created that column and now profiles are visible without error.

"My members get the error: "404 - sorry user id not found"" I couldn't replicate this issue. Could you tell me how I can do that?

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
11 years 3 weeks ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Thanks, 1054 solved!

When the user log out then they get the 404 - Sorry, User ID not found. Tested it now and it still happens.

11 years 2 weeks ago
Licenses:

Hi, Dirk.

It's because System - Jomsocial Redirect plugin is enabled and after logout it redirected to Profile. I changed it so now redirects to Community frontpage.
Please check if it works for you.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
11 years 2 weeks ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Everything is working now, much appreciated!

10 years 1 month ago
  • Dirk's Avatar
    Topic Author
  • Dirk
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hi
Have the same problem again! Please assist urgently. Happens only when login and in place of .../commuity/profile page the 1054 error shows up.

Attachments:
10 years 1 month ago
Licenses:

Hi, Dirk.

This time your issue has nothing to do with JomSocial. Error notice says it very clear:

Unknown column 'sectionid' in table 'yrtsq_content'. This table belongs strictly to Joomla! and contains articles.
You need to create column 'sectionid' manually. It's a bit strange as sections ware deprecated in Joomla! 1.6.
Please, post on forum.joomla.org if you need assistance.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved