CB Tools->DB Check mistake

15 years 10 months ago #66758 by zseni
CB Tools->DB Check mistake was created by zseni
I installed the 1.2 on a new side. The setup was successful. I synchronizatied the users, which was successful, but the database check publishes the undermentioned mistake always. The users don't appear it the User Managment.
What is the mistake?

Php version: 5.1.6

[code:1]Checking Community Builder Datbase:

All Community Builder comprofiler_field_values table fieldid rows all match existing fields.

All Community Builder comprofiler_field_values table rows link to correct fieldtype fields in comprofiler_field table.

All Community Builder comprofiler table rows have links to user table.

All users table rows have links to comprofiler table.

All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table.

users table has no zero id row.

comprofiler table has no zero id row.

All rows in comprofiler table have user_id columns identical to id columns.

Checking Community Builder folders:
Avatars and thumbnails folder is Writeable.

All users table rows have ACL entries in core_acl_aro table.

ERROR: sql query: SELECT a.value AS id, a.aro_id FROM #__core_acl_aro a LEFT JOIN #__users u ON u.id = a.value WHERE a.section_value = 'users' AND u.id IS NULL : returned error: A(z) 'a.aro_id' oszlop ervenytelen 'field list'-ben SQL=SELECT a.value AS id, a.aro_id FROM jos_core_acl_aro a LEFT JOIN jos_users u ON u.id = a.value WHERE a.section_value = 'users' AND u.id IS NULL

ERROR: sql query: SELECT a.value AS id, a.aro_id FROM #__core_acl_aro a LEFT JOIN #__core_acl_groups_aro_map g ON g.aro_id = a.aro_id WHERE g.aro_id IS NULL : returned error: A(z) 'a.aro_id' oszlop ervenytelen 'field list'-ben SQL=SELECT a.value AS id, a.aro_id FROM jos_core_acl_aro a LEFT JOIN jos_core_acl_groups_aro_map g ON g.aro_id = a.aro_id WHERE g.aro_id IS NULL

ERROR: sql query: SELECT g.aro_id AS id FROM #__core_acl_groups_aro_map g LEFT JOIN #__core_acl_aro a ON a.aro_id = g.aro_id WHERE a.aro_id IS NULL : returned error: A(z) 'a.aro_id' oszlop ervenytelen 'where clause'-ben SQL=SELECT g.aro_id AS id FROM jos_core_acl_groups_aro_map g LEFT JOIN jos_core_acl_aro a ON a.aro_id = g.aro_id WHERE a.aro_id IS NULL
All Core CB Database is up to date.
Click here to Show details
[/code:1]

Post edited by: zseni, at: 2008/06/29 01:12

Please Log in to join the conversation.

15 years 10 months ago #66760 by beat
Replied by beat on topic Re:CB Tools->DB Check mistake
Could you please translate what :

oszlop ervenytelen

means ?

this concerns column aro_id of joomla table jos_core_acl_aro

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 10 months ago #66773 by zseni
Replied by zseni on topic Re:CB Tools->DB Check mistake
Hi!

I'm sorry, but we are hungarian and use hungarian server.
Well, oszlop ervenytelen means column invalid.

Please Log in to join the conversation.

15 years 10 months ago #66795 by zseni
Replied by zseni on topic Re:CB Tools->DB Check mistake
I deleted everything from my site and install again everything.
Now, the CB is working well. I don't know what problem was.
Now, I make hungarian language pack to CB 1.2.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.459 seconds

Facebook Twitter LinkedIn