Re: [TYPO3-english] database problems

[Katja Lampela]

Hi,

The situation at the moment with some big databases following - I use the 
cache_hash table as example.

The install tool tells me to create the cache tables, like:
CREATE TABLE cache_hash ( id int(11) unsigned NOT NULL auto_increment, hash 
varchar(32) NOT NULL default '', content mediumblob, tstamp int(11) unsigned 
NOT NULL default '0', ident varchar(32) NOT NULL default '', PRIMARY KEY (id), 
KEY hash (hash) ) ENGINE=InnoDB;

hitting the update button doesn't do anything, the list is still there.

If I give this query in phpmyadmin, I get: #1050 - Table 'cache_hash' already 
exists

In phpmyadmin I can't see the cache tables.

And to remind where this all started: I changed the databases to use MyISAM for 
a moment and now I try to change the the default setup back (cache tables to 
InnoDB).
All the smaller sites are ok and the install tool gave
ALTER TABLE cache_hash ENGINE=InnoDB;
Current value: ENGINE=MyISAM

And update did the job, the tables were changed back to InnoDB.

But now my problems continue with these big sites/databases.

Any suggestion what I might try? This is tricky since I can't take backup, the 
error is:
mysqldump: Got error: 1146: Table 'mytable.cache_hash' doesn't existsing LOCK 
TABLES
--
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net

___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

[TYPO3-english] database problems

[Katja Lampela]

Hi,

I've been struggling now with innoDB's configuration on a virtual hosting 
server.

Now the innoDB was configured poorly and the ibdata1 file raised up to 
enourmous size.

For solution I installed to TYPO3installations the extension ggforcemyisam that 
forces MyISAM tables in TYPO3 installation.
here is the main class:
-
class ux_t3lib_install extends t3lib_install {

/**
 * Overwrite a set 'InnoDB' value with 'MyISAM'
 * Parent method does the actual work
 *
 * @see t3lib_install::getFieldDefinitions_fileContent
 * @param string $fileContent
 * @return array
 */
public function getFieldDefinitions_fileContent($fileContent) { 
$result = parent::getFieldDefinitions_fileContent($fileContent);
foreach ($result as $table) {
$table['extra']['ENGINE'] = 'MyISAM';
}
return $result;
}
}


Now after innodb optimization (so that evry db uses its own innodb files) I 
would like to change back to default TYPO3 database configuration and I 
uninstalled the ggforcemyisam.

Now my install tool informs that some tables should be created, for example:

CREATE TABLE cache_hash ( id int(11) unsigned NOT NULL auto_increment, hash 
varchar(32) NOT NULL default '', content mediumblob, tstamp int(11) unsigned 
NOT NULL default '0', ident varchar(32) NOT NULL default '', PRIMARY KEY (id), 
KEY hash (hash) ) ENGINE=InnoDB;

But even I hit the update button the tables don't get created.

Now when I go to phpMyAdmin I get error:

SELECT COUNT( * ) AS num
FROM `taito`.`cache_hash`

MySQL said:

#1033 - Incorrect information in file: './taito/cache_hash.frm'

So any idea, what should I do now? If you think this is a bigger issue and 
fixing it needs some financing, please contact me by email.

--
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net

___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: [TYPO3-english] database problems

[Mathias Schreiber [wmdb]]

So any idea, what should I do now? If you think this is a bigger issue
and fixing it needs some financing, please contact me by email.


I'd go and run myisamchk first.
Maybe just some index got messed up.



--
Ernesto, Nov. 9th 2010:
In the graphics generation routines of TYPO3 *anything* could cause a
side effect.
___
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english