Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#529 2008-03-20 02:18:16

typeshige
Member
From: USA
Registered: 2005-08-11
Posts: 151
Website

Re: ign_password_protect

I can’t seem to download the newest version. Nothing happens when I click the link.

Thanks,
Shige

Offline

#530 2008-03-20 14:03:12

Niconemo
Member
From: Rhône-Alpes, France
Registered: 2005-04-18
Posts: 557

Re: ign_password_protect

It’s working for me now. No problem for downloading, installing and activating.

Thank you, igner !

Last edited by Niconemo (2008-03-20 14:05:46)


Nico

Offline

#531 2008-03-20 16:58:44

typeshige
Member
From: USA
Registered: 2005-08-11
Posts: 151
Website

Re: ign_password_protect

The problem I had with downloading was on my side…

I’m experimenting with the plugin now and I always see this message at the top of the login form.

“There was a problem logging in.”

I had been using Rudd’s privileged plugin too. So I tried turning that off in case there was a conflict. Then I cleared all my private variables but none of those two things worked.

Do you know what I should look out for?

Offline

#532 2008-03-27 14:18:07

progre55
Member
Registered: 2006-05-02
Posts: 668

Re: ign_password_protect

igner:

First off, thanks for the great plug in.

Recently I had to transfer a client’s site from one host to another. I made a mySQL backup and then imported it into the new location. Everything worked great (all tables imported and are working correctly), except:

  • It would not let me import the `txp_priv` table (I get a cannot have null value message …)
  • When I go to look at the extensions tab, I get a “Restricted Area” message (because I am sure it can not get to (see) ign_user_mgmt)

Now the ign_users table is present and working. I know it is working because I can log into the website using existing user names and passwords. Obviously, my problem is moving forward …

I am running: 0.4.2d of the plug in. I have modified the $ign_levels = array to add additional levels and then when new accounts are created, an appropriate level is assigned to them …

I know the above are inter-connected, if you could give me some guidance it would be greatly appreciated.

Thank you in advance for your assistance.

progre55

Last edited by progre55 (2008-03-27 14:20:06)

Offline

#533 2008-03-27 17:42:47

igner
Plugin Author
Registered: 2004-06-03
Posts: 337

Re: ign_password_protect

@typeshige – are you still having issues with the login form?

@progre55 – What version of TXP are you using?


And then my dog ate my badger, and the love was lost.

Offline

#534 2008-03-27 17:57:58

progre55
Member
Registered: 2006-05-02
Posts: 668

Re: ign_password_protect

igner:

On the new host, the v.4.0.6

On the old host, an older version (not sure exactly which one)

progre55

Last edited by progre55 (2008-03-27 17:58:10)

Offline

#535 2008-03-27 18:10:02

igner
Plugin Author
Registered: 2004-06-03
Posts: 337

Re: ign_password_protect

Hmm, if I had to guess, I’d suspect that there’s something in the txp_privs table that’s giving you trouble. only a user registered as an ‘admin’ in the back-end can see that tab, so double-check that that user you’re logged in as has admin privileges.


And then my dog ate my badger, and the love was lost.

Offline

#536 2008-03-27 21:20:48

progre55
Member
Registered: 2006-05-02
Posts: 668

Re: ign_password_protect

Inger:

Makes sense, because right now I do not even have a txp_privs table. when I tried to import it, I got error message (with only this table) that it could not import because of “null” values … all of the other tables imported without any errors …

Below is my priv_table

Table structure for table `txp_priv`

