No contents and a database error

[Michelle]

A super moderator in my site was trying to break him article in several pages with the break bbcode and told me it didn't work. Surprised I went there and realised there was no errors in the syntax and yet, no pages!!
We were trying to find out what the problem was when, if these weren't enough, now whe also have a database error:
Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT t.threadid, t.title, u.username, t.forumid FROM vb3_thread t
INNER JOIN vb3_user u ON t.postuserid = u.userid
WHERE t.forumid in (-1,34,35,36) AND t.threadid IN (-1,13,12,15,10,14,16,17,11) ORDER BY RAND() LIMIT 0,;

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 '' at line 3
Error Number : 1064
Date : Saturday, January 14th 2006 @ 03:30:09 PM
Script : http://www.mycat.gr/forum/showthread.php?t=16
Referrer : *********
IP Address : ********
Username : Michelle
Classname : vb_database

Any ideas?
Here is the faulty article (in fact it's a copy of the type "article" called "breed", not actually an article :)): http://www.mycat.gr/forum/showthread.php?t=16

[The Geek]

One of your modules has an empty setting. Try going back through them and saving (both showthread and forumdisplay pages).

HTHs

[Michelle]

Nope I can't find any, I am searching for much time now.
Can you have a look please? (I hope you still have the admin login :))

Oh and btw it doesn't happen only in this article but in all the articles in the showthread page (forumdisplay is ok)

[The Geek]

It will be a module in one of your module sets (the showpage portion).

Anyhooo, I dont keep logins so you need to double check your module set settings and then if you are still having problems, drop me a line :)

[Michelle]

I've not only double-checked but I've been checking the default module set (Reviews work ok but I checked their set too) since you told me :(
I even tried to figure out something via the database error but no luck :(
I'm going to send you a pm, so check your pms in 1-2 minutes from now :)

[Michelle]

Any luck with this? :o

[The Geek]

Just about to go look at it :)

[Michelle]

YESSS!!! At last!!!! I can't stand the complaints of my beta testers any more!!! Yay!!!

[Michelle]

Geek check your pms, the problem is not solved :(

[NCangler]

I just installed the v.1.0 upgrade and I"m having the same problem. Any resolution to this? THanks for any help.

[NCangler]

Okay, I'm slow. :) I found it in the modules. As described there were no entries or "0" in the number to display in the module. It is working now. :)

[Rich]

Hello,

I have found that when adding a new module, you need to set the order number twice. The first is when you register the module and the second time is after it displays the module in the listing for that set. It doesn't seem to "remember" what you entered when you first registered the new module.

[The Geek]

huh, I havent noticed that. Ill check it out.

[toxic]

Can someone help me also with this. i just installed GARS Gold, and have teh same problem. i setup 3 forums to use for Articles, tutorials and reviews.

when there was no posting in the forum i was able to post an article/review/tutorail but then I cannot view it now once i had saved it.

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT * FROM gars WHERE threadid=;

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 '' at line 1
Error Number : 1064

etc etc

I cannot understand what module to eidt please will someone be more specific as to WHAT i have goto edit.

[The Geek]

It sounds like you MAY have another hack that is interfering with GARS. Canyou check by disabling all other hacks and just testing?

Thanks :)

[toxic]

ok have found that i cannot use vbAdvanced portal with navbar on left of forums with GARS has anyone a work around for this, i have even tried using no modules for gars on sides etc, but no joy

[toxic]

all my forum php pages have at the start:

<?php
define('VBA_PORTAL', true);
define('VBA_PAGE', 'include');

which obviously GARs does not like. any work around for this? i have noticed workarounds for other vbgeek products and VBA CMPS, surely there should be one for this hack?

[The Geek]

Are you sure? I couldnt imaging the column thing for vba causing a problem. I was thinking it was more like something that uses the hook system.

[toxic]

as soon as I removed the code from forumdisplay.php it worked.

when i added

define('VBA_PORTAL', true);
define('VBA_PAGE', 'include'); to forumdisplay

i get:

Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT * FROM gars WHERE threadid=;

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 '' at line 1
Error Number : 1064
Date : Monday, February 6th 2006 @ 10:38:13 AM
Script : ***********************
Referrer : ********************
IP Address : *****************
Username : Toxic
Classname : vb_database

funny thing is is i use the

define('VBA_PORTAL', true);
define('VBA_PAGE', 'include');

code and have no articles i cna actually post a new thread/post. but if there is a post already in an article i cannot view it:)

[The Geek]

hmmm. My only guess is that vba must overwrite a variable I need.

[toxic]

hmmm. My only guess is that vba must overwrite a variable I need.

is there any easy way i can find out what variable both hacks share? I really want both VBA and GARS but it looks like i may need to drop VBA in forums for it to work.

[The Geek]

well, for some odd reason it looks as if $threadid gets unset somewhere in vba. Though honestly that seems really odd as its a common variable that I doubt Brian would have purposely unset.

Search through the vba includes files for unset and see if there is a threadid in any of them.

[toxic]

:( none that i can find.

[The Geek]

Im not too sure what to say at this point. I will look into it when I can get some time on a test board - however this wasnt happening with earlier versions of vba (to my knowledge) and vba isnt my product so its a bit difficult to identify the problem.

[toxic]

thanks. i've disabled the code for the forums so GARS works and just added the code to other pages that gars doesn't use.