Masking Problems

Started by bros, April 12, 2008, 10:28:17 PM

Previous topic - Next topic

metallica48423

you don't necessarily need to drop it unless the SQL specifies it will try to create it again, but to avoid duplicate key errors you need to truncate it.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

#41
Quote from: metallica48423 on May 03, 2008, 12:41:28 AM
you don't necessarily need to drop it unless the SQL specifies it will try to create it again, but to avoid duplicate key errors you need to truncate it.

nm. i'll run it in a bit

bros

BigDump: Staggered MySQL Dump Importer v0.29b
Processing file: smf perm.sql

Starting from line: 1

Error at the line 30: INSERT INTO `smf_permissions` VALUES(10, 'arcade_favorite', 1);

Query: -- phpMyAdmin SQL Dump
--
--
--
--
--
CREATE TABLE `smf_permissions` (
`id_group` smallint(5) NOT NULL default '0',
`permission` varchar(30) NOT NULL default '',
`add_deny` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id_group`,`permission`)
--
--
INSERT INTO `smf_permissions` VALUES(10, 'arcade_favorite', 1);


MySQL: 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 '-- phpMyAdmin SQL Dump -- -- -- -- -- CREATE TABLE `smf_permissions` ( `id_' at line 1

bros


metallica48423

can you post the first 20 lines of your sql dump?
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

Quote from: metallica48423 on May 04, 2008, 06:31:22 PM
can you post the first 20 lines of your sql dump?


-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 01, 2008 at 07:46 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `thecastl_smf1`
--

-- --------------------------------------------------------

--
-- Table structure for table `smf_permissions`
--

CREATE TABLE `smf_permissions` (
  `id_group` smallint(5) NOT NULL default '0',
  `permission` varchar(30) NOT NULL default '',
  `add_deny` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id_group`,`permission`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `smf_permissions`
--

first 31 lines

metallica48423

remove the


it shouldn't be there
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

Removed it

It said it worked.

Now lets see if people can create masks

bros


bros


bros


metallica48423

i added 'manage membergroups' to a test member on my board, and they had access to create new membergroups (we don't use 'masks').

What happens when they try?  can you take a screenshot?

Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

Quote from: metallica48423 on May 08, 2008, 02:53:14 PM
i added 'manage membergroups' to a test member on my board, and they had access to create new membergroups (we don't use 'masks').

What happens when they try?  can you take a screenshot?



Okay. Membergroup, mask, same thing. Mask is shorter to type :D

I think that the membergroup part of the admin panel isn't there when they try.

metallica48423

it was for mine, thats strange.

I'm about fresh out of ideas... i might need to have someone else take a look
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

Quote from: metallica48423 on May 09, 2008, 04:19:29 PM
it was for mine, thats strange.

I'm about fresh out of ideas... i might need to have someone else take a look

k


bros


metallica48423

can you attach a picture of that group's permissions settings?
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

Quote from: metallica48423 on May 11, 2008, 01:59:02 AM
can you attach a picture of that group's permissions settings?

Is it just me or did the text get reallllly small here.

hard to read.





metallica48423

That is strange.  someone else might need to take a look at this because i really am fresh out of ideas on what could be going on.

Does the show permissions page for the user in question show that they have the manage and assign membergroups permission?
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

bros

Quote from: metallica48423 on May 11, 2008, 03:36:17 PM
That is strange.  someone else might need to take a look at this because i really am fresh out of ideas on what could be going on.

Does the show permissions page for the user in question show that they have the manage and assign membergroups permission?


Advertisement: