How to remove all authors of a site alphabetically

Professional Business Joomla template for corporate and business websites suitable for showing stock quotes, up to date news, portfolio management resources or international market data.
GK User
Mon Feb 25, 2013 8:09 am
Hi.

I tried to install the com_alphacontent_v4.0.18 component but I receive an error of JInstaller: :
Install: Error of SQL the Error of a database with number 1064
I don't understand in what a mistake.
The mistake turns out because of incompatibility of the Joomla 2.5.9 version or the SQL base is spoiled ?
Someone from colleagues already faced such problem?

Alex
:roll:
User avatar
Junior Boarder

GK User
Mon Feb 25, 2013 8:12 am
Hi
The installer issues this message in attempt to deliver a component:

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' at line 11 SQL=CREATE TABLE IF NOT EXISTS `b518i_alpha_rating` ( `ref` int(11) NOT NULL auto_increment, `id` int(11) NOT NULL default '0', `total_votes` int(11) NOT NULL default '0', `total_value` int(11) NOT NULL default '0', `used_ips` longtext NOT NULL default '', `component` varchar(30) NOT NULL default '', `cid` int(11) NOT NULL default '0', `rid` int(11) NOT NULL default '0', PRIMARY KEY (`ref`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `#__alpha_rating` (
`ref` int(11) NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`total_votes` int(11) NOT NULL default '0',
`total_value` int(11) NOT NULL default '0',
`used_ips` longtext NOT NULL default '',
`component` varchar(30) NOT NULL default '',
`cid` int(11) NOT NULL default '0',
`rid` int(11) NOT NULL default '0',
PRIMARY KEY (`ref`)
) TYPE=MyISAM;
User avatar
Junior Boarder

GK User
Mon Feb 25, 2013 4:22 pm
Hi.

I corrected an error 1064.
Task on demonstration of authors of a site is -

It is necessary to show authors alphabetically:
- there is a lot of authors
- having clicked in menu point authors, to receive two lines of letters A of B.... I and A B C... Z
- having clicked on a letter A to remove all authors on a letter A
- so for each letter of the alphabet

Probably someone already solved such problem with display of authors of a site.
What expansion needs to be used for such task?

Regards,
Alex
User avatar
Junior Boarder


cron