Invalid default namespace ID detected. - what the hell ?

[Bossland]

Invalid default namespace ID detected. Make sure that you have set up the default namespace via the Namespace Manager. If you have, check that the CES VaultWiki option "Namespace ID of the Default Namespace" matches a namespace ID from left column of the Namespace Manager (default: 6) and is not a forum ID.

If that setting is correct, it is possible that the Namespace Cache is not up to date because of corruption or a recent VaultWiki upgrade. To solve this issue, simply go to the Namespace Manager and select Rebuild All Namespaces.

Thats how i love paid products, they allways work, like the vBSEO shit.

Now, for someone who does not know what this stuff means at all ...

Namespace Manager <--- ????
CES VaultWiki <--- ?????
Namespace ID of the Default Namespace <--- ????

What the heck the thing wants from me

[Bossland]

Database error in vBulletin 4.0.2:

Invalid SQL:

			SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
			FROM vb_thread AS thread
			LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
			WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10'  AND thread.forumid NOT IN(3,39,)
			ORDER BY lastpost DESC
			LIMIT 0, 15;

MySQL 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 ')
			ORDER BY lastpost DESC
			LIMIT 0, 15' at line 4
Error Number  : 1064

disabled VaultWiki after 1k vBulletin spam emails in 15 minutes

[pegasus]

The first error means that you never setup the default namespace. Not sure what version of VaultWiki you're using (Lite has this info in the readme), this is mentioned here: http://www.vaultwiki.org/manual/Initial-Setup

Also it doesn't help us solve a database issue when you remove the URL where it's occurring. When you do that, we have no idea what to do to reproduce the problem.

[Bossland]

I still dont get it what is the CES VaultWiki > Namespace Manager i do not see such a thing in my Admin CP

I dont think its too much of effort to see my subscription - Premium 3.0 RC2 bought today

uploaded all files , run the install / deleted the install folder and run into that issue

Not sure what this Namespace Manager is and where i can find it

[pegasus]

I don't think that the VaultWiki sub-group will appear while VaultWiki is disabled. It's annoying, but this is the way vBulletin does things.

Sorry for if I was being curt before. You were not showing as licensed until a few minutes ago, which is why I asked.

Still, the MySQL error you received should have also included a script URL that was throwing the error. This URL will tell us what file contains the issue.

[Bossland]

i am adding now 3 reports

Database error in vBulletin 4.0.2:

Invalid SQL:

			SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
			FROM vb_thread AS thread
			LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
			WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10'  AND thread.forumid NOT IN(3,39,31,38,)
			ORDER BY lastpost DESC
			LIMIT 0, 15;

MySQL 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 ')
			ORDER BY lastpost DESC
			LIMIT 0, 15' at line 4
Error Number  : 1064
Request Date  : Monday, May 3rd 2010 @ 10:47:44 PM
Error Date    : Monday, May 3rd 2010 @ 10:47:44 PM
Script        : http://www.buddyforum.de/forum.php
Referrer      : http://www.buddyforum.de/forumdisplay.php?32-Gatherbuddy-Honorbuddy-Downloads
IP Address    : 94.197.xxx
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Database error in vBulletin 4.0.2:

Invalid SQL:

			SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
			FROM vb_thread AS thread
			LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
			WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10'  AND thread.forumid NOT IN(3,39,)
			ORDER BY lastpost DESC
			LIMIT 0, 15;

MySQL 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 ')
			ORDER BY lastpost DESC
			LIMIT 0, 15' at line 4
Error Number  : 1064
Request Date  : Monday, May 3rd 2010 @ 10:48:33 PM
Error Date    : Monday, May 3rd 2010 @ 10:48:33 PM
Script        : http://www.buddyforum.de/forum.php
Referrer      : http://www.buddyforum.de/
IP Address    : 71.61.xxx
Username      : xxx
Classname     : vB_Database
MySQL Version :

Database error in vBulletin 4.0.2:

Invalid SQL:

			SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
			FROM vb_thread AS thread
			LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
			WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10'  AND thread.forumid NOT IN(3,39,)
			ORDER BY lastpost DESC
			LIMIT 0, 15;

MySQL 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 ')
			ORDER BY lastpost DESC
			LIMIT 0, 15' at line 4
Error Number  : 1064
Request Date  : Monday, May 3rd 2010 @ 10:45:45 PM
Error Date    : Monday, May 3rd 2010 @ 10:45:45 PM
Script        : http://www.buddyforum.de/forum.php
Referrer      : http://www.buddyforum.de/addonchat.php
IP Address    : 87.79.xxx
Username      : xxx
Classname     : vB_Database
MySQL Version :

[pegasus]

The query in question is not a part of, nor is it modified by VaultWiki. It is a problematic query in the Recent Threads widget in the vBulletin CMS. There is a problem with either using this on non-CMS pages, or it was a bug in vB 4.0.2 (current release is vB 4.0.3 PL 1).

The fact that it seemed to occur around the time you installed VaultWiki is just a coincidence... I recommend updating your vBulletin installation.

[Bossland]

I have the CMS Version of vB , i will update from vB 4.0.2 PL4 to 4.0.3 PL1 and give you feedback here.

It can not be a coincidence since it stopped once i disabled the display of the Wiki

[Bossland]

Only admins can see this error. Other users can visit the site normally, but your immediate attention is needed in the AdminCP.

Invalid default namespace ID detected. Make sure that you have set up the default namespace via the Namespace Manager. If you have, check that the CES VaultWiki option "Namespace ID of the Default Namespace" matches a namespace ID from left column of the Namespace Manager (default: 6) and is not a forum ID.

If that setting is correct, it is possible that the Namespace Cache is not up to date because of corruption or a recent VaultWiki upgrade. To solve this issue, simply go to the Namespace Manager and select Rebuild All Namespaces.

Updated to 4.0.3 and activated for 2 seconds

[pegasus]

This message will persist until an admin actually uses the tools in VaultWiki > Namespace Manager to create the wiki areas. If it's not appearing in your AdminCP, then you need to enable VaultWiki, and possibly refresh the left frame. If you are using the mod "Enhanced ACP Nav" (http://www.vbulletin.org/forum/showthread.php?t=95679), then you need to switch to the Custom navigation view.