Mini-calendar specific hyperlink

[Geraint]

Looks as though your server is unable to create this database table from PHP can you run this query from phpmyadmin to create it manually

Code: Select all

CREATE TABLE IF NOT EXISTS j17_jev_users (
   id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
   user_id int( 11 ) NOT NULL default '0',
   published tinyint( 2 ) NOT NULL default '0',

   canuploadimages tinyint( 2 ) NOT NULL default '0',
   canuploadmovies tinyint( 2 ) NOT NULL default '0',

   cancreate tinyint( 2 ) NOT NULL default '0',
   canedit tinyint( 2 ) NOT NULL default '0',

   canpublishown tinyint( 2 ) NOT NULL default '0',
   candeleteown tinyint( 2 ) NOT NULL default '0',

   canpublishall tinyint( 2 ) NOT NULL default '0',
   candeleteall tinyint( 2 ) NOT NULL default '0',

   cancreateown tinyint( 2 ) NOT NULL default '0',
   cancreateglobal tinyint( 2 ) NOT NULL default '0',
   eventslimit int( 11 ) NOT NULL default '0',
   extraslimit int( 11 ) NOT NULL default '0',
   
   categories varchar(255) NOT NULL default '',
   calendars varchar(255) NOT NULL default '',
   
   created datetime  NOT NULL default '0000-00-00 00:00:00',   
   
   PRIMARY KEY ( id ),
   KEY user (user_id  )
) ENGINE=MyISAM


[andrechapleau]

Well... My php and MySQL knowledge is quite limited, to say the least.

I never did a query in phpMyAdmin. So I'm a little lost here.

I guess I have to select my Joomla database and click on "Query"... After that, I need to select a column... Which one? Do I have to fill the criteria field? Do I select all the tables? After that, I suppose I just paste your query in the field and click on "Submit Query"... Is that it?

Just need to be sure. This is all new to me.

Thanks.

[carcam]

Just choose you Joomla! Database and you may see a button called "SQL" click on it and a textbox where you can introduce the query will appear. Introduce your query there and click "Continue".

[nicolsaaa]

Just choose you Joomla! Database and you may see a button called "SQL" click on it and a textbox where you can introduce the query will appear. Introduce your query there and click "Continue".

i didnot find it sir where it is???

[Geraint]

unzip and upload this file to administrator/components/com_jevents/controllers/ then open this URL on your site (changing the domain of course)

http://WWW.YOURDOMAIN.COM/administrator/index.php?option=com_jevents&task=config.dbsetup

I changed the query that creates this table slightly so it should now work on your server

[andrechapleau]

Thanks Geraint! The database in now set. That's great!

The only problem I have now is the overide thing... Is there a reason why it won't work like it did in Joomla 1.5?

Is there something different I have to do?

Thanks again,

André

[Geraint]

Template layout overrides have not changed JEvents - what problems are you having?

[andrechapleau]

Well, it's the same problem that a posted here last year. I had to do an overdide to bypass the hyperlink of the mini-calendar module (an link to a specific page). After your indications (see first entries of that same post), I succeeded to make the overide, but since I migrated the site to 2.5, the overide (a copied the calendar.php file) does'nt work.

There is the 1.5 page (online) : http://quebecissime.net/index.php?optio ... Itemid=427

And there is the new 2.5 site : http://67.205.91.198/~quebecis/index.ph ... -la-bolduc

When clicking on any date, I'm supposed to be redirected to the internal calendar menu (main menu : "Calendrier")

Thanks for your help.

André

[Geraint]

In which folder did you place your Joomla 2.5 calendar.php override file?

[andrechapleau]

I placed the "default" and the "geraint" folders there:

/templates/rt_zephyr/html/mod_jevents_cal