vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - YABBSEO[vB] Lite - Another Better SEO Module for vB 3.8.x (https://vborg.vbsupport.ru/showthread.php?t=203849)

conankid 12-25-2009 02:48 AM

Database error when access /album.php?albumid=xxxxx Can you help me?

Leica.Robbiani 12-27-2009 11:29 PM

Hey man, thanks a lot for your help :up: :) :up:

Quote:

Originally Posted by shabbir4it (Post 1928698)
Hi,

There is an sql syntax error in your plugin in yabbseo/sitemap.func.php, You can notice the extra comma the query.
Line:288
PHP Code:

$albums $db->query_read("
        SELECT album.userid,,album.title,album.albumid
        FROM " 
TABLE_PREFIX "album AS album
        WHERE album.albumid in (
$albumids)
        "
); 

Regards,
Syed


final kaoss 12-31-2009 03:39 PM

1 Attachment(s)
that worked, thanks. And for the lazy just upload this file to forum/yabbseo directory.

ConsoleShark 01-03-2010 05:10 AM

Error: Messes up copyright , Jelsoft Enterprises Ltd. becomes Content Relevant URLs by YABBSEO v1.1. Also Yep, album.php creating an abulm give you a database error.

final kaoss 01-03-2010 05:41 PM

nothing like that happened to me and the album error is gone.

ConsoleShark 01-12-2010 09:59 PM

extreme-gaming the file you uploading fixed the error in the albums, however it still messes up the copyright Jelsoft Enterprises Ltd. becomes Content Relevant URLs by YABBSEO v1.1

final kaoss 01-14-2010 06:53 PM

????????? Not on my end... All I did to that file was remove the extra comma (which was the recommended fix a few posts ago) and upload it for the lazy here. I don't see how that can affect the copyright that you mention, it certainly hasn't done that to me, you should check your plugins to make sure one of those aren't doing it.

Also I have a request for the addon author. I notice that when I highlight a thread & view souce in firefox the "id" has no seo... is there anyway you can make the id say the actual name of the thread instead of "thread_title_139"

<a href="http://vgchat.info/forum/f38-super-nintendo-game-genie-codes-and-pro-action-replay-codes/aaahh-real-monsters-game-genie-codes-139.html" id="thread_title_139">AAAHH! Real Monsters Game Genie Codes</a>

christon26 01-14-2010 11:04 PM

Quote:

Originally Posted by ConsoleShark (Post 1953955)
extreme-gaming the file you uploading fixed the error in the albums, however it still messes up the copyright Jelsoft Enterprises Ltd. becomes Content Relevant URLs by YABBSEO v1.1

Line 465 in yabbseo/forumhook/parse_output.php makes those changes, basically it 'tells' the script to replace Jelsoft Enterprises Ltd with the yabbseo copyright:

Code:

$output = str_replace(strpos($output,'<!--YABBSEO_COPYRIGHT-->')===false ? "Jelsoft Enterprises Ltd" : "<!--YABBSEO_COPYRIGHT-->",
Simply replace the following lines:

Code:

# copyright information
$copyrights = array(
1=>'<a href="http://yabsoft.com" target="blank">Search Engine Friendly URLs by YABBSEO '.YABBSEO_VER.'</a>',
2=>'<a href="http://yabsoft.com" target="blank">Content Relevant URLs by YABBSEO '.YABBSEO_VER.'</a>',
3=>'<a href="http://yabsoft.com" target="blank">Search Engine Optimization by YABBSEO '.YABBSEO_VER.'</a>',
4=>'<a href="http://yabsoft.com" target="blank">SEO by YABBSEO '.YABBSEO_VER.'</a>',
5=>'Search Engine Friendly URLs by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
6=>'Content Relevant URLs by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
7=>'Search Engine Optimization by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
8=>'SEO by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
);

With:

Code:

# copyright information
$copyrights = array(
1=>'Jelsoft Enterprises Ltd<br /><a href="http://yabsoft.com" target="blank">Search Engine Friendly URLs by YABBSEO '.YABBSEO_VER.'</a>',
2=>'Jelsoft Enterprises Ltd<br /><a href="http://yabsoft.com" target="blank">Content Relevant URLs by YABBSEO '.YABBSEO_VER.'</a>',
3=>'Jelsoft Enterprises Ltd<br /><a href="http://yabsoft.com" target="blank">Search Engine Optimization by YABBSEO '.YABBSEO_VER.'</a>',
4=>'Jelsoft Enterprises Ltd<br /><a href="http://yabsoft.com" target="blank">SEO by YABBSEO '.YABBSEO_VER.'</a>',
5=>'Jelsoft Enterprises Ltd<br />Search Engine Friendly URLs by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
6=>'Jelsoft Enterprises Ltd<br />Content Relevant URLs by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
7=>'Jelsoft Enterprises Ltd<br />Search Engine Optimization by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
8=>'Jelsoft Enterprises Ltd<br />SEO by YABBSEO '.YABBSEO_VER.' ?2005, YABSoft.com',
);

And that will fix it plus put the seo copyright down on the next line :)

final kaoss 01-16-2010 11:07 PM

What I meant by this was the search result could show like
http://vgchat.info/forum/search.php?...er&u=tautvys92
instead of
http://vgchat.info/forum/search.php?do=finduser&u=73

Quote:

Originally Posted by yabsoft (Post 1905542)
I donot know your issue, but http://vgchat.info/forum/search.php?do=finduser&u=73 shows fine, I think.


Deadsy 02-17-2010 07:29 AM

We installed it on our testforum, but let me get this straight. If I want to do some changes, I've to edit the config.php or is there any controlpanel?


All times are GMT. The time now is 05:08 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01145 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
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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