thanks for the maquee fix. Drop into my website, one of my designers may be able to help you out with that image.

Every time i try to do the update and import the new product, i check the allow overwrite but it keeps saying the different sql databases already exist...I have even deleted every part of the toplist from my database and I still get the same errors. Please help!!!

Can you paste the error for me please?

Thanks.

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'toplist_enabled',
'toplist_options',
'1',
'1',
'free',
'yesno',
10,
0,
1,
'toplist'
),
(
'disabled_message',
'toplist_options',
'The Toplist is Currently Disabled. Please Come Back Later.',
'The Toplist is Currently Disabled. Please Come Back Later.',
'free',
'textarea',
20,
0,
1,
'toplist'
),
(
'toplist_ranking_method',
'toplist_options',
'0',
'0',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">In Hits</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">Out Hits</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">Rating</option>\r\n</select>',
30,
0,
1,
'toplist'
),
(
'toplist_count_out_from_guests',
'toplist_options',
'0',
'0',
'free',
'yesno',
40,
0,
1,
'toplist'
),
(
'toplist_limit_out_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
50,
0,
1,
'toplist'
),
(
'toplist_out_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
60,
0,
1,
'toplist'
),
(
'toplist_limit_in_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
70,
0,
1,
'toplist'
),
(
'toplist_in_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
80,
0,
1,
'toplist'
),
(
'toplist_allowed_user_groups',
'toplist_options',
'2,5,6,7',
'2,5,6,7',
'free',
'',
90,
0,
1,
'toplist'
),
(
'toplist_allow_member_edit',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_allowed_to_moderate',
'toplist_options',
'5,6,7',
'5,6,7',
'free',
'',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
130,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
150,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
170,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
240,
0,
1,
'toplist'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
260,
0,
1,
'toplist'
),
(
'toplist_show_forumhome_images',
'toplist_options',
'0',
'0',
'free',
'yesno',
270,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_direction',
'toplist_options',
'left',
'left',
'free',
'',
280,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_scrollamount',
'toplist_options',
'5',
'5',
'free',
'',
290,
0,
1,
'toplist'
),
(
'toplist_forumhome_number_of_images',
'toplist_options',
'0',
'0',
'free',
'',
300,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Sunday, January 8th 2006 @ 03:45:03 PM

This is the error I get when importing the product and selecting to overwrite the existing one.

In my admin panel everything is there except toplist options...and on the toplist.php there is no place to add a site to it.

Hi,

Can you PM me admin access details, and PHPMyAdmin info please so I can take a look?

Thanks,
Derek

I got that error fixed that i post i now have a different error. It is when i try to go to the toplist.php page. It works fine when its disabled but when enabled i get this error.


At the top of the page it says
Warning: Division by zero in /toplist.php on line 146

Warning: Division by zero in /includes/functions.php on line 1809

then

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM vb3_toplist_sites WHERE status='active' ORDER BY `in` DESC 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 1
Error Number : 1064
Date : Sunday, January 8th 2006 @ 08:39:35 PM
Script : http://www.foreverdarkness.com/forum/toplist.php

Check to make sure sites per page in the Toplist options isn't set to 0.

I dont see where that is located...it is not in my toplist options and I also searched it in my database and could not find it. Please help.

Should be at http://www.yourdomain.com/forums/adm...oplist_options

Try finding Sites Per Page on that page. If it's not there, you need to reimport the xml file because your settings must be missing then.

Actually there was an error in the xlp product file...duplicate part at the end.

<setting varname="" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="toplist_open_in_new_window" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>

cause the error i originally had up top.