jollymoon

[solved]
I dug around a little bit and noticed at the bottom of my “view source” for the webpage the jquery.colorbox.js was loaded with a ?ver=1.3.20 I checked the directory : …/wp-content/plugins/lightbox-plus/js/jquery.colorbox.js and my version was WRONG… I reloaded a fresh copy of lightbox-plus (had the new version of jquery.colorbox.js) and all the errors disappeared…

Evidently the online “update plugin” did not reload the correct version of the jquery file… had to do a manual upload…

Works!

Thanks for your help

I found and loaded :
https://www.23systems.net/plugins/lightbox-plus/
and it works with the sliding menu at https://www.edparton.com/blog and has better lightbox options… I already tooled it up and reconfigured a bunch of stuff… lots of options to play with up-front and under the hood.

Seems to work well so far. I found out the some of the Plugins were to blame for the double jquery load. Like commentLuv and comment form… I kept activating and un-activating each plugin until I got my lightbox plus to work, my menu, and a decent comment option for guests and registered users… I still get a double jquery load… Doesn’t seem to slow my blog too much.

Hope this helps.

Just for fun and to try and figure out what had happened to my LINKS and CATEGORIES I went back into PERMALINKS and changed to “Month and name” and VOILA… everything worked… ??

I then reactivated all my plugins and everything is fine…

I have NO idea what the PERMALINK change had to do with my screwed up links, but now all is well and working fine.

Sure caused me some consternation and heartache…

Maybe some other post knows what the 3.1 upgrade did to the PERMALINK structure and why switching back and forth from DEFAULT cured the gremlin??

This was driving me crazy…

I tried a lot of the suggested replacements, downgrades and plugin tips listed above because all of my blog LINKS and CATEGORIES stopped working, but nothing helped… Save ONE…

The post by QUICOTO suggested going into the PERMALINKS and selecting DEFAULT…

Now ALL my pages, links, categories, etc. work just fine. What was in 3.1 that screwed up all the link structure. So THIS TIME it was NOT a theme problem… First time an upgrade so destroyed my blog…

Hope this helps.

Did you make sure you saved it? (inside your SQL editing program? before exiting?)

Did you run the upgrade.php? ( Like above?)

Did you download and install Database Manager plugin? and run REPAIR ? (like above?)

Hope this helps…

I had almost forgotten how to do this…

You have to edit INSIDE your MySQL from whatever program your ISP lets you access it with… This would be inside your web console that allows you to edit your website at the server.

You edit the “wp_metadata” file inside the database that controls your WordPress installation. You have to use “browse” and find the tables USER_ID, wp_metauser, wp_capabilities… and select EDIT… Make sure you note the user # and edit the correct tables.

The wp_options file contains a line about version number called DB_VERSION change this number to 8204 … (on page 2, look for a little drop down box with page numbers)

Save the changes and exit the MySQL editor… then follow the rest of the help above…with the upgrade.php and the WP Database Manager Plugin.

Gotta be brave and change NOTHING else in your MySQL editor and you might make it.

[insert major waiver statement of damage and liability to your database and all the people who will be mad at me for posting this]

What an adventure !

I started out noticing that my “USERS” menu item was missing.

Then I tried to export my .WXR (really a .xml) so that I could upload my data to a new installation if needed thinking this would replace the missing “USERS” menu item. I kept getting “You do not have sufficient permissions to access this page.”

.htaccess manipulations and deactivating all my plugins (including changing the directory names) had no affect on admin getting permissions. Neither did “switching to the default WordPress theme” no go… didn’t work. Even creating a new “administrator” user did not help. I also tried setting all my directory permissions to 777, no go. The “force-upgrade.php” script mentioned in several posts did not work either. There was also nothing in the wp-config.php file that helped including blanking or deleting the “secret” access keys.

I even reloaded all the WP files for 3.0.3 and did the “manual” upgrade instructions and still NADA.

