Installation error (mysql)
Permalink
Hello. I hope You could help me with this problem. It occurs at the beginning of installation concrete5.4.2.2:
"mysql error: [1050: Table '`pupkin`.`areagroupblocktypes`' already exists] in EXECUTE("CREATE TABLE AreaGroupBlockTypes ( cID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, arHandle VARCHAR(255) NOT NULL, gID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, uID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, btID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (cID, arHandle, gID, uID, btID) );")". Though the current database was empty and had all necessary privileges.
Additional information:
Windows XP SP3/Apache/2.2.9 (Win32) PHP/5.2.11/Mysql 5.5;
Docroot "C:/apache/concrete5.4.2.2/" in httpd.conf;
used virtual host (httpd-vhosts.conf):
<VirtualHost *:80>
DocumentRoot "C:/apache/concrete5.4.2.2/"
ServerName pupkin.ru
ServerAliashttp://www.pupkin.ru
ErrorLog "C:/apache/concrete5.4.2.2/files/pupkin.ru/error.log"
CustomLog "C:/apache/concrete5.4.2.2/files/pupkin.ru/access.log" common
</VirtualHost>
I'd appreciate any help you could give me.
"mysql error: [1050: Table '`pupkin`.`areagroupblocktypes`' already exists] in EXECUTE("CREATE TABLE AreaGroupBlockTypes ( cID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, arHandle VARCHAR(255) NOT NULL, gID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, uID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, btID INTEGER(10) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (cID, arHandle, gID, uID, btID) );")". Though the current database was empty and had all necessary privileges.
Additional information:
Windows XP SP3/Apache/2.2.9 (Win32) PHP/5.2.11/Mysql 5.5;
Docroot "C:/apache/concrete5.4.2.2/" in httpd.conf;
used virtual host (httpd-vhosts.conf):
<VirtualHost *:80>
DocumentRoot "C:/apache/concrete5.4.2.2/"
ServerName pupkin.ru
ServerAliashttp://www.pupkin.ru
ErrorLog "C:/apache/concrete5.4.2.2/files/pupkin.ru/error.log"
CustomLog "C:/apache/concrete5.4.2.2/files/pupkin.ru/access.log" common
</VirtualHost>
I'd appreciate any help you could give me.
Given the error it returns i'd check the database if it's empty because it seems that the table: `areagroupblocktypes` already exists
I was checking the database every time through the failure. It was empty, no tables. I even restarted Mysql service. No changes.
