× Support for Joomla 2.5 templates is discontinued. This forum category is read-only.

Sql error while installing

More
9 years 8 months ago #2196 by alaa_alnahal
alaa_alnahal created the topic: Sql error while installing
I had purchased eco cosmetics template about a year ago , and while installing and after I fill in database information's I get this 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 'TYPE=MyISAM CHARACTER 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`) ) TYPE=MyISAM CHARACTER SET `utf8`

I think it is a conflict with sql server version .
my sql server version is : 5.5.21-55
and PHP version is : 5.2.17
PHP version

please help me to resolve this problem as soon as possible.

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #2198 by izabela
izabela replied the topic: Re: Sql error while installing
Hi,

Try change all TYPE=MyISAM to ENGINE=MyISAM in "root/installation/sql/mysql/" and install the quickstart once more.
That should help.

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #2201 by alaa_alnahal
alaa_alnahal replied the topic: Re: Sql error while installing
Thank you very much, the problem was solved.

But after installing I get another error in main menu

[
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 Home
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 Template Features
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 DJ-Catalog2 

Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 DJ-Catalog2 -Single
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 DJ-Catalog2 - Blog
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 DJ-Catalog2 - Table
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 DJ-Catalog2 - Producer
 


Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 Joomla! Overview 

Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 What's New in 1.5? 

Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 The News
 


Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 FAQ 

Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 Web Links
 


Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 News Feeds 

Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 More about Joomla!
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 Web Links
 




Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404
 The News
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 390
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 159
 RTL Languages 

Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 390
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 159
 LTR Languages
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 390
 
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 159
 RTL Languages



Please I beg you help soon

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #2202 by izabela
izabela replied the topic: Re: Sql error while installing
Hi,

Install the latest menu version -> dj-extensions.com/dj-menu/item/item/13-dj-menu.html

Please Log in or Create an account to join the conversation.

More
9 years 8 months ago #2204 by alaa_alnahal
alaa_alnahal replied the topic: Re: Sql error while installing
thank again
but after installing new version of Dj-menu
i get the same error
I thing that the error in this path
Deprecated: Function eregi() is deprecated in /home/alkhurai/public_html/templates/jm-eco-cosmetics/html/mod_djmenu/default.php on line 404

it seems in the file in the template folder

is there any updates of the tempate " eco cosmetics"
please continue with me

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #2211 by izabela
izabela replied the topic: Re: Sql error while installing
Hi,

Do you use the template version for Joomla 1.5 or 2.5?

Please Log in or Create an account to join the conversation.

Time to create page: 0.180 seconds
Secured payments Payment Methods

INDICO S.C.

ul. Przyjaźni 9, 84-215 Gowino, registered in Centralna Ewidencja i Informacja o Działalnosci Gospodarczej
NIP/VATID: PL5882424318

Copyright © 2009-2021 Joomla-Monster.com All rights reserved.

Joomla-Monster.com and this site is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.