Thread: Miscellaneous Hacks - Rotating Banner System
View Single Post
  #202  
Old 12-14-2008, 05:57 AM
emdee emdee is offline
 
Join Date: Jul 2006
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the default/preloaded sample ads work ok, but when creating new ads and saving them im getting error:
any ideas why? please explain in detail (noob here)

PHP Code:
Database error in vBulletin 3.7.4:

Invalid SQL:
INSERT INTO rbs_banners (
            
id
            
name
            
url
            
image
            
text
            
startdate
            
enddate
            
notes
            
maximpressions
            
vertical
            
forumids,  
            
enabled,
            
forumhome,
            
clicktrack,
            
mails,
            
usergroups
            
VALUES (
            
NULL
            
'New banner'
            
'http://www.vbulletin.org'
            
''
            
'<a href=\"http://www.vbulletin.org\">vbulletin</a>'
            
'1229262600'
            
'1260798600'
            
''
            
'0'
            
'0'
            
''
            
'1'
            
'0'
            
'0',
            
'',  
            
'',
            );

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 35
Error Number  
1064
Request Date  
SundayDecember 14th 2008 01:51:52 AM
Error Date    
SundayDecember 14th 2008 01:51:52 AM
Script        
http://www.mydomain.com/forums/admincp/admin_rbs.php?do=edit
Referrer      http://www.mydomain.com/forums/admincp/admin_rbs.php?do=edit
IP Address    69.196.139.105
Username      
the_admin_username
Classname     
vB_Database
MySQL Version 
5.0.51a-community 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01240 seconds
  • Memory Usage 1,794KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete