vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Board Optimization - SEO YouTube and Google Videos (https://vborg.vbsupport.ru/showthread.php?t=131567)

Adult SEO 11-14-2006 08:12 PM

Quote:

Originally Posted by redlabour (Post 1117396)
Argh - i get the Errormessage :

"No Database selected" on a white Page after i entered the first Youtube Video in a Post.

I use 3.6.3 !

Ok, it might be that it is due to that I don't use the vBulletin MySQL object but the default PHP MySQL functions wich work fine on my server.

I will upgrade the mod to use the vBulletin MySQL object to see if this will fix the problem for you.

Best Regards,
Jan Jaap

Adult SEO 11-14-2006 08:26 PM

Quote:

Originally Posted by redlabour (Post 1117396)
Argh - i get the Errormessage :

"No Database selected" on a white Page after i entered the first Youtube Video in a Post.

I use 3.6.3 !

Even if the Hack is deactivated or not.

And it is ignoring all old short Links from "Embed XHTML valid YouTube and Google Video into your posts" so over hundreds Links have to be corrected.

Klick uninstalled. Sorry .... :/

Hi!

This has nothing to do with this mod, 100% sure.

Why? Because this mod does not change any links.

I've upgraded the mod however so it uses the standard vBulletin database functions, wich might make it faster.

Best Regards,
Jan Jaap

Ricsca 11-14-2006 08:29 PM

Error:

"Table 'tartaporta_mkp2.vb_seovideos' doesn't exist"

Whay ?

Bye

Adult SEO 11-14-2006 08:36 PM

Hi!

Sorry, I've found the problem.

When saving the Product from within vBulletin the instalation information isn't preserved.

Just to be sure, I will add an seperate install script.

Best Regards,
Jan Jaap

redlabour 11-14-2006 08:37 PM

Quote:

Originally Posted by Adult SEO (Post 1117407)
Hi!

This has nothing to do with this mod, 100% sure.

No Database selected is only appearing for Posting with your Mod installed and youtube and/or google link in it.

transitbus 11-14-2006 08:38 PM

Fatal error: Call to a member function on a non-object in /home/shebalis/public_html/includes/class_bbcode.php(166) : eval()'d code on line 15

When trying to link a google video

for example:

http://video.google.com/videoplay?do...62058784&hl=en

In fact this mod screwed up my entire posting functions

Adult SEO 11-14-2006 08:41 PM

Quote:

Originally Posted by transitbus (Post 1117419)
Fatal error: Call to a member function on a non-object in /home/shebalis/public_html/includes/class_bbcode.php(166) : eval()'d code on line 15

When trying to link a google video

for example:

http://video.google.com/videoplay?do...62058784&hl=en


Hi!

I am verry verry sorry for this, I uploaded an untested product and then tested it to see this error, I then deleted the product but you must have downloaded it within these 5 minutes.

It's fixed now, please download the latest product for it to work.

You might also need to run the included installer.

Best Regards,
Jan Jaap

Adult SEO 11-14-2006 08:44 PM

Quote:

Originally Posted by redlabour (Post 1117418)
No Database selected is only appearing for Posting with your Mod installed and youtube and/or google link in it.

Hi!

Please download the latest product XML and installer and please try again if you want. The mod doesn't touch the MySQL connection at all so I am not aspecting that the plugin is able to cause the loss of the MySQL connection.

Best Regards,
Jan Jaap

Adult SEO 11-14-2006 08:46 PM

Quote:

Originally Posted by Ricsca (Post 1117409)
Error:

"Table 'tartaporta_mkp2.vb_seovideos' doesn't exist"

Whay ?

Bye

Hi!

When saving a product with an XML configured installer the installer is lost, so please use the attached installer to install the database.

https://vborg.vbsupport.ru/attachmen...chmentid=55961

Best Regards,
Jan Jaap

Adult SEO 11-14-2006 08:49 PM

Quote:

Originally Posted by redlabour (Post 1117418)
No Database selected is only appearing for Posting with your Mod installed and youtube and/or google link in it.

Just so you know: The only MySQL that is used is to:
  1. check the seovideos table to see if a video has been parsed before, if so it will return the information.
  2. insert the information of a video into the seovideos table after parsing the video.
There is no other MySQL used in this mod.

PHP Code:

$result $db->query_read("SELECT id,title FROM `".TABLE_PREFIX."seovideos` WHERE `video_id`='".addslashes($videoid)."' AND `type`='google' LIMIT 1");
if (
$db->num_rows($result)) {
    
$video_info $db->fetch_array($result);
    if (
$video_info["title"] == 'seovideos-no-title') {
        
$video_info["title"] = $vbulletin->options["seo_videos_default_google_title"];
    }
    return 
$video_info["title"];
} else {
    .... 
PARSING OF THE VIDEO ...
    
$result $db->query_write("INSERT INTO `".TABLE_PREFIX."seovideos` ( `id` , `type` , `video_id` , `title` ) VALUES ('', 'google', '".addslashes($videoid)."', '".addslashes($title)."');");


That's all.


All times are GMT. The time now is 06:48 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.01480 seconds
  • Memory Usage 1,755KB
  • 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
  • (7)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