You cannot delete a `registered`. Only higher-level users have this power. WHY??

Discuss the integration of SMF here.
Locked
higherauthority
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Wed Sep 20, 2006 4:17 am

You cannot delete a `registered`. Only higher-level users have this power. WHY??

Post by higherauthority » Wed Jan 03, 2007 5:43 am

OK I am running Joomla 1.0.12 with SMF 1.1.1  using SMF JOMLA bridge ver 1.16.   Everything seems to be fine except the other day I noticed a member that when the db sync took place I think something went wrong.  This one user it will not let me modify or anything I get this error

You cannot delete a `registered`. Only higher-level users have this power.  I am logged on as a superadmin ??????????  This is just a regular registered user.   Can some one help me I want to make them an author and make it so I can modify their info if I need to in the future
Last edited by higherauthority on Sat Jan 27, 2007 9:10 am, edited 1 time in total.

 
User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22525
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: You cannot delete a `registered`. Only higher-level users have this power. W

Post by pe7er » Wed Jan 03, 2007 7:14 am

Can you login directly into SMF with a superadmin account, and try again?
Does that give any error too?
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

higherauthority
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Wed Sep 20, 2006 4:17 am

Re: You cannot delete a `registered`. Only higher-level users have this power. WHY??

Post by higherauthority » Wed Jan 03, 2007 7:23 am

same thing

User avatar
chette
Joomla! Explorer
Joomla! Explorer
Posts: 484
Joined: Wed Aug 17, 2005 11:20 pm
Location: Pasig City, Philippines
Contact:

Re: You cannot delete a `registered`. Only higher-level users have this power. W

Post by chette » Sun Jan 14, 2007 8:17 pm

Somewhere in this forum I was given the advice to run the following:

Code: Select all

UPDATE jos_users SET gid=18 WHERE gid=1;
That solved the problem for me.

higherauthority
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Wed Sep 20, 2006 4:17 am

Re: You cannot delete a `registered`. Only higher-level users have this power. WHY??

Post by higherauthority » Thu Jan 25, 2007 5:43 am

me to  :)

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22525
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: You cannot delete a `registered`. Only higher-level users have this power. W

Post by pe7er » Fri Jan 26, 2007 8:34 am

Good to see that you've solved it!

Could you please mark your first message in this thread as "solved" ?
(Modify the first message and choose the Message Icon [solved]).
This way the list of messages shows that the question was solved, and other users can benefit from it.
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

User avatar
salim
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Tue Sep 05, 2006 10:26 am
Location: On Earth

Re: You cannot delete a `registered`. Only higher-level users have this power. W

Post by salim » Thu Apr 19, 2007 8:38 am

Look when u syn with smf bridge 1.1.6, what happens is that all username, name, password and email are inserted with following codes

Code: Select all

// if the username doesn't exist in Mambo/Joomla, create it
			$write_user = "
				INSERT INTO {$mosConfig_dbprefix}users 
					(username, name, password, email) 
				VALUES ('$smf_row[0]','$smf_row[1]','migrated','$smf_row[3]')";

u can find this codes in file located at `/administrator/components/com_smf/admin.smf.php`and function name is `function smf2mos ($option)`

that means other columns in db are left out and will take default value(s). Default value for column `gid` is `1` which mean not only you will get error but everyone else whoever will syn users with that bridge.

As mention by `chette`

Code: Select all

UPDATE jos_users SET gid=18 WHERE gid=1;
is only solution afaik. Either Joomla ppl have to change there default value of `gid` or SMF Bridge ppl have to add `gid` in their code to overcome this problem.

Regards
Faisal
The second half of a man's life is made up of nothing but the habits he has acquired during the first half. - Fyodor Dostoevsky

User avatar
mrmer1in
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Wed Jun 07, 2006 8:24 am

Re: You cannot delete a `registered`. Only higher-level users have this power. W

Post by mrmer1in » Mon May 07, 2007 1:50 pm

- SOLVED! - Solution to Error message: You cannot delete a `registered`. Only higher-level users have this power.
chette wrote: Somewhere in this forum I was given the advice to run the following:

Code: Select all

UPDATE jos_users SET gid=18 WHERE gid=1;
That solved the problem for me.
Thankyou, Thankyou, Thankyou! : ) That solved the problem for me too.  :pop

However... some people pay not understand. So, here is the basic explanation:
The Code above is an SQL statement. "jos_users" is a table in the Database. "jos" is the prefix for tables as set during installation, so in my case the statement above did not work until I changed it to "joom_users".  :)
I hope this helps anyone who is lost. PS: if you don't have access to DB, then try install a component to run queries from inside Joomla Admin panel. eg. "PU Database Admin - A database administration component for Joomla"

By the way; what the hell is GID for in the user table?  ???
Last edited by mrmer1in on Mon May 07, 2007 1:56 pm, edited 1 time in total.

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22525
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: You cannot delete a `registered`. Only higher-level users have this power. W

Post by pe7er » Mon May 07, 2007 1:58 pm

mrmer1in wrote:By the way; what the hell is GID for in the user table?  ???
GID is Group ID.

For some background info about ACL see the PDF manual at http://phpgacl.sourceforge.net/
(btw this model is not fully implemented in Joomla 1.0.x)
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

User avatar
salim
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Tue Sep 05, 2006 10:26 am
Location: On Earth

Re: You cannot delete a `registered`. Only higher-level users have this power. WHY??

Post by salim » Mon May 07, 2007 2:06 pm

Good one

i was posting `mrmer1in` - i mean i was writing him and got notification again abour GID

Special thanks to `mrmer1in ` for point out that prefix thingy and thanks pe7er for link

thanks guy

Faisal
The second half of a man's life is made up of nothing but the habits he has acquired during the first half. - Fyodor Dostoevsky

 

Locked

Return to “SMF - Simplemachines.org Forum”