[Mambo 4.6.2 bug]: Error On Clean Install

16 years 4 months ago #50638 by jkcgroup
Replied by jkcgroup on topic Re:[Mambo 4.6.2 bug]: Error On Clean Install
Hey Annabel, thanks for your response and here is the latest in this escapade.

Ran CB DB Check................. OK FINE
Ran CB Sync Users............... OK FINE
Tried to login.................. FAILED, SAME ISSUE

Using phpMyAdmin
Repaired ALL tables in DB....... OK FINE
Tried to login.................. FAILED, SAME ISSUE
Exported and Reimported two tables mentionned
Tried to login.................. FAILED, SAME ISSUE

Went into garage, got my hammer & waved it at screen
Tried to login.................. FAILED, SAME ISSUE

My next idea would be to use my hammer, but before I do, I am open to anything else.

Thanks Annbel and Beat and...

JKC

Please Log in to join the conversation.

16 years 4 months ago #50644 by annabel
Replied by annabel on topic Re:[Mambo 4.6.2 bug]: Error On Clean Install
Hello,

Patience is ... a virtue.

This problem in the past was due to
$mosConfig_lang which has to replaced by $mosConfig_locale in login module. That was before september 2007.

I believe you have the latest version of CB. So the $mosConfig_lang is not the cause.

There might be a possibility: CB install does not go thru as expected and might have failed.

Re-install it if necessary.

2) before doing that, send me the content of
mos_users,
mos_core_acl_aro,
mos_core_acl_groups_aro_map,
mos_core_acl_groups

3) drop all the entries in mos_session.

4) meanwhile, could you try with another user ?
does this happen to all the user ?

5) will look at the content of the above tables.

Please Log in to join the conversation.

16 years 4 months ago #50650 by jkcgroup
Replied by jkcgroup on topic Re:[Mambo 4.6.2 bug]: Error On Clean Install
Virtue...... hmmmm :P

I do have the latest CB version.
I have tried using a different user with same results.
Cleared mos_session table

Here is conent for those tables;

--
-- Dumping data for table `mos_core_acl_aro`
--
INSERT INTO `mos_core_acl_aro` (`aro_id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0),
(11, 'users', '63', 0, 'coop', 0),
(12, 'users', '64', 0, 'Dean Caros', 0),
(14, 'users', '66', 0, 'Jacques', 0),
(15, 'users', '67', 0, 'Prince Moustapha', 0),
(16, 'users', '68', 0, 'Clodyle', 0),
(17, 'users', '69', 0, 'Money', 0),
(18, 'users', '70', 0, 'julien', 0),
(19, 'users', '71', 0, 'carole mc clure', 0),
(20, 'users', '72', 0, 'Homer', 0);

--
--
-- Dumping data for table `mos_core_acl_aro_groups`
--
INSERT INTO `mos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES
(17, 0, 'ROOT', 1, 22),
(28, 17, 'USERS', 2, 21),
(29, 28, 'Public Frontend', 3, 12),
(18, 29, 'Registered', 4, 11),
(19, 18, 'Author', 5, 10),
(20, 19, 'Editor', 6, 9),
(21, 20, 'Publisher', 7, 8),
(30, 28, 'Public Backend', 13, 20),
(23, 30, 'Manager', 14, 19),
(24, 23, 'Administrator', 15, 18),
(25, 24, 'Super Administrator', 16, 17);

--
--
-- Dumping data for table `mos_core_acl_groups_aro_map`
--
INSERT INTO `mos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(18, '', 14),
(18, '', 15),
(18, '', 16),
(18, '', 17),
(18, '', 18),
(18, '', 19),
(18, '', 20),
(24, '', 11),
(24, '', 12),
(25, '', 10);

--
--
-- Dumping data for table `mos_users`
--
INSERT INTO `mos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'homerp', 'homer@', '75c6f03161d020201000414cd1501f9f', 'Super Administrator', 0, 1, 25, '2007-11-09 12:54:07', '2007-11-20 10:04:16', '', ''),
(63, 'coop', 'coop', 'distributeurscoop@', '503cda99156860c4491cf1007fdcd6ce', 'Administrator', 0, 0, 24, '2007-11-10 13:04:14', '2007-11-19 17:40:39', '', ''),
(64, 'Dean', 'Dean', 'dean@', 'aabf11b3599bbdf37f8f6020e467fd2d', 'Administrator', 0, 0, 24, '2007-11-13 14:57:15', '0000-00-00 00:00:00', '', ''),
(66, 'Jacques', 'Velo', 'claude@', '503cda99156860c4491cf1007fdcd6ce', 'Registered', 0, 0, 18, '2007-11-16 18:33:34', '0000-00-00 00:00:00', '', ''),
(67, 'Prince', 'Mubarak', 'prince@', 'ff24fefce7040369fd4fda33fd2d036d', 'Registered', 1, 0, 18, '2007-11-17 06:54:48', '0000-00-00 00:00:00', '', ''),
(68, 'Clodyle', 'Clodyle', 'clodyle@', '34feb64a2be8d158c20f1f62530dbff6', 'Registered', 0, 0, 18, '2007-11-17 19:15:02', '0000-00-00 00:00:00', '', ''),
(69, 'Money', 'Money', 'velocitymoney@', '4b10c03a722acb389b47f3b29cd2dcfb', 'Registered', 0, 0, 18, '2007-11-17 19:30:34', '0000-00-00 00:00:00', '', ''),
(70, 'julien', 'julien', 'julienlavigne@', '93bbfe828d0b9a02698ba39f7babd24a', 'Registered', 0, 0, 18, '2007-11-18 08:03:06', '0000-00-00 00:00:00', '', ''),
(71, 'carole', 'carole', 'cmc2@', 'd786b22a7aeec43767f610920fdda17f', 'Registered', 0, 0, 18, '2007-11-18 14:30:08', '0000-00-00 00:00:00', '', ''),
(72, 'Homer', 'homerp', 'homer@', 'b5330eec41c8ac50d764678b6c2d4149', 'Registered', 0, 0, 18, '2007-11-20 09:51:20', '0000-00-00 00:00:00', '', '');
--

