vb.org Archive
Page 6 of 11 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - Threads Started by User in Postbit and Profile (https://vborg.vbsupport.ru/showthread.php?t=115136)

Boofo 05-15-2006 07:26 PM
You need to post the whole error. I can't tell much with what you have there.

evofile 05-15-2006 10:05 PM
Code:

Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);
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 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064
Date : Monday, May 15th 2006 @ 09:41:36 PM
Script : http://forum.evofile.com/cron.php?&rand=694578
Referrer : http://www.evofile.com/
IP Address : 69.86.205.252
Username : Unregistered
Classname : vb_database

Boofo 05-16-2006 12:54 AM
Quote:
Originally Posted by evofile
Code:

Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);
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 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064
Date : Monday, May 15th 2006 @ 09:41:36 PM
Script : http://forum.evofile.com/cron.php?&rand=694578
Referrer : http://www.evofile.com/
IP Address : 69.86.205.252
Username : Unregistered
Classname : vb_database
What version of MySQL are you running on the server?

evofile 05-16-2006 02:24 AM
Quote:
Originally Posted by Boofo
What version of MySQL are you running on the server?
4.0.24

Boofo 05-16-2006 02:37 AM
Hang in there, we're looking at it now. ;)

Oblivion Knight 06-14-2006 10:09 AM
Yup, I'm getting the same error but with vBulletin 3.6.0 Beta 2..

It might have been doing it before the upgrade, but I've only just re-added an email address to receive database error messages (they do my head in!).. Running MySQL 4.0.27-standard.

Boofo 06-14-2006 10:22 AM
Quote:
Originally Posted by Oblivion Knight
Yup, I'm getting the same error but with vBulletin 3.6.0 Beta 2..

It might have been doing it before the upgrade, but I've only just re-added an email address to receive database error messages (they do my head in!).. Running MySQL 4.0.27-standard.
I thought 3.6 took a higher MySQL version that that.

Oblivion Knight 06-14-2006 10:29 AM
Quote:
Originally Posted by Boofo
I thought 3.6 took a higher MySQL version that that.
From vbulletin.com:
vBulletin 3.6 now requires PHP 4.3.3 or later and MySQL 4.0.16 or later.

:)

Boofo 06-14-2006 10:38 AM
I'm using 4.1.11 and this hack works fine with that. I have a fix for it for older versions somewhere.

Freesteyelz 06-15-2006 06:59 AM
Genius! Thank you guys! *Clicked Install*


All times are GMT. The time now is 11:56 PM.
Page 6 of 11 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

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.01189 seconds
  • Memory Usage 1,740KB
  • 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
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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