App issue inserting into temp_messages table App issue inserting into temp_messages table
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

App issue inserting into temp_messages table

Started by Darwin, April 07, 2010, 02:55:07 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Darwin

I have a fresh install of 1.5.3 and the installation seemed to go well.

I am in the midst of testing the gallery.  The only user is my administrative account.  When logging in or out I get critical database errors:

Apr 07, 2010 at 05:01 AM - While executing query 'INSERT INTO cpg15x_temp_messages  SET  message_id = 'd41d8cd98f00b204e9800998ecf8427e',  user_id = '0',  time   = '1270641672',  message = 'Welcome+dgadmin+...'' in include/functions.inc.php on line 4807 the following error was encountered: ^M
Duplicate entry 'd41d8cd98f00b204e9800998ecf8427e' for key 1^M

I am using MySQL 5 and sharing the table with a PHPBB 3 instance.  I checked the table using phpMyAdmin and the table appears to be defined properly, and is empty.  I am not sure of what versions of web server I am using.

When I click a menu item (such as Home) I seem to do OK.  I haven't even gotten to the point of testing uploads etc, as I want to get each piece resolved as I encounter it.

Any ideas?


Darwin

Thanks.

I'll see if that fix works tonight.

I need to learn to search a little more effectively.

Darwin

The fix worked for me...
Just replaced

$message_id = md5(uniqid());

with

$message_id = md5(uniqid(''));