SMF Support > Install and Upgrade Help

Serious ADMIN problem

<< < (2/2)

Kays:
Hi, that query is for 1.x which is one reason it don't work. The query you need to run is the following:


--- Code: ---UPDATE smf_members SET id_group = '1' WHERE member_name = 'admin'


--- End code ---

Also, you might need to change "admin" to the user name you registered with. Do check the members table to see that an account has been set up and use that name.

therealabdo:
I went to Cpanel > PhpMyAdmin > *****_SMF > SQL and copied pasted the line you have posted
 and here is what i have got

0 rows affected. ( Query took 0.0004 sec )

therealabdo:
My problem was that i don't have an ADMIN
which means i have no users! :(

what i have done is that i have created a new user
then i wrote the query with the same user name
it converted this user to Admin :D

but a new problem occurred :(
"You have not removed install.php!"

which i will start to search for a solution!

Colin:
Simply connect to FTP and delete the install.php file.

Labradoodle-360:
Also...you'd want it to be WHERE id_group = 1. Not WHERE id_group = '1', because the column id_group is an integer, not a string.

Navigation

[0] Message Index

[*] Previous page