Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > vRewrite - SEOed URLs for vBulletin
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
SQL Error After Installing Details »»
SQL Error After Installing
Version: , by skooby skooby is offline
Developer Last Online: Dec 2011 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-02-2006 Last Update: Never Installs: 0
 
No support by the author.

I can pretty much say there is a problem with vRewrite because when I turn it off the SQL Problem stops.

Here is the SQL error that comes up when vRewrite is enabled:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

			SELECT t.lastposter AS username, u.userid, t.threadid
			FROM thread AS t JOIN user AS u ON (u.username=t.lastposter)
			WHERE t.threadid IN (3,64,6,61,68)
				AND t.visible = 1;

MySQL Error  : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
			WHERE t.threadid IN (3,64,6,61,68)
				AND t.v' at line 3
Error Number : 1064
I am running VB 3.5.4 and vRewrite 1.5.1. I left all the options on their default settings (except for turning it on). I double checked the 3 template files and the added line of code is correctly placed above $headinclude. Thanks for the help and it seems like a great plugin

Cheers
-Jimmy

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 09-01-2006, 08:01 AM
Hypocrisy Hypocrisy is offline
 
Join Date: Feb 2006
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've got the same problem too. How do I fix this?
Reply With Quote
  #3  
Old 09-11-2006, 11:54 AM
GafferSports GafferSports is offline
 
Join Date: Dec 2005
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Superb support, considering I get this problem too and it has not been answered since June
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:16 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.03481 seconds
  • Memory Usage 2,205KB
  • Queries Executed 18 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete