Sero Theme Events/New Problems

Same problem here – I installed with WP 2.8 – and it has never worked. My posts to Aaron – the theme developer – sit awaiting moderation for weeks…

I am thinking it is sopmething in the upgrade interfering with the feed…

It couldn’t be something daft like the date formats… could it?/????

Any help would be most welcome… and if I find anything, I will post here.
-Simon

Here is the full result from running the query…

Error

SQL query: Documentation

SELECT DISTINCT *
FROM wp_posts AS posts
LEFT JOIN wp_term_relationships ON ( posts.ID = wp_term_relationships.object_id )
LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id )
WHERE 1 =1
AND wp_term_taxonomy.taxonomy = ‘category’
AND wp_term_taxonomy.term_id
IN (
$sero_events_id
)
AND (
posts.post_status = ‘publish’
OR posts.post_status = ‘future’
)
AND (
posts.post_type = ‘post’
)
AND posts.post_password = ”
AND (
posts.post_date >= NOW( )
)
GROUP BY posts.ID
ORDER BY posts.post_date ASC
LIMIT 0

MySQL said: Documentation
#1054 – Unknown column ‘$sero_events_id’ in ‘where clause’

I am improvising here! $sero_events_id is a php variable… so I am tracing that… and will replace it in the query with a value… or just delete the clause.

I examined the MySQL database and found that the term_id for the Events category was 10, in my database. (That all depends on the order in which you create categories!

I re-ran the query directly against the database, insertingthe value 10 as follows:

SELECT DISTINCT *
FROM wp_posts AS posts
LEFT JOIN wp_term_relationships ON ( posts.ID = wp_term_relationships.object_id )
LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id )
WHERE 1 =1
AND wp_term_taxonomy.taxonomy = ‘category’

AND wp_term_taxonomy.term_id = 10 // This is the clause I changed//

AND (
posts.post_status = ‘publish’
OR posts.post_status = ‘future’
)
AND (
posts.post_type = ‘post’
)
AND posts.post_password = ”
AND (
posts.post_date >= NOW( )
)
GROUP BY posts.ID
ORDER BY posts.post_date ASC
LIMIT 0

The result of this was the information that no rows were found. There is clearly something wrong in this query – it should deliver one row of data in my database – since I have one future event in the Events category.

I am now dissecting teh query clause by clause. Will keep you “posted”.
By the way, right now, ALL my posts only seem to go to the News tab – and nowhere else! Hmmm… I might have to raid another theme for code that works!

Simon Carter
Leaphrog Design
http://www.leaphrog.co.uk

I now find that actually NO posts are posting correctly….
so I am going to pull this SQL query down to basics to see which part does not work…

I am recording this all here partly for myself… so don’t worry if you don’t get what I am doing… because neiother do I! Haha

OK – The EVENTS part is working now… although it is a clumsy fix… because I think there is a backend problem – for example, when I set which category to feed to NEWS and EVENTS, there is nothing appearing in the drop-downs… so THAT is where the real problem is.

The work-around is good, as long as you know what is the

term_id

for the Events category (In MY database, it is 10)

From the WP Dashboard… select >Appearance>Editor
on the right side choose the Theme Functions (functions.php).

Scroll down to line 185, which is in the function get_upcoming_events().

************ IMPORTANT***********************************************
COPY the whole line to Notepad or somewhere as a back-up, in case you need to restore it!
*********************************************************************
Did you do the above? If not… GO BACK AND DO IT NOW!

This line creates an SQL query in the form of a text string… and assigns it to a variable called $query. It is a very long line…. You need to find the section that says…
AND wp_term_taxonomy.taxonomy = ‘category’
AND wp_term_taxonomy.term_id
IN (
$sero_events_id
)

and change it to:

AND wp_term_taxonomy.taxonomy = ‘category’
AND wp_term_taxonomy.term_id
= 10

or – whatever your particular EVENTS category term_id IS (Mine is 10)

Next, go to the END of the same line… to the expression…

LIMIT 0

and change it to:

LIMIT 0, 5 This allows up to 5 future events to be displayed… in the EVENTS tab. You can make it any number you like…

NOW, I still have ALL posts appearing on the NEWS tab… so I will work on making that just display the NEWS category…

I will use the same code as the amended code above, but change the category_id to the NEWS category ID… and set it to show the five most recent PAST events. I will document that later.

OK – NOW my site works using the EVENTS and NEWS tabs as they should work.
Problems still, in that I cannot get any OTHER posts to appear – but this does not matter to me, since this site is fairly static (except for NEWS and EVENTS).
****************
Solution Stage 1:

DOWNGRADE WordPress installation to version 7.2.1, using the instructions at: http://techie-buzz.com/wordpress/downgrade-uninstall-wordpress-28.html

This will allow you to configure the NEWS category correctly in the Admin page. The EVENTS drop-down is still blank.

DO NOT BE ALARMED when you have completed your downgrade, if WordPress tells you you have to UPGRADE your admin pages when you log in to Admin. This is ok – it is only the Admin zone that is upgraded again, and the back-end is still 7.2.1 (You will see this at the top of the admin screen where you are continuously prompted to upgrade to 8.2.1. Learn to live with it!

The zipped backup of my database needed to be UNZIPPED before it was successfully re-uploaded and imported.

*****************
Solution Stage 2:

You need to find the term_id for the Events category. You cannot set it using the Admin tools, because it is not working, so you have to do it manually.

Your EVENTS category has a “term_id” which you will need. It is an integer number probably between 1 and however many categories you have made (ever). You can use trial and error here – OR go into the database using PhpMyAdmin and look in the table wp_term_taxonomy which contains this field.

*****************
Solution Stage 3:

Get the EVENTS tag working by editing the file function.php (THEME FUNCTIONS) under APPEARANCE > EDITOR. Scroll down to line 185 (although the line numbers in 2.7.1 have now disappeared!!!!) so you can search )(find) the comment line… //Get events

Beneath it you will find the code for the function get_upcoming_events().

It is the line beginning with “$query” that you need to edit. It contains the expression:

WHERE 1 =1
AND wp_term_taxonomy.taxonomy = ‘category’
AND wp_term_taxonomy.term_id
IN (
$sero_events_id
)

My term_id for Events category was 10, so I changed the expression above to:

WHERE 1 =1
AND wp_term_taxonomy.taxonomy = ‘category’
AND wp_term_taxonomy.term_id
= 10

*****************
My News and Events tabs now both work as expected.

Hope it helps.

If you have difficulties with any of this, let me know if you need more detail.

********************************************************************

I can walk you through the database bits if you need help but probably need to fix a time for real-time chat for this. I used PhpMyAdmin, through the C Panel interface of my hosting company. I had not don it before – although I know databases quite well. “But screw (y)our courage to the sticking place and (you)’ll not fail!) (Macbeth)(-ish)