Problem with contact categories [SOLVED]

[rentasite]

Thanks Yianni. I will follow the above steps. And i will reply back here.

[rentasite]

If you do try this:
1. Install Elxis 2009.1. Don't, finish the installation, just do the import data to db step and halt there.
2. Go to phpmyadmin and to the just created table "elx_components". Check the values of the db column named "admin_menu_link". Are the links full or cropped?
If they are OK (full), then everything works fine, continue the installation, DONE.

The links are cropped. As seen in the attachment. So i continued with the steps bellow.

Continue if the links are not full.
3). Go back to the elxis installer and click the icon to re-start the installation from the beginning.
Open this file: installation/schema/elxis.xml
Go to lines 219 to 243.
Change this: & to this: & in the insert querries.

Done.
& was also found (and changed) in lines 927-933 in elxis.xml

4). Try to install Elxis again and when you reach the database info page check the checkbox "drop existing tables".
5). Continue and install elxis. Halt exactly after the database step.
6). Check again the inserted links in phpmyadmin. Did the problem solved?

After step 4 i get this error message: XML error: EntityRef: expecting ';' at line 221


[attachment deleted by admin]

[datahell]

OK, try 3 more possible solutions.

1. URL encode:
replace "&" with %26
Example:
option%3Dcom_banners%26task%3Dlistclients
(In the example above I have also replaced "=" with %3D, but this is not required as "=" is not a problem).

2. Use CDATA
Surround queries with <query><![CDATA[query here]]></query>
Example:
<query><![CDATA[INSERT INTO components VALUES (6, 'Weblink Categories', NULL, 0, 4, 'option=categories&amp;section=com_weblinks', 'Manage weblink categories', NULL, 2, 'js/ThemeOffice/categories.png', 0, NULL)]]></query>

3. Add problematic links to the fixamenuLinks method.
File: installation/includes/elxisinstaller.php
Line: 464
Method: fixamenuLinks
Add proper links replacements to the $fixes array.
Usage:
array('original', 'replacement'),
example:
array('option=com_databasetask=backup', 'option=com_database&amp;task=backup'),

[datahell]

I am testing solutions 1 and 2 locally and I will notify you in a few minutes regarding the test results.

TEST RESULTS:
Solution 1( URL encode) did not worked!
Solution 2 (CDATA) worked fine!

Use CDATA and better also replace &amp; with just & inside the querries. If this works for you I will update the Elxis installer to use CDATA in these queries.

[rentasite]

thanks. i will wait and proceed.

[datahell]

For those want to reproduce the test I did, open any elxis component file (f.e. weblinks.php - do the test locally) and at the very top area write:

Code: (php) [Select]

<?php 
$database->_resource->debug = true;
require_once($mainframe->getCfg(&#39;absolute_path&#39;).&#39;/includes/adodb/adodb-xmlschema03.inc.php&#39;);
$schema = new adoSchema($database->_resource);
$schema->ContinueOnError(true);
$schema->SetPrefix($database->_table_prefix);
$schema->ParseSchema($mainframe->getCfg(&#39;absolute_path&#39;).&#39;/testschema.xml&#39;);
$schema->ExecuteSchema();
exit();
?>
Don't use opening and closing PHP tags on the component's file if you include the source inside already opened tags.

The "testschema.xml" file contents:

Code: (xml) [Select]

<?xml version="1.0" encoding="UTF-8"?>
<schema version="0.3">
<sql>
<query>INSERT INTO components VALUES (NULL, 'TEST1', NULL, 0, 1, 'option=com_test&amp;task=list', 'test1', 'com_test', 2, 'js/ThemeOffice/categories.png', 0, NULL)</query>
<query>INSERT INTO components VALUES (NULL, 'TEST2', NULL, 0, 1, 'option=com_test%26task=list', 'test2', 'com_test', 2, 'js/ThemeOffice/categories.png', 0, NULL)</query>
<query><![CDATA[INSERT INTO components VALUES (NULL, 'TEST3', NULL, 0, 1, 'option=com_test&task=list', 'test3', 'com_test', 2, 'js/ThemeOffice/categories.png', 0, NULL)]]></query>
<query><![CDATA[INSERT INTO components VALUES (NULL, 'TEST4', NULL, 0, 1, 'option=com_test&amp;task=list', 'test4', 'com_test', 2, 'js/ThemeOffice/categories.png', 0, NULL)]]></query>
</sql>
</schema>

Visit from your browser the component's page to run the test.

Remove the imported lines in db table elx_components when finish.

[rentasite]

I am testing solutions 1 and 2 locally and I will notify you in a few minutes regarding the test results.

TEST RESULTS:
Solution 1( URL encode) did not worked!
Solution 2 (CDATA) worked fine!

Use CDATA and better also replace &amp; with just & inside the querries. If this works for you I will update the Elxis installer to use CDATA in these queries.

Ok, im doing it now. Thanks.

[rentasite]

The installation went further ok. I finished it. but from the admin area, the URL (in Categories Manager) is still as follows:


/administrator/index2.php?option=categories&amp;section=com_contact_details

[datahell]

What's wrong with the above URL? It seems ok.

[rentasite]

Don't u see the &amp; ?

And the result is... i go to Contact Categories, and it returns me to Categories Manager.

[datahell]

I told you to replace &amp; with just & in sql queries. Did you do that? (although &amp; is fine -and better/XHTML valid- for links)
It converted the & to &amp; ?
Maybe it would be better to send me access info to your site to test it by myself.