Results 1 to 3 of 3

Thread: [Solved] Fatal error when installing Graphical Text

  1. #1
    User
    Join Date
    06-20-09.
    Posts
    63

    Default [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?

  2. #2
    User
    Join Date
    06-20-09.
    Posts
    63

    Default 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.

  3. #3
    User
    Join Date
    06-20-09.
    Posts
    63

    Default 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 ops:

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •