Hall of Fame

[tatilvitrini]

Hi.

I have problem with Edit user to make moderator access but

Warning: Invalid argument supplied for foreach() in /home/izlekop/public_html/dev/moderator/edit-user.php on line 60

Can you help me about it plase

[tatilvitrini]

Someone will help me ?

[PHPVibe A.]

Hi, can you check if the database data is installed (groups table is populated)?
Please use the search, this way you will find fast what you need and not have to wait for an answer from us.

http://www.phprevolution.com/forum/troubleshooting-issues/user-group-not-working/

[tatilvitrini]

ow I see there no tables. can you send me the vibe_users_group.sql?

[PHPVibe A.]

ow I see there no tables. can you send me the vibe_users_group.sql?

Table or data?

[PHPVibe A.]

Go to phpmyadmin, open your database and run this via the sql tab:

Code Select Expand

INSERT INTO `#db-prefix#users_groups` (`id`, `name`, `admin`, `default_value`, `access_level`) VALUES
(1, 'Administrators', 1, 0, 3),
(4, 'Members', 0, 1, 1),
(3, 'Author', 0, 2, 2),
(2, 'Moderators', 0, 2, 2);

BEFORE change #db-prefix# to your prefix of table, vibe_, or what you have chosen.

[tatilvitrini]

How I can run ? I am very bad with database sql

[PHPVibe A.]

If by any chance it's not there:

Code Select Expand

CREATE TABLE IF NOT EXISTS `#dbprefix#users_groups` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_swedish_ci NOT NULL,
  `admin` tinyint(1) NOT NULL,
  `default_value` tinyint(1) NOT NULL,
  `access_level` bigint(32) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=0 ;

Again, attention to the prefix.

[PHPVibe A.]

Do you have phpmyadmin?

[tatilvitrini]

yes I have

[PHPVibe A.]

If your prefix is "vibe_", just navigate in phpmyadmin to your database, select it with click, select the "SQL" tab and paste this

Code Select Expand

INSERT INTO `vibe_users_groups` (`id`, `name`, `admin`, `default_value`, `access_level`) VALUES
(1, 'Administrators', 1, 0, 3),
(4, 'Members', 0, 1, 1),
(3, 'Author', 0, 2, 2),
(2, 'Moderators', 0, 2, 2);

then click "Go".

If not, change vibe_ with your prefix, before executing the sql.

[tatilvitrini]

Thanks. it worked well

[PHPVibe A.]

Glad to help!