vb.org Archive

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)

Sai01 04-20-2011 09:50 AM

how can you get it to install? i can't even get it to install on my 4.1.3 vbulletin. database error all the time is all i get.

*is waiting for beta4 for the fix*

Skyrider 04-20-2011 10:17 AM

Quote:

Originally Posted by Sai01 (Post 2186602)
how can you get it to install? i can't even get it to install on my 4.1.3 vbulletin. database error all the time is all i get.

*is waiting for beta4 for the fix*

Check a few pages back, someone attached the plugin as a temp fix.

netpants 04-20-2011 11:30 PM

I am getting this error, anyone know how to fix it?

vB 4.1.3

Code:

Cannot use object of type mysqli_result as array in /home/username/public_html/pointmarket/market_purchase.php

djdog 04-21-2011 07:06 PM

Uploading Beta 3, I get the SQL 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

I've read back a few posts:

Quote:

Originally Posted by guest9 (Post 2181690)
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

Quote:

Originally Posted by TheMayhem (Post 2181759)
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 ;)


Tried these with and without reading (first try), but to no avail - This did not work.

Edited to use Code Tags:

Quote:

Originally Posted by tandalier (Post 2182231)
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

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`");
print "<b>3.1.0:</b> 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 "<b>3.1.0:</b> 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 "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_5` column";

to

Code:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_2`");
print "<b>3.1.0:</b> 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 "<b>3.1.0:</b> 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 "<b>3.1.0:</b> Updating Market Store Table... Adding `image_big_5` column";


Download is altered product file (Same edits as above)
Quote:

Originally Posted by Staxed (Post 2182428)
for anyone that doesn't want to edit the file themselves, here's an updated product

This is what is happening each time; They do 'Import', but their is no 'admin settings' and market.php shows 'database error'.

When doing the alterations from what I've tried and what people asked, I get the same error from Alpha, Beta 1, Beta 2 and Altered Beta 3's. (Originally gives me the big_image error)

I get 'undisclosed_tag' - Which I assume means some where in the XML Code there must be an undisclosed tag causing it not install.

I'm hoping a beta4 (or final) will be released soon.

or at least a temporary fix.

Webrunner 04-21-2011 07:28 PM

Quote:

Originally Posted by Webrunner (Post 2185735)
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?

Anyone?

I have another question.
My users are complaining that they "bought" a post color and that the post color isn't visible in the social group discussions.
Does anyone know how to get this done? :confused:

TheMayhem 04-21-2011 10:56 PM

Yeah it just needs a plugin, I never really paid attention to the social groups but if I remember I'll get it on the next beta for you :)

I was able to get my hosting/test site up today finally so I've been working through the bugs. I'm going to schedule Beta 4 for Sunday as an Easter day release :)

Webrunner 04-22-2011 04:57 AM

That is great news, thanks for your support!
So i guess you won't be needing one of my servers?

TheMayhem 04-23-2011 02:59 AM

Okay I'm still planning on releasing Beta 4 this coming Sunday.

However, I was working on the Market tonight and decided to release Beta 3 again updated that corrects the product import bug as well as the store pages in the ACP. The reason you were getting that is between Beta 2 and Beta 3 I was reworking how I store images related to the Market Store and how they are viewed. I wanted to create a little slideshow for each market store product that could be scrolled through. I never completed it though and always intended releasing it on beta 4 to be tried. However, I made an error with the mysql part and never remembered to check it before I released Beta 3.

So if your using Beta 3 and already corrected the sql error, I still ask you download the updated beta3r2 zip and upgrade your database as well as the files. I'll include a more detailed release on Sunday but I want to make sure my fix works on users who experienced this bug as well as new users and the only way for me to tell is if you test it.

Keep up with the bug reports so that I can include it on Sunday's release for Beta 4. Hope all is well for all the users using this mod. :)

djdog 04-24-2011 10:00 AM

Downloaded.

Uploaded new files.

Uninstalled old version from Product Manager.

Result: unclosed_tag

Point Market, Admin panel doesn't display.

market.php still has a 'Database Error'.

Uninstalled using the "Newer Beta 3r2" and didn't work, I doubled check the MySQL database;

These tables were still intacted.
Code:

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;
So, I dropped them and imported the database and same error unclosed_tag.

Point Marked, admin panel doesn't show.

Uninstalled it again and;

Code:

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;
Remains, possible for converting reasons?

I'll wait for beta 4.

I'm on 4.0.1 - So wondering if this is the issue.

I have a few friends who own their own vBulletin license and I told I'm going to install it and see if it works.

Tested: 4.0.1 - Doesn't Work
Tested: 4.1.x - Works!

I would like this corrected to work on vBulletin 4.0.1 - Thanks.

TheMayhem 04-24-2011 02:37 PM

Quote:

Originally Posted by djdog (Post 2188043)
Downloaded.

Uploaded new files.

Uninstalled old version from Product Manager.

Result: unclosed_tag

Point Market, Admin panel doesn't display.

market.php still has a 'Database Error'.

Uninstalled using the "Newer Beta 3r2" and didn't work, I doubled check the MySQL database;

These tables were still intacted.
Code:

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;
So, I dropped them and imported the database and same error unclosed_tag.

Point Marked, admin panel doesn't show.

Uninstalled it again and;

Code:

`market_bank_paycheck`, `market_coupons`, `market_currency`, `market_currency_transactions`;
Remains, possible for converting reasons?

I'll wait for beta 4.

I'm on 4.0.1 - So wondering if this is the issue.

I have a few friends who own their own vBulletin license and I told I'm going to install it and see if it works.

Tested: 4.0.1 - Doesn't Work
Tested: 4.1.x - Works!

I would like this corrected to work on vBulletin 4.0.1 - Thanks.

I am not going to be able to fix this error unless you provide temporary admin access for me via private message. I've had people report this bug throughout the existance of the market but no one ever provides me access to physically be able to test it and since it only occurs to a very small percent of people there is no way for me to be able to track down where the error is actually occurying.


All times are GMT. The time now is 08:24 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.07385 seconds
  • Memory Usage 1,769KB
  • 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
  • (8)bbcode_code_printable
  • (7)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