Author Topic: Contribution Page ID is NOT accepted on Menu Manger (Read 6873 times)

Signals · April 02, 2009, 11:49:11 am

Thanks for your contribution (no pun intended).

It is a different ISP, and you have no extra extensions. What revision of Joomla are you running?

I am not seeing the ?? surrounding the page types, so that seems to be another issue but, yes, it is the line 68 in select.php that is causing me grief.

Anyone else?

Matthew

carpenter · April 03, 2009, 02:09:17 pm

1.5.9

carpenter · April 03, 2009, 02:35:01 pm

Lobo, you said:

the views code was contributed by a community member. To be honest, we dont really understand the mechanism of how it works etc very well, hence our ability to debug / help fix the issue is quite limited

lobo

I get the same problem on the civi2.2 joomla demo site. Could you please confirm that this is happening to everyone using the Joomla ver of 2.2?

http://joomla.demo.civicrm.org/administrator/index.php?option=com_menus&task=edit&type=component&url[option]=com_civicrm&url[view]=Contributions&menutype=mainmenu

Thanks,
Dan

Signals · April 20, 2009, 09:25:24 pm

Folks,

I continue to struggle with the same issue on this site. I have tried upgrading to Joomla! 1.5.10 and CiviCRM 2.2.2, but no luck.

I have another organization I wanted to pitch CiviCRM to so yesterday I set up a new website, using J! 1.5.10 and C! 2.2.2. Though it is not completely set up / configured, it did not seem to have a problem in the initial test. I will continue to set up this site and see if I can get a working site with CiviCRM.

So what's the difference between the two sites? They are on different servers, though with the same ISP. so I don't think that would do it.

Using phpMyAdmin, which is way beyond my scope of understanding, I look at the database tables to see what differences I can find. The one that jumps out at me is that the original (non-working) site has similar field names to the newer site, but several are appended with _en_US and a related field ending in _es_ES. I used to have JoomFish installed for translations but it did not work very well so I uninstalled it. Joomla! itself, however, retained its two language files. The new site has not been introduced a second language nor is it planned at this time.

Before I spend many hours copying out all my data and totally blowing out the site so I can start again re-building from scratch (content, menus, template, CiviCRM fields etc), does anyone have any final suggestions?

I await words of wisdom from the community.

Thanks in advance,
Matthew

Dave Greenberg · April 21, 2009, 02:22:50 pm

Matthew - Thx for digging into the tables on your "broken" site - that gave me a clue. Turns out that at least one cause for the menu manager problem(s) is that it currently does NOT work for sites that have been configured for Multiple Language Support in CiviCRM (under Global Settings >> Localization). This was apparently done on your original site.

I'm not sure how big a fix this will be - but I've filed an issue for 2.2.3. If it's not too complex, the fix will be included in the next release.

http://issues.civicrm.org/jira/browse/CRM-4404

Unfortunately I don't think there's an easy way to "recover" the CiviCRM configurations in your original site (custom fields etc.). However, you can probably retain your Joomla stuff by uninstalling CiviCRM and deleting all civicrm_* tables using phpMyAdmin to run the sql script we provide to drop all our tables. Check under administer/components/com_civicrm/civicrm/sql/civicrm_drop.mysql .

Signals · April 22, 2009, 11:42:50 am

Dave,

Thanks for replying to my post. As my database has encountered three levels of multilingual support (Joomla! itself, Joom!Fish and CiviCRM), I want to be clear on this, and feel this issue would warrant clarification for the community at large.

Let's assume a brand new "English-only" site.

1) I install CiviCRM and I am able to add CiviCRM menu items in Joomla!. (This is the case with my new site.)
2) I add the Spanish language file for Joomla! and I can still add CiviCRM menu items in Joomla!.
3) I add Joom!Fish with Spanish language file, making the Joomla! website bilingual, and I can still add CiviCRM menu items in Joomla!.
4) I add CiviCRM Spanish language file and activate Spanish language in CiviCRM and I can NO LONGER add menu items.

If so, it would be fair to say that CiviCRM for Joomla does not have multilingual capabilities yet, but I can still add CiviCRM in English to a multilingual site. Is that correct?

