Search Form and Social Buttons

HotThemes Logo and Top Menu

To request a forum account, please login here and open support ticket. Only customers with active order(s) can open forum account!

× Discussion about "Cosmetics" Joomla/VirtueMart template.

Topic-icon Upgraded and still error message

  • BarbaraQuinn
  • BarbaraQuinn's Avatar Topic Author
  • Visitor
  • Visitor
6 years 4 months ago #10187 by BarbaraQuinn
BarbaraQuinn created the topic: Upgraded and still error message
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.

More
6 years 4 months ago #10203 by milos
milos replied the topic: Re: Upgraded and still error message
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
  • BarbaraQuinn's Avatar Topic Author
  • Visitor
  • Visitor
6 years 3 months ago #10288 by BarbaraQuinn
BarbaraQuinn replied the 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
6 years 3 months ago #10292 by ivan.milic
ivan.milic replied the topic: Re: Upgraded and still error message
Then do that replacement in
/installation/sql/mysql/joomla.sql

Please Log in to join the conversation.

  • BarbaraQuinn
  • BarbaraQuinn's Avatar Topic Author
  • Visitor
  • Visitor
6 years 3 months ago #10316 by BarbaraQuinn
BarbaraQuinn replied the 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.079 seconds

Links, Partners and Social Media