Hello,

I guess that I should have made some updates before I jumped from 1.0 b41 to 2.0 b61, only it has been working great with the old version, so saw little need to make any changes. Only reason I did update now was simply cause the old mod_eventlistcal15q v.07 stopped working when you entered December 2009.

Now to the problem; it would seem that all my old events and categories in redEVENT are still there, only they can not be displayed. One of my events is visible but it lacks a category. When you enter to edit this event you'll find that the category list is completely empty, even though there are 6 categories listed under the redEVENT category tab.

When I enter to edit one of the existing categories under the category tab, you'll get an error if you try to save any changes.



I seem to get more or less the same problem if I am to try creating a new category (not that I really want to).



It would seem as if some columns in the database are missing, perhaps database changes which I should have gotten with previous versions that been released between 1.0 b41 and 2.0 b6.1. I am not sure, but this would probably explain why the categories can not be read, nor created and that the events can not be displayed in archive tab and not at all in frontend even though the Events statistic display that I have several events archived and one published.

Is there a simple way to make the database adjustments to fix this problem?

Your help is much appreciated!

you can add the field manually in the database with phpmyadmin, in the table jos_redevent_categories
=> color VARCHAR(20) NULL DEFAULT NULL

So that is the only thing that generates the problem? Would that change alone fix all the problems?

That did help me a little, I can now edit and add new categories. Unfortunately I still can't display the published and archived files, nor can I select a category for the events, which I assume is the reason for why they can not be displayed. But perhaps that isn't the only reason considering that the categories can not be viewed on frontend.

I attached a printscreen from editing the supposedly published event. That is the only event that I can see in backend, all the archived events are gone under the archive tab, but I can at least see that they're still on the database.



I obviously miss some columns in the database, considering that I didn't have the color column under jos_redevent_categories. Perhaps this should be reviewed to see what I lack and what I need to add to make it all work again.

Hi, could you please send me an email with your jos_redevent_xxx and jos_rwf_xxx tables at julien@redweb.dk

and if you have it, please send the same tables before the update.

Mail sent.