Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Store missing menu items #146

Closed
ppzinx opened this issue Feb 10, 2023 · 7 comments
Closed

Store missing menu items #146

ppzinx opened this issue Feb 10, 2023 · 7 comments

Comments

@ppzinx
Copy link

ppzinx commented Feb 10, 2023

hello,
At first everything was fine, menu was full of options then i don't know where i messed up.
The menu showed just the Accessories option and it's glitched.

I reinstalled the full store plugin with all Resources and i keep running into this problem.

help?

screenshot: https://ibb.co/25WZttS
20230210165941_1 – kopija

@Max66888
Copy link

Please show your items.txt

@ppzinx
Copy link
Author

ppzinx commented Feb 10, 2023

here's my items.txt file:

items.txt

@ppzinx
Copy link
Author

ppzinx commented Feb 10, 2023

now i managed to get it work a bit more but everything is broken
Screenshot_276

when i open shop toplist from menu nothing shows only over !storetop it shows up

when i open Accessories i get this menu and it's functions are broken
Screenshot_277

fun & Entertain shows only one option
Screenshot_278

never edited any file

when i try to run [[ANY] Store by Zephyrus evrithing works fine, new-syntax verison gives me this errors

@ppzinx
Copy link
Author

ppzinx commented Feb 10, 2023

sorry i forgot to compile all plugins for store now i have menu like this
https://files.fm/u/3fdd9586a#/view/ce2zhpjxt

error log

L 02/10/2023 - 23:17:09: [store.smx] SQL error happened.
Query: delete store_items, store_equipmentfrom store_items, store_equipment where (store_items.unique_id = store_equipment.unique_id) and store_items.date_of_expiration<>0 and store_items.date_of_expiration<1676067429
Error: near "store_items": syntax error

@Max66888
Copy link

sorry i forgot to compile all plugins for store now i have menu like this
https://files.fm/u/3fdd9586a#/view/ce2zhpjxt

error log

L 02/10/2023 - 23:17:09: [store.smx] SQL error happened.
Query: delete store_items, store_equipmentfrom store_items, store_equipment where (store_items.unique_id = store_equipment.unique_id) and store_items.date_of_expiration<>0 and store_items.date_of_expiration<1676067429
Error: near "store_items": syntax error

You need to add unique ids to all the required items and then make sure that your plugins are writing to the database properly?

@ppzinx
Copy link
Author

ppzinx commented Feb 11, 2023

menu fixed

@ppzinx ppzinx closed this as completed Feb 11, 2023
@ppzinx ppzinx closed this as not planned Won't fix, can't repro, duplicate, stale Feb 11, 2023
@Max66888
Copy link

menu fixed

So is it consistent with my description?

azalty added a commit to azalty/zephyrus-store-preview-new-syntax that referenced this issue Feb 11, 2023
Thanks to nuclearsilo583#146 for reporting an SQL error
nuclearsilo583 pushed a commit that referenced this issue Feb 18, 2023
Thanks to #146 for reporting an SQL error
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants