hello - I just installed this great mod but I am having a problem - everything is working correctly till the moment I am choosing a category of sites to view - sites are displayed only when View All Sites option is turned on - when we are trying to sort sites by category none of pages is being shown (one random site is displaying always at top)

hi im getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status = 'inactive';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 01:30:55 PM
Script : http://www.puregraffiti.com/graffiti...list_admin.php
Referrer :
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database


and when i access: http://www.puregraffiti.com/graffiti-space/toplist.php

i get:

puregraffiti, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


also,

i have no topsites category under my admincp for vbulletin like how it shows on your screenshots that im supposed to have... ??

someone please help

i just installed this mod, i was wondering if anyone know how i change the banner allowed file extensions as the default mod only allows jpeg, gif and png image banner files and i prefere to use jpg, and when i try to upload a jpg banner i get an error message

Thanks for any help

Can you PM me a link to your site so I can take a look?

Make sure you imported the product XML file under vB's product manager, then set the usergroup permissions and everything should be working.

Currently you have to edit the add_site.php, edit_site.php, and /admincp/toplist_admin.php files to add image types. You will need to know the mime type for each file type you want to add (e.g. image/jpeg).

The line should look like this:
Derek

hi, i went to redo that, and i went to import and got this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE image LIKE 'http://%';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 06:35:04 PM
Script : http://www.puregraffiti.com/graffiti...ncp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti...?do=productadd
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

then i went to do it again cause it didnt add it, and i got this:



Database error in vBulletin 3.5.4:

Invalid SQL:
CREATE TABLE `toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;;



MySQL Error : Table 'toplist_ratings' already exists
Error Number : 1050
Date : Monday, June 19th 2006 @ 06:37:29 PM
Script : http://www.puregraffiti.com/graffiti...ncp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti...?do=productadd
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

Please login to PHPMyAdmin, and delete all of the toplist_ tables, as well as the toplistpermissions column in the usergroup table (Do not delete the table itself!), and try the import again.

Derek

PM sent - thanks for support

I'm currently running MySQL 5.0.18.

Ok, I'll release an update shortly to fix these db errors. It seems that MySQL has added some more keywords so I will need to add ` around everything.

Derek

Ok I have released the update. Those of you having SQL errors should redownload the zip file and reupload the files only. You don't have to reimport the xml file.

Please let me know if you continue to have problems.

Thanks,
Derek