categories not showing when logged on

OK, the i nstallaion works again, however the original problem with the error of the categories not showing when logged on is still the same and has not been fixed.

Any ideas?

Thanks,



Max

Thanks Doc for looking at it and trying to fix this issue, however the version I just now downloaded does not even install.... Tried several times and always get the same SQL error in the installation process. Please see below for all the error messages.

Appreciate your help.

Max


Error Messages:

---

JInstaller::install: SQL Error. DB function failed with error number 1064
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 \'(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(\' at line 9 SQL=CREATE TABLE IF NOT EXISTS `jos_ksads_ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT 1, `user_id` int(11) NOT NULL, `ad_ident` varchar(20) NOT NULL, `ad_name` varchar(255) NOT NULL, `ad_address` varchar(255) NOT NULL, `ad_intro` varchar(255) NOT NULL, `ad_desc` longtext(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(10) NOT NULL, `ad_location` varchar(100) NOT NULL, `ad_post` varchar(10) NOT NULL, `ad_delivery` varchar(100) NOT NULL, `ad_image` varchar(255) NOT NULL, `ad_img_comment` varchar(255) NOT NULL, `ad_boxnumber` tinyint(1) NOT NULL, `contact_name` varchar(255) NOT NULL, `contact_tel` varchar(30) NOT NULL, `contact_email` varchar(255) NOT NULL, `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `published` tinyint(1) NOT NULL, `prolonged` smallint(2) NOT NULL DEFAULT 0, `show_address` tinyint(1) NOT NULL, `views` int(11) NOT NULL DEFAULT 0, `meta` varchar(255) NOT NULL, `phonetic` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ad_name` (`ad_name`), UNIQUE KEY `id` (`id`) ) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';
SQL =
CREATE TABLE IF NOT EXISTS `jos_ksads_ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT 1,
`user_id` int(11) NOT NULL,
`ad_ident` varchar(20) NOT NULL,
`ad_name` varchar(255) NOT NULL,
`ad_address` varchar(255) NOT NULL,
`ad_intro` varchar(255) NOT NULL,
`ad_desc` longtext(2000) NOT NULL,
`ad_state` tinyint(1) NOT NULL DEFAULT 0,
`ad_price` int(10) NOT NULL,
`ad_location` varchar(100) NOT NULL,
`ad_post` varchar(10) NOT NULL,
`ad_delivery` varchar(100) NOT NULL,
`ad_image` varchar(255) NOT NULL,
`ad_img_comment` varchar(255) NOT NULL,
`ad_boxnumber` tinyint(1) NOT NULL,
`contact_name` varchar(255) NOT NULL,
`contact_tel` varchar(30) NOT NULL,
`contact_email` varchar(255) NOT NULL,
`date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`published` tinyint(1) NOT NULL,
`prolonged` smallint(2) NOT NULL DEFAULT 0,
`show_address` tinyint(1) NOT NULL,
`views` int(11) NOT NULL DEFAULT 0,
`meta` varchar(255) NOT NULL,
`phonetic` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ad_name` (`ad_name`),
UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064
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 \'(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(\' at line 9 SQL=CREATE TABLE IF NOT EXISTS `jos_ksads_ads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT 1, `user_id` int(11) NOT NULL, `ad_ident` varchar(20) NOT NULL, `ad_name` varchar(255) NOT NULL, `ad_address` varchar(255) NOT NULL, `ad_intro` varchar(255) NOT NULL, `ad_desc` longtext(2000) NOT NULL, `ad_state` tinyint(1) NOT NULL DEFAULT 0, `ad_price` int(10) NOT NULL, `ad_location` varchar(100) NOT NULL, `ad_post` varchar(10) NOT NULL, `ad_delivery` varchar(100) NOT NULL, `ad_image` varchar(255) NOT NULL, `ad_img_comment` varchar(255) NOT NULL, `ad_boxnumber` tinyint(1) NOT NULL, `contact_name` varchar(255) NOT NULL, `contact_tel` varchar(30) NOT NULL, `contact_email` varchar(255) NOT NULL, `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `published` tinyint(1) NOT NULL, `prolonged` smallint(2) NOT NULL DEFAULT 0, `show_address` tinyint(1) NOT NULL, `views` int(11) NOT NULL DEFAULT 0, `meta` varchar(255) NOT NULL, `phonetic` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ad_name` (`ad_name`), UNIQUE KEY `id` (`id`) ) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';
SQL =
CREATE TABLE IF NOT EXISTS `jos_ksads_ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT 1,
`user_id` int(11) NOT NULL,
`ad_ident` varchar(20) NOT NULL,
`ad_name` varchar(255) NOT NULL,
`ad_address` varchar(255) NOT NULL,
`ad_intro` varchar(255) NOT NULL,
`ad_desc` longtext(2000) NOT NULL,
`ad_state` tinyint(1) NOT NULL DEFAULT 0,
`ad_price` int(10) NOT NULL,
`ad_location` varchar(100) NOT NULL,
`ad_post` varchar(10) NOT NULL,
`ad_delivery` varchar(100) NOT NULL,
`ad_image` varchar(255) NOT NULL,
`ad_img_comment` varchar(255) NOT NULL,
`ad_boxnumber` tinyint(1) NOT NULL,
`contact_name` varchar(255) NOT NULL,
`contact_tel` varchar(30) NOT NULL,
`contact_email` varchar(255) NOT NULL,
`date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`published` tinyint(1) NOT NULL,
`prolonged` smallint(2) NOT NULL DEFAULT 0,
`show_address` tinyint(1) NOT NULL,
`views` int(11) NOT NULL DEFAULT 0,
`meta` varchar(255) NOT NULL,
`phonetic` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ad_name` (`ad_name`),
UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8 COMMENT=\'stores the classifieds information\';

I had version 1.5.34 installed and except for a few problems with the layout the version did work quite ok.... I have just installed version 1.5.35 and somehow I can see the categories as GUEST (not logged in as a user), however once I log on to the site as registered user it shows me just a line of text:

Please Log in to view this page.

instead of the categories...

Once I log off again it shows again the categories fine ....

Any idea why this is ??

Thanks


Max

hmmm, tried to upload some screenshots but seems not to work...