I messed something up :(

[davincim]

My memory's a little fuzzy on the exact sequence of events, but when I was configuring things in the setup manager, I entered the database information. When I first saved it I got an error. I clicked on the resulting link for setupSQL.php (I think that was the name). I got the warning message about it erasing the db, but since I had nothing in the db specifically for the calendar I figured I was all right.

So once I did that, I got the success message. But when I returned to my blog, my calendar looked all right (like it did before the change), but I use WordPress and in the categories section of the sidebar I get this message:

[Table 'stritad_calendar.wp_categories' doesn't exist]
SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count FROM wp_categories WHERE cat_ID > 0 ORDER BY cat_name asc

I only have two databases and I cannot find any reference ot the table it lists: stritad_calendar. I even deleted my WP db an reinstalled (I was just starting out with it anyway), but that didn't get rid of the error.

My blog is www.stritadads.club.com (http://www.stritadads.club.com).

Any help is very much appreciated.

[Brian]

(FWIW, it doesn't actually erase anything. The text is there as a precaution.)

You should use the same DB information for the calendar as you did for WP. Did you do this?

[davincim]

Hi Brian, no I didn't. I was careful to make a new db and therefore entered the name to it in the settings.

[davincim]

Oh wait, I just re-read your post. I should use the same db as my WP? Okay, but how does that explain the error I'm getting for the categories section of my sidebar? And to be sure I've clearly defined the type of "categories" I'm talking about it's the one that categorizes the posts in blog, not the categories of my calendar. :)

[Brian]

That error about categories isn't from this calendar script. I'm not sure what it would be. If you still have this problem, you may want to post in the Integration section of the forums so the CMS expert ve9gra can take a look. :)

[davincim]

Will do. Thanks Brian. :)

[ve9gra]

As a quick explanation, WP expects to have access to its database from begining of the page to the end. Since you've introduced a new script inside of WP, if you use a different database WP won't be able to find anything after you run the calendar. It will try to keep using the last database connection that was established... You can verify this by looking at the error message.

[Table 'stritad_calendar.wp_categories' doesn't exist]

It's using the calendar database to look for a WP table. Just change the setting in the Setup Manager (to use the same database as WP) and save the settings. It will ask you to create the table, let it do so. Afterwards, everything should work as expected.

Good luck.

[davincim]

That did the trick! Thanks a bunch, ve9gra. :)