yes, but how can I create them. Does serweb is very usefull? thanks, Eliass Daniel-Constantin Mierla wrote: > 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 >>> >> >
_______________________________________________ Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
