okay so you have managed to get rid of all the duplicates, now just your version is incorrect.
I have pasted my tables,
+-----------------------+---------------+ | table_name | table_version | +-----------------------+---------------+ | gw | 1 | | lcr | 1 | | gw_grp | 1 | | realm | 1 | | subscriber | 5 | | reserved | 1 | | phonebook | 1 | | pending | 4 | | missed_calls | 2 | | location | 6 | | grp | 2 | | event | 1 | | aliases | 6 | | active_session | 1 | | acc | 2 | | config | 1 | | silo | 3 | | domain | 1 | | uri | 2 | | server_monitoring | 1 | | server_monitoring_agg | 1 | | trusted | 1 | | usr_preferences | 1 | | preferences_types | 1 | | admin_privileges | 1 | | calls_forwarding | 1 | | speed_dial | 1 | +-----------------------+---------------+
harry gaillac wrote:
I drop create ser db. However when I start ser i get : serveur1:~# tail /var/log/syslog Jun 3 18:39:01 serveur1 /USR/SBIN/CRON[2616]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm) Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: Maxfwd module- initializing Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: permissions - initializing Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: WARNING: File not found: /etc/ser/permissions.allow Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: Default allow file (/etc/ser/permissions.allow) not found => empty rule set Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: WARNING: File not found: /etc/ser/permissions.deny Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: Default deny file (/etc/ser/permissions.deny) not found => empty rule set Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: AVPops - initializing Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: auth_db:str_fixup: Invalid table version (use ser_mysql.sh reinstall) Jun 3 18:44:02 serveur1 /usr/sbin/ser[2729]: ERROR: fix_expr : fix_actions error
version table from phpmyadmin: Résultat de la requête SQL
Serveur: localhost Base de données: ser Généré le : Vendredi 03 Juin 2005 à 18:39 Généré par: phpMyAdmin 2.6.2 / MySQL 4.0.24_Debian-10-log requête SQL: SELECT * FROM `version` LIMIT 0, 30; Enregistrements: 27 table_name table_version subscriber 5 reserved 1 phonebook 1 pending 4 missed_calls 2 location 6 grp 2 event 1 aliases 6 active_sessions 1 acc 2 config 1 silo 3 realm 1 domain 1 uri 1 server_monitoring 1 server_monitoring_agg 1 trusted 1 usr_preferences 2 usr_preferences_types 1 admin_privileges 1 calls_forwarding 1 speed_dial 2 gw 1 gw_grp 1 lcr 1
Version table with command: +-----------------------+---------------+ | table_name | table_version | +-----------------------+---------------+ | subscriber | 5 | | reserved | 1 | | phonebook | 1 | | pending | 4 | | missed_calls | 2 | | location | 6 | | grp | 2 | | event | 1 | | aliases | 6 | | active_sessions | 1 | | acc | 2 | | config | 1 | | silo | 3 | | realm | 1 | | domain | 1 | | uri | 1 | | server_monitoring | 1 | | server_monitoring_agg | 1 | | trusted | 1 | | usr_preferences | 2 | | usr_preferences_types | 1 | | admin_privileges | 1 | | calls_forwarding | 1 | | speed_dial | 2 | | gw | 1 | | gw_grp | 1 | | lcr | 1 | +-----------------------+---------------+ 27 rows in set (0.01 sec)
--- Iqbal iqbal@gigo.co.uk a écrit :
they should be identical, do u keep logs of queries sent to Mysql , if so look at them when u use phpmyadmin, and also manual queries, and you will see what is actually being sent, the log will usually be in /var/log on the machine with the DB
Iqbal
harry gaillac wrote:
Why datas from phpmyadmin are not equal to mysql> select * from version;
Is it a bug ? --- Iqbal iqbal@gigo.co.uk a écrit :
whats the error, I cut and pasted that query and
it
deleted the row,
Iqbal
harry gaillac wrote:
Do you know the right SQL command to delete
multiple
values ? I try mysql> delete from version where
table_name='trusted';
it's not good
Harry
--- Iqbal iqbal@gigo.co.uk a écrit :
what does select * from version display
Iqbal
harry gaillac wrote:
>Ok, > >I understand . >I use phpmyadmin to manage ser however >mysql> select * from version; don't display the > > > > > > same
>result > >Harry > >--- Iqbal iqbal@gigo.co.uk a écrit : > > > > > > > > > >>now remove all the duplicate rows, leaving >> >>
only
>> >> >> >> >> >> one
>>of each type, eg if >>you have alook there are two rows called >>domains...remove one, lcr is >>also there twice, >> >>Iqbal >> >>harry gaillac wrote: >> >> >> >> >> >> >> >> >> >>>here is table version from ser DB: >>>+-----------------------+---------------+ >>>| subscriber | 5 | >>>| reserved | 1 | >>>| phonebook | 1 | >>>| pending | 4 | >>>| missed_calls | 2 | >>>| location | 6 | >>>| grp | 2 | >>>| event | 1 | >>>| aliases | 6 | >>>| active_sessions | 1 | >>>| acc | 2 | >>>| config | 1 | >>>| silo | 3 | >>>| realm | 1 | >>>| domain | 1 | >>>| uri | 1 | >>>| server_monitoring | 1 | >>>| server_monitoring_agg | 1 | >>>| trusted | 1 | >>>| usr_preferences | 2 | >>>| usr_preferences_types | 1 | >>>| admin_privileges | 1 | >>>| calls_forwarding | 1 | >>>| speed_dial | 2 | >>>| gw | 1 | >>>| gw_grp | 1 | >>>| lcr | 1 | >>>| subscriber | 5 | >>>| reserved | 1 | >>>| phonebook | 1 | >>>| pending | 4 | >>>| missed_calls | 2 | >>>| location | 6 | >>>| grp | 2 | >>>| event | 1 | >>>| aliases | 6 | >>>| active_sessions | 1 | >>>| acc | 2 | >>>| config | 1 | >>>| silo | 3 | >>>| domain | 1 | >>>| domain | 1 | >>>| uri | 1 | >>>| server_monitoring | 1 | >>>| server_monitoring_agg | 1 | >>>| trusted | 1 | >>>| usr_preferences | 2 | >>>| usr_preferences_types | 1 | >>>| admin_privileges | 1 | >>>| calls_forwarding | 1 | >>>| speed_dial | 2 | >>>| gw | 1 | >>>| gw_grp | 1 | >>>| lcr | 1 | >>>+-----------------------+---------------+ >>>54 rows in set (0.00 sec) >>> >>>--- Iqbal iqbal@gigo.co.uk a écrit : >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>>>can u dump your version table here, and let >>>> >>>>
us
>>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>look >> >> >> >> >> >> >> >> >>>>at it >>>> >>>>
=== message truncated ===
_____________________________________________________________________________ Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos ! Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
.