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

Database error in vBulletin 4.1.2:

Invalid SQL:

UPDATE market_items
SET `order` =
WHERE mid = '5';

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 'WHERE mid = '5'' at line 3
Error Number : 1064

Any ideas?

Also -

Quote:

Parse error: syntax error, unexpected $end in /home/koolaid/public_html/forums/includes/cron/pointmarket_expire.php on line 282

TheMayhem

03-11-2011 03:39 PM

The pointmarket_expire bug I already found and fixed. It was just a missing bracket I did by accident before releasing Alpha 4.

I'll look into the other reported little sql bugs, they shouldn't be that difficult to correct.

The concept of coupons is for allowing additional discounts for users for certain market items that are based off a set criteria that the administrator decides. So for example, if a user was a member of a certain primary usergroup they might get an additional discount of 25% off an item.

Beta 1 comes out this Sunday as I've mentioned several times. In it I'll have all market items fully functional. It doesn't look like I am going to have time to script for the Market Store the ability to purchase items and download them. I also won't get to the coupon listings in this release. Those will come out in a later beta phase.

kesandal

03-11-2011 04:05 PM

Quote:

Originally Posted by TheMayhem (Post 2172282)

Beta 1 comes out this Sunday as I've mentioned several times.

@TheMayhem: Are my 2 reported bugs fixed too? :)

fly	03-11-2011 06:19 PM

Okay, is there something that I can run to clear out all these thread bans? None of them are expiring.

TheMayhem

03-11-2011 07:51 PM

Quote:

Originally Posted by fly (Post 2172330)

Okay, is there something that I can run to clear out all these thread bans? None of them are expiring.

Set the expiration to a day and upgrade to beta 1 sunday night and then run the expirations afterwards. It should clear them.

fly	03-11-2011 07:52 PM

Quote:

Originally Posted by TheMayhem (Post 2172355)

Set the expiration to a day and upgrade to beta 1 sunday night and then run the expirations afterwards. It should clear them.

Man, I hope you make your deadline again! :D

fly	03-11-2011 10:06 PM

And can someone explain the gift cost to me? The price next to the gift says 500.00, but the total up top says 1000.00 - with no real explanation of why the prices are different.

smirkley

03-12-2011 02:49 AM

Running alpha 4

Bug1

When purchasing a gift market item made by another member : this shows up in header,...

Quote:

Warning: include_once([path]/pointmarket/gift_purchase.php) [function.include-once]: failed to open stream: No such file or directory in [path]/market.php on line 436

Warning: include_once() [function.include]: Failed opening '[path]/pointmarket/gift_purchase.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/market.php on line 436

Bug2
Tried to clear user title color, set to one day expire, ran all maintenance, color will not expire. Will check again tomorrow and report back to see if cron reset it.

Bug3

Using the username color/glow/strikethru items purchased,... they work but they also insert html code into the html alt for the avatar image and a couple of other places.

And btw, thanks for fixing the maintenance link on thread purchases items. That was bugging the crap out of me.

smirkley

03-13-2011 04:33 AM

Report back on Bug2, color still has not expired. Running other tests.

All times are GMT. The time now is 12:36 AM.

Page 169 of 223

169

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

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