vb.org Archive - Major Additions

Page 27 of 74

« First

Last »

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

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

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

- - Major Additions - Zoints SEO (https://vborg.vbsupport.ru/showthread.php?t=127336)

MrLeN

10-30-2006 06:38 AM

I installed Zoints SEO, but it started causing conflicts with other software that I am using with the forums and unfortunately, I had to remove it. I came here for instructions how to remove it and I was told to use the uninstall via the product manager and remove the files from the installation.

I did this, but I am still getting database errors in my email. It says:

Quote:

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT linkid, name, links.catid, userid, username, dateline, links.lastpostdateline, title
FROM wgreen_adv_links AS links
LEFT JOIN wgreen_adv_links_categories AS categories USING (catid)
WHERE links.dateline > 1162098001 AND suspended = 0 AND valid = 1;

MySQL Error : Column: 'valid' in where clause is ambiguous
Error Number : 1052
Date : Monday, October 30th 2006 @ 12:59:01 AM
Script : http://www.mysite.com/community/cron.php?rand=801531
Referrer : http://www.mysite.com/community/
IP Address : 211.28.xxx.xxx
Username : Unregistered
Classname : vb_database

How can I repair my vBulletin database to get it working without errors, before the Zoints SEO installation altered it? Or, what did Zoints SEO do to alter my database?

Any advice/direction appreciated.

rogersnm

10-30-2006 03:48 PM

Run every cron job until you find the one that errors. And then tell me which product it is for. It looks like Advanced Navbars.

Hoffi

10-31-2006 06:58 AM

Did you use the vbAdvanced Linkdirectory or something similar?
The Tables are not vBulletin Standard oder ZOINTS related.

gsm4arab1

10-31-2006 11:54 AM

Very wonderful zointsseo-2.2.2 I have installed on the site, but unfortunately became servers Special me very slow and very high

Server Load 4.78 (4 cpus)

Is there a solution to the lack of high Load server

thanks ......................

Greek76

11-01-2006 08:26 AM

Problem with mod rewrite. I added the code to the .htaccess and uploaded it. I click enable mod rewrite. Now when you visit the categories I get the page can not be found what am I doing wrong?

This how I added the code...

Quote:

Options +FollowSymlinks
RewriteEngine on

RewriteRule ^([a-z0-9_\-]*-(f|all)[0-9]+(p[0-9]+|/index[0-9]*)?\.html)$ forumdisplay.php/$1 [QSA,L]
RewriteRule ^([a-z0-9_\-]*-(t|p)[0-9]+(p[0-9]+|/index[0-9]*)?\.html)$ showthread.php/$1 [QSA,L]
RewriteCond %{REQUEST_URI} !(index\.php|\.css) [NC]
RewriteRule ^(archive|sitemap)/(.*)$ $1/index.php/$2 [QSA,L]

Ramsesx

11-01-2006 05:59 PM

Quote:

Originally Posted by phlogiston

I'm pretty certain I've figured out why I haven't experienced problems with vBGallery (and other addons) while using Zoints SEO - I have vBa CMPS wrapped around everything and forums in root dir = not standard.

So I worked out a possible fix.
If anyone wants to try this (without guarantee!) to get Zoints SEO working on sites with photopost's vBGallery (may also solve the incompatibility with vBadvanced Links Directory) I'm fairly/quite confident it may work. (I apologise for the vagueness but I don't have good test installs at present :()

in the "Zoints SEO" plugin at parse_templates (on line #1),
originally (Zoints SEO v 2.2.2) it should be

PHP Code:


		
			
if ($vbulletin->options['zointsseo_on'] AND $vbulletin->options['zointsseo_rewrite_urls'] AND VB_AREA == 'Forum' AND !defined('VBA_PORTAL'))

change VBA_PORTAL to VBA_SCRIPT,
ie REPLACE line#1 with

PHP Code:


		
			
if ($vbulletin->options['zointsseo_on'] AND $vbulletin->options['zointsseo_rewrite_urls'] AND VB_AREA == 'Forum' AND !defined('VBA_SCRIPT'))

this should prevent the <base href=""> tag being added to the header which I think was the problem.

Again, apologies for the lack of testing of this before offering it as a possible solution.

Seems to work for me, thanks.

phlogiston

11-01-2006 09:46 PM

Quote:

Originally Posted by Ramsesx

Seems to work for me, thanks.

cool :D

I've been doing some more prodding at the code to see if it's extendable to rewriting the vBGallery urls, so far it looks doable. Not quite at a usable stage yet,
although www.spoiltcat.com/julian_cope-i1444.html is much prettier than unrewritten www.spoiltcat.com/photos/showimage.php?i=1444 !!

Zoints

11-01-2006 11:12 PM

A vbgooglemap fix?

Those of you who have had trouble with vbgooglemap, please give this fix a shot and see if it works for you and report back. Thanks :)

Zoints

11-01-2006 11:14 PM

Quote:

Originally Posted by phlogiston

Nice! Can others confirm if this is working for them?

Keep this up and we'll need to create a phlogiston SEO fork :cool:

Floris

11-03-2006 08:51 PM

********Please do not use this modification unless you are VERY well educated on SEO and forum modification********

Well, that rules me out :) I want the plugin to take care of things and not having to educate myself first .. if I am educated on this ..... I didn't need the plugin :p

All times are GMT. The time now is 04:39 PM.

Page 27 of 74

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01634 seconds Memory Usage 1,751KB 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 (2)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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: