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~
Any mods installed?
Yes, 1 .. [Ultimate ShoutBox]
In order to get the actual error message...
Sources/Errors.php
// 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];
// 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];*/
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~
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.
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~
Run this query.
ALTER TABLE smf_members ADD lngfile tinytext NOT NULL default '', ADD KEY(lngfile(30));
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~
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.