We use some templates for joomla 1.5, and in our hosting we use MySQL 5.5.23, and with some templates has problems with the BD, per example Sportline, i downloaded the demo zip, but i receive:
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`
If i update the term TYPE per ENGINE i can install but i receive errors like Warning: Invalid argument supplied for foreach() in /home/bvargas/public_html/components/com_content/models/frontpage.php on line 104
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bvargas/public_html/libraries/joomla/database/database/mysql.php on line 344
In the template yoututorial i have the same error, i asked my provider of hosting and says thats an error of syntaxis on the BD script, can you help us please? THanks
Are you sure your are posting in product assigned forum?: Yes
What is your CMS version?: Joomla 1.5
MySQL Version: 5.x
PHP version: 5.x
Link to installation: betting711.com
Have you edited any files? If yes tell us which ones.: No
Is this personal or client website?: Client
Are you sure your are posting in product assigned forum?: Yes
What is your CMS version?: Joomla 1.5
MySQL Version: 5.x
PHP version: 5.x
Link to installation: betting711.com
Have you edited any files? If yes tell us which ones.: No
Is this personal or client website?: Client
Are you sure your are posting in product assigned forum?: Yes
What is your CMS version?: Joomla 1.5
MySQL Version: 5.x
PHP version: 5.x
Link to installation: betting711.com
Have you edited any files? If yes tell us which ones.: No
Is this personal or client website?: Client
Linear Mode
