DropShipping/Supplier Interface

[evildee]

I get this error when trying to apply the sql patch. Does anyone know how to fix this?

SQL query:     
              -- --------------------------------------------------------
-- 
-- Table structure for table `supplier_admin_groups`
-- 
 CREATE  TABLE  `supplier_admin_groups` ( `supplier_admin_group_id` int( 10  ) unsigned NOT  NULL  AUTO_INCREMENT ,
 `supplier_id` int( 10  ) unsigned NOT  NULL ,
 `supplier_admin_group_enabled` tinyint( 1  )  NOT  NULL ,
 `supplier_admin_group_name` varchar( 32  )  NOT  NULL ,
 `supplier_admin_group_issuperadmin` tinyint( 1  )  NOT  NULL default  '0',
 PRIMARY  KEY (  `supplier_admin_group_id`  ) 
) ENGINE  =  MYISAM DEFAULT CHARSET  = utf8;

     
      MySQL said:  
  #1064 - 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 'DEFAULT CHARSET=utf8' at line 8

[tajul_ashyqin]

I get this error when trying to apply the sql patch. Does anyone know how to fix this?

SQL query:     
              -- --------------------------------------------------------
-- 
-- Table structure for table `supplier_admin_groups`
-- 
 CREATE  TABLE  `supplier_admin_groups` ( `supplier_admin_group_id` int( 10  ) unsigned NOT  NULL  AUTO_INCREMENT ,
 `supplier_id` int( 10  ) unsigned NOT  NULL ,
 `supplier_admin_group_enabled` tinyint( 1  )  NOT  NULL ,
 `supplier_admin_group_name` varchar( 32  )  NOT  NULL ,
 `supplier_admin_group_issuperadmin` tinyint( 1  )  NOT  NULL default  '0',
 PRIMARY  KEY (  `supplier_admin_group_id`  ) 
) ENGINE  =  MYISAM DEFAULT CHARSET  = utf8;

     
      MySQL said:  
  #1064 - 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 'DEFAULT CHARSET=utf8' at line 8

Try to copy and paste it thru the 'Install SQL Patches'. You can access it thru admin in the 'Tools' menu. Good luck...

[jezjones29]

This is a great add on - thank you for your hard work!

As soon as I installed it I new it was what I was looking for. I have changed the header_navigation.php file and removed all the extra links like:

require(DIR_WS_BOXES . 'configuration_dhtml.php');*/

One note, I don't think that the 'Edit suppliers to categories/products link' section is working correctly. I had to do a hack on my database to allow my user to access the categories they where assigned to.
The problem is that a) the database doesn't get updated when an admin assigns b) the database isn't updated with all the root cat ID's

For example to access the child of a parent, the parent must also be assigned to the user.. I hope that makes sense?

[tajul_ashyqin]

This is a great add on - thank you for your hard work!

As soon as I installed it I new it was what I was looking for. I have changed the header_navigation.php file and removed all the extra links like:

require(DIR_WS_BOXES . 'configuration_dhtml.php');*/

One note, I don't think that the 'Edit suppliers to categories/products link' section is working correctly. I had to do a hack on my database to allow my user to access the categories they where assigned to.
The problem is that a) the database doesn't get updated when an admin assigns b) the database isn't updated with all the root cat ID's

For example to access the child of a parent, the parent must also be assigned to the user.. I hope that makes sense?

did you mean that the mod is working soon after installation?!

[evildee]

Try to copy and paste it thru the 'Install SQL Patches'. You can access it thru admin in the 'Tools' menu. Good luck...

I've tried that too. No luck. Maybe because I'm running 1.3.6?

[bettysue]

Does anyone know if this mod is compatible with v1.36?

Just want to check prior to installation.

thank you,
betty