Sero Theme Events/New Problems

Good job! Well done!

My ULTIMATE solution
********************

NO code changes in PHP required….

The problem is in the database: There need to be FOUR records in the table called wp_options.
491 0 sero_events_id 10 yes
165 0 sero_events_limit 7 yes
162 0 sero_news_id 11 yes
163 0 sero_news_limit 7 yes

The first column contains unique IDs – just use IDs that have not been used yet.

The 4th column contains the term_id from the wp_term_taxonomy table for EVENTS (10 in my case) and NEWS (11 in my case). The two 7s represent the limit of posts to be displayed. Set to what you like.

Upgrading back to WordPress 2.8.1 still allowed the EVENTS and NEWS tabs to work correctly… and all the PHP code to remain unaffected.

??

I am very happy about this solution. It is better than my work-arounds above – in that … it is a better work-around! Haha.

Simon, I have been waiting for an “ultimate solution.” I’m glad to see you found one but now I need a little help implementing it.

where do I go to edit the wp_options table? Is that in the main wordpress folder? do I update it then FTP it over.. I’m totally new at this and I don’t want to have to change themes, so any help you can give would be appreciated. thanks.

ok so I’ve been playing around and I assume now that it has to be updated in MySql but I don’t know how to add to it and i’m a little scared I’ll mess it up. can you give me or point to me detailed instructions on doing this. thanks.

Hi Mitchellrw
Just one or two questions so I can give the the correct advice:

Are you using PhpMyAdmin?
Are you doing this via a C-Panel with your hosting company?

Let me know and I will see what advice I can give.

Cheers
Simon
https://www.leaphrog.co.uk

Hi Simon,

I have been following the thread too as I am having the same issue. I know enough to be dangerous but not enough to go straight into your fix. I am on WordPress 2.8.1, using PhpMyAdmin, via Plesk (not c-panel). I can get to PhpMyAdmin but need advice on editing.

Thanks,

Tigue

Ok, I have verified all 4 records are in the database correctly, I deleted and re-added the events catagory and the database updated the term_id correctly. I went ahead and modified the php also to see what happened… still no events. I have found that if I include a category widget in the optional sidebar, the events category is visible but always empty when clicked. The posts show up fine in the default theme under that category. Any advice?

I am working through my hosting company (1and1)
I go to “mysql admin” then click “phpmyadmin” next to the mysql database which lets me edit on “phpmyadmin.1and1.com”
That’s about all I know. I see “wp_options” listed as the 3rd option down. and it gives me options to “browse, structure, search, insert, etc”

This is where I get stuck. Hope that helps.

Thanks,
Will

Thank you very much for your help. I was having the same problem, but using your notes I fixed the problem. I’ve never administrated a mySQL database before but figured it out in about 10 minutes.
If this helps anyone, here’s what I did:
I’m using cPanel on lunarpages webhost…
1. clicked on MySQL Databases icon
2. clicked on phpMYADMIN at the bottom of the page
3. clicked on “databases”
4. clicked on the link for my wordpress database (it will be named whatever you created)
5. clicked on wp_term_taxonomy and looked for category descriptions of News and Events (note: I had to go back into my website and add the description to News and Events so I could identify them here). Wrote down the term_id
6. clicked on wp_options (left side of phpMyAdmin page for me) and then clicked Browse link and looked page by page until I found the sero_news_id and sero_events_id mentioned by simon.carter. I found that I only needed to add the actual term_id, save, and voila! Everything works again.
To add the term_id I simply clicked on the pencil icon (edit) to the left of each _id and filled in the term_id number in the blank box and saved.

Thank you for all your work on this simon.carter. Very much appreciated.

Dane
webservant- Calvary Chapel of Richmond
https://www.calvarychapelofrichmond.com

Thanks Dane – I think you saved me some work here (Nice to compare your site with my client’s, BTW! Good work!).

Will – is Dane’s advice enough for you or do you need more?

Tiguemon – Can I have the URL of your site to see where you are, at the moment? You seem to have created an Events Category ok – but you don’t mention assigning the Events Category term_id to the Events Tab… When I see your site, maybe we can take it from there.

??
Simon
Leaphrog Design
https://www.leaphrog.co.uk

Got it! Thanks so much guys!

BTW, I know this should go in a different thread but have any of you had any trouble w/the image carousel not working?

I know you don’t want to hear this… but… nope – it has always been about the only thing in the theme that HAS worked well.

By the way, did anyone notice the support site for the Sero theme disappearing from the Internet last week – and the subscription was paid until November!… Hmmm.

Are your images all the correct size? Try loading them only two at a time to see if one of them is causing prob!

Just Tiguemon to be unstuck now… ??

It’s nice to be useful. Kinda like payback for having a free theme!

I can’t even display the “sample” images that are included in the theme. I tried reinstalling the theme but that didn’t work either. The footer images work.

Yeah I don’t know what’s up w/him taking the site down. The owner’s name is Aaron Robbins. He hasn’t updated his blog since December ( https://www.aaronrobbins.com ) still updates his twitter though ( https://twitter.com/aaronrobbins ) and no, I’m not stocking him, I just went looking for info on what happened to Sero. I didn’t find any
Maybe he is like a lot of creative types and just has a short attention span?

Anyone know how to modify the tabs on the main page to dynamic tabs (I need to have drop down lists for each tab)

Thanks,

Dane

Simon,

Thanks for all your support, but I decided to go with another theme instead. I ended up with the Upsilon theme from Living OS. I added an event calendar plugin and all is well. It is not as easy to modify but with your help here I felt more confident about doing the edits. I will include the links below:

Upsilon theme:
https://themes.livingos.com/2008/03/04/livingos-upsilon/

Calandar plugin:
https://wpcal.firetree.net/

Bread of Life Church:
https://www.bolocala.com