vb.org Archive - Major Additions - Point Market System 3.1x

Database error in vBulletin 4.1.4:



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 > 1311076856

        

        

        

        GROUP BY isuser;



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

Error Number  : 1054

Quote:

Originally Posted by DS MrSinister (Post 2222398)

*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost....postcount=1905

Wow, thanks for asking and thanks for the answer! I had that error too and had no idea it was that particular plug-in causing it. Sure saved me some time you asking!

TimesOut

07-23-2011 05:21 AM

We still waiting the Developer to find a salutation for the problem with bank in v. 4.1.4

Reycer

07-23-2011 07:20 PM

Quote:

Originally Posted by Successfulsteps (Post 2222627)

Wow, thanks for asking and thanks for the answer! I had that error too and had no idea it was that particular plug-in causing it. Sure saved me some time you asking!

Everyone should read the previous posts. This fix has been listed about a dozen times.

tdkmatt

07-24-2011 10:31 AM

it doesnt work for me, it says i do not have permission to access the page ? i did add myself with all rights

http://www.fatalitynetworking.com/forum/market.php

JayCat

07-25-2011 09:23 AM

This mod uses way too many mysql queries.

I loaded my profile page and it sent over 700 queries to my database. It does this every time I load my page. (Disabling this mod brought it down to about 48... so I know it was because of this mod).

Right now I think you are using some sort of loop that submits a query to check for every action I've made with the point market (donating, gifts, etc.). This amounts to about 700 or so...

There needs to be a better way to retrieve the data rather than a loop... I had to disable this mod in order to keep my query count reasonable for my host.

edit: using Point Market System 3.1x, and the latest version of vbulletin 4.1.4PL2

8thos

07-26-2011 04:38 AM

Quote:

Originally Posted by TheMayhem (Post 2197871)

Official 3.1.0 Gold Post

I think I spent 9 months working on the 3.1x series and it feels great to finally make this post. Over the past half year and beyond, I've set out to create the most powerful point/store system that has ever been available at anytime during the existance of forum hacks. Based on your feedback as users of this modification, I finally feel that the Point Market is stable enough to be labled gold. What's gold? This is the finished product of what I wanted from the 3.1x series. I feel that the remaining bugs are minimal enough that no real big issues should exist.

I should first note that this upgrade IS REQUIRED!!! Any version before this (even the 3.0 series) needs to upgrade to this series. There is just too many features, changes, and tweaks over the history of the market for you not to upgrade. In addition in this final gold release, there was one major security fix that had to be addressed. Users NEED to upgrade to this version.

I want to thank all users for their patience. I can now resume scripting the 3.1x series with patches and new features. If you are interested in a branded free option, you are more then welcome to private message me for details.

~Brad

Holy Mother of God dude you went H.A.M. (Hard As a Mufukka). The ability to purchase smilies!!!!!!!!!

CODEHX

07-26-2011 06:30 PM

Database error in vBulletin 4.1.4:

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 > 1311707591

GROUP BY isuser;

MySQL Error : Unknown column 'user.market_username_color' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 26th 2011 @ 12:28:11 PM
Error Date : Tuesday, July 26th 2011 @ 12:28:11 PM
Script : http://unitedbroskigamers.com/online.php
Referrer : http://unitedbroskigamers.com/forum.php
IP Address : 204.213.227.242
Username : CODEHX
Classname : vB_Database
MySQL Version : 5.0.91-log

Successfulsteps

07-26-2011 06:48 PM

Quote:

Originally Posted by DS MrSinister (Post 2222398)

*Stamos2003

here is a temporary fix.

https://vborg.vbsupport.ru/showpost....postcount=1905

Quote:

Originally Posted by CODEHX (Post 2225296)

There's a fix in the above captioned quote. I don't understand why they don't put that in the first post of these threads. 130 pages of a thread is an awful lot of posts to sift through and most people who run a forum that is growing and thriving .. frankly do not have the time to read that MANY posts.

The Bank Interest isn't working right either and that has yet to be addressed in 4.1.4. I wish the developer would come back and address that issue.

Reycer

07-27-2011 12:02 AM

Quote:

Originally Posted by Successfulsteps (Post 2225297)

Yes but if they skip ahead to the last page the fix can EASILY be found, as it keeps getting repeated numerous times. But agreed, it should be put into the first post for sure.

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

Page 194 of 223

194

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02764 seconds Memory Usage 1,757KB 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_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (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: