Username
Forgot password?
Welcome to our site!
Or Join with FTTF

Some issues about activation email sending, MySQL, broken links.

0

13780 views
Hi Dmitri,

First of all LampCMS has definitely more successful features and architecture than other similar applications, even perhaps more successful than Stack Overflow's itself. So really we have to thank you for this features.

We are planning to use LampCMS in an University at Turkey. University's web site: http://omu.edu.tr/

But after the installation of LampCMS for testing application we are experiencing some problems. I will list these issues below.


Activation E-mail Sending

Our EMAIL_SERVER configuration:


[EMAIL_SERVER]
;
; Supported values are "sendmail", "smtp" or leave blank
; If left blank then php's mail() function will be used (not recommended)
TRANSPORT =
;
; If TRANSPORT set to smtp setup at least SMTP_HOST
; optionally SMTP_PORT, SMTP_ENCRYPTION, SMTP_USERNAME, SMTP_PASSWORD
SMTP_HOST = "smtp.gmail.com"
;
; Leave default value (25) unless you know that your smtp server runs on different port
; If your smtp server requires secured connection then ask your server admin
; for port number
SMTP_PORT = 465
; Leave blank unless your server requires encryption
; in which case supported options are 'ssl' or 'tls'
SMTP_ENCRYPTION = 'ssl'
;
; If your smtp server requires authentication then enter SMTP_USERNAME and SMTP_PASSWORD below
; Enclose value in double quotes!
SMTP_USERNAME = "lampcms55@gmail.com"
;
SMTP_PASSWORD = "PASSWORD"
;
; ONLY of value of TRANSPORT is sendmail
; enter a full path to sendmail program on your server
; path to exim or postfix are also supported
SENDMAIL_PATH = /usr/sbin/sendmail
;
; optionally enter command line options
; recommended to leave default value here
; unless you know what you doing
; IMPORTANT: must include the - (dash) in front of options
SENDMAIL_OPTIONS = "-bs"



It is definitely correct login details but there is no any Activation E-mail sent on Sign Up. 465 port open. What can we doing wrong, we need help ?

MySQL

Our MySQL configuration:


[DB]
Database_name=lampcms
Database_host=88.249.43.38
TCP_Port_number=3306
Database_type=mysql
Database_username=lampcms
Database_password=PASSWORD
Persistent = 0


When we ask a question with a Google Auth Account (We can't get standard and validated account cause of Activation E-mail Sending issue), we are getting this Alert(Error):

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'userlink' at row 1 Exception Class: PDOException
Error code: 22001 File: C:\inetpub\wwwroot\answers2\lib\Lampcms\Modules\Search\IndexerMySQL.php Line: 166 Trace: #0 C:\inetpub\wwwroot\answers2\lib\Lampcms\Modules\Search\IndexerMySQL.php(166): execute() #1 C:\inetpub\wwwroot\answers2\lib\Lampcms\QuestionParser.php(429): indexQuestion(Lampcms\Question) #2 C:\inetpub\wwwroot\answers2\lib\Lampcms\QuestionParser.php(138): addToSearchIndex() #3 C:\inetpub\wwwroot\answers2\lib\Lampcms\Controllers\Ask.php(122): parse(Lampcms\SubmittedQuestionWWW) #4 C:\inetpub\wwwroot\answers2\lib\Lampcms\Controllers\Ask.php(93): process() #5 C:\inetpub\wwwroot\answers2\lib\Lampcms\WebPage.php(284): main() #6 C:\inetpub\wwwroot\answers2\www\index.php(123): __construct(Lampcms\Registry)

It saying : Data too long for column 'userlink' at row. So it is creating an empty table on MySQL. Screenshots:



When open the table : "
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)"

What can we doing wrong, we need help ?

Broken Links

Here are broken link samples from our web site:

Google Auth Sign Up Broken:
http://answers2.amisosyazilim.com/index.php/userinfo/3/Mehmet_Mert_Y%C4%B1ld%C4%B1ran

Standard Sign Up Not Broken: http://answers2.amisosyazilim.com/index.php/userinfo/2/mehmetmert

Google Auth Sign Up Not Broken: http://answers2.amisosyazilim.com/index.php/userinfo/7/MEHMET_MERT_YILDIRAN

Google Auth Sign Up Not Broken: http://answers2.amisosyazilim.com/index.php/userinfo/5/LAMP_CMS

First link contains Turkish Character can that is be the problem for broken link ?

http://answers2.amisosyazilim.com/index.php/userinfo/3/Mehmet_Mert_Y%C4%B1ld%C4%B1ran broken

http://answers2.amisosyazilim.com/index.php/userinfo/3/ working.

Our members will be Turkish so we have to solve this problem. Can you help me how can I change to working link design.

Also
http://support.lampcms.com has an broken link or an error: http://support.lampcms.com/users/12/snytkine


You can have a look to our LampCMS test website: http://answers2.amisosyazilim.com/

Our company's website: http://www.amisosyazilim.com/

My personal website: http://www.mehmetmertyildiran.com/

Contact: http://www.mehmetmertyildiran.com/#!?page_id=9

Thanks for your help ...
 
asked September 29, 2013 at 1:14 PM

 tr
I solved MySQL error in question_title table change userlink column type varchar(60) to varchar(120) Activation E-mail Sending is an ongoing problem. Turkish Character in userlink is an ongoing problem. e.g. http://answers2.amisosyazilim.com/index.php/userinfo/3/Mehmet_Mert_Y%C 4%B1ld%C4%B1ran
flag
Sep 29, 2013 03:08 PM

1 Answer

0
Best answer
 
Problems are solved;

I solved MySQL error in question_title table change userlink column type varchar(60) to varchar(120)
I solved EMAIL_SERVER => TRANSPORT = "smtp"

I solved userlink lib\Lampcms\Controllers\Userinfo.php line 176:

throw new \Lampcms\RedirectException('/userinfo/' . $this->User->getUid() . '/');

flag
answered September 29, 2013 at 5:16 PM

Your answer

Join with account you already have

FTTF

Preview

Alert