I created a server with mandriva, configure, put the drupal files, but when starts the install
i get this error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'modules/system/system.module' for key 1

The database was empty. How can i fix it? Thx

This error was in Database configuration, after i select the database, username and password.

Comments

John_B’s picture

Try a fresh database. Sometimes when you drop all tables in a db which previously contained data, there is left over an error in the mysql schema which causes mysql to 'think' the db is not empty. Debugging those errors is tricky.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

ghbacala’s picture

I tryed with XAMPP, works fine, tryied Hostinger as host, works fine, but trying to use in a Intranet, i got this error.

This error is with a new db. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'modules/system/system.module' for key 1

Cause when i use a old db, i get the message "Table variable already exists."

And the installation doesn't proceed .

This can be caused by MySQL PDO?

Web server Apache/2.2.8 (Mandriva Linux/PREFORK-6mdv2008.1)
PHP 5.2.5
PHP register globals Disabled
PHP extensions Enabled
Database support Enabled
PHP memory limit 32M
File system Writable (public download method)
Unicode library PHP Mbstring Extension.

John_B’s picture

Like I said, it is normally caused by that particular database looking empty but not behaving as empty owing an error in Mysql. That is why I suggest making a fresh database for the install.

I do not think your post changes my original answer. However there is one point in it which could be a problem: normally for a simple Drupal site 64MB memory limit is OK, and 128 on a bigger site. I would not try running the install on 32MB. You are better off with a more recent version of PHP but that is probably not relevant to the present problem. The memory limit might be.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

ghbacala’s picture

Updated php limit to 64Mb. Checked the fresh table and the problem persists

John_B’s picture

Strange. Rather than waste time trying to debug, I would be inclined to run the install on your XAMPP and drop the newly installed site on the Intranet.

If you really want to debug, I would take a look at php max_execution_time, and maybe mysql interactive_timeout, as it sounds as though some function may be timing out and restarting during the creation of the database.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

ghbacala’s picture

Thx. I guive up using Mandriva. I using Xampp in a personal desktop to provide the server, not more a dedicated server.