View Single Post
  #532  
Old 02-04-2007, 04:11 PM
Yvgeniy Yvgeniy is offline
 
Join Date: Jan 2007
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Alright, I've got my first error so far. Looks like it's related to apostrophes in the names of songs:

Database error in vBulletin 3.6.4:

Invalid SQL:
update vB_mp3playlist set

id='10',

url_product='http://www.artdecade.us/AintTalkinboutLove.mp3',

url_product_stream='true',

url_product_buffer='2',

mp3name='Van Halen - Ain't Talkin' 'bout Love',

approvemp3='1'

where id='10';

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 't Talkin' 'bout Love',

approvemp3='1'

where id='10'' at line 11
Error Number : 1064
Date : Sunday, February 4th 2007 @ 10:01:32 AM
Script : http://www.sakstudios.net/forums/adm...edit_playlist1
Referrer : http://www.sakstudios.net/forums/adm...laylist1&id=10


Some other things that I'd like to note that could use improvement are:

- Ability to send mp3 notification PM to multiple users rather than just one.
- Ability to allow mods to approve mp3's rather than just admins (I haven't tried it, but I'm guessing only mods are able to approve mp3's so far).
- Perhaps ability to choose to use a different database for handling playing and play list information, in which case it would also be possible to increase the song limit and have no tax on the main forum database.

So far that's all I can think of at the moment.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01155 seconds
  • Memory Usage 1,766KB
  • 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)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