[SOLVED] CB login and workflow mods do not work

15 years 3 months ago #86905 by mbissett
Server environment:
Joomla! 1.5.9 Production/Stable
MySQL: 5.0.67-community
Collation: utf8_general_ci
PHP: 5.2.8

Client environment:
Tested with Firefox 3.05 and Safari 3.2.1 on Mac, and IE 7.0.6 on Windows

I just updated from the CB RC4 (where everything was working fine) to 1.2 stable and now the CB login module does not work. After entering a username/password for a registered user, clicking the login button or hitting the enter key only causes a page refresh, with no change. The user does not get logged in. There is no error message. If I intentionally use an incorrect password, I do get the error popup.

I tried using the native Joomla login module and now that does not work either.

I can create a new user OK using the CB or native Joomla registration, but cannot login with the new user once it's created.

The CB 1.2 stable install went without problems, everything was green, and I ran all the tools OK. All directories and files have correct permissions. I made sure to delete the old CB menu items and emptied the menu trash before creating new CB menu items.

SEF on or off does not make a difference. I've tried commenting/uncommenting the .htaccess settings (Options +FollowSymLinks and Rewrite Base/), with no effect.

PHP safe mode is off.

Livesite value in configuration.php does not make a difference.

Second problem is the CB Workflows module does not appear at all when published.

Since this is a new site (not yet in production) I had the luxury of trying a fresh full install. I even tried dropping all the CB tables and doing another fresh install. Nothing has helped.

Any help is appreciated. Thanks.

Debug output from a login attempt follows:

Profile Information
Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.054 seconds, 3.75 MB
Application afterRoute: 0.064 seconds, 4.48 MB
Application afterDispatch: 0.125 seconds, 8.27 MB
Application afterRender: 0.232 seconds, 11.02 MB
Memory Usage
11600960
16 queries logged

1.
SELECT *
FROM jos_session
WHERE session_id = 'bae00268d8337192bb7c16daee8f56b6'
2.
DELETE
FROM jos_session
WHERE ( time < '1233118401' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'bae00268d8337192bb7c16daee8f56b6'
4.
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'bae00268d8337192bb7c16daee8f56b6','1233125601','','0','1','0' )
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
7.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
8.
SELECT published
FROM jos_plugins
WHERE element = 'jceembed' OR element = 'mediaobject'
9.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
10.
SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-28 06:53:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-28 06:53:21' )
ORDER BY f.ordering
LIMIT 0, 1
11.
SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-28 06:53:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-28 06:53:21' )
ORDER BY f.ordering
12.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
13.
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos_polls
WHERE id = 15
AND published = 1
14.
SELECT id, text
FROM jos_poll_data
WHERE pollid = 15
AND text <> ""
ORDER BY id
15.
SELECT a.id,a.dates, a.times, a.enddates,a.title,c.id AS mcatid,c.catname,l.id AS mlocid,l.venue, DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month
FROM jos_eventlist_events AS a
LEFT JOIN jos_eventlist_categories AS c
ON c.id = a.catsid
LEFT JOIN jos_eventlist_venues AS l
ON l.id = a.locid
WHERE a.published = 1
AND c.access <= 0
16.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-28 00:53:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-28 00:53:21' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=1)
AND (s.id=1)
AND f.content_id IS NULL
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5

Language Files Loaded

* /home/mchenryd/public_html/language/en-GB/en-GB.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.com_content.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.tpl_rt_replicant2_j15.ini
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_breadcrumbs.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_poll.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_cblogin.ini
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_login.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_comprofilermoderator.ini
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_eventlistcal15q.ini
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_search.ini 1
* /home/mchenryd/public_html/language/en-GB/en-GB.mod_roknewsflash.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

Post edited by: nant, at: 2009/01/29 07:46

Please Log in to join the conversation.

15 years 3 months ago #86907 by nant

Please Log in to join the conversation.

15 years 3 months ago #86912 by mbissett
Replied by mbissett on topic Re:CB login and workflow mods do not work
I used the steps listed in the README-UPGRADE.txt file.

When that failed to work, I uninstalled CB and did a new install using the steps listed in the README-NEW-INSTALL.txt file.

All the backend stuff seems to be working fine.

I'm just getting started with this site. It's using a RocketTheme template, and here's the URL if that helps:

www.mchenrydems.org

Please Log in to join the conversation.

15 years 3 months ago #87013 by beat
Please try to reinstall, possibly with expert ftp overwrite method (also in README).

It looks very much as a partial upgrade

Check also all owner/permissions of the CB folders:

components/com_comprofiler and below
administrator/components/com_comprofiler and below
modules/ and below

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

15 years 3 months ago #87022 by mbissett
Replied by mbissett on topic Re:CB login and workflow mods do not work
Thank you, Beat. After some sleep, I've already decided to start fresh with a clean Joomla install using my host's (Rochen) fantastico installer, then test all functions as I rebuild the site. I'm just now verifying the SEF with only native Joomla 1.5.9 templates and no extensions, after enabling the .htacess that comes with the installer. SO far everything works. I have backups of my entire site as well as an SQL export in case I need them.

Next step will be to install CB as a new install. Once I have all my functionality and content working I will let you know how it goes. Thanks again.

Please Log in to join the conversation.

15 years 3 months ago #87056 by mbissett
Just following up to let you know that the clean install seems to be working as designed. Have not tested all the workflow features but registration and login are working fine.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.254 seconds

Facebook Twitter LinkedIn