Upgrade Database Error

Started by sits, September 30, 2005, 08:45:54 AM

Previous topic - Next topic

sits

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!

Thanks in-advance,
sits~

Ben_S

Liverpool FC Forum with 14 million+ posts.

sits


Oldiesmann

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];*/
Michael Eshom
Christian Metal Fans

sits

#4
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~

Oldiesmann

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.
Michael Eshom
Christian Metal Fans

sits

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~

Oldiesmann

Run this query.

ALTER TABLE smf_members ADD lngfile tinytext NOT NULL default '', ADD KEY(lngfile(30));
Michael Eshom
Christian Metal Fans

sits


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:..


  • Unknown column 'mem.buddy_list' in 'field list'
  • File: /var/www/html/smf/Sources/Load.php
  • Line: 777


    At one time a few months back I did (try) to install the [Buddy List mod] ..but I un-installed it or I thought I did...
    Should I run the same Query again or a bit of a different one?

    Thanks again for helping,
    sits~

Oldiesmann

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.
Michael Eshom
Christian Metal Fans

Advertisement: