View Single Post
Old December 7th, 2004, 05:54 PM   #5 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,752
Okay but what I am saying regardless is your should use the init_usergroups function in the new file and then populate the inserts. Your missing important features if your using a n old usergroups structure.

This is what I see in the threads file

$query[] = "CREATE TABLE {$pp_db_prefix}usergroups (groupid int(5) NOT NULL auto_increment,
groupname varchar(50) NOT NULL default '',
cpaccess smallint(3) NOT NULL default '0',
modaccess smallint(3) NOT NULL default '0',
uploads smallint(3) NOT NULL default '1',
comments smallint(3) NOT NULL default '1',
uploadsize int(10) default NULL,
editpho int(3) NOT NULL default '0',
editposts int(3) NOT NULL default '0',
reqmod INT(3) DEFAULT '0' NOT NULL,
highlight INT(3) DEFAULT '0' NOT NULL,
bold INT(3) DEFAULT '0' NOT NULL,
italic INT(3) DEFAULT '0' NOT NULL,
PRIMARY KEY (groupid)) TYPE=MyISAM";

13 fields

Then the import usergroups function

$query="INSERT INTO {$Globals['pp_db_prefix']}usergroups (groupid,groupname,modaccess,cpaccess,uploads,comments,uploadsize,editpho,editposts,reqmod,highlight,bold,italic) VALUES('$gid','$name','$modaccess','$cpaccess','$uploads','$comments','$uploadsize','$editpho','$editposts','$reqmod', $highlite, $bold, $italic)";

again 13 fields

I see no reason it would fail
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote