| View previous topic :: View next topic |
| Author |
Message |
Evaders99
Joined: Jan 11, 2002
Posts: 3049
Location: USA
|
 Posted: Sun Jan 21, 2007 2:59 am Post subject: FIX: SQL Errors |
 |
|
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 Sun Feb 11, 2007 2:17 am; edited 1 time in total |
|
| Back to top |
|
 |
Evaders99
Joined: Jan 11, 2002
Posts: 3049
Location: USA
|
| Posted: Mon Jan 22, 2007 6:51 pm Post subject: |
|
|
| Code: |
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 -
The cake is a lie. |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3049
Location: USA
|
| Posted: Thu Mar 01, 2007 10:55 pm Post subject: |
|
|
| Code: |
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 -
The cake is a lie. |
|
| Back to top |
|
|
blackhawk
Newbie
Joined: Mar 21, 2008
Posts: 1
|
| Posted: Fri Mar 21, 2008 4:11 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
Evaders99
Joined: Jan 11, 2002
Posts: 3049
Location: USA
|
| Posted: Mon Mar 24, 2008 10:32 pm Post subject: |
|
|
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 -
The cake is a lie. |
|
| Back to top |
|
|
|
![Welcome to Evaders Squadron Coding [ESC]](themes/Onset/images/logo.gif){kind=logo}
