Can't create a published categorie

by **TopCop** » Sat Feb 07, 2009 3:15 pm

OS : Linux i
PHP : 5.2.8
MySQL : 5.0.67-log
Zeit : 15:05
Caching : Deaktiviert
GZIP : Deaktiviert

Joomla 1.5.9
JEvents 1.5 beta

Hi,
I installed JEvents for the first time on my system.
I did a DB Setup after installation.
When I create a new categorie, the categorie is created but unpublished. So when I want to create a new event I can see that there is a unpublished categorie. But in the categorie list I'm not able to see this unpublished categorie and change it to published.
When I go to manage ical calenders I get the following error:

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /homepages/22/d207966045/htdocs/vm/administrator/components/com_jevents/controllers/icals.php on line 101
DB function failed with error number 1146
Table 'dbXXXXXXXX.jos_jevents_categories' doesn't exist SQL=SELECT c.*, e.color FROM jos_jevents_categories AS e, jos_categories as c WHERE c.id=e.id

Any help would be appreciated.

TopCop

by **Geraint** » Sat Feb 07, 2009 3:19 pm

The problem is that you have a table missing something went wrong with te DB setup.

Can you enable Joomla max error reporting (in joomla config) and Joomla debug messages and hit DB setup again.

Cut and paste into your reply any error messages and the debug code that includes the "create table jos_jevents_categories".

thanks

Geraint

by **TopCop** » Sat Feb 07, 2009 3:32 pm

==> PM

Thanks in advance,
TopCop

by **Gugge** » Sat Feb 07, 2009 9:15 pm

I have the same problem:

This is what I get when trying to create the databases:

Code: Select all: DatabaseMySQL::query: 1146 - Table 'joomla.jos_jevents_categories' doesn't exist SQL=SELECT c.* , e.color, g.name AS _groupname, pc.title as parentcat, e.admin FROM jos_categories as c LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_categories as pc ON pc.id = c.parent_id LEFT JOIN jos_jevents_categories as e ON e.id = c.id WHERE c.section='com_jevents' AND c.parent_id=0 ORDER BY ordering

This is the output when (re-)installing the component (note the time):
Application afterLoad: 0.146 seconds, 0.37 MB
Application afterInitialise: 2.294 seconds, 4.58 MB
Application afterRoute: 2.294 seconds, 4.58 MB
Application afterDispatch: 314.827 seconds, 8.58 MB
Application afterRender: 316.102 seconds, 9.23 MB

No sign of any "

Code: Select all: create jos_jevents_categories

"

If I do a completely new installation (and manually remove all tables) I can access the admin interface, I don't get any errors, but I can't create any categories. They do get created in the jos_categories, though .

Running Apache/2.0.59 (Win32) DAV/2 PHP/5.2.3 at localhost with a memorylimit 128 Mbyte

Gugge

by **Geraint** » Sat Feb 07, 2009 9:24 pm

Sorry - A stupid mistake in the table construction query.

At line 545 of administrator/components/com_jevents/controllers/config.php

Change the code from

Code: Select all: admin int(12) NOT NULL default 0,

to

Code: Select all: admin int(12) NOT NULL default 0

I'll fix the package immediately.

Geraint