 |
 |
 |
 |
|
|
Date: 08/10/00
- Next message: toby cabot: "Re: [phplib] Reconize n"
- Previous message: Davor Cengija: "Re: [phplib] mysql_pconnect at db_mysql.inc"
- In reply to: Koo: "[phplib] After Upgrading MySQL.. error appeared."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Tue, 8 Aug 2000, Koo wrote:
>Database error: Invalid SQL: insert into active_sessions ( sid, name,
>val, changed ) values ('06af2aa25b4b7aef22e20fe0b8844461', 'sessid',
>'c2Vzc2lkOiR..long long crypted characters..jt9Jzsg', '20000808000004')
>MySQL Error: 1062 (Duplicate entry
>'sessid-06af2aa25b4b7aef22e20fe0b8844461' for key 1)
>Session halted.
[...]
>
>The message disappeared after I reload those pages.
>
>WHAT I'VE TRIED:
>- compiled and installed new MySQL
>- restarted mysql server
>- restarted apache server
>- tested new features of MySQL with a PHP script. worked fine.
This should help:
>- emptied all data in the table "active_sessions"
>- close and open my browser (Netscape)
>
>WHAT I'VE NOT TRIED:
>- recompiled Apache+PHP+...etc
You don't have to.
>
>What causes the problem?? Do I really have to recompile
>Apache+PHP+MODSSL... again from scratch to solve the problem??
The problem is probably caused by index inconsistency. It's
usually enough to delete all the entries from
yourDB.active_sessions table, and/or to run isamchk (from
mysql package) on the affected table.
--
v
Davor Cengija
davor <email protected>
============================
"Nicht in die Augen bringen"
---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>
- Next message: toby cabot: "Re: [phplib] Reconize n"
- Previous message: Davor Cengija: "Re: [phplib] mysql_pconnect at db_mysql.inc"
- In reply to: Koo: "[phplib] After Upgrading MySQL.. error appeared."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]