CREATE TABLE txp_priv (
  id int(8) NOT NULL auto_increment,
  priv varchar(128) NOT NULL default '',
  1 tinyint(1) NOT NULL default '0',
  2 tinyint(1) NOT NULL default '0',
  3 tinyint(1) NOT NULL default '0',
  4 tinyint(1) NOT NULL default '0',
  5 tinyint(1) NOT NULL default '0',
  6 tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

Data for table `txp_priv`

INSERT INTO txp_priv VALUES (1, 'admin', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (2, 'admin.edit', 1, 0, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (3, 'admin.list', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (4, 'article.delete.own', 1, 1, 1, 1, 0, 0);
INSERT INTO txp_priv VALUES (5, 'article.delete', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (6, 'article.edit', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (7, 'article.edit.published', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (8, 'article.edit.own', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (9, 'article.edit.own.published', 1, 1, 1, 1, 0, 0);
INSERT INTO txp_priv VALUES (10, 'article.publish', 1, 1, 1, 1, 0, 0);
INSERT INTO txp_priv VALUES (11, 'article.php', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (12, 'article', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (13, 'list', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (14, 'category', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (15, 'css', 1, 1, 0, 0, 0, 1);
INSERT INTO txp_priv VALUES (16, 'diag', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (17, 'discuss', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (18, 'file', 1, 1, 1, 1, 0, 1);
INSERT INTO txp_priv VALUES (19, 'form', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (20, 'image', 1, 1, 1, 1, 0, 1);
INSERT INTO txp_priv VALUES (21, 'import', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (22, 'link', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (23, 'log', 1, 1, 1, 0, 0, 0);
INSERT INTO txp_priv VALUES (24, 'page', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (25, 'plugin', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (26, 'prefs', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (27, 'section', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (28, 'tab.admin', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (29, 'tab.content', 1, 1, 1, 1, 1, 1);
INSERT INTO txp_priv VALUES (30, 'tab.extensions', 1, 1, 0, 0, 0, 0);
INSERT INTO txp_priv VALUES (31, 'tab.presentation', 1, 1, 1, 0, 0, 1);
INSERT INTO txp_priv VALUES (32, 'tag', 1, 1, 1, 1, 1, 1);

One last thing, I just looked at a recent TXP install (without the plug in) and there is no priv table. Is this added when the plug in is installed?

thanks for your assistance.

progre55

Last edited by progre55 (2008-03-27 21:23:25)

Offline

#537 2008-03-27 21:36:04

igner
Plugin Author
Registered: 2004-06-03
Posts: 337

Re: ign_password_protect

very odd – though unrelated to the pass_protect plugin.
What I’d try is to add the table, then run the inserts one by one to see which is failing, and correct that item. Though I don’t see any line items that’d cause a failure…


And then my dog ate my badger, and the love was lost.

Offline

#538 2008-03-28 14:24:44

progre55
Member
Registered: 2006-05-02
Posts: 668

Re: ign_password_protect

Inger:

I tried to load just that table, and this is the exact error I am receiving:

—————————————————————

SQL-query:

Table structure for table `txp_priv`

CREATE TABLE txp_priv(

id int( 8 ) NOT NULL AUTO_INCREMENT ,
priv varchar( 128 ) NOT NULL default ‘’,
1tinyint( 1 ) NOT NULL default ‘0’,
2tinyint( 1 ) NOT NULL default ‘0’,
3tinyint( 1 ) NOT NULL default ‘0’,
4tinyint( 1 ) NOT NULL default ‘0’,
5tinyint( 1 ) NOT NULL default ‘0’,
6tinyint( 1 ) NOT NULL default ‘0’,
PRIMARY KEY ( id )
) TYPE = MYISAM
MySQL said:

  1. - 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 ’1 tinyint(1) NOT NULL default ‘0’, 2 tinyint(1) NOT NULL def

—————————————

Any suggestions.

progre55

Last edited by progre55 (2008-03-28 14:25:34)

Offline

#539 2008-03-28 15:04:12

igner
Plugin Author
Registered: 2004-06-03
Posts: 337

Re: ign_password_protect

that is missing the space before every instance of tinyint. It should be
. . . 1 tinyint( 1 ) NOT NULL default ‘0’, 2 tinyint( 1 ) NOT NULL default ‘0’, 3 tinyint( 1 ) NOT NULL default ‘0’, 4 tinyint( 1 ) NOT NULL default ‘0’, 5 tinyint( 1 ) NOT NULL default ‘0’, 6 tinyint( 1 ) NOT NULL default ‘0’, ...


And then my dog ate my badger, and the love was lost.

Offline

#540 2008-03-28 15:10:52

progre55
Member
Registered: 2006-05-02
Posts: 668

Re: ign_password_protect

Inger:

When I am loading the file … the space is there:

Table structure for table `txp_priv`

CREATE TABLE txp_priv (
  id int(8) NOT NULL auto_increment,
  priv varchar(128) NOT NULL default '',
  1 tinyint(1) NOT NULL default '0',
  2 tinyint(1) NOT NULL default '0',
  3 tinyint(1) NOT NULL default '0',
  4 tinyint(1) NOT NULL default '0',
  5 tinyint(1) NOT NULL default '0',
  6 tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

I double checked. I am not sure wehy when it throws the erro everything is bunched.

progre55

Last edited by progre55 (2008-03-28 15:18:14)

Offline

Board footer

Powered by FluxBB