[Solved] Fatal error when installing Graphical Text
When trying to install the 0.5.0 stable version of Graphical Text on a 2.8.1 TL, I got this error:
Code:
Fatal error: Uncaught exception Exception with message Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 39 (CREATE TABLE `tl_graphicaltext` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `tstamp` int(10) unsigned NOT NULL default '0', `sorting` int(10) unsigned NOT NULL default '0', `type` varchar(255) NOT NULL default '', `tag` varchar(255) NOT NULL default '', `description` text NULL, `cacheOutput` char(1) NOT NULL default '', `AntiAliasing` char(1) NOT NULL default '', `BackgroundType` varchar(255) NOT NULL default 'none', `bgcolor` varchar(6) NOT NULL default 'ffffff', `fgcolor` varchar(6) NOT NULL default '000000', `Font` varchar(255) NOT NULL default '', `FontSize` int(11) NOT NULL default '12', `FontAngle` int(11) NOT NULL default '0', `padding` varchar(255) NOT NULL default '0', `ImageSize` varchar(255) NOT NULL default '0', `textposition` varchar(255) NOT NULL default 'middle-center', `BackgroundImage` varchar(255) NOT NULL default '1', `BackgroundPadding` varchar(255) NOT NULL default '', `DisplayFont` char(1) NOT NULL default '', `TextIntensity` int(3) NOT NULL default '100', `preview` char(1) NOT NULL default '1', `bgcolor2` varchar(6) NOT NULL default '000000', `DisplayIcon` char(1) NOT NULL default '', `IconPosition` varchar(255) NOT NULL default 'left', `IconImage` varchar(255) NOT NULL default '1', `IconIntensity` int(3) NOT NULL default '100', `IconPadding` varchar(255) NOT NULL default '0', `FontSpacingFactor` double NOT NULL default '1', `FileCacheSeconds` int(10) unsigned NOT NULL default '86400', `Extensions` text NOT NULL, `OutputFileType` varchar(255) NOT NULL default 'PNG', `OutputFileTypeJPGQuality` int(3) NOT NULL default '80', `OutputFileTypePNGQuality` int(1) NOT NULL default '1', `LowResImages` char(1) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE ;) thrown in /home/marie-noelle/www/cevennes2/system/libraries/Database.php on line 599
What I am to do? :(
Re: Fatal error when installing Graphical Text
I'm not sure what the problem was, but the installation succeeded on another site ...
but I get an error when trying to create a first element:
Code:
Fatal error: Uncaught exception Exception with message Query error: Table 'marienoegal.tl_graphicalelements' doesn't exist (SELECT name,id FROM tl_graphicalelements WHERE 1) thrown in /homez.110/marienoe/www/system/libraries/Database.php on line 533
I checked the DB using PhpMyAdmin and, though there is a tl_graphicaltext table, there is no tl_graphicalelements :(
I don't understand what's going on.
Re: [Solved] Fatal error when installing Graphical Text
My mistake: I installed the module manually and didn't pay attention to dependency :roll:
With the automatic installation - from the backend - there is no error.
Sorry for the disturbance :oops: