vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vbBux / vbPlaza (https://vborg.vbsupport.ru/forumdisplay.php?f=171)
-   -   Serious Error With DB -Expiring Option (https://vborg.vbsupport.ru/showthread.php?t=127314)

webgroup 09-22-2006 11:32 PM

Serious Error With DB -Expiring Option
 
This is the problem:

User buys access to secondary usergroup, the access expires, vbplaza redirects him to the vbplaza to renew, then he get this error:

Database error in vBulletin 3.6.0:

Invalid SQL:

UPDATE vbnewusergroup
SET usergroupid = '22'
WHERE userid = '10088';

MySQL Error : Unknown column 'userid' in 'where clause'
Error Number : 1054
Date : Friday, September 22nd 2006 @ 07:57:05 PM
Script : http://www.mysite.net/forum/vbplaza.php?do=expireitems

Group 22 is his primary user group, the default group for any regular user, not the VIP group he bought and its expiring.

This happens everytime they try to enter the website, thus making it inaccessible FOREVER.

Please help.

Thanks

webgroup 09-24-2006 02:43 PM

is this mod supported or not?

Why they created a sub-forum just for this mod??? :cross-eyed:

angelo 09-25-2006 03:10 PM

^no shit

webgroup 10-01-2006 06:07 PM

every user that have bought this option from the vbplaza, its having the same problem when it expires, they can't enter the website again, never.
Paying members in my case....


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

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.00989 seconds
  • Memory Usage 1,711KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete