Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#1 2017-04-24 14:09:36

happylag
Member
Registered: 2016-04-05
Posts: 177

Users bugs

Hello,

A lot of users contact me because of those bugs:

1) When a user registers, after filling form and click on create account, he is redirected to this error:

Query: INSERT INTO user_profile SET user_id = 1626
Error Message: Field 'about' doesn't have a default value
Error Number: 1364

The account is still created but he doesn't receive confirmation email.

2) When clicking on login and Did not receive confirmation email? he is redirected to http://www.domain.com/user/lost/ and receive login and password informations but not link confirmation.

3) In admin - User - Edit a user: and click on edit at the bottom of the page i get this error:

Query: SELECT user_id FROM user WHERE user_id = LIMIT 1
Error Message: 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 'LIMIT 1' at line 1
Error Number: 1064

I sent you an email.

Offline

#2 2017-04-25 12:48:36

symtab
Administrator
Registered: 2010-08-23
Posts: 7,461
Website

Re: Users bugs

1) This is related to a default configuration in mysql, edit libraries/framework/database/mysql.php and libraries/framework/database/mysqli.php and add:

$this->query('SET SQL_MODE=""');

after:

$this->query('SET CHARACTER SET utf8');

2. Hmm...this should go to domain.com/user/confirm/ for email confirmation and domain.com/user/lost/ for password recovery. I will test this.

3. Hmm...it works for me. Just tested!


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2017-04-25 13:53:12

happylag
Member
Registered: 2016-04-05
Posts: 177

Re: Users bugs

1. It works now thank you.

2. Please go on my sites and click on login at the top right. The link "Did not receive confirmation email?" goes to http://www.domain.com/user/lost/ . Could you please let me know how to fix this?

3. I still have this bug, I sent you an email. I'm not sure, but i think this bug happen to users who created account when 1) wasn't fixed.

Last edited by happylag (2017-04-25 14:10:19)

Offline

Board footer

Powered by FluxBB