vb.org Archive - vB Forum Counter v2.1

Page 4 of 4

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

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vB Forum Counter v2.1 (https://vborg.vbsupport.ru/showthread.php?t=69971)

okc	02-18-2005 09:44 PM

Quote:

Originally Posted by bitg

Since I installed this hack, I get a database error.
_________________________________
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT forum.title AS forumtitle, thread.threadid, thread.title, thread.dateline,
thread.lastpost, pollid, open, thread.replycount, postusername, postuserid,
thread.lastposter, thread.dateline, views
FROM forum AS forum
INNER JOIN thread AS thread USING(forumid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE FIND_IN_SET('16', forum.parentlist) AND
thread.lastpost > 1096689607 AND
thread.visible = 1 AND
deletionlog.primaryid IS NULL

mysql error: Column: 'views' in field list is ambiguous

mysql error number: 1052

getting exact same error - any thoughts?

okc	02-18-2005 10:37 PM

nevermind update fixed it

venomx

02-24-2005 09:21 AM

For vbadvance cmps shouldnt

Code:

else

{

        // or doing it once an hour

        $DB_site->shutdown_query("

                INSERT INTO " . TABLE_PREFIX . "views (forumid)

                VALUES (" . intval($foruminfo['forumid']) . ')'

also change to

Code:

else

{

        // or doing it once an hour

        $DB_site->shutdown_query("

                INSERT INTO " . TABLE_PREFIX . "view (forumid)

                VALUES (" . intval($foruminfo['forumid']) . ')'

okc	03-24-2005 11:11 PM

Has anyone updgraded to 3.07 with this hack? I just upgraded to vb 3.07 & can't get the views column to appear - it just doesn't show up - do you know what I could check?

okc	04-15-2005 03:58 AM

for anyone using 3.07, I also had to go into includes/functions_diget.php & remove the , views after thread.lastposter, thread.dateline

Marco van Herwaarden

04-15-2005 06:51 AM

The error you got before means that the 'views' column exist in more then 1 table used in the query. If you don't tell MySQL from which table you want to use that column, it won't have a clue what you are look for.

Solution:
Change 'views' into 'thread.views'

(Assuming that you are looking for the view count on the threads.)

eXtremeTim

04-22-2005 04:23 AM

Great hack. Would be nice to have a combined install file and not just the upgrade version. I would release the combined version I made but I made changes to it.

All times are GMT. The time now is 09:32 PM.

Page 4 of 4

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01075 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_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (7)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: