Hello,

After running update.php, I've got this? I would like to be sure there are no problems :)

All this is normal?

Thanks

user warning: Table 'user_stats_values' already exists query: CREATE TABLE user_stats_values ( `name` VARCHAR(128) NOT NULL DEFAULT '', `uid` INT unsigned NOT NULL DEFAULT 0, `value` INT NOT NULL DEFAULT 0, PRIMARY KEY (name, uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/pariscin/www/includes/database.inc on line 515.
user warning: Table 'user_stats_ips' already exists query: CREATE TABLE user_stats_ips ( `iid` INT NOT NULL auto_increment, `uid` INT unsigned NOT NULL DEFAULT 0, `ip_address` VARCHAR(15) NOT NULL DEFAULT '', `first_seen_timestamp` INT NOT NULL DEFAULT 0, PRIMARY KEY (iid), INDEX uid (uid), INDEX first_seen_timestamp (first_seen_timestamp) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/pariscin/www/includes/database.inc on line 515.

The following queries were executed
user_stats module
Update #6101
Failed: CREATE TABLE {user_stats_values} ( `name` VARCHAR(128) NOT NULL DEFAULT '', `uid` INT unsigned NOT NULL DEFAULT 0, `value` INT NOT NULL DEFAULT 0, PRIMARY KEY (name, uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
Failed: CREATE TABLE {user_stats_ips} ( `iid` INT NOT NULL auto_increment, `uid` INT unsigned NOT NULL DEFAULT 0, `ip_address` VARCHAR(15) NOT NULL DEFAULT '', `first_seen_timestamp` INT NOT NULL DEFAULT 0, PRIMARY KEY (iid), INDEX uid (uid), INDEX first_seen_timestamp (first_seen_timestamp) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
INSERT INTO {user_stats_values} (name, uid, value) SELECT 'login_count', pv.uid, CAST(pv.value AS SIGNED) FROM {profile_fields} pf INNER JOIN {profile_values} pv ON pf.fid = pv.fid WHERE pf.name = 'user_login_count'
INSERT INTO {user_stats_ips} (uid, ip_address) SELECT pv.uid, pv.value FROM {profile_fields} pf INNER JOIN {profile_values} pv ON pf.fid = pv.fid WHERE pf.name = 'user_ip_address'
DELETE FROM {profile_values} WHERE fid = 2
DELETE FROM {profile_values} WHERE fid = 3
DELETE FROM {profile_values} WHERE fid = 1
DELETE FROM {profile_fields} WHERE name IN ('user_post_count', 'user_ip_address', 'user_login_count')

Comments

liam mcdermott’s picture

Which version were you upgrading from? Alpha 2, Beta 1 or something else?

This is not meant to happen, but it won't break your installation.

liam mcdermott’s picture

Status: Active » Postponed (maintainer needs more info)
junro’s picture

Upgrading from beta1. I'm using lot of modules, and I've got a big database.

I've got only this message just after running update.php, and no messages since.

Maybe there will be no effects... I hope so :) Seems to have no effects right now.

liam mcdermott’s picture

Status: Postponed (maintainer needs more info) » Active

Thanks for the update. I'll try an update myself, see if the bug can be reproduced.

It won't hurt anything, it was just trying to create two tables that already exist.

junro’s picture

Priority: Normal » Minor

ok, thanks, If I have some news about it, I will write it here :)

fumbling’s picture

I got the same message when running update.php. Then I got an error posting a comment (I should have grabbed it, couldn't reproduce), then a validation error. I disabled user stats for now and no more errors. No sure what's what, but thought I should share.

liam mcdermott’s picture

Status: Active » Closed (won't fix)

Am going to wontfix this for the moment. I've tried several ways to reproduce this and can't. Even tried going from Alpha2, upgraded to Beta1, then Beta2, then visiting update.php, which reports that there are no updates needing to be run.

If anyone is still seeing this bug, and can provide some more information on how to reproduce it, feel free to re-open this bug report!

Then I got an error posting a comment (I should have grabbed it, couldn't reproduce), then a validation error.

This is most probably: #381532: author_pane error : "ip_address" does not exist

You should try using the -dev release, until beta4 is released. :)