[Typo3] Extension Modern Link List

Erik Svendsen erik at linnearad.no
Fri Nov 11 14:37:49 CET 2005


Hello luc_boudreau at uqss.uquebec.ca,

You can change the value in the file ext_tables.sql in extensions before 
you install the extension. Change float to something that works. But it can 
make problems with other part of the system. But you can test it.

Maybe the best solution is to install full MySql.


WBR,
Erik Svendsen
www.linnearad.no

> I've tracked the problem down to this sql statement :
> 
> #
> # Table structure for table 'tx ablinklist link'
> #
> CREATE TABLE tx ablinklist link (
> uid int(11) unsigned DEFAULT '0' NOT NULL auto increment,
> pid int(11) unsigned DEFAULT '0' NOT NULL,
> tstamp int(11) unsigned DEFAULT '0' NOT NULL,
> crdate int(11) unsigned DEFAULT '0' NOT NULL,
> cruser id int(11) unsigned DEFAULT '0' NOT NULL,
> deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
> hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
> fe group int(11) DEFAULT '0' NOT NULL,
> label tinytext NOT NULL,
> description text NOT NULL,
> href tinytext NOT NULL,
> clicks int(11) DEFAULT '0' NOT NULL,
> click ip tinytext NOT NULL,
> rating float UNSIGNED DEFAULT '0' NOT NULL,    <---------
> votes int(11) unsigned DEFAULT '0' NOT NULL,
> vote ip tinytext NOT NULL,
> status int(11) unsigned DEFAULT '0' NOT NULL,
> category int(11) unsigned DEFAULT '0' NOT NULL,
> contact tinytext NOT NULL,
> image blob NOT NULL,
> PRIMARY KEY (uid),
> KEY parent (pid)
> );
> And found information about this problem which seems to come from PHP
> :
> 
> http://bugs.php.net/bug.php?id=33005&edit=1
> 
> Quote :
> 
> mysqli do not supports float type neither in results nor in params.
> for result it returns NULL instead of float, for params there is no
> type letter for float type...
> 
> Is there any workaround ?
> 
> Luc Boudreau
> SID - Université du Québec
> luc boudreau at uqss.uquebec.ca
> -----Message d'origine-----
>> De : BOUDREAU, Luc
>> Envoyé : 10 novembre 2005 14:27
>> À : 'TYPO3 English'
>> Objet : Extension Modern Link List
>> I can't install the extension Medern Link List (Extension Key: ab
>> linklist)
>> 
>> I've downloaded the extension from the online repository and if I try
>> to install it or click on it's name to get more info, I get the
>> following :
>> 
>> ------------------------------------------------------------------
>> SQL engine parse ERROR: Field type unknown!: near "float unsigned NOT
>> NULL default '0' "
>> ------------------------------------------------------------------
>> I can't find any info on this anywhere !! I'm beginning to fear that
>> my database is corrupted.
>> 
>> Did it ever occured to any one of you ? Maybe with another extension
>> ?
>> 
>> Luc Boudreau
>> SID - Université du Québec
>> luc boudreau at uqss.uquebec.ca





More information about the TYPO3-english mailing list