[Serusers] serweb: "DB Error: no such table"

[Jan Janak]

On 08-07-2005 15:29, Steve Blair wrote:
> 
> Karl:
> 
>   Just for completeness let me ask if ser_mysql.sh needs to be executed 
> when updating
> from 0.9.2 to 0.9.3 stable? I would normally drop the database and 
> recreate it using this
> script but no changes have been made to the table definitions I can save 
> some time.

  There were some small last-minute changes. Some tables did not have
  columns needed by serweb. It is better to drop and recreate the tables
  if you want to be on the safe side (otherwise you will see some error
  messsages in serweb).

  SER is not affected, you only need to upgrade if you are using serweb.

    Jan.

> 
> 
> Thanks,Steve
> 
> Karel Kozlik wrote:
> 
> >Hello,
> >plase (CC) the list in your replies.
> >
> >serweb-0.9.3 match tables of ser-0.9.3
> >
> >But there are a little confusion in db schema of ser-0.9.3 and 
> >ser-cvs. Some tables have diferent names.
> >
> >serweb-cvs should also match tables of ser-cvs, but I didn't check it 
> >in last days. Note that cvs version is not oficial release. And is not 
> >recomended to mix develeper version of serweb from cvs and oficial 
> >release of ser.
> >
> >
> >Karel
> >
> >harry gaillac napsal(a):
> >
> >>Hello Karel,
> >>
> >>why serweb-0.9.3 don't match ser tables?
> >>
> >>I think you read my posts
> >>
> >>Harry
> >>--- Karel Kozlik <karel at iptel.org> a écrit :
> >>
> >>
> >>>Hello,
> >>>there are two ways:
> >>>- install serweb 0.9.3 (recomended)
> >>>- change cofiguration of your version of serweb to
> >>>fit db schema of
> >>>  ser 0.9.3. Change the names of tables in
> >>>config_data_layer.php
> >>>
> >>>Karel
> >>>
> >>>Timur V. Elzhov napsal(a):
> >>>
> >>>>Dear SER experts,
> >>>>
> >>>>I've downloaded and configured SER v0.9.3, as well
> >>>
> >>>
> >>>as serweb, the
> >>>
> >>>>head CVS version. I succeeds by serweb with
> >>>
> >>>
> >>>subscribtion, logging
> >>>
> >>>>on, and changing my own details. But the red
> >>>
> >>>
> >>>message appears on my
> >>>
> >>>>user page:
> >>>>
> >>>> "DB Error: no such table".
> >>>>
> >>>>However, again, there is now problem with actions
> >>>
> >>>
> >>>mentioned just above.
> >>>
> >>>>I'm not familiar with PHP, but I found that many
> >>>
> >>>
> >>>php files under
> >>>
> >>>>"serweb/data_layer/" directory contain the same
> >>>
> >>>
> >>>"if" statement comprising
> >>>
> >>>>the "DB_ERROR_NOSUCHTABLE" constant:
> >>>>
> >>>> if (DB::isError($res)) {
> >>>>     if ($res->getCode()==DB_ERROR_NOSUCHTABLE)
> >>>
> >>>
> >>>return true;  //expected, table mayn't exist in
> >>>installed version
> >>>
> >>>>     else {log_errors($res, $errors); return
> >>>
> >>>
> >>>false;}
> >>>
> >>>> }
> >>>>
> >>>>- it may be useful ...
> >>>>
> >>>>How should I locate & resolve this problem?
> >>>>
> >>>>Much thanks.
> >>>>
> >>>>
> >>>
> >>>_______________________________________________
> >>>Serusers mailing list
> >>>serusers at lists.iptel.org
> >>>http://lists.iptel.org/mailman/listinfo/serusers
> >>>
> >>
> >>
> >>
> >>
> >>    
> >>
> >>    
> >>       
> >>___________________________________________________________________________ 
> >>Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! 
> >>Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
> >
> >
> >_______________________________________________
> >Serusers mailing list
> >serusers at lists.iptel.org
> >http://lists.iptel.org/mailman/listinfo/serusers
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers