vb.org Archive - Toplist

Page 71 of 159

« First

121

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Toplist (https://vborg.vbsupport.ru/showthread.php?t=98646)

Ramsesx

05-05-2006 12:38 AM

Hi derek, I changed my site to a new server and new domain now I get this error:

PHP Code:


		
			
Database error in vBulletin 3.5.4:



Invalid SQL:

UPDATE vb3_toplist_sites SET out=out+1 WHERE id='27';



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 'out=out+1 WHERE id='27'' at line 1

Error Number : 1064

Date         : Friday, May 5th 2006 @ 03:37:23 AM

Script       : http://www.mydomain.de/forum/out.php?id=27

Referrer     : http://www.mydomain.de/index.php

IP Address   : 87.123.18.57

Username     : MC

Classname    : vb_database

Please can you give me a hint where i need to look? Thank you.

derekivey

05-05-2006 01:55 AM

I'm not too sure. I would have to take a look at it. Can you please PM me the URL to your site so I can take a look?

Thanks,
Derek

ubblite

05-05-2006 09:20 AM

derekivey,

Any luck with a solution to my above posted problem?

Thanks

derekivey

05-05-2006 09:42 AM

Can you PM me a link to your site as well so I can look at it?

Thanks,
Derek

chriszep

05-08-2006 10:19 AM

Quote:

Originally Posted by derekivey

You have to use PHPMyAdmin to remove all the toplist_* tables, and there is a field in the usergrouppermissions table.

Derek

ok I have done it , remove everything with "toplist" (made a search in PHPMyAdmin ) and remove field in the usergrouppermissions table.
now when I ulpload the product , i have this :

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;

MySQL Error : Duplicate column name 'status'
Error Number : 1060
Date : Monday, May 8th 2006 @ 01:18:09 PM
Script : http://xxxxxxxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://xxxxxxxxxxxxxxxx/forums/admin...?do=productadd
IP Address : xxxxxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxx
Classname : vb_database

thanks ;)

derekivey

05-08-2006 07:14 PM

Remove that code from the install code and try again.

ALTER TABLE `" . TABLE_PREFIX . "toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;

lasor

05-11-2006 09:48 AM

Excellent Job Thanks....

One question on frontpage is the anyway to open links in new window. I have selected this option in the acp options and it works fine on my toplist page but the links on the frontpage do not open in new window?

Thanks

derekivey

05-11-2006 06:44 PM

The CMPS module might not have that yet, I'm not sure if I added it or not. You can easilly add it by editing the module's template though.

Derek

lasor

05-11-2006 06:58 PM

Thanks for that...But can give me a little more of a clue..Sorry Im not an 100% upto date with vBulletin and coding...

Thanks again

lasor

05-12-2006 11:50 AM

Another really cool option would be the ability to disable indevidual banners from being displaid on the front page. I am pretty sure there must be a pretty simple way of doing this...

All times are GMT. The time now is 04:11 AM.

Page 71 of 159

« First

121

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02315 seconds Memory Usage 1,746KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: