zomzommarketing

OK, I figured mine out.

I opened the file into Dreamweaver which sorts out the correct spacing (I presume) because doing a paste directly didn’t work.

Once that was done (as well as adding “– “) at the dashed line, everything worked.

cheers

Found something:

This
— MySQL dump 8.21
—
— Host: localhost Database: abbeylanebandb_db1
———————————————————
— Server version 3.23.49-log

—
— Table structure for table ‘wp_categories’
—

has to be changed to this
— MySQL dump 8.21
—
— Host: localhost Database: abbeylanebandb_db1
— ——————————————————-
— Server version 3.23.49-log

—
— Table structure for table ‘wp_categories’
—

“– ” must be added at the lone dashed line. Now there is another error.

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”wp_links’
—

CREATE TABLE wp_links (
link_id bigint(20)

It would be great to hear the fix on this too because I have almost the exact same problem. My database is 3.23.49 going to 4.1 I believe.

The biggest issue for me is the old site is gone and the host provided the sql file in an email to me (he’s a friend, don’t worry), so that’s all I have.

My error on phpmyadmin doesn’t tell me where the problem lies:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘———————————————————
— Se

You see, it seems to cut of the info I need.

In any event I will follow this support question by markdanthonysr because I betting it is the same fix.

OK, let’s resolve this now:

in 2.1 widgets are still a plugin and found in the plugin folder. find widgets.php and look for this line of code
<?php wp_list_cats...
(mine was on line 919)
Make the changes based on the https://codex.www.ads-software.com/Template_Tags/wp_list_cats instuctions. Mine looked like this when it was done:

<?php wp_list_cats("sort_column=id&optioncount=$c&hierarchical=$h&exclude=1, 4"); ?>

Thanks for letting me think out loud.

Oh I am such a noob!

OK, That’s what’s happening then.

Where is that code located – I think I can handle it from here after pointing me in the right direction – thanks

I love WordPress –

Yup, Tried that with a cut and paste – no go.

Tried this too:
<?php wp_list_categories('orderby=ID&include=2,3,5,6,7,8,9'); ?>

No change.

Nothing in functions.php to change?

The code is in my sidebar.php file.

It looks like this:
<?php wp_list_categories('orderby=id&exclude=4'); ?>

But it still orders by name and category 4 still is on display.

(I made a home page with <?php get_header(); query_posts('category_name=home'); ?> in the header. home is category 4 and doesn’t need to be in the list. The list is a portfolio of services.

The theme is from TemplateMonster.

It’s odd that wp_list_pages is not in the header but rather in the index.php, page.php and now my home.php don’t you think? This wouldn’t cause it would it?

I have tried that before posting this but thanks for that quick reply. That’s why I’m thinking I need to replace more elsewhere in the theme than just the one line.