Jump to content
Sign in to follow this  
prova

Administration Access Level Accounts 2.0

Recommended Posts

hi

I tried to install the contribution Administration Access Level Accounts 2.0, just load the sql file I have a problem:

 

 

 

INSERT INTO admin_files VALUES (3, 'catalog.php', 1, 0,'1, 18 ');

 

# 1265 - Data truncated for column 'admin_groups_id' at row 1

 

 

in practice the value that does not accept is 1,18 because the database should be 1 or 2

 

# Table structure for table `admin_files`

# ---------------------------------------

 

DROP TABLE IF EXISTS admin_files;

CREATE TABLE admin_files (

admin_files_id int(11) NOT NULL auto_increment,

admin_files_name varchar(64) NOT NULL default '',

admin_files_is_boxes tinyint(5) NOT NULL default '0',

admin_files_to_boxes int(11) NOT NULL default '0',

admin_groups_id set('1','2') NOT NULL default '1',

PRIMARY KEY (admin_files_id)

);

 

 

 

What should I do?

Thanks

 

P.S. I have oscommerce version 2.2 rc2a you can find contribution at http://addons.oscommerce.com/info/1359

Share this post


Link to post
Share on other sites

I've run into the same problem.

 

What version of PHP are you using?

 

--

 

This worked for me - allowing me to run the SQL. The data is being cut off, and instead of MYSQL just cutting it off - it's returning the error that's it's being cut off.

 

(Also apparently relates to MYSQL 5 not allowing a space in a float field.)

 

 

In my.ini put sql-mode=MYSQL40, and restart the mysql server.

 

 

I commented it out back out of my.ini after I ran the SQL.

 

 

hi

I tried to install the contribution Administration Access Level Accounts 2.0, just load the sql file I have a problem:

 

 

 

INSERT INTO admin_files VALUES (3, 'catalog.php', 1, 0,'1, 18 ');

 

# 1265 - Data truncated for column 'admin_groups_id' at row 1

 

 

in practice the value that does not accept is 1,18 because the database should be 1 or 2

 

# Table structure for table `admin_files`

# ---------------------------------------

 

DROP TABLE IF EXISTS admin_files;

CREATE TABLE admin_files (

admin_files_id int(11) NOT NULL auto_increment,

admin_files_name varchar(64) NOT NULL default '',

admin_files_is_boxes tinyint(5) NOT NULL default '0',

admin_files_to_boxes int(11) NOT NULL default '0',

admin_groups_id set('1','2') NOT NULL default '1',

PRIMARY KEY (admin_files_id)

);

 

 

 

What should I do?

Thanks

 

P.S. I have oscommerce version 2.2 rc2a you can find contribution at http://addons.oscommerce.com/info/1359

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×