i tried to upload the module but it give me this error:

Database error in vBulletin 3.6.8:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vb_adv_modules
(`0`, `active`, `userperms`)
VALUES
('', '1', '4,6,8,7,2,5,1,3');

MySQL Error : Unknown column '0' in 'field list'
Error Number : 1054
Date : Tuesday, September 11th 2007 @ 08:55:15 PM
Script : ........../vba_cmps_admin.php?do=uploadmodule
Referrer : ........./vba_cmps_admin.php?do=download
IP Address : xxxxxxx
Username : xxxxxx
Classname : vb_database

can someone help? I can't upload this module to vba, keep getting the same error as above

thanks

Finally i got it to work. Just forget about uploading the module to vba.

Here is what i did:

1. login vb backend
2. under vba cmps add module
3. select template
4.1 fill in module title
4.2 fill in template to include adv_porta_vBiSpy
4.3 select style you want to install.
4.4 paste the following in template content:

it should work,

thanks much - how can I make this a side module instead of a center module?

I have ultimate side columns running is there a way of adding this there so it shows on the main page rather than in a CMS?

These instructions helped the most! :up:

But now, VBISPY shows up on every single page of my forum, even in sub forums. I'd like this only on my main INDEX page. Any ideas?

How do I just have the Date and Thread Title show up? I want to remove all the other elements.

is it possible to customize the number of posts displayed in this module?

Anyway I try to get this module active it kicks back this database error.

What gives?


Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT *
FROM vb_template
WHERE title = 'adv_portal_vBiSpy'
AND styleid IN();

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 4
Error Number : 1064
Date : Tuesday, February 12th 2008 @ 01:23:04 PM
Script : http://www.my.domain.com/forum/admin...cmps_admin.php
Referrer : http://www.my.domain.com/forum/admin...&type=template
IP Address : x.xxx.xxxx.xxx
Username : xxxxxxxxxx
Classname : vb_database

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_modules
(`0`, `active`, `userperms`)
VALUES
('', '1', '4,6,8,15,14,12,16,5,18,7,2,10,1,3');

MySQL Error : Unknown column '0' in 'field list'
Error Number : 1054
Date : Tuesday, March 11th 2008 @ 04:15:20 PM
Script : http://www.xx.com/admincp/vba_cmps_a...o=uploadmodule
Referrer : http://www.xx/admincp/vba_cmps_admin.php?do=download
IP Address : xx
Username : xx
Classname : vb_database
MySQL Version : 5.0.45-community-log




Any help ?