Posted: Sun Jan 21, 2007 2:59 am Post subject: FIX: SQL Errors user_login_tries, user_last_login_try
If you get the following error
Code:
SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'
Run this in phpMyAdmin to create that field
Code:
ALTER TABLE nuke_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
_________________ Evaders99 Webmaster Administrator Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
The cake is a lie.
Last edited by Evaders99 on Thu Feb 05, 2009 8:38 pm; edited 3 times in total
SQL Error : 1054 Unknown column 'user_last_login_try' in 'field list'
Run this in phpMyAdmin
Code:
ALTER TABLE nuke_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;
_________________ Evaders99 Webmaster Administrator Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
SQL Error : 1054 Unknown column 'session_admin' in 'field list'
Run this in phpMyAdmin
Code:
ALTER TABLE nuke_bbsessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL
_________________ Evaders99 Webmaster Administrator Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
hello im new here and to phpnuke too, i had that problem mentioned as first and second post and fixed it with the code viy phpMyAdmin, than the login worked but unfortunately a blank screen appears.
When i enter the bb forum via the link in navigation bar i can see im logged in but i cant post or reply anything couse only a blank screen apears. Navigation on the forum works normal.
When i login via my user account no blank screen appears when i like to post or reply but i wanted to fix that forum login error and dont use that way everytime. When i login via user account im in the forum in too, but when i login in forum im not in my user account logged in ? Is that normal ?
Thanks for helping a noob yeah phpnuke is newland for me...
Would be nice if someone can help me out, thanks
The forums login is buggy. I recommend you only use the Your_Account module and delete the links to login from the Forums _________________ Evaders99 Webmaster Administrator Fighting is terrible, but not as terrible as losing the will to fight.
- SW:Rebellion Network - Evaders Squadron Coding -
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
![Welcome to Evaders Squadron Coding [ESC]](themes/Onset/images/esc_reflect.png)
yeah phpnuke is newland for me...