Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Wed Feb 01, 2006 7:25 pm Reply with quote

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.
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Wed Feb 01, 2006 8:46 pm Reply with quote

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

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Wed Feb 01, 2006 11:30 pm Reply with quote

Did you run the upgrade script? I'm most certain that that code is in there.
 
View user's profile Send private message
Susann
PostPosted: Thu Feb 02, 2006 5:05 pm Reply with quote

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.
 
mrbilly
Worker
Worker


Joined: Jun 07, 2006
Posts: 114

PostPosted: Fri Jun 16, 2006 1:01 pm Reply with quote

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?
 
View user's profile Send private message
Susann
PostPosted: Fri Jun 16, 2006 1:17 pm Reply with quote

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


Last edited by Susann on Fri Jun 16, 2006 1:22 pm; edited 1 time in total 
mrbilly
PostPosted: Fri Jun 16, 2006 1:20 pm Reply with quote

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?
 
mrbilly
PostPosted: Fri Jun 16, 2006 1:24 pm Reply with quote

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'
 
Susann
PostPosted: Fri Jun 16, 2006 1:34 pm Reply with quote

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.


Last edited by Susann on Fri Jun 16, 2006 1:45 pm; edited 1 time in total 
mrbilly
PostPosted: Fri Jun 16, 2006 1:40 pm Reply with quote

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



Wave :clap:
 
Susann
PostPosted: Fri Jun 16, 2006 1:55 pm Reply with quote

Smile My star is Raven and Evaders too.

RavensScripts
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©