vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Correct syntax for sql query? (https://vborg.vbsupport.ru/showthread.php?t=76384)

guvner 02-15-2005 11:01 PM

Correct syntax for sql query?
 
Hi everyone,

I just ported a SMF board acrosss to VB and seem to have lost a lot of pre-existing signatures. I've also had a few members ask why, when they activate a sig, it doesn't flow through all their previous posts like it does with other forums, even if they didn't have a sig before.

Since I have a fast growing forum, it's an important issue for many of them because they're looking for link backs to improve their page rank.

I've discovered that with VB, because the sig was "turned off" in the postbit in earlier posts, it can't update historically. Fair enough, so I went looking for a hack that would help me add them to previous posts and all I could find was an old reference here from May 2003 which requires this sql query to be run.

Code:

UPDATE post SET post.showsignature = 1 WHERE user.signature != "" AND post.userid = user.userid;
Well, I'm a long way from being even slightly competent with mySQL and no matter what I try (and I've tried so many variations), I can't run the query (on my test board) ;)

The last failure was using:
Code:

UPDATE post SET vb3_post.showsignature = 1 WHERE vb3_user.signature != "" AND vb3_post.userid = vb3_user.userid
The error I get every time is "MySQL said: #1146 - Table 'xxxxxxx_testvbulletin.post' doesn't exist

Assume my DB is called xxxxxxx_testvbulletin and my table prefix is vb3_ could someone who "gets it" please help me with the correct syntax?

Thanks in advance.

Mike :)

Zachery 02-16-2005 01:38 AM

Why not just use clear.php ? :)

tehste 02-16-2005 10:00 AM

I'm assuming vb3_ is the table prefix.
try:
Code:

UPDATE vb3_post SET showsignature = 1 WHERE showsignature = 0
in php my admin or the query runner from the vbulletin admin cp.
(This will make signature appear on all posts.

guvner 02-16-2005 10:17 AM

Zachery - sorry but I don't know what clear.php is.

No matter - zsdave, thank you so much - it worked really well! :laugh:


All times are GMT. The time now is 07:00 AM.

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.01131 seconds
  • Memory Usage 1,718KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete