administrator account log_error table latest version of SMF 2.1

[L2Scarlet]

Hi SMF team, I have this problem when I want to login on administrator account ONLY! (With other users everything is ok)
What happened before this error with "log_errors", my database was offline and after database was restarted I got this error ...
(I use SSI.php on all my external webpages) but I can't login as admin, please help. 

Code Select Expand


array(13) { [0]=> array(3) { ["file"]=> string(80)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs-Db-mysql.php" ["line"]=> int(585) ["function"]=> string(9) "log_error" } [1]=> array(3) { ["file"]=> string(80)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs-Db-mysql.php" ["line"]=> int(489) ["function"]=> string(12) "smf_db_error" } [2]=> array(3) { ["file"]=> string(73)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [3]=> array(3) { ["file"]=> string(80)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs-Db-mysql.php" ["line"]=> int(585) ["function"]=> string(9) "log_error" } [4]=> array(3) { ["file"]=> string(80)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs-Db-mysql.php" ["line"]=> int(489) ["function"]=> string(12) "smf_db_error" } [5]=> array(3) { ["file"]=> string(73)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Errors.php" ["line"]=> int(138) ["function"]=> string(12) "smf_db_query" } [6]=> array(3) { ["file"]=> string(80)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs-Db-mysql.php" ["line"]=> int(585) ["function"]=> string(9) "log_error" } [7]=> array(3) { ["file"]=> string(80)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs-Db-mysql.php" ["line"]=> int(489) ["function"]=> string(12) "smf_db_error" } [8]=> array(3) { ["file"]=> string(71)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs.php" ["line"]=> int(4764) ["function"]=> string(12) "smf_db_query" } [9]=> array(3) { ["file"]=> string(71)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs.php" ["line"]=> int(3516) ["function"]=> string(16) "setupMenuContext" } [10]=> array(3) { ["file"]=> string(71)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs.php" ["line"]=> int(3673) ["function"]=> string(17) "setupThemeContext" } [11]=> array(3) { ["file"]=> string(71)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/Sources/Subs.php" ["line"]=> int(3295) ["function"]=> string(15) "template_header" } [12]=> array(3) { ["file"]=> string(64)
"/home/xxxxxxxxxx/xxxxxxxxxx/xxxxxxxxxx.com/public_html/forum/index.php" ["line"]=> int(166) ["function"]=> string(6) "obExit" } } Error loop.


[L2Scarlet]

0 replies, really ?

Support section isn't free, right? )

[Illori]

support here is free. you have not even waited 24 hours for a reply. remember this support forum is not real time support. we reply if and when we have something to add to the topic.

[Arantor]

2.1 version what, exactly?

[L2Scarlet]

Thank you.

In my post I said that I use latest version of 2.1 so that means it's 2.1 RC2
https://www.simplemachines.org/community/index.php?topic=570249.0


2.1 RC2 (installed from .zip archive, from download section)


P.S. enableErrorLogging 1 (enabled).
I thought it was from sessions but it's not. I can log in with normal users.
I think it's something between admin account and log_errors when you tried to log in to admin acc. because with normal users is working perfectly. !!

What do I need to do to get back on my admin, please? Thanks in advance. (I have access only to phpMyAdmin)

[Illori]

SMF 2.1 RC2 is not the latest version there is a more updated version on GitHub which is why we asked.

[L2Scarlet]

yes, you're right. I forgot about github and the development place.
Yes, I installed the RC2 from forum (and not Github).

I got access to my admin again but I disabled the errors.
enableErrorLogging = 0 (from PhPMyAdmin)

There is something weird between errors and the admin interface. FIX IT please (at least in the forum download section - the most downloaded version). Ty

[Illori]

do you have any mods installed?

we will not release a new version on the site here until we are well ready, we recommend users to download off GitHub and install that version since it has been a while since a release was made.

[L2Scarlet]

Yes, I have mods installed like.. PrettyURLs and DiscordHook, tha's all.

I get this in forum Maintenance when I wanted to clean/empty logs.

Table 'xxxxxx.smf_log_errors' doesn't exist in engine

In PhPMyAdmin the same. DO I need to reinstall that smf_log_errors table? Where can I get one for 2.1 RC2? (I don't want to reinstall the entire forum again to generate that missing table)

[vbgamer45]

Strange...
You can create a table manually

Code Select Expand



CREATE TABLE {$db_prefix}log_errors (
id_error MEDIUMINT UNSIGNED AUTO_INCREMENT,
log_time INT(10) UNSIGNED NOT NULL DEFAULT '0',
id_member MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
ip VARBINARY(16),
url TEXT NOT NULL,
message TEXT NOT NULL,
session VARCHAR(128) NOT NULL DEFAULT '',
error_type CHAR(15) NOT NULL DEFAULT 'general',
file VARCHAR(255) NOT NULL DEFAULT '',
line MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
backtrace VARCHAR(10000) NOT NULL DEFAULT '',
PRIMARY KEY (id_error),
INDEX idx_log_time (log_time),
INDEX idx_id_member (id_member),
INDEX idx_ip (ip)
)