0
Welcome Guest! Login
0 items Join Now

XAMPP Rocket Launcher issue SQL syntax error

Last Post
Search Topic

  • XAMPP Rocket Launcher issue SQL syntax error

    Posted 14 years 2 months ago
    • Hi All,
      Getting SQL syntax error after database configuration step when trying to install Joomla Panacea package locally with XAMPP

      Message below any ideas would be appreciated?

      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 'textCHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) textCHARACTER SET `utf8`
    #625392
    • prim's Avatar
    • prim
    • Preeminent Rocketeer
    • Posts: 17290
    • Thanks: 217

    Re: XAMPP Rocket Launcher issue SQL syntax error

    Posted 14 years 2 months ago
    • I've never seen that error before. You are trying to install the template on Joomla 1.5.22 right?
    • Please reply with a direct link to the issue & create a new thread for each new issue.

      A template is only as good as the content that goes into it ;) - DanG
    #625446

  • Re: XAMPP Rocket Launcher issue SQL syntax error

    Posted 14 years 2 months ago
    • Used you launcher package rt_panacea_j15-rocketlauncher which I would assume has the latest version of Joomla?
    #625876

  • Re: XAMPP Rocket Launcher issue SQL syntax error

    Posted 14 years 2 months ago
    • just tried a clean install with Joomla 1.6 and no issues, however when I try Joomla 1.5 I get the issue?
    #625885
    • prim's Avatar
    • prim
    • Preeminent Rocketeer
    • Posts: 17290
    • Thanks: 217

    Re: XAMPP Rocket Launcher issue SQL syntax error

    Posted 14 years 2 months ago
    • I have added this issue to our bug-tracker so that the developers can have a look at it.
    • Please reply with a direct link to the issue & create a new thread for each new issue.

      A template is only as good as the content that goes into it ;) - DanG
    #626542
    • DirtySnipe's Avatar
    • DirtySnipe
    • Hero Rocketeer
    • Posts: 424
    • Thanks: 0
    • ICT Manager

    Re: XAMPP Rocket Launcher issue SQL syntax error

    Posted 14 years 2 months ago
    • I had problems ages ago with installing a template with xampp. I found out in the end it was down to my password containing a "

      It was breaking the install.

      Not sure if this is the same problem. Was quite a long time ago.
    #626817

Time to create page: 0.062 seconds