Topic: Create new admin - please help

Hi !!

I want creat new administrator with phpmyadmin. How??

Re: Create new admin - please help

Why not just create a new user and update their status in the profile page? tongue

Anyway, it's just a simple SQL query
UPDATE prefixusers set g_id = 1 where id = admin_id

replace prefix with the table prefix (or remove it if you have none)
replace admin_id with the id of the person you want to make admin

Re: Create new admin - please help

Thanks, but...

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'set g_id = 1 where id = 2' at line 1

sql query:

UPDATE SET g_id =1 WHERE id =2

Re: Create new admin - please help

yes, because you're missing the table name tongue
Like I said, replace prefix with the table prefix
So if the prefix for your tables is foo_ you would put foo_users as your table

Re: Create new admin - please help

sorry, but agein...

#1054 - Unknown column 'g_id' in 'field list'

sql query: UPDATE users SET g_id =1 WHERE id =2

;(

Re: Create new admin - please help

Meh, my mistake, use group_id instead of g_id tongue

So, like this:
UPDATE users SET group_id =1 WHERE id =2

Re: Create new admin - please help

OK!! Big thanks.

By the way, how with phpmyadmin (sql query) set up all users Polish language. After migration evrybody have English language...

sorry for my english.

Re: Create new admin - please help

update users set language = 'Polish'