Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Topic started by: sits on September 30, 2005, 08:45:54 AM

Title: Upgrade Database Error
Post by: sits on September 30, 2005, 08:45:54 AM
After running the upgrade - SMF 1.1 RC1. I can't log-on, I keep getting this Error..


Database Error..
Please try again. If you come back to this error screen, report the error to an administrator. 

Has anyone else had this problem?..and if so, what to do?

See Forum Here! (http://www.thyself.org/smf/)

Thanks in-advance,
sits~
Title: Re: Upgrade Database Error
Post by: Ben_S on September 30, 2005, 08:47:22 AM
Any mods installed?
Title: Re: Upgrade Database Error
Post by: sits on September 30, 2005, 08:55:49 AM
Yes, 1 .. [Ultimate ShoutBox]
Title: Re: Upgrade Database Error
Post by: Oldiesmann on September 30, 2005, 09:27:33 AM
In order to get the actual error message...

Sources/Errors.php

Code (find) Select
// Show an error message, if possible.
$context['error_title'] = $txt[1001];
if (allowedTo('admin_forum'))
$context['error_message'] = nl2br($query_error) . '<br />' . $txt[1003] . ': ' . $file . '<br />' . $txt[1004] . ': ' . $line;
else
$context['error_message'] = $txt[1002];


Code (replace) Select
// Show an error message, if possible.
$context['error_title'] = $txt[1001];
// if (allowedTo('admin_forum'))
$context['error_message'] = nl2br($query_error) . '<br />' . $txt[1003] . ': ' . $file . '<br />' . $txt[1004] . ': ' . $line;
/* else
$context['error_message'] = $txt[1002];*/
Title: Re: Upgrade Database Error
Post by: sits on September 30, 2005, 09:45:03 AM
1st, Thank you! :)

I did what you suggested and received this Error:
Unknown column 'lngfile' in 'field list'
File: /var/www/html/smf/Sources/LogInOut.php
Line: 208


208. LIMIT 1", __FILE__, __LINE__);

But, I don't know where to go from there..help again?

Thanks,
sits~
Title: Re: Upgrade Database Error
Post by: Oldiesmann on September 30, 2005, 10:05:56 AM
Download smf_1-1-rc1_upgrade.zip, extract upgrade.php and upgrade_1-1.sql, upload both files to your SMF directory and run upgrade.php. That should fix the problem.
Title: Re: Upgrade Database Error
Post by: sits on September 30, 2005, 10:29:57 AM
I did what you suggested and received this Error Again..

Unknown column 'lngfile' in 'field list'
File: /var/www/html/smf/Sources/LogInOut.php
Line: 208


The upgrade was successful, so it said..?  what now..? .. this is frustrating..Lol..:)
sits~
Title: Re: Upgrade Database Error
Post by: Oldiesmann on September 30, 2005, 10:59:38 AM
Run this query.

ALTER TABLE smf_members ADD lngfile tinytext NOT NULL default '', ADD KEY(lngfile(30));
Title: Re: Upgrade Database Error
Post by: sits on September 30, 2005, 11:47:14 AM

Thank you..that ablest allowed me to log on, but on child-boards - [veiw profile] - [stats] - and a few other thing I keep getting this Error:..


Title: Re: Upgrade Database Error
Post by: Oldiesmann on September 30, 2005, 01:39:44 PM
Looks like your members table got screwed up when you were upgrading. I'm not sure how many columns are missing, so the easiest way to make sure everything gets done properly is to do the following:

First, run this query:
UPDATE smf_settings SET smfVersion = '1.0.5';

Then, upload upgrade.php, upgrade_1-0.sql and upgrade_1-1.sql to your SMF directory and run upgrade.php again. This time it will think you're upgrading from an older version of SMF, and therefore it will re-create all the tables for you.