[3.2][3.3][RC] Advanced Shop System

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Post Reply
User avatar
3Di
Former Team Member
Posts: 15883
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: [3.2][BETA] Advanced Shop System

Post by 3Di »

eunaumtenhoid wrote:
Thu Dec 05, 2019 1:42 am

Code: Select all

WHERE i.category_id = c.category_id' .
Ref.: viewtopic.php?p=15373971#p15373971

Exactly, shouldn't happen.

How to reproduce it please? If I go to ROOT/app.php/aps/items I see no errors, can't reproduce.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
eunaumtenhoid
Registered User
Posts: 996
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][BETA] Advanced Shop System

Post by eunaumtenhoid »

to reproduce is exactly on this link you quoted
ROOT/app.php/aps/items
Erro Geral
SQL ERROR [ mysqli ]

Unknown column 'c.category_id1' in 'where clause' [1054]

SQL

SELECT c.category_title, SUM(i.item_purchases) as purchases FROM phpbb_ass_items i, phpbb_ass_categories c WHERE i.category_id = c.category_id1 AND c.category_active = 1 GROUP BY i.category_id ORDER BY c.category_order

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 196
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/phpbbstudio/ass/operator/blocks.php
LINE: 155
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbbstudio\ass\operator\blocks->charts()

FILE: [ROOT]/ext/phpbbstudio/ass/operator/blocks.php
LINE: 258
CALL: call_user_func_array()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbbstudio\ass\operator\blocks->__call()

FILE: [ROOT]/ext/phpbbstudio/aps/controller/main_controller.php
LINE: 295
CALL: call_user_func_array()

FILE: [ROOT]/ext/phpbbstudio/aps/controller/main_controller.php
LINE: 205
CALL: phpbbstudio\aps\controller\main_controller->call_function()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 135
CALL: phpbbstudio\aps\controller\main_controller->display()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 57
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
3Di
Former Team Member
Posts: 15883
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: [3.2][BETA] Advanced Shop System

Post by 3Di »

3Di wrote:
Thu Dec 05, 2019 2:12 am
If I go to ROOT/app.php/aps/items I see no errors, can't reproduce.
But we took a note and will investigate on this, thanks for feedback and report. :)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
eunaumtenhoid
Registered User
Posts: 996
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][BETA] Advanced Shop System

Post by eunaumtenhoid »

I went to ACP> APS> display> shop
and I disabled everything, leaving only recent items, no error now

img ACP
Image

IMG SITE
Image
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
mrgoldy
Development Team Member
Development Team Member
Posts: 1392
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][BETA] Advanced Shop System

Post by mrgoldy »

Just visiting a URL is not a 'way to reproduce'. It usually means more steps, what changed, etc..

Anyways, this will be fixed in the next release.

Also, in that last screenshot of yours, you are missing various Font Awesome icons.
So there is something wrong with your style aswell.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
eunaumtenhoid
Registered User
Posts: 996
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][BETA] Advanced Shop System

Post by eunaumtenhoid »

yeah, I disabled all store functions in ACP>>APS>>Display>>SHOP, leaving only recent items

new bug?
in ACP>>APS>>ASS>>ITEMS>>ITEM>>Display settings
When an image is placed in Item images, it is displayed 2x in the store and is it normal?

Image


otter bug?
no acp in the shop logs shows only one purchase (bought and then used the item), but in the shop overview shows the same user as if he had made 2 purchases

Image

Image

Is it correct to show only 1 or is the sum of the user actions that defines how many purchases he made?



will add notification for gifts received via ACP?
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
Exclusive
Registered User
Posts: 596
Joined: Mon Jun 25, 2018 1:33 pm

Re: [3.2][BETA] Advanced Shop System

Post by Exclusive »

mrgoldy wrote:
Tue Dec 03, 2019 11:48 pm
Well, not sure what to respond to that.
Yes, Advanced Shop System does work together with Advanced Points System, hence the almost identical names.
Or better yet, the Shop system is depending on the Points system. So the Advanced Shop System needs the Advanced Points System.

And to answer "How do this work?" I would suggest first installing them both and trying them out.
Then, if something is still unclear, please post again. However, please provide a bit more details and a less generic question.

Cheers,
Thank you for your reply, I was looking for a shop extension for my forum (something similar to Advanced Shop but without the Advanced Point) that was why I asked that question.
Use Search Button to get Instant Results | Follow Forum Rules
Avoid Spams in the forum to prevent banning the offending account. | ⟿ Visit My Awesome phpBB Forum! ⬳

Best Web Hosting with 99.9% Uptime! | ✔ Buy Cheap Domain Names
User avatar
eunaumtenhoid
Registered User
Posts: 996
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][BETA] Advanced Shop System

Post by eunaumtenhoid »

It would be very welcome an option in ACP to be able to move items from one category to another
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Shop System

Post by Lona »

Hallo.
Installed phpbb 3.2.8., OSPanel.
Purchased goods are not downloaded. The system asks if you want to download? We click YES and we get 404 error page. At the same time, logging out occurs.

Perhaps this is due to the location of the site on the local server?
Last edited by Lona on Tue Dec 17, 2019 2:55 am, edited 1 time in total.
User avatar
mrgoldy
Development Team Member
Development Team Member
Posts: 1392
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][BETA] Advanced Shop System

Post by mrgoldy »

We do not speak Russian (or what ever language that is), so please post in English.

Could you open your 'developer tools' in your browser, then download the file and check the error in your console. For example, the 'response' in the 'Network' tab. We need some error message to work with. As all downloads work fine on our boards, both with and without JS.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Shop System

Post by Lona »

mrgoldy wrote:
Mon Dec 16, 2019 5:34 pm
so please post in English.
Oh, I'm sorry, it's my inattention! Corrected the russian text. :oops:
Went to deal with the console.
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Shop System

Post by Lona »

If we use F12 - so we go to 'Network', and tham - ?
User avatar
3Di
Former Team Member
Posts: 15883
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: [3.2][BETA] Advanced Shop System

Post by 3Di »

Lona wrote:
Tue Dec 17, 2019 4:12 pm
If we use F12 - so we go to 'Network', and tham - ?
And then repeat the steps you did and see if errors are thrown, report those errors if any.
Lona wrote:
Mon Dec 16, 2019 5:02 pm
Purchased goods are not downloaded. The system asks if you want to download? We click YES and we get 404 error page. At the same time, logging out occurs.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Shop System

Post by Lona »

3Di,
and see if errors are thrown
where to look?
What should we see? Any code? Or - ?
The system of F12 says nothing. There is not any red marks.

:? :oops:
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Shop System

Post by Lona »

And when we have already downloaded a file where can we see it?
Post Reply

Return to “Extensions in Development”