Upgraded and still error message

  • BarbaraQuinn
  • Topic Author
  • Visitor
  • Visitor
12 years 7 months ago #10187 by BarbaraQuinn
Upgraded and still error message was created by BarbaraQuinn
Can anyone please tell me why I keep getting this message?

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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `wa89g_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`) ) TYPE=MyISAM CHARACTER SET `utf8`

Thank you

Please Log in to join the conversation.

  • milos
    Support Staff
  • Moderator
  • Moderator
More
12 years 7 months ago #10203 by milos
Please try to change TYPE=MyISAM to ENGINE=MyISAM everywhere in file /installation/sql/mysql/sample_data.sql

Then re-run installer.

Please Log in to join the conversation.

  • BarbaraQuinn
  • Topic Author
  • Visitor
  • Visitor
12 years 7 months ago #10288 by BarbaraQuinn
Replied by BarbaraQuinn on topic Re: Upgraded and still error message
Milos.
Hello. I uploaded the template successfully to my Apache Server via Filezilla. No problem.
Attached is what I get which is nothing.

I also took a look at the "/installation/sql/mysql/sample_data.sql" and changing TYPE=MyISAM to ENGINE=MyISAM

TYPE=MyISAM: does not exist everything is ENGINE=MyISAM

Any more thoughts? It seems to be clearly the sql file and my local server. Attached is the server info. In additon the database with all the info in it looks good also.

Thank you very much for any help you can offer
Attachments:

Please Log in to join the conversation.

More
12 years 7 months ago #10292 by ivan.milic
Then do that replacement in
/installation/sql/mysql/joomla.sql

Please Log in to join the conversation.

  • BarbaraQuinn
  • Topic Author
  • Visitor
  • Visitor
12 years 7 months ago #10316 by BarbaraQuinn
Replied by BarbaraQuinn on topic Re: Upgraded and still error message
Worked like a charm. Thank you very very much

Please Log in to join the conversation.

Time to create page: 0.295 seconds
Powered by Kunena Forum