Having looked at the issues link in your post, you mentioned URL params. I tried using http://www.hispaniccanadian.org/index2.php?option=com_civicrm&task=civicrm/contribute/transact&reset=1&id=3 (tried the live site from inside the admin panel and removed /administrator from the path) both as an External Link and a Wrapper and it brought up the page, though I am still working with the Treasurer to get his PayPal account working. Once he fixes that, is there any reason why the data may not be processed properly doing it this way? This may be a way of getting around this issue until the permanent solution is incorporated into a future revsion.

Thoughts?

Thanks,
Matthew

carpenter · April 22, 2009, 12:56:11 pm

We did a fresh install of civicrm 2.2.2 and it corrected the problem.

Signals · April 22, 2009, 02:15:52 pm

Looking at the drop civicrm issue. In phpMyAdmin, if I only want to get rid of the fields that end in _en_US and _es_ES, leaving their non-suffixed counterparts in tact? If I do this, it may keep my data in tact, no?

Dave Greenberg · April 22, 2009, 08:54:22 pm

Quote from: Signals on April 22, 2009, 02:15:52 pm

Looking at the drop civicrm issue. In phpMyAdmin, if I only want to get rid of the fields that end in _en_US and _es_ES, leaving their non-suffixed counterparts in tact? If I do this, it may keep my data in tact, no?

I don't know the answer to this. I've asked the person who designed this part of the system to chime in.

Dave Greenberg · April 22, 2009, 08:58:48 pm

Quote from: Signals on April 22, 2009, 11:42:50 am

4) I add CiviCRM Spanish language file and activate Spanish language in CiviCRM and I can NO LONGER add menu items.

If so, it would be fair to say that CiviCRM for Joomla does not have multilingual capabilities yet, but I can still add CiviCRM in English to a multilingual site. Is that correct?

Turning on multi-lingual capabilities is definitely breaking the ability to add front-end menus. However, I'm not sure how display of front-end pages in different languages is affected. Looking for our i18n gurus to chime in here.

Quote from: Signals on April 22, 2009, 11:42:50 am

Having looked at the issues link in your post, you mentioned URL params. I tried using http://www.hispaniccanadian.org/index2.php?option=com_civicrm&task=civicrm/contribute/transact&reset=1&id=3 (tried the live site from inside the admin panel and removed /administrator from the path) both as an External Link and a Wrapper and it brought up the page, though I am still working with the Treasurer to get his PayPal account working. Once he fixes that, is there any reason why the data may not be processed properly doing it this way? This may be a way of getting around this issue until the permanent solution is incorporated into a future revsion.

I'm pretty sure you can use the explicit URL links (as you have above) to send contributors to the online contribution page. However - it's best for you to test this through w/ a PayPal test account - in test-drive mode. You would add &action=preview to the end of the URL you have above.

Piotr Szotkowski · April 23, 2009, 02:01:08 am

Quote from: Signals on April 22, 2009, 02:15:52 pm

Looking at the drop civicrm issue. In phpMyAdmin, if I only want to get rid of the fields that end in _en_US and _es_ES, leaving their non-suffixed counterparts in tact? If I do this, it may keep my data in tact, no?

Unfortunately, the moment you went multilingual, the original (non-suffixed) columns were renamed to be suffixed, so they are no longer there (look at the civicrm_contact table – the first_name column is no more, only first_name_en_US and first_name_es_ES). What you see on the database level are views into the original tables (civicrm_contact_en_US, etc.) which expose the suffixed columns under their original names (so civicrm_contact_en_US.first_name is actually a view at civicrm_contact.first_name_en_US).

This means there isn’t a simple way to revert to a single-language install. There are almost 90 fields in the database that were localised, and you’d have to first move all of the *_en_US columns to their non-suffix counterparts, then drop all the *_es_ES columns and all the views, and then tweak civicrm_domain database.

That said, I’ll be working on extending the multilingual support in Joomla! for my Google Summer of Code project this year, and I might as well start by providing a multi-language-to-single-language revert script if you’d like to be the first user. If you send me your database (to shot@civicrm.org) I should have it reverted to single language by the end of the next week (and I’ll do my best to fix the original issue earlier).

Signals · April 23, 2009, 08:42:22 pm

Piotr,

Thanks for your input. In fact, while I was waiting for further feedback (my time to play with this is limited these days so, when I get time, I "try stuff"), I tried the following:

