Elcan Software

Small software, big solutions.

Home arrow Support Forum
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Re:SQL Error in joomla 1.15 (1 viewing) (1) Guest
Help for feed2post
Go to bottom Post Reply Favoured: 0
TOPIC: Re:SQL Error in joomla 1.15
#632
movilla (Admin)
Admin
Posts: 279
graph
User Offline Click here to see the profile of this user
Re:SQL Error in joomla 1.15 6 Months ago Karma: 1  
Dear supa, seems like your sql server is not mysql 4 or higher...try editing the feedpost.xml file inside the zip package and replace that query with this one:
Code:

CREATE TABLE `#__feedpost_config` ( `id` int(11) NOT NULL auto_increment, `useiconv` tinyint(4) NOT NULL default '1', `getwith` tinyint(4) NOT NULL default '0', `insertadvert` tinyint(4) NOT NULL default '1', `includelink` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Feed2post options' AUTO_INCREMENT=1 ;
The old query will have #_ as the prefix too, you should look for:
Code:

<query> CREATE TABLE `#__feedpost_config` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `useiconv` TINYINT NOT NULL DEFAULT '1', `getwith` TINYINT NOT NULL DEFAULT '0', `insertadvert` TINYINT NOT NULL DEFAULT '1', `includelink` TINYINT NOT NULL DEFAULT '0' ) ENGINE = MYISAM COMMENT = 'Feed2post options'; </query>
and replace that lines with the ones I gave you before, let's see if that works, if not, I'm afraid that feed2post needs mysql...won't work if you have any other sql server... Best regards, Mario
 
Report to moderator   Logged Logged  
 
Best regards,
Mario - Feed2post coder
  The administrator has disabled public write access.
      Topics Author Date
    thread link
SQL Error in joomla 1.15
supa 2008/05/18 06:24
    thread link
thread linkthread link Re:SQL Error in joomla 1.15
movilla 2008/05/18 14:05
    thread link
thread linkthread linkthread link Re:SQL Error in joomla 1.15
movilla 2008/05/18 14:09
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Sponsors

Your Ad Here
Joomla Templates by Joomlashack