- Posts: 6
- Forum
- Joomla-Monster Forum
- Free Templates
- Templates for Joomla 2.5
- JM-Eco-Cosmetics
- Sql error while installing
×
Support for Joomla 2.5 templates is discontinued. This forum category is read-only.
Sql error while installing
- alaa_alnahal
-
Topic Author - Offline
Less
More
7 years 2 days 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
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.
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.
7 years 1 day 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.
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.
- alaa_alnahal
-
Topic Author
- Offline
Less
More
- Posts: 6
7 years 1 day 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
[
Please I beg you help soon
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 LanguagesPlease I beg you help soon
Please Log in or Create an account to join the conversation.
7 years 1 day ago #2202
by izabela
izabela replied the topic: Re: Sql error while installing
Please Log in or Create an account to join the conversation.
- alaa_alnahal
-
Topic Author
- Offline
Less
More
- Posts: 6
7 years 1 day 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
it seems in the file in the template folder
is there any updates of the tempate " eco cosmetics"
please continue with me
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 404it 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.
6 years 11 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?
Do you use the template version for Joomla 1.5 or 2.5?
Please Log in or Create an account to join the conversation.
- Forum
- Joomla-Monster Forum
- Free Templates
- Templates for Joomla 2.5
- JM-Eco-Cosmetics
- Sql error while installing
Time to create page: 0.260 seconds
