J and Beyond 2013 | An International Joomla! Conference - May 31st - 2nd, 2013, Noordwijkerhout, The Netherlands
It is currently Mon May 20, 2013 9:51 pm

Import event via sql

Discuss JEvents 2.x for Joomla 1.5-2.5 here - club members can use the special club forum for faster response times.
Forum rules
When requesting support, please copy and paste the 'Version information for Support Forum' from the JEvents Control Panel into your post. If you cannot see this, please enable JEvents project news within it's configuration. Also, if you get a 500 Error, Enable Joomla! Maximum Error Reporting and view the page again, you should now have a more detailed error which will help us to resolve you issue quickly.

Import event via sql

Postby EzerchE » Fri Dec 14, 2012 1:45 pm

Hello, i have an script to creating new events from sql queries, without using admin panel.

That was working correctly since 2 years. But a few days ago it started to not show my new created events on calendar.(passed events shows correctly) I am writing to jevents_vevdetail and jevents_vevent tables. Is that anything changed with 2.2.8?

if i create manually an event, that appears on calendar. But if i copy the jevents_vevdetail and jevents_vevent tables of that event and re-create a new event from it, thats not appear on calendar.
EzerchE
Posts: 14
Joined: Thu Feb 26, 2009 11:58 am

Re: Import event via sql

Postby Geraint » Fri Dec 14, 2012 2:45 pm

Nothing changed recently.

You also need to write to the rrule and repetitions table for JEvents to work correctly.
------------
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: 30529
Joined: Fri Feb 15, 2008 6:14 pm

Re: Import event via sql

Postby Tonyp » Fri Dec 14, 2012 2:53 pm

What version were you on before the update?
---------------------------------------

Do not forget if you like JEvents, why not join the CLUB! for priority support and lots of excellent plugin's. JEvents Club
User avatar
Tonyp
Contributor
Posts: 8744
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Re: Import event via sql

Postby EzerchE » Fri Dec 14, 2012 3:03 pm

2.2.7 was my previous version. i am not sure if is it caused the problem but the script was working correctly. i dont know what has been changed. i wasnt used rrule and repetitions before. but i will try that.
EzerchE
Posts: 14
Joined: Thu Feb 26, 2009 11:58 am

Re: Import event via sql

Postby Tonyp » Fri Dec 14, 2012 3:06 pm

Check that you have not enabled multicat support in the JEvents configuration
---------------------------------------

Do not forget if you like JEvents, why not join the CLUB! for priority support and lots of excellent plugin's. JEvents Club
User avatar
Tonyp
Contributor
Posts: 8744
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Re: Import event via sql

Postby EzerchE » Fri Dec 14, 2012 3:31 pm

Enable multi-category events (Joomla 2.5+) this option is selected as NO
EzerchE
Posts: 14
Joined: Thu Feb 26, 2009 11:58 am

Re: Import event via sql

Postby Geraint » Sat Dec 15, 2012 10:11 am

EzerchE wrote:2.2.7 was my previous version. i am not sure if is it caused the problem but the script was working correctly. i dont know what has been changed. i wasnt used rrule and repetitions before. but i will try that.

Without writing to the repetitions table I don't see how JEvents could work at all since this is a CORE table for getting event information.
------------
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: 30529
Joined: Fri Feb 15, 2008 6:14 pm


Return to Jevents 2.x (Free Access)

Who is online

Users browsing this forum: Yviberlin

cron

Main Menu

User Menu

Hosted By


Who is online

In total there is 1 user online :: 1 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: Yviberlin

Login Form