Not Solved [Error Message] Invalid argument supplied for foreach()
#1
Not Solved
Hi there!

I have a problem recently: I can no longer see my users.

How did this problem arise?

Well, I just wanted to reset auto_increment in users so everything would start from 1 again, because my userid was already at 17 - don't ask me why because I don't know myself. Could someone please help me with this error, please?

I would not like to lose the plugins that I have just about updated to my own liking.

Thanks for the help!  Heart


Attached Files Thumbnail(s)
   
Reply
#2
Not Solved
What MyBB version are you running?
-Ben

Please do not PM me for support. I am looking to be hired for paid services.

You can view my paid services here.
Reply
#3
Not Solved
I don't understand the obsession with having tidied table identifiers to such extend.
Reply
#4
Not Solved
Be very careful when manipulating ID's. It could only make sense to modify uid in mybb_users on an empty forum.
A uid is tied to many other tables like threads, posts etc.

For a repair, get your recent registered user id from mybb_users (highest value) and set auto-increment to +1,
E.g. current user uid's in mybb_users: 1, 2, 3, 5, 7, 12, 13, 14, 22, 23
Set auto-increment to 24 to be safe.
Ensure there are no uid references to accounts with a uid higher than 23 in other tables (threads, posts, ratings, PM) to avoid coontent mismatches!

[ExiTuS]
[Image: logo_wernicke_8040.png]
MyBB Forum + innovative full-responsive Theme
Live-Escape-Game-Forum
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)