vb.org Archive - Top Topics/Threads

Page 2 of 4

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)

- - Top Topics/Threads (https://vborg.vbsupport.ru/showthread.php?t=99397)

lazytown

10-31-2005 05:31 AM

I disabled the "no permission" setting to get the script to run, and received the following error

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT thread.threadid, thread.title AS threadtitle, thread.lastpost, thread.forumid, thread.open, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.dateline, thread.visible, forum.forumid, forum.title AS forumtitle, user.username, user.userid AS lastposterid
FROM thread
LEFT JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN user AS user ON(user.username = thread.lastposter)
WHERE thread.open = 1
AND thread.visible = 1
ORDER BY thread.replycount DESC
LIMIT 0,;

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 '' at line 8
Error Number : 1064
Date : Sunday, October 30th 2005 @ 11:29:18 PM
Script : XXX
Referrer :
IP Address : XXX
Username : XXX
Classname : vb_database

-vissa

lazytown

10-31-2005 05:41 AM

The provided phpmyadmin SQL statements are whacked... They won't work for most people (at least on 3.5 gold)... Anyone got this to work? what did you change?

-vissa

tnguy3n

11-01-2005 08:54 AM

sorry if that doesn't work for you.
I'll put it into product manager if that helps you with the installation (of course, only when I have time).

Snake

11-02-2005 10:45 AM

The SQL queries do not work. Please fix it asap.

Snake

11-02-2005 01:46 PM

This is funny. Now I get this error permission.

Quote:

Aftermath, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Allan

11-05-2005 08:41 AM

Thanks but no display :(

Snake

11-05-2005 06:13 PM

Bump.

Snake

11-06-2005 06:17 PM

Bump!!!

Allan

11-08-2005 07:21 PM

The problem with your hack, it is because the members can see the private forums

Snake

11-09-2005 09:07 AM

Nope, they cannot view the private forums. I have just logged into the admincp and check whether they can or not. The option was set to "No" already. So what's the problem? :)

All times are GMT. The time now is 02:52 PM.

Page 2 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01070 seconds Memory Usage 1,729KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: