user login - SQL Error

Posted: Wed Feb 01, 2006 7:25 pm

When I tried to login at the bottom of the forum I got this error message:

Quote:

Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM nuke_users WHERE username = 'balblabla'

Line : 70
File : login.php

How to fix this ?

If I would like to remove this forums login at the bottom completly where can I comment out this.

registered · Posted: Wed Feb 01, 2006 8:46 pm

Well the forums login never works anyway, but seems you're missing some fields from BBToNuke 2.0.19

Code:




ALTER TABLE nuke_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL; 


ALTER TABLE nuke_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;

Just disable the login - its in your template's index_body.tpl

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Did you run the upgrade script? I'm most certain that that code is in there.

Posted: Thu Feb 02, 2006 5:05 pm

I´m sure something went wrong with this upgrade.
The version information is phpBB 2.0.19 but I quess it isn´t.The error message above is gone, but I found another error with news and comments.It seems I need a fresh install.

Worker Joined: Jun 07, 2006 Posts: 114

I am seeing the same error message after carrying out my own installation of RavenNuke76 v2.02.02 Distro.

I do not think I have run any upgrade scripts for this yet.

How do I run the uprade script Raven is reffering to?....where is the script located?

Posted: Fri Jun 16, 2006 1:17 pm

Don't worry! You need only Evaders solution Alter Table ... because there is nothing in an upgrade script.
It s changed in the next release of RavenNuke Smile

Posted: Fri Jun 16, 2006 1:20 pm

Hi susann. thank you for taking the time to reply to this.

I am able to access my database and the tables using phpmyadmin thingy, but I do not know what the changes should be or more specifically, where to make the actual changes.

can you advise please?

Posted: Fri Jun 16, 2006 1:24 pm

To clarify, I am not sure what a column is...is it the 'lines' of information going left to right.....if it is, I do not know how to 'add a column'

Posted: Fri Jun 16, 2006 1:34 pm

At the top you have :Databases - SQL - Status - Variables - Engines - etc.

Click on sql in your database and copy this code into the empty field to execute the sql command click okay:

Quote:

ALTER TABLE nuke_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE nuke_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;

Always make a backup so you can restore if something goes wrong.

That´s all.

Posted: Fri Jun 16, 2006 1:40 pm

susann!!!!!!!!!..........GIRL POWER!!!!.......lol......thanks.....no more error...problem solved.....you STAR!!!...............thank you.

Wave

Posted: Fri Jun 16, 2006 1:55 pm

My star is Raven and Evaders too.

RavensScripts