David IQ Software Development

Well you can't use those files if you're using 2.0.18. If you did then you would probably get a blank page (as you already have). If you're going to stick to the 2.0.18 version then see if the premodified files for that version are available at sourceforge.net (search for attachment mod).

I followed these directions.... to the dot.... but I did something wrong...

Im really new to this whole deal so go really easy on me Smile


If you have no MODs installed
Step 1
Download the “Changed Files Only” from the download page at phpBB.com, and unzip it to a directory at your hard drive

Step 2
Inside of this zip you'll see several more zip files. Unzip the one that refers to the version you're updating

Step 3
Upload all those files, while overwriting all old ones. You should also upload the /install and /contrib directory which can be found in the main zip file (phpBB-2.0.xx-files.zip)

Step 4
Run /install/update_to_latest.php trough your browser, using http://www.domain.com/phpBB/install/upd ... latest.php, for example

Step 5
Delete the /contrib and /install directories from your server


Error message I got after I updated, and attempted to log in...


Error in obtaining userdata

Code:
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 = 'admin'

Line : 65
File : login.php



thank you...

Last edited by doubleatheman on Fri Jan 26, 2007 3:13 am; edited 1 time in total
Back to top
View user's profile Send private message
doubleatheman
Registered User


Joined: 25 Jan 2007
Posts: 4


PostPosted: Fri Jan 26, 2007 3:05 am Post subject: Reply with quote Edit/Delete this post
More error messages from my install file...
http://www.arcturus-uav.com/php/install ... latest.php


Code:

Information
Database type :: mysql
Previous version :: 2.0.18
Updated version :: 2.0.22

Updating database schema
Progress :: . . . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Access denied for user 'yscr_bbFLm6'@'localhost' to database 'phpbb_3'
SQL :: ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL


Error :: Access denied for user 'yscr_bbFLm6'@'localhost' to database 'phpbb_3'
SQL :: ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL


Error :: Access denied for user 'yscr_bbFLm6'@'localhost' to database 'phpbb_3'
SQL :: ALTER TABLE phpbb_search_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL


This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our development board. See README for details on how to obtain advice.

Updating data
Progress :: . . . . . . .

Updating version and optimizing tables
Progress :: . . Done
Result :: No errors

Update completed
Please make sure you have updated your board files too, this file is only updating your database.
You should now visit the General Configuration settings page in the Administration Panel and check the General Configuration of the board. If you updated from versions prior to RC-3 you must update some entries. If you do not do this emails sent from the board will contain incorrect information. Don't forget to delete this file!





Update completed
Please make sure you have updated your board files too, this file is only updating your database

Download the full 2.0.22 package from phpBB and upload all files replacing all of the old ones. DON'T upload config.php as this will make you lose your database connection settings. Once you're done uploading run install/update_to_latest.php and you're almost done. All you have to do after that is delete the contrib and install folders and that's it.

Then for attachments you download the premodified files package from here, unzip, and upload the contents to your site replacing all files, run installer/install.php, delete the installer/install.php folder, and then you're done.

. Upgrade from previous stable (released) versions of phpBB 2
If you are currently using a stable release of phpBB 2 updating to this version is straightforward. You would have downloaded one of three packages and your choice determines what you need to do. Please Note: That before upgrading we heavily recommend you do a full backup of your database and existing phpBB2 source files! If you are unsure how to achieve this please ask your hosting provider for advice.

MySQL Users Please Note: Changes introduced in 2.0.4 may increase the size of your database, more specifically the search_wordmatch table. There are other changes in that release which are designed to reduce the database size. However these additional changes may not apply to all types of forum (particularly non-English boards). While any increases will be relatively small compared to the overall database size it may be an issue for some users. In particular users on hosting plans which limit database size and where the database is near that limit.

Please make sure you update your phpBB2 source files too, even if you run the update_to_latest.php file.

Information
Database type    :: mysql
Previous version :: 2.0.18
Updated version  :: 2.0.22

Updating database schema
Progress :: . . . Done
Result   :: Some queries failed, the statements and errors are listing below 

Error :: Access denied for user 'yscr_bboL95'@'localhost' to database 'phpbb_6'
SQL   :: ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL


Error :: Access denied for user 'yscr_bboL95'@'localhost' to database 'phpbb_6'
SQL   :: ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL


Error :: Access denied for user 'yscr_bboL95'@'localhost' to database 'phpbb_6'
SQL   :: ALTER TABLE phpbb_search_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL


This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our development board. See README for details on how to obtain advice.

Updating data
Progress :: . . . . . . . 

Updating version and optimizing tables
Progress :: . . Done
Result   :: No errors 

Update completed
Please make sure you have updated your board files too, this file is only updating your database.

You should now visit the General Configuration settings page in the Administration Panel and check the General Configuration of the board. If you updated from versions prior to RC-3 you must update some entries. If you do not do this emails sent from the board will contain incorrect information. Don't forget to delete this file!

General Error 
  
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 = 'admin'

Line : 65
File : login.php 
 

Check to see what database permissions the yscr_bboL95 user has. You should be able to figure this out by looking through your database section in your site's control panel. Most likely the auto-setup doesn't give alter permissions to the database user