Meanwhile I'll reinstall CB again...

BTW... I put away the hammer for the moment.

Thanks again.

JKC

Please Log in to join the conversation.

16 years 4 months ago #50678 by beat
beat wrote:

I suppose there is a "." to remove in your url ? ;)

I'm suspecting something misconfigured on the server's redirections or .htaccess file in your folder, ot the php sessions not enabled correctly, or folder not writable, or something along those lines...


- Removed .htaccess file in home directory ?

- checked system information ?

- all ok there ?

e.g.:

[code:1]
Safe Mode: OFF
Open basedir: none
Display Errors: ON
Short Open Tags: ON
File Uploads: ON
Magic Quotes: ON
Register Globals: OFF
Output Buffering: OFF
Session save path: /tmp
Session auto start: 0
XML enabled: Yes
Zlib enabled: Yes
Disabled Functions: none
[/code:1]

- checked status/logs/access_logs and error_logs ?

- asked hoster to check why it's staying 5 mins ?

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.

16 years 4 months ago #50708 by annabel
Replied by annabel on topic Re:[Mambo 4.6.2 bug]: Error On Clean Install
Hi again,

1. I have checked the tables, the synchronization seems to work fine.

2. Beat has mentionned a potential problem with your .htaccess,
then I would suggest a quick acid test:

Try to login with mambo login instead:
unpublish CB login, and re-publish Login module of mambo.
If this works, then CB installation has failed and needs
a re-installation.

3. after CB installation please follows the checklist:

there must be 9 new tables:
`mos_comprofiler`,
`mos_comprofiler_fields`,
`mos_comprofiler_field_values`,
`mos_comprofiler_lists`,
`mos_comprofiler_members`,
`mos_comprofiler_plugin`,
`mos_comprofiler_tabs`,
`mos_comprofiler_userreports`,
`mos_comprofiler_views`

IF ONE table IS MISSING, then there is a problem.
check all these tables with phpMyAdmin for errors.

Before using CB:
a) Go to components and select Community Builder Tools:

populate with sample data
Run check community builder database.
Run Synchronize users.

b) in module
unpublish mambo login when using CB login

c) in menu manager
select usermenu AND
make sure the following items are created

User Profile
click New, select component,
then Community Builder (com_comprofiler)

User list
click New, select Link-URL and point it to
index.php?option=com_comprofiler&task=usersList

member list
click New, select Link-URL and point it to
index.php?option=com_comprofiler&task=usersList&listid=2
=============================================================
COULD YOU PROVIDE ME YOUR LINK ?

will register with user007
will login with user007
=============================================================

Please Log in to join the conversation.

16 years 4 months ago #50715 by jkcgroup
Replied by jkcgroup on topic Re:[Mambo 4.6.2 bug]: Error On Clean Install
Okay when I unpbulished cblogin and publisehed Mambo login, it worked properly, so I proceeded to uninstall CB, I deleted the compile tables and proceeded to reinstall CB.

Here's something I just noticed on reinstall of CB.
I got this error.

Funny thing is it set up 9 tables and allows registration etc...

1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL error:DB function failed with error number 1064
You have an error in your SQL syntax near '; ' at line 2 SQL=ALTER TABLE `mos_comprofiler_fields` ADD `pluginid` INT( 11 ) , ADD `params` MEDIUMTEXT;
SQL =
ALTER TABLE `mos_comprofiler_fields` ADD `pluginid` INT( 11 ) ,
ADD `params` MEDIUMTEXT;

URL is www.coopmidland.com

Thanks Annabel

Post edited by: jkcgroup, at: 2007/11/21 01:22

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.238 seconds

Facebook Twitter LinkedIn