JEvents 1.5 (No longer actively supported)

Legacy Import Deleting All But Last Category

JEvents 2.0 was launched over 2 years ago and the latest stable version is version 2.2 which will run on Joomla 1.5 and Joomla 2.5. JEvents 1.5 is therefore no longer actively supported - you should upgrade to JEvents 2.2+ as soon as possible.
Forum rules
Please include as much detail in any test or bug reports for JEvents 1.5 as possible.

First of all, check if you are running the latest available version of Joomla! and JEvents. Posts for issues, where both systems are not updated, will be ignored.

We need the following at least:

* PHP version (e.g. 5.2.5). Note: Support for PHP4 is discontinued.
* Joomla! version
* JEvents version
* Web Server software (Apache or IIS with version number if possible)
* Server Operating system (e.g. Linux, Windows, Solaris, Darwin ...)
* Database version
* memory_limit from your phpinfo
* Web browser and version

Please enable error reporting and include any error messages in your posting. You do this via the Joomla Configuration - set "error reporting" to "maximum" on the Server tab.

Finally, please describe the steps required to recreate the problem and also please enable error reporting and give us any error messages generated.

Postby arc_admin » Sat Feb 07, 2009 10:29 pm

PHP 5.2.8
Joomla 1.5.9
Apache 2.2.11
Linux
MYSQL 5.0.67

I think the last change made to import has an unintended affect. I just did a complete un-install and re-install with current beta. I did the DB Setup and then proceeded to import my Legacy database. I had 81 items in my legacy database in 5 categories. Legacy convert produced the following output:

* 26 iCal events processed
* 26 deleted iCal events removed
* 28 iCal events processed
* 28 deleted iCal events removed
* 18 iCal events processed
* 18 deleted iCal events removed
* 6 iCal events processed
* 6 deleted iCal events removed
* 3 iCal events processed
* Events Migrated

Note that it did see all 81 items, but as it imported each category it then deleted the items as it moved on to the next category. Only the three items in the last category imported survived the process. Although all five categories have been created in my new database.

My theory is that something in the category control break processing causes it to delete all items before moving on. Problem is easily reproduced.

Cheers,
Ken
arc_admin
 
Posts: 57
Joined: Thu Jun 12, 2008 3:26 am

Postby Geraint » Sun Feb 08, 2009 9:22 am

Hi Ken

This only affects new database setups (which is why I hadn't spotted it). When I deleted my ical tables and setup the database again I could recreate the problem.

I'll investigate.

Geraint
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42850
Joined: Fri Feb 15, 2008 6:14 pm

Postby Geraint » Sun Feb 08, 2009 9:41 am

Ok - I figured out what's going on. After I introduced the concept of the "default" calendar I changed the migration code so that migrated events go into this calendar (there's no need to create a new calendar for each old category) but didn't add the category constraint on the routine to clear out the old events.

The fix is easy. In components/com_jevents/libraries/iCalICSFile.php change line c. 218 to read:
Code: Select all
$sql = "SELECT ev_id, uid FROM #__jevents_vevent WHERE icsid=".$this->ics_id . " AND catid=".$catid;

Notice the extra constraint on catid.

I'll check it in later today

Geraint
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42850
Joined: Fri Feb 15, 2008 6:14 pm

Postby arc_admin » Sun Feb 08, 2009 3:40 pm

Thank you, Geraint. That did it.

I did the following:
1) Applied the code change
2) Deleted Ical Related Tables
3) Convert Legacy Events

Everything looks great.

Side note: you might want to add an "Are you sure" to the 'Delete Ical Related Tables' and the 'DB Setup' in the CPanel. An accidental click could cause some poor admin a whole lot of grief!

Cheers,
Ken
arc_admin
 
Posts: 57
Joined: Thu Jun 12, 2008 3:26 am


Return to JEvents 1.5 (No longer actively supported)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: No registered users