Joomla Templates Club 406,261 posts

[slipy Friend slipyJoin date: October 2011Posts: 10Downloads:0Uploads:0 Thanks: 4]

#171980

Hi!

Does somebody could help me to know why I have an error when I try to register as a new user on my jomsocial website: http://www.kokutana.ch/index.php/en/

first page is okay but then when trying to pass from the second to the third (after the info owner/renter) I can´t pass as there is a server error.

Many thanks for your help

[slipy Friend slipyJoin date: October 2011Posts: 10Downloads:0Uploads:0 Thanks: 4]

#430652

Here the error:

500 – JDatabaseMySQL::query: 1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 SQL=SELECT id,default_freq,template FROM y2tz5_email_alert_type WHERE id=

[Manos Moderator ManosJoin date: February 2014Posts: 2806Downloads:46Uploads:56 Thanks: 200 Thanked: 633 times in 576 posts]

#430663

Hi,

I just visited your website and i managed with no problems at all to register a user named demo (you can delete this user safely). Also most of the time a 500 error is a server issue and i suggest that you should address this to your host for more help.

Please let me know if there is anything else i can help you with.

Regards

1 user says Thank You to Manos for this useful post

1. slipy

[slipy Friend slipyJoin date: October 2011Posts: 10Downloads:0Uploads:0 Thanks: 4]

#430664

I found the problem! J!Mail alert was the problem. I removed that component and now it works fine!

[Manos Moderator ManosJoin date: February 2014Posts: 2806Downloads:46Uploads:56 Thanks: 200 Thanked: 633 times in 576 posts]

#430665

Hi,

I am glad that everything works for you now!!! 🙂

Regards

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#432483

Hi I’m having the same problem, can you help?
my site is: http://www.unaj.edu.ar/comunidad
I get this legend:DB function failed with error number 1146
Table ‘comunidad.jos_community_users’ doesn’t exist SQL=INSERT INTO `jos_community_users` ( `userid`,`points`,`thumb`,`avatar`,`params` ) VALUES ( ’62’,’0′,’components/com_community/assets/default_thumb.jpg’,’components/com_community/assets/default.jpg’,’notifyEmailSystem=1nprivacyProfileView=0nprivacyPhotoView=0nprivacyFriendsView=0nprivacyVideoView=1nnotifyEmailMessage=1nnotifyEmailApps=1nnotifyWallComment=0n’ )

THANK YOU!

[Manos Moderator ManosJoin date: February 2014Posts: 2806Downloads:46Uploads:56 Thanks: 200 Thanked: 633 times in 576 posts]

#433250

Hi,

You error shows that the table doesn’t exist i suggest that you try to install jomsocial again and see if that helps you.
Regards

1 user says Thank You to Manos for this useful post

1. sergiosp

[sergiosp Friend sergiospJoin date: February 2009Posts: 270Downloads:78Uploads:49 Thanks: 35]

#433268

I solved the problem thanks!!!!!!!

[Author]

Posts