Opening group causes SQL error - JomSocial Forum

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.

Opening group causes SQL error

12 years 2 months ago

#99455

Topic Author
Ron
Offline
Fresh Boarder
Thank you received: 2

Licenses:

JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

See attached.

www.playshakespeare.com/community/groups...-shakespeare-company

Error:
UNKNOWN COLUMN 'GROUPID' IN 'WHERE CLAUSE' SQL=SELECT COUNT(*) FROM `PLV9W_COMMUNITY_FILES` WHERE `GROUPID` = '4'

Attachments:

12 years 2 months ago

#99492

Michał
Offline
Moderator
Posts: 13447
Thank you received: 3689

Licenses:

Hi, Ron.

Please, read that topic: www.jomsocial.com/forum/installation/195...ect-count-from#99448

- 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

The following user(s) said Thank You: Ron

12 years 2 months ago

#99604

Topic Author
Ron
Offline
Fresh Boarder
Thank you received: 2

Licenses:

JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Now, my groups and group categories are missing.

Attachments:

12 years 2 months ago

#99712

Michał
Offline
Moderator
Posts: 13447
Thank you received: 3689

Licenses:

Hi, Ron.

I presume that you made a safe copy before did that? :)
This SQL query didn't remove anything in your database but just add an additional column to table.

Please, check your database if it contains group records... or edit your first post and add PHPmyAdmin credentials.

- 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

12 years 2 months ago

#99781

Topic Author
Ron
Offline
Fresh Boarder
Thank you received: 2

Licenses:

JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

The records are still in the database. They just aren't showing up in JomSocial.

12 years 2 months ago

#99874

Michał
Offline
Moderator
Posts: 13447
Thank you received: 3689

Licenses:

Hi, Ron.

Please, edit your first post and add PHPmyAdmin nad FTP credentials.
I assign developer to this thread.

- 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

12 years 2 months ago

#99957

Topic Author
Ron
Offline
Fresh Boarder
Thank you received: 2

Licenses:

JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Now added.

12 years 2 months ago

#100029

Dimas Tekad Santosa
Visitor
Thank you received: 0

Licenses:

I just checked and seems everything working fine

Attachments:

12 years 2 months ago

#100032

Topic Author
Ron
Offline
Fresh Boarder
Thank you received: 2

Licenses:

JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Weird. They now show up for me. Thanks for checking!

12 years 2 months ago

#100036

Dimas Tekad Santosa
Visitor
Thank you received: 0

Licenses:

you're welcome

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