I’m trying to setup process (Quick setup) but at step 4 I get the error report like this:”
Failed to create user:
Field ‘profile_views’ doesn’t have a default value”
What’s your suggestion? Im testing it localhost. Thanks a lot.
This issue is caused by a setting in your mysql.ini file. This issue normally pops up when using WAMP setups due to the default mysql configuration but sometimes on other web hosts. To fix it, try the following:
1) This is caused by the STRICT_TRANS_TABLES SQL mode defined in the PROGRAMDATA \MySQL\MySQL Server 5.6\my.ini file. Removing that setting and restarting MySQL should fix the problem. Look for:
sql_mode = “STRICT_TRANS_TABLE”
And remove that setting. You may have multiple settings in this field, but just remove the STRICT_TRANS_TABLE setting and it should fix your issue.
2) Other resources: See https://www.farbeyondcode.com/Solution-for-MariaDB-Field--xxx--doesn-t-have-a-default-value-5-2720.html
3) If editing that file doesn’t fix the issue, see http://dev.mysql.com/doc/refman/5.6/en/option-files.html for other possible locations of config files.
4) A quick fix would be to set a default value for profile_views in the database. But this error may pop up again if another field doesn’t have a default value.
Let me know if that helps and if I can help you any other way.
Hi, thanks a lot it’s solved. I have another question. I have an application (php, pdo, mysql) it is not a Codeigniter based app. Is it possible to join it with this super login System? Thanks
It might be possible. The difficulty will depend on your own system and how skilled you are with it. You should take a look at the application/controllers/Login.php file to see how the login/user system works.
Thanks for your help
Some questions before to buy your product.
I don’t want dashboard for user, I saw in your online documentatioon that we can use your index_check.php and login_checker.php to protect page.
I also want to have the possibilities to implant the paypal : is it to redirect the button to your product?
You can use the index_check.php to help protect pages. I’m not sure what you mean to “implant PayPal”. The PayPal feature on Pro Login allows users to buy credits to buy premium plans, which requires them being logged into the system. If you can explain to me in a little more detail of how you’d like to use it, perhaps I can offer some more insight.
Thanks for the quick reply
What I need is to use all your script without dashboard.
Example: I have an existing web page and and i wat that the person that come in must login after that on the same page I have a picture with a product and the price of it: I want that if the person click on it he use your part of script with the page of paypal .
I want to be to the only person to use the dashboard
I don’t think that will work for you. The PayPal script is designed only for purchasing credits, not products. You would need to modify it/make code changes in order for you to be able to sell products using it.
Thanks Perhaps can I find somebody that can make this
Hello i am trying to install your product but unable to install as i am getting PHP ERROR.
This is ERROR i am getting
A PHP Error was encountered
Message: touch(): open_basedir restriction in effect. File(APPPATH . �/cisessions/�/ci_sessiond3i82av99q9dttos2mbalcc9cb7um6fj) is not within the allowed path(s): (**)
Line Number: 248
A PHP Error was encountered
Message: session_write_close(): Failed to write session data using user defined save handler. (session.save_path: APPPATH . �/cisessions/�)
Line Number: 0
This error i am getting when i am trying to add website or status
DataTables warning:table id=status-table – Invalid JSON respose. For more information about this error, please see http://datatables.net/tn/1
Looks like you have session restrictions on your server’s PHP settings which aren’t letting you store user data. Have you made changes to the config file for the sessions or something?
Send me an email with your site URL and I’ll take a look
Email sent check at your end
Issue has been resolved.
Glad you got it resolved
This comment is currently being reviewed.
How to delete ci_sessions without cron-job?
Any update for phpass 0.3 to phpass 0.5 . Please include difference.
If you want to login on multiple devices, turn off secure login in the Admin Panel. This option refreshes the user’s cookies whenever they login so that all old logins become invalidated. Turning it off, it’ll allow the user to stay logged in across multiple devices.
I’m not sure what you mean by delete ci_sessions without cron-job? There isn’t a cron job at the moment that deletes ci_sessions either.
You can check out the changes to the PHPpass library here: http://www.openwall.com/phpass/
any way to automatic delete inactive sessions from ci_sessions
You could take a look at the timestamp field in ci_sessions and run checks to see whether it’s out of date or not. I’m not 100% sure how you check for “inactive” though.
Thanks for this good stuff. Is there a version of the languges files for french ?
thanks a lot.
There isn’t a french translation currently available, however you can translate it yourself by modifying the language files. There is a guide in the documentation that can help:
A user who is a regular member cannot login as Facebook login.
Why not? Is there an error message? Clicking Login with Facebook will normally generate a new account because the user is logged out at the moment they do that.
No error message. I sent email screenshot
A person who a normal member before, can not login with facebook afterwards. the system is trying to open the second record.
Our newest version update (1.9) contains many bug fixes and upgrades that you guys have reported to us. If you have something you’d like to see, send us an email at email@example.com with your request.
The following updates have been made:
Updated to latest version of CodeIgniter 3.1.6
User can now logout even if they don't choose a username
Fixed issue with Google Login
Updated Facebook SDK
User is now deleted from User Group when the User is deleted from the system
Added dropdown menu when you click on your avatar in top nav bar.
Added list of Online Members to Members List
Added Online Count to bottom of layout; can update by running cron (see documentation)
Added option to Global Settings that allow you to resize avatar uploads
Added new User Logs to the system (logs every action)
User Log page in Admin allows Admin to view all logs
Fixed bug with selecting email template language
Completely redesigned Login/Register pages, with AJAX error checking.
Fixed issue with row count when searching
Big thank you to everyone who helped report these bugs and also sent us feedback on updates! If you encounter any new bugs after this update, be sure to send us an email and we’ll help fix them right away.
A list of files that need updating is located in the documentation at:
Or in the download
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $7
Deliver better projects faster. Photos, templates & courses
Unlimited downloads. Only $29/month
Learn almost anything with
Envato Tuts+ for free
9000 free tutorials, 3000 paid courses
Designers matched perfectly to
you on Envato Studio
2000 artists ready to undertake your work