1) I uninstalled CiviCRM.
2) I dropped all tables (left column - sorry if I am using the wrong terminology) suffixed _es_ES.
3) I went through all remaining tables and dropped fields within them suffixed _es_ES.
4) I removed the suffix _en_US from all fields in the non-suffixed tables.
5) I dropped all tables suffixed _en_US.

At this point, as far as I could tell, there was nothing in the entire database that suggested a language via one of those two suffixes.

I then re-installed CiviCRM and it was broken. The error seemed to be looking for some suffixed values. I guess that didn't solve it, so I did a restore to at least bring it back for now.

With respect to your project, I am happy to help and be a part of the ongoing advancement of CiviCRM. Anything that won't break the live site, I'm there. In terms of extending the multilingual support, is there any way I can help? I am not a coder but would be happy to help you test the app when it is ready.

I will send you my database momentarily.

Thanks,
Matthew

Piotr Szotkowski · April 24, 2009, 12:05:51 am

Quote from: Signals on April 23, 2009, 08:42:22 pm

Thanks for your input. In fact, while I was waiting for further feedback (my time to play with this is limited these days so, when I get time, I "try stuff"), I tried the following:

1) I uninstalled CiviCRM.
2) I dropped all tables (left column - sorry if I am using the wrong terminology) suffixed _es_ES.

(They look like tables, but they’re only views – i.e., ‘windows’ that expose the ‘real’ tables’ data under different names.)

Quote

3) I went through all remaining tables and dropped fields within them suffixed _es_ES.
4) I removed the suffix _en_US from all fields in the non-suffixed tables.
5) I dropped all tables suffixed _en_US.

Wow, you did a lot of work!

Quote

At this point, as far as I could tell, there was nothing in the entire database that suggested a language via one of those two suffixes.

You also need to visit the civicrm_domain table and in the sole row in that table set the column locales to NULL.

Quote

With respect to your project, I am happy to help and be a part of the ongoing advancement of CiviCRM. Anything that won't break the live site, I'm there. In terms of extending the multilingual support, is there any way I can help? I am not a coder but would be happy to help you test the app when it is ready.

Thanks! As soon as I’ll have some stuff to test I’ll let you know. :)

Signals · April 24, 2009, 12:43:26 am

Quote

You also need to visit the civicrm_domain table and in the sole row in that table set the column locales to NULL.

ACK!!! You mean after all that work, I was one step away from this thing being corrected? Wow! What a drag!

Anyway, thanks for your clarification regarding mySQL. Though I am anxious to actually start using CiviCRM (live), this has certainly been a terrific learning experience!

I look forward to receiving your project output.

Regards,
Matthew

Piotr Szotkowski · August 12, 2009, 05:56:06 am

My GSoC project ended and I’m happy to report that a multilingual → single-language transition should be possible as of CiviCRM 3.0.alpha1.

CiviCRM Community Forums (archive)

News:

Author Topic: Contribution Page ID is NOT accepted on Menu Manger (Read 6873 times)

Signals

Re: Contribution Page ID is NOT accepted on Menu Manger

carpenter

Re: Contribution Page ID is NOT accepted on Menu Manger

carpenter

Re: Contribution Page ID is NOT accepted on Menu Manger

Signals

Re: Contribution Page ID is NOT accepted on Menu Manger

Dave Greenberg

Re: Contribution Page ID is NOT accepted on Menu Manger

Signals

Re: Contribution Page ID is NOT accepted on Menu Manager

carpenter

Re: Contribution Page ID is NOT accepted on Menu Manger

Signals

Re: Contribution Page ID is NOT accepted on Menu Manager

Dave Greenberg

Re: Contribution Page ID is NOT accepted on Menu Manager

Dave Greenberg

Re: Contribution Page ID is NOT accepted on Menu Manager

Piotr Szotkowski

Re: Contribution Page ID is NOT accepted on Menu Manager

Signals

Re: Contribution Page ID is NOT accepted on Menu Manager

Piotr Szotkowski

Re: Contribution Page ID is NOT accepted on Menu Manager

Signals

Re: Contribution Page ID is NOT accepted on Menu Manager

Piotr Szotkowski

Re: Contribution Page ID is NOT accepted on Menu Manger