I checked the SQL tables for “admin” (or your adminstrator name)and made sure the wp_user_level is set to “10” in the wp_metauser and that the wp_capabilities is set to
” a:1:{s:13:”administrator”;s:1:”1″;} ” (no quotes) (wp_ is the default prefix and if you named your DB files with something else in your wp-config.php then that is where you need to go look , like wpx_ or wp2_ or wordpress_ etc.)

I finally got the permissions for admin to work by changing the version number in my SQL table to “8204” (it was something like 15032) Make sure you know there is more than one page in the SQL editing and table area…mine had 8 pages and it was on the 2nd page). You have to have access and know how to edit your SQL database files… (scary, I know) and then go to your WordPress directory and “upgrade.php” -voila- Permissions restored. And the “USER” menu item appeared as well!

Now I got permissions to work, BUT every single post and link on my blog got a “404 error” message! I thought I had royally messed up. All the data was there in the DB and in the “posts” when you logged into admin, but none of the links to each “post” would work.

Finally, I had a plugin called “WP DataBase Manager” that has an option to “REPAIR” database. I ran it as a last ditch effort and it worked. It DID! and everything is working perfectly!

Sure hope this saves all you people the 6 hours+ of hunting and digging that I went through.

I started out with a similar problem…

I started out noticing that my “USERS” menu item was missing.

Then I tried to export my .WXR (really a .xml) so that I could upload my data to a new installation if needed thinking this would replace the missing “USERS” menu item. I kept getting “You do not have sufficient permissions to access this page.”

.htaccess manipulations and deactivating all my plugins (including changing the directory names) had no affect on admin getting permissions. Neither did “switching to the default WordPress theme” no go… didn’t work. Even creating a new “administrator” user did not help. I also tried setting all my directory permissions to 777, no go. The “force-upgrade.php” script mentioned in several posts did not work either. There was also nothing in the wp-config.php file that helped including blanking or deleting the “secret” access keys.

I even reloaded all the WP files for 3.0.3 and did the “manual” upgrade instructions and still NADA.

I checked the SQL tables for “admin” (or your adminstrator name)and made sure the wp_user_level is set to “10” in the wp_metauser and that the wp_capabilities is set to
” a:1:{s:13:”administrator”;s:1:”1″;} ” (no quotes) (wp_ is the default prefix and if you named your DB files with something else in your wp-config.php then that is where you need to go look , like wpx_ or wp2_ or wordpress_ etc.)

I finally got the permissions for admin to work by changing the version number in my SQL table to “8204” (it was something like 15032) Make sure you know there is more than one page in the SQL editing and table area…mine had 8 pages and it was on the 2nd page). You have to have access and know how to edit your SQL database files… (scary, I know) and then go to your WordPress directory and “upgrade.php” -voila- Permissions restored. And the “USER” menu item appeared as well!

Now I got permissions to work, BUT every single post and link on my blog got a “404 error” message! I thought I had royally messed up. All the data was there in the DB and in the “posts” when you logged into admin, but none of the links to each “post” would work.

Finally, I had a plugin called “WP DataBase Manager” that has an option to “REPAIR” database. I ran it as a last ditch effort and it worked. It DID! and everything is working perfectly!

Sure hope this saves all you people the 6 hours+ of hunting and digging that I went through.

What an adventure !

I started out noticing that my “USERS” menu item was missing.

Then I tried to export my .WXR (really a .xml) so that I could upload my data to a new installation if needed thinking this would replace the missing “USERS” menu item. I kept getting “You do not have sufficient permissions to access this page.”

.htaccess manipulations and deactivating all my plugins (including changing the directory names) had no affect on admin getting permissions. Neither did “switching to the default WordPress theme” no go… didn’t work. Even creating a new “administrator” user did not help. I also tried setting all my directory permissions to 777, no go. The “force-upgrade.php” script mentioned in several posts did not work either. There was also nothing in the wp-config.php file that helped including blanking or deleting the “secret” access keys.

