On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

Current User: Guest
Please consider registering

 
Search Forums:


 




Page Category Plus cannot handle databases with hyphens

UserPost

10:45 pm
15 Dec 2007


regenpfeifer

New Member

posts 2

 
1

I’m trying Page Category Plus 1.1. with WP 2.3.1 german-edition. When choosing the <"Verwalten" (should be something like "Manage" in English) -> Page Category Plus> -options I’m getting the following error message:

WordPress database error:
[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 '-blog' at line 1]
SHOW TABLES FROM mydatabasename-blog

This seems to be due to the fact that I’m using database-names containing hyphens, which has caused no problems so far with wordpress or any other plugin.

11:25 pm
15 Dec 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
2

The line of code utilises the DB_NAME constant which is defined in your config.php file. I can see no propblem withn the plugin code whatsoever and as DB_NAME is used all over WP, I am unable to explain the error you are seeing.

11:54 pm
15 Dec 2007


regenpfeifer

New Member

posts 2

 
3

Thank you for your answer, Andy. My "config.php" has the following line:

define(’DB_NAME’, ‘mydatabase-blog’);

WordPress: 2.3.1 (de)

PHP: 4.3.10

MySQL: 4.1.10a

I’m getting this error in nine WordPress-Installations which are all hosted at a Virtual Server with SUSE Linux 9.3.

Any more ideas?

10:24 am
17 Dec 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
4

Sorry - I can find no answer. Even on the rather old version of MySQL yiuy are using there the SQL is correct as far as my research goes. Sorry.

Does anyone else have any deas? 



Reply to Topic: Page Category Plus cannot handle databases with hyphens

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 12 + 10        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

13 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 1941

Posts: 13154

Members:

There are 916 members

There are 796 guests


Yellow Swordfish has made 5009 posts

Top Posters:

Mr Papa - 1437

-Radio- - 518

ovizii - 106

jfv - 82

RoseCitySister - 68

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)