vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBindex v3.0.0 RC5 (https://vborg.vbsupport.ru/showthread.php?t=59524)

Briboy923 01-28-2004 05:35 PM

Hi. I get

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 ')
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0)

mysql error number: 1064

when I try to access VBIndex , this is fresh install of VBIndex RC3 on VB3 RC3

NTLDR 01-28-2004 06:04 PM

Make sure you have set all the options correctly in the ACP and saved them if you still get the error post the entire contents of the email in [code] tags here.

Zaeolos 01-28-2004 06:17 PM

There are 2 things I need help with...

1. My smilies do not work in the Shoutbox and I have changed the path in the database to the full path of the image.

2. How can I make the width of the vbindex portion of the main page the same width as the nav bar?

NTLDR 01-28-2004 06:20 PM

1. They can't be the correct path if they don't show. Make sure its a full URL like http://www.mysite.com/forum/images/smilies/smile1.gif

2. Edit the VBINDEX template to suit your needs.

Zaeolos 01-28-2004 06:22 PM

Quote:

Originally Posted by NTLDR
1. They can't be the correct path if they don't show. Make sure its a full URL like http://www.mysite.com/forum/images/smilies/smile1.gif

2. Edit the VBINDEX template to suit your needs.

When I right click the properties of the image placeholder in the shoutbox, it does not show the same path as what I changed it to in the database. I have checked all that I know.

Also if it was wrong, then they would not work in the forums, and they do.

NTLDR 01-28-2004 06:24 PM

What path is in the HTML and what path is in the smilie manager?

Zaeolos 01-28-2004 06:27 PM

Quote:

Originally Posted by NTLDR
What path is in the HTML and what path is in the smilie manager?

The path that the placeholder shows is:

http://www.mysite.com/images/smilies/biggrin.gif

And the path that is in the smilies manager is:

http://www.mysite.com/forums/images/smilies/biggrin.gif

Also NTLDR, do you think you can set me up as Licensed over at Coreforums?

NTLDR 01-28-2004 06:45 PM

Seems vB isn't updating the smilies properly, create a file with the following content:

PHP Code:

<?php

require_once('./global.php');
require_once(
'./includes/adminfunctions.php');

build_image_cache('smilie');

?>

That should rebuild the smilies and update the correctly. Once you have confirmed your email I can mark you as licenced.

Zaeolos 01-28-2004 07:00 PM

That worked perfectly. It might not have been VBulletin. I used that script in this thread to manualy update the database with the path and that may have been the cause. I have 50 smilies and thought that may have been quicker than going through one by one.

Thanks for everything.

Z

Natch 01-28-2004 07:13 PM

Quote:

Originally Posted by Zaeolos
That worked perfectly. It might not have been VBulletin. I used that script in this thread to manualy update the database with the path and that may have been the cause. I have 50 smilies and thought that may have been quicker than going through one by one.

Thanks for everything.

Z

You have to be very careful with that script - it will make the changes that YOU ASK FOR.


All times are GMT. The time now is 05:55 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.02668 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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