I even reloaded all the WP files for 3.0.3 and did the “manual” upgrade instructions and still NADA.

I checked the SQL tables for “admin” (or your adminstrator name)and made sure the wp_user_level is set to “10” in the wp_metauser and that the wp_capabilities is set to
” a:1:{s:13:”administrator”;s:1:”1″;} ” (no quotes) (wp_ is the default prefix and if you named your DB files with something else in your wp-config.php then that is where you need to go look , like wpx_ or wp2_ or wordpress_ etc.)

I finally got the permissions for admin to work by changing the version number in my SQL table to “8204” (it was something like 15032) Make sure you know there is more than one page in the SQL editing and table area…mine had 8 pages and it was on the 2nd page). You have to have access and know how to edit your SQL database files… (scary, I know) and then go to your WordPress directory and “upgrade.php” -voila- Permissions restored. And the “USER” menu item appeared as well!

Now I got permissions to work, BUT every single post and link on my blog got a “404 error” message! I thought I had royally messed up. All the data was there in the DB and in the “posts” when you logged into admin, but none of the links to each “post” would work.

Finally, I had a plugin called “WP DataBase Manager” that has an option to “REPAIR” database. I ran it as a last ditch effort and it worked. It DID! and everything is working perfectly!

Sure hope this saves all you people the 6 hours+ of hunting and digging that I went through.

I just assumed that the DB backup within WordPress was the same as an “EXPORT”

Now when I try to EXPORT the WP files I get “insufficient priviledges” when I am the only administrator… and I can’t get to USERS to change this as USERS is missing from my menu??

confusing….

ERROR
Please upload a valid WXR (WordPress eXtended RSS) export file.
ERROR

I followed the instructions in the above link for backing up my WP DB… I keep getting the above error when I try to import the DB.

If the MyPHPSQL exports an .SQL file how do I make this compatible with WordPress?

The plugins ( I have tried several) for backing up the DB also export to a .SQL format and when I try to import the file to a new WordPress installation I still get the above error…

help

Silly Question:

What is the exact format for exporting the DB from MySQL?? and how does one make the export file a WXR WordPress eXtended RSS?
(Please upload a valid WXR (WordPress eXtended RSS) export file.)

Doesn’t the WP DB database manager plugin export to the right format? I Can’t get it to export correctly either…??? it has extention of .sql or you can gZIP it…??

I just did a pristine install of WP 3.0.3 into a new directory.

“Users” menu appears as normal.

I checked the SQL DB and tried to compare the differences between the two installs.

The old install had “USERMETA” as:
a:1:{s:13:”administrator”;b:1;}

The New Intall had “USERMETA” as:
a:1:{s:13:”administrator”;s:1:”1″;}

So I edited the Old Install to: a:1:{s:13:”administrator”;s:1:”1″;}
and still no “User” menu item on the Old Install.

I don’t know what the above code means, but surely there is a DB entry that will let me access my users???

Thanks

I just checked my SQL DB and have only the following items:
wpx_commentmeta
wpx_comments
wpx_links
wpx_options
wpx_postmeta
wpx_posts
wpx_terms
wpx_term_relationships
wpx_term_taxonomy
wpx_usermeta
wpx_users

I also have an old set:
wpress_comments
wpress_links
wpress_options
wpress_postmeta
wpress_posts
wpress_terms
wpress_term_relationships
wpress_term_taxonomy
wpress_usermeta
wpress_users

Seems the only difference between the two is the “Comment Metadata”

Maybe someone can tell me what is missing??

Nope… No help… My DB backups evidently don’t go back far enough to see if they could overcome the problem… and I don’t think it is a “theme” issue, because I can change to the default theme and the problem still persists.

“amended the bits that needed changing” (from your above link) and editing the SQL DB is something I can do, if I know what it is I am to change…

Even if I do a pristine install from WP 3.0.3 when I add my current DB I think the problem will follow…My DB is to extensive to start over…

Thanks for the help…