vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Vb mysql subscriptions error (https://vborg.vbsupport.ru/showthread.php?t=99681)

DannyMilner 10-30-2005 12:08 PM

Vb mysql subscriptions error
 
When I do this...

Subscription Manager > VIP Membership > Add user

once I submit the date, user ect... I get this error

Database error in vBulletin 3.5.0:

Invalid SQL:

PHP Code:

                    INSERT INTO subscriptionlog
                    
(subscriptioniduseridpusergroupidstatusregdateexpirydate)
                    
VALUES
                    
(22141411130681160, );

MySQL Error  You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
Error Number 
1064
Date         
SundayOctober 30th 2005 09:06:45 AM
Script       
http://www.domain.net/admincp/subscriptions.php
Referrer     http://www.domain.net/admincp/subscriptions.php?do=adjust&subscriptionid=2&s=
IP Address   xx.xxx.x.xxx
Username     
User
Classname    
vb_database 


tnguy3n 10-30-2005 12:16 PM

expirydate is missing in the VALUES.

DannyMilner 10-30-2005 01:14 PM

Quote:

Originally Posted by tnguy3n
expirydate is missing in the VALUES.

Okay, how do I fix that mate?

Marco van Herwaarden 11-01-2005 09:50 AM

You might want to ask in the thread of the hack you are using for subscriptions.

007 11-30-2005 04:23 PM

I have this same problem and I haven't hacked the subscriptions at all...

Marco van Herwaarden 11-30-2005 06:03 PM

Ahh that was a bug in vB, think i even submitted a bug report for it and it is marked as being fixed. There was no check on the expire date and this would cause an error if left blank.

Marco van Herwaarden 11-30-2005 06:04 PM

See: http://www.vbulletin.com/forum/bugs3...iew&bugid=1736


All times are GMT. The time now is 07:00 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.01126 seconds
  • Memory Usage 1,729KB
  • 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)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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