• Registered: 2005-04-29
  • Posts: 4

Topic: Error: Unable to insert into online list. 1.2.5

Tonight I have been updating all the way from 1.0 and I made it to 1.2 without error.  After being told I succesfully updated to 1.2.5 I now receive an error when I go to the forum.
Error: Unable to insert into online list.

I ran the update script.  (12_to_125_update.php)

Now when I run the script it says

----------------------------------------------------------------------
File: /home/webmaster/public_html/forum/12_to_125_update.php
Line: 69

PunBB reported: Version mismatch. This script updates version 1.2, 1.2.1, 1.2.2, 1.2.3, 1.2.4 to version 1.2.5. The database 'mailhollywood' doesn't seem to be running a supported version.

----------------------------------------------------------------------

I assume the error is because I already updated.

Any suggestions on fixing the first error?  Maybe a permissions problem?
Thanks!!
Andrew

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: Error: Unable to insert into online list. 1.2.5

turn on debug mode ( http://punbb.org/forums/viewtopic.php?id=2658 ) and tell us what it says then

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Registered: 2005-04-29
  • Posts: 4

Re: Error: Unable to insert into online list. 1.2.5

Ok, now this is what I get:
File: /home/webmaster/public_html/forum/include/functions.php
Line: 115

PunBB reported: Unable to insert into online list

Database reported: Duplicate entry '1' for key 1 (Errno: 1062)

THANKS FOR YOUR HELP!

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error: Unable to insert into online list. 1.2.5

That's odd. The user_id column of the online table should allow duplicates. It's as if it has been assigned a primary index instead of a regular index. Could you check in e.g. phpmyadmin what kind of index the user_id column of the online table has?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-04-29
  • Posts: 4

Re: Error: Unable to insert into online list. 1.2.5

Here is the table structure sql:

-- Table structure for table `pun_online`
--

CREATE TABLE `pun_online` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `ident` varchar(200) NOT NULL default '',
  `logged` int(10) unsigned NOT NULL default '0',
  `idle` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  KEY `pun_online_user_id_idx` (`user_id`)
) TYPE=HEAP;


Also, when I view the table structure I get a warning message displayed from phpmyadmin that says, "PRIMARY and INDEX keys should not both be set for column `user_id`."

Thanks....

  • Registered: 2005-04-29
  • Posts: 4

Re: Error: Unable to insert into online list. 1.2.5

I hate to be a bother but I have not received a response yet to the additional information posted.  My bb is still down awaiting a resolution.  My last post was a month ago now.  When I empty the table it works again but soon I have the problem of the error message I receive.  Thank you for your help continued help.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error: Unable to insert into online list. 1.2.5

Remove the primary key index for user_id.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website