Login/Logout error on modx_log_hosts DB table

Hello,

I have finally moved my homepage from an older server to a new one. Everything seems to work well after the import except of a little error when logging in or out as regular web user.

A MODx error page is shown for a sec when I logout for example, but it’s then redirected to the standard page.

The error is:


Any ideea how to fix this? I don’t know what to remove from the modx_log_hosts table without braking anything else.

Thank you!
Boby

Is there some reason why you are keeping your logs for so long? Go to the backup manager and empty them from time to time. I believe that the function uses "truncate", which will reset the auto_increment value to 1.

Your problem is that that is an "int" field, and an "int" can only go up to 2147483647.

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

Thanks Susan for the reply

I have cleared now the logs tables, when I logged the first time in no errors were shown. However on logging out or logging in again the same errors showed up.

It’s always this 2147483647

There’s no auto_increment, the table is InnoDB. You are right about the maximum value, how can I change the log to start from 0 again?

Thanks, Boby.

Go in with your phpMyAdmin, and in the "Operations" tab, there will be a field for setting the auto_increment value. Empty the table, then make sure that is set to 1.

There is no auto_increment for this table

I have defragmented the tabled and flushed it, same thing

Probably it’s stored somewhere else, any ideea where?

Sounds like you may have exported and imported using slightly incompatible syntaxes or versions of MySQL or phpMyAdmin. I’ve had this problem before when moving from MySQL 4.x to 3.x especially -- none of the auto_increment fields have the auto_increment attribute specified on the field definition after the import. It’s easy to go into the structure definition and simply change the field definition to be auto_increment (and make sure it is specified as the primary key, as well).

Yep, I upgraded from MySQL 3.2 to 5

Do I have to add more auto_increment attributes to the other "modx_log_xyz" tables?

Thank you!

No, looking at the installation setup files, these tables don’t have an auto_increment. But that value has to be coming from somewhere.

Ok, that’s not any kind of incremented value, it’s a crc32 hash of your hostname.

Hi again!

I have now reinstalled these tables. The error persists if I have Log Visits turned on.
Could it be because my homepage is www.frozenminds.com and the hostname of my computer at home is frozenminds ?

Another question, I have in config.inc.php a variable:

and in my modx_system_settings DB table I have a field site_id that is different. Do these two values have to match or not?

Boby