Install Error Message

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
commanderyoda
Registered User
Posts: 169
Joined: Tue Sep 07, 2004 12:18 am

Install Error Message

Post by commanderyoda »

Ok . . . I already have a functioning message board with Yahoo as a host. Then I tried to set up a second board and got the below debug error message. I've seen it before and I've tried serveal times to reinstall but it keeps repeating. I create the install and contrib folders, then launch the install file and then delete the install and contrib folders but still I get the below message. What have I done wrong?

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 phpbb_users WHERE username = 'Cobra'

Line : 65
File : login.php

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

When restoring a database from an older version of PHPBB onto a current board, you must upload the install/ directory from the PHPBB archive, run install/update_to_latest.php to make the data "correct", then remove the install/ directory.

The error should go away, assuming that YAHOO gave your MySQL user the privileges needed to alter tables... Sometimes, they don't, and you have to manually do the changes, through phpmyadmin (which generally will have a higher-privilege username attached to it).
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

Locked

Return to “2.0.x Support Forum”