vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)
-   -   [v2.5.7+] Problem with Announcement (https://vborg.vbsupport.ru/showthread.php?t=130228)

Mudvayne 10-28-2006 09:16 PM

[v2.5.7+] Problem with Announcement
 
Hello Mr. Zeropage.. Everything is fine.. Infact the announcement too.. But it gives me SQL error. Here is the error..
Quote:

mySQL query error: UPDATE vb_games_settings SET arcade_status='1',arcade_language='en',g_display_s ort='gtitle',g_display_order='ASC',scores_amount=' 10',score_type='all',log='0',skin='1',use_cats='1' ,crown_type='1',notification='pm',show_new='2',sho w_new_frame='86400',show_active='a:7:{s:5:"glist"; s:1:"1";s:4:"play";s:1:"1";s:8:"newscore";s:1:"1"; s:5:"stats";s:1:"1";s:15:"viewtournaments";s:1:"1" ;s:11:"playtourney";s:1:"1";s:11:"viewtourney";s:1 :"1";}',auto_prune='1',auto_prune_time='2',auto_pr une_time2='2592000',games_pr='4',games_pp='12',use r_choices='5,10,15,20,25',allow_user_skin='0',def_ cat='6',cats_per_tr='3',show_crowns='0',show_t_won ='0',score_sep=',',dec_amount='0',league_scores='1 0,9,8,7,6,5,4,3,2,1,0',use_announce='1',announceme nt='[COLOR=\"Darkblue\"]Enjoy & Let Others Enjoy. U Need Minmum 10 Post Per Day To Play Golpo Arcade.
Every Week We will Add Lots Of New games. Stay Here & Enjoy Ur Stay\\'.[/COLOR]

[COLOR=\"Red\"]Scores will be auto pruned every 2 months.[/COLOR]',announcement_parsed='<font face=\"Vardana\"><b><font color=\"Darkblue\">Enjoy &amp; Let Others Enjoy. U Need Minmum 10 Post Per Day To Play Golpo Arcade.<br />
Every Week We will Add Lots Of New games. Stay Here &amp; Enjoy Ur Stay\\'.</font></b></font><br />
<font face=\"Verdana\"><font color=\"Red\"><b>Scores will be auto pruned every 2 months.</b></font></font>',games_new='15',games_popular='15'

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 '.[/COLOR][/B][/FONT]
[FONT=\"Verdana\"][COLOR=\"Red\"][B]Scores will be auto pr' at line 1
mySQL error code:
Date: Saturday 28th of October 2006 05:10:51 PM
The problem is with ' <-- this character.. If I use 'll then I got the error but will is fine :p.. But in previous version 'll worked fine..

sinisterpain 10-29-2006 03:41 AM

Same error here basically any edits I make in game settings will now cause an SQL error

Feckie (Roger) 10-29-2006 08:49 AM

The ( ' ) also gives a database error when naming the games.

MrZeropage 10-29-2006 10:51 AM

Yes, just don't use this character by now, will fix that later ...


All times are GMT. The time now is 03:09 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.00929 seconds
  • Memory Usage 1,719KB
  • 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_quote_printable
  • (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