Elxis CMS Forum

Support => Installation => Topic started by: anacon on October 03, 2008, 01:37:35

Title: error with login form
Post by: anacon on October 03, 2008, 01:37:35
i make update elxis 2008 to 2008.1 and i have this error when new user try to make username

mysql Σφάλμα [1054] : EXECUTE
URI: index.php
Message: Unknown column 'sendmail' in 'where clause'
SELECT email, preflang FROM elx_users WHERE gid='25' AND block='0' AND sendmail='1'

Η εγγραφή ολοκληρώθηκε!
Μπορείτε τώρα να συνδεθείτε
Μόλις συνδεθείτε επισκεφθείτε τη σελίδα του προφίλ σας για να επεξεργαστείτε τα προσωπικά σας στοιχεία.
Title: Re: error with login form
Post by: datahell on October 03, 2008, 08:55:28
The column is named sendemail and not sendmail.
Fixed, thanks for the bug report.

Till a fix is released:
File components/com_registration/registration.php
Go to line 378
Change this:
$database->setQuery("SELECT email, preflang FROM #__users WHERE gid='25' AND block='0' AND sendmail='1'");
to this:
$database->setQuery("SELECT email, preflang FROM #__users WHERE gid='25' AND block='0' AND sendemail='1'");
 
Title: Re: error with login form
Post by: anacon on October 03, 2008, 13:13:16
Done Everything is ok now. Update complete. http://www.ayiamarina.com now is work with Elxis 2008.1