DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Page 1 of 2 12 Last
Results 1 to 10 of 19

Thread: Changed A VBShop Item itemid in DB directly, now cannot remove the item.


Forum: vBShop Lite Support

Questions & Answers for vBShop.
Click here to buy!

  1. #1
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Nov 2015
    Posts
    10
    Rep Power
    0

    Default Changed A VBShop Item itemid in DB directly, now cannot remove the item.

    This is a site I host. One of the Site's moderators wanted to add a new item to the shop, and then changed the itemid in the dbtech_vbshop_item table. This broke the item and it cannot be deleted or edited, even after changing the ID back, and they've asked me to fix it. I'm assuming there's some reference I have to fix, but I'm not sure.
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  2. #2
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    Can you please try clicking "Repair Cache" in the sidebar?

    For the future, please instruct your moderators to not directly alter the database, as there's quite the tree of references involved. Currently, our DB tables do not use Foreign Keys due to limited support for these on legacy systems, so the application itself will need to be allowed to maintain these references.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  3. #3
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Nov 2015
    Posts
    10
    Rep Power
    0

    Default

    I have tried the "rebuild cache" several times, and it does not make a difference.

    I have instructed them to not make changes like this.
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  4. #4
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    If you PM me with an AdminCP account that has at least Can Administer vBShop and the canrunqueries permission in config.php (please make sure you test this before giving me the access details, if I can't execute SQL queries then we're just wasting each other's time), as well as give me all information regarding the affected item, I can look into this @ your site.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  5. #5
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Nov 2015
    Posts
    10
    Rep Power
    0

    Default

    We went ahead and tried to create a new item after you so graciously fixed the problem, and we run into the same issue. We still get the message that item_id=0 cannot be found and when you try to edit the object, it tells you data is missing. We also had to try two times for anything to even show up. If you need access again, let me know as I've disabled that account post your fix (d'oh!)
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  6. #6
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    Do you have Suhosin installed on your server? If so, please disable it, as it is a likely cause of this problem.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  7. #7
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    Hello @Patches,

    This ticket has now been closed with the status Answered.

    We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

    If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

    Thank you!
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  8. #8
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Nov 2015
    Posts
    10
    Rep Power
    0

    Default

    Again, my apologies for not following proper process. Susohin is not installed on the server from what I can tell.
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  9. #9
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,730
    Blog Entries
    13
    Rep Power
    10

    Default

    I will need the FTP and AdminCP access restored in order to look into this further.

    I'm also in the process of travelling for the holidays, so it may be a few days before I can properly look at this
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

  10. #10
    Junior Member
    Level 0 (0 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Nov 2015
    Posts
    10
    Rep Power
    0

    Default

    I'll get you resetup with AdminCP access.

    I don't think we ever had you on FTP before, so I'll need to see about setting that up as well.

    Sorry for the delay in reply, I too was traveling for the holidays.
    0 0 0
     
    Changed A VBShop Item itemid in DB directly, now cannot remove the item. Send PM  

Page 1 of 2 12 Last

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [vB 4.2.x] New Item Type: Remove Infraction
    By tinvip98 in forum vBShop Lite Support
    Replies: 1
    Last Post: 18th March 2013, 13:39
  2. [vB 4.1.x] Database error when Adding New Item in vbshop 2.2.4
    By hero70411 in forum vBShop Lite Support
    Replies: 5
    Last Post: 12th January 2012, 17:30
  3. Replies: 3
    Last Post: 16th June 2011, 09:34

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.