Invalid default namespace ID detected.

Invalid default namespace ID detected. - what the hell ?

Quote:

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

Code:

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

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.

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

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.

i am adding now 3 reports

Code:

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 :

Code:

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 :

Code:

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 :

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.

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

Quote:

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

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.