vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Database and SQL errors in Who's Online page. (https://vborg.vbsupport.ru/showthread.php?t=269657)

Laurvick 09-04-2011 04:41 PM

Database and SQL errors in Who's Online page.
 
Whenever I go to the Who's Online page, I get an error.

Invalid SQL:

SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
, user.market_username_color,
user.market_username_glow, market_username_subscript
FROM session as session

WHERE session.lastactivity > 1314829461

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054

kh99 09-04-2011 04:54 PM

Do you or did you have the Point Market System mod installed? It seems like it didn't install or uninstall correctly.

Laurvick 09-04-2011 04:55 PM

Quote:

Originally Posted by kh99 (Post 2241909)
Do you or did you have the Point Market System mod installed? It seems like it didn't install or uninstall correctly.

I have it installed, what can I do to fix it then?

kh99 09-04-2011 05:01 PM

Apparently your database doesn't have some of the columns that are added when that mod is installed, so maybe try reinstalling it. (If running install doesn't work you might have to uninstall it first, although you may lose data if you do that). You might get better guidance if you ask in the mod thread.


All times are GMT. The time now is 02:39 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.00994 seconds
  • Memory Usage 1,712KB
  • 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
  • (1)bbcode_quote_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