Hello Eliass, you haven't created the serweb tables - phplib_id is missing. If you use serweb 0.9.x, you need them, otherwise you can change the phplib_id with id when creating the view.
Cheers, Daniel On 07/11/08 14:00, Eliass Salim wrote: > Hi Daniel, > > Here is the result of the command. > > Thanks. > > mysql> show create table openser.subscriber; > +------------+--------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------+ > | Table | Create > Table > > > > > > > > > > > | > +------------+-------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------------------------------------------------------------------------------------------------ > > > ------------------------------------------------------------------------------------------------------------------------------------ > > > ------------------------------------------------------------------------------------------------------------------------------------ > > > ------------------------------------------------------------------------------------------------------------------------------------ > > > ------------------------------------------------------------------------------------------------------------------------------------ > > > ------------------------------------------------------+ > | subscriber | CREATE TABLE `subscriber` ( > `id` int(10) unsigned NOT NULL auto_increment, > `username` varchar(64) NOT NULL default '', > `domain` varchar(64) NOT NULL default '', > `password` varchar(25) NOT NULL default '', > `first_name` varchar(64) NOT NULL default '', > `last_name` varchar(64) NOT NULL default '', > `email_address` varchar(64) NOT NULL default '', > `datetime_created` datetime NOT NULL default '1900-01-01 00:00:01', > `ha1` varchar(64) NOT NULL default '', > `ha1b` varchar(64) NOT NULL default '', > `timezone` varchar(64) default NULL, > `rpid` varchar(64) default NULL, > `vmail_password` varchar(40) default NULL, > `vmail` tinyint(1) default '1', > PRIMARY KEY (`id`), > UNIQUE KEY `account_idx` (`username`,`domain`), > KEY `username_idx` (`username`) > ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 | > +------------+---------------------------------------------------------------------------------------------------------------------- > > > -------------------------------------------------------------------------------------------------------------------------------------- > > > -------------------------------------------------------------------------------------------------------------------------------------- > > > -------------------------------------------------------------------------------------------------------------------------------------- > > > -------------------------------------------------------------------------------------------------------------------------------------- > > > -------------------------------------------------------------------------------------------------------------------------------------- > > > ------------------------------------------+ > 1 row in set (0.06 sec) > > > Daniel-Constantin Mierla wrote: >> Hi Eliass, >> >> >> >> On 07/09/08 18:04, Henning Westerholt wrote: >>> On Wednesday 09 July 2008, Eliass Salim wrote: >>> >>>> yes, but when I installed openser, I also installed webser >>>> that is what I don't understand >>>> Can you tell me which file I have to modify please. >>>> >>> >>> Hi Eliass, >>> >>> i misread your first mail, i thought you have _not_ installed the >>> SERWEB stuff and not activated SERWEB=yes in openserctlrc. Do you >>> have installed the SERWEB tables too? >>> >>> >> paste here the output of "show create table openser.subscriber' -- it >> will reveal if you have needed columns. >> >> Cheers, >> Daniel >> > -- Daniel-Constantin Mierla http://www.asipto.com _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
