News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

administrator account log_error table latest version of SMF 2.1

Started by L2Scarlet, October 23, 2019, 08:44:31 PM

Previous topic - Next topic

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. 


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


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

Holder of controversial views, all of which my own.

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


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)
)
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: