DB Error after new module creation

[jluerken]

Hi Geek and others,

I created a new module (a simple copy of an existing one) and made
one forum using this module.

Now if I try to enter a thread I get a db 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,124) AND t.threadid IN (-1,9709,7647,5868,5928,6319,9705,9722,6702,6992,764 6,5942,6328,11142,9710,9706,5961,9708,7645,6149,62 84,6910,9707,6190,11156,7644) ORDER BY RAND() LIMIT 0,;


Can someone please help?

[Lizard King]

Did you fill all module settings ?

[jluerken]

Did you fill all module settings ?

I made a copy from a default module set so all values should be correct or?
I opened the new set and It looks like every field has a value.
Problem here is that there is no info which fields are really required and which not. :(

A working GARS is looking great but creating new modules is a pain in the ass :D

[The Geek]

there is a missing setting or a corrupt copy. THe above sql is either for a featured item module or top x module. Check to make sure there are limit values on each.

[jluerken]

I do not see any empty field.
I've done a search in this forum here and have seen that others have the same problem.

It would be good to have an error routing in GARS to show which fields are missing when creating new modules.

[WAR]

The Limit field is blank in whatever module generated that error.

It should have said that the error was near '' on line 3 correct?

I just experienced the same error when I enabled featured articles for the first time in a new type (that I had copied from the default)

[jluerken]

I've got no idea where the problem is and support seems to be limited currently :(

[Lizard King]

You must have different module settings and within these settings you forget to add a value to one of your modules. thats why you are receiving this error. you must check each of your modules (both showthread and forumdisplay) and check if you forget something.

[The Geek]

Supports a bit limited right now as im just on my way back :)

It could be a corrupt copy... Im planning on tweaking a couple of things tomorrow to provide a permenant safety catch for this situation.

[jluerken]

This sounds very good Geek and I think It will help all customers a lot.
Can't await it...

[The Geek]

mkay... its not looking like ill be able to complete all items on my list for the next update tonight... however here is a workaround for right now.

Edit your geek/gars/mods/featured.php and top.php files and change

intval($settings) ? $limit = $settings['limit'] : 5;

to

$limit = $settings['limit'];
if ($limit<1)
{
$limit = 5;
}

[jluerken]

I wait for the update :D

[jluerken]

Any idea when you will release an update?

[The Geek]

Most likely next week. Im trying to roll in some other updates into a solid 1.01 release. I would suggest implimenting the fix mentioned above. Its pretty easy.

[jluerken]

Most likely next week. Im trying to roll in some other updates into a solid 1.01 release. I would suggest implimenting the fix mentioned above. Its pretty easy.

Ok I'll wait for the udpate then...