Elkarte icon indicating copy to clipboard operation
Elkarte copied to clipboard

The database value you're trying to insert does not exist: group_list

Open emanuele45 opened this issue 6 years ago • 15 comments

    no_session_data
    Type of error: Critical
    The database value you're trying to insert does not exist: group_list
    Function: boardsAllowedTo
  /index.php?action=dlattach;attach=1334;type=avatar
    File: /public/sources/Security.php
    Line: 1231

ref https://www.elkarte.net/community/index.php?topic=5204.0

emanuele45 avatar May 09 '18 11:05 emanuele45

I noticed this same error in few other places while working on my local environment.

emanuele45 avatar May 26 '18 12:05 emanuele45

I've not been able to produce this one myself .... hope you can track it down.

Spuds avatar May 26 '18 20:05 Spuds

This happens when $user_info is not set as far as I can tell, because it comes with other two errors: Notice: Undefined index: groups in sources/Security.php at Line: 1216 Warning: array_diff(): Argument #1 is not an array in sources/Security.php at Line: 1216 In the "normal flow" I'm not sure how it could happen, but in specific cases like the one reported for /index.php?action=dlattach;attach=1334;type=avatar it could be some path doesn't bring to the setting up of $user_info. Not sure how, not sure why.

emanuele45 avatar May 26 '18 22:05 emanuele45

The only thing I can think of that calls that early is a frontpage hook, its before loadUserSettings();

Spuds avatar May 26 '18 22:05 Spuds

I have this error as soon as I install 1.1.3 and visit the index. It makes my forum impossible to use. What is your PHP and MySQL version? And your host? Mine is PHP 7.2.5 with MySQL 5.7 with AwardSpace hosting.

Dinocanid avatar May 26 '18 23:05 Dinocanid

I'm testing on 7.2.5 and 5.5.60. What do you have under admin->layout->Select the action to show on the front page ? ... if you change it does it then work correctly for you?

Spuds avatar May 27 '18 12:05 Spuds

What would the link to that be? If my try to go to /admin then there's still a blank page. You can see it here.

Dinocanid avatar May 27 '18 15:05 Dinocanid

Although its the same error, it seems like a different (but perhaps related) issue since your site does not even load. Are there any errors in your php error file on the server?

Spuds avatar May 27 '18 16:05 Spuds

It seems like the site not loading was an issue with the host. I ended up switching to infinityfree (mostly because I didn't have access to the error logs, which was a big no-no) and it works without errors now.

Dinocanid avatar May 27 '18 18:05 Dinocanid

Cool ... yes some hosts go a little over board on what they lock down.

Spuds avatar May 27 '18 19:05 Spuds

Another one: https://www.elkarte.net/community/index.php?topic=5282.0

The only thing I can think of that calls that early is a frontpage hook, its before loadUserSettings();

@Spuds could it be the allowedTo call in sportal_init from SP?

emanuele45 avatar Jun 08 '18 21:06 emanuele45

Always a chance nods .. I kept trying to reproduce this running SP but have not seen the error. That however does not indicate that SP is not causing it. I'll check the code in that area to be sure as I can.

Spuds avatar Jun 09 '18 00:06 Spuds

@Spuds were we able to reproduce this one?

emanuele45 avatar Apr 07 '19 21:04 emanuele45

I've not looked into this 😞 I need to get some SP items fixed up and I'll check at it then.

Spuds avatar Apr 07 '19 21:04 Spuds

Had the same issue like original poster. Accidentally solved it by deactivating ublock (origin) and disconnect browser plugin in Firefox temporarily. Hope this helps.

eisenherzz avatar Jun 12 '19 19:06 eisenherzz

No reports of this in many years, and likely a browser or elkarte addon issue.

Spuds avatar Apr 13 '24 13:04 Spuds