Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.
Forgot Password?
Navigation

SQL error help needed

Last updated on 8 years ago
C
CatzenjaegerSenior Member
Posted 8 years ago
Hi in my infusion i get a error when i post texts in a textfield as Item decription

Quote

PDOMySQL.inc
/site/infusions/figurelib/admin.php?aid=xxxxxxxxxxx&section=items&action=edit&item_id=926&step=7

Severity : Notice generated by user using trigger_error() function
Query Error: UPDATE fusionSL2JP_figure_items SET figure_title = 'Neomorph Life-Size Head', figure_artists = 'CoolProps has created a replica of this creature&
#039;s head in life-size with the cooperation of Odd studio, who produced the original prop for the film.', figure_series = '', figure_variant = '', figure_weight = 'TBD', figure_editionsize = '', figure_pubdate = '2019-3-1', figure_videourl = '', figure_images_source = '', figure_credits = '', figure_brand = '9', figure_category = '2', figure_class = '2', figure_country = '206', figure_manufacturer = '14', figure_material = '16', figure_poa = '2', figure_packaging = '4', figure_certificate = '3', figure_limitation = '3', figure_numbered = '3', figure_signature = '2', figure_width = '64', figure_height = '21', figure_depth = '78', figure_scale = '2', figure_status = '4', figure_color = '10', figure_hand_cast = '3', figure_hand_painted = '1', figure_hand_finished = '1', figure_retailprice = '1199.00', figure_usedprice = '0.00', figure_accessories = '', figure_description = 'Sideshow and CoolProps are pleased to present the Neomorph Life-Size Head Prop Replica. The Neomorph appeared in the dark in Alien: Covenant, and attacked the covenant crew continuously with its quick movement. Though this alien has a creepy emotionless face, at its confrontation with David, it almost looked as if the Neomorph showed human expression. CoolProps has created a replica of this creature's head in life-size with the cooperation of Odd studio, who produced the original prop for the film.', figure_manufacturer_item_id = '903719', figure_upc = '', figure_ean = '', figure_jan = '', figure_isbn = '', figure_itf14 = '', figure_asin = '', figure_ebay_item_id = '', figure_affiliate_various_1 = '<a href="https://affiliates.sideshowtoy.com/Tracker.aspx?aid=3923&sku=903158&cid=-1"><button type="button" class="btn btn-outline-success btn-block"><img src="http://xxxxxxxxxxxxx.com/site/infusions/figurelib/images/flags/flag_usa.png" alt="US"> Buy at Sideshow </button></a>', figure_affiliate_various_2 = '', figure_affiliate_various_3 = '', figure_affiliate_various_4 = '', figure_affiliate_various_5 = '', figure_affiliate_various_6 = '', figure_affiliate_various_7 = '', figure_affiliate_various_8 = '', figure_affiliate_various_9 = '', figure_affiliate_various_10 = '', figure_related_01_url = '', figure_related_02_url = '', figure_related_03_url = '', figure_related_04_url = '', figure_related_05_url = '', figure_related_01_text = '', figure_related_02_text = '', figure_related_03_text = '', figure_related_04_text = '', figure_related_05_text = '', figure_show_images = '1', figure_show_data = '1', figure_show_videos = '1', figure_show_affiliates_various = '1', figure_show_affiliates_amazon = '1', figure_show_affiliates_ebay = '1', figure_show_related = '1', figure_show_collection = '1', figure_show_comments = '1', figure_show_ratings = '1', figure_show_social_sharing = '1', figure_freigabe = '1', figure_draft = '0', figure_draftstep = '13', figure_visibility = '0', figure_timestamp = '1533105957', figure_language = 'English', figure_submitter = '1', figure_clicks = '66', figure_trash1 = '', figure_trash2 = '', figure_trash3 = '', figure_trash4 = '', figure_trash5 = '', figure_trash6 = '', figure_trash7 = '', figure_trash8 = '', figure_trash9 = '', figure_trash10 = '', figure_trash11 = '', figure_trash12 = '', figure_trash13 = '', figure_trash14 = '' WHERE figure_id='926'
Stack Trace:
#0 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/classes/PHPFusion/Database/Driver/PDOMySQL.inc(64): PDO->prepare('UPDATE fusionS...')
#1 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/classes/PHPFusion/Database/AbstractDatabaseDriver.inc(312): PHPFusion\Database\Driver\PDOMySQL->_query('UPDATE
fusionS...', Array)
#2 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/db_handlers/all_functions_include.php(113): PHPFusion\Database\AbstractDatabaseDriver->query('UPDATE fusionS...', Array)
#3 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/sqlhandler.inc.php(810): dbquery('UPDATE
fusionS...')
#4 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendItems.class.php(514): dbquery_insert('fusionSL2JP_fig...', Array, 'update')
#5 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendItems.class.php(1230): figurelibBackendItems->handlePostedData()
#6 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendItems.class.php(88): figurelibBackendItems->displayForm()
#7 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendView.class.php(106): figurelibBackendItems->viewBackend()
#8 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin.php(132): figurelibBackendView->viewContent()
#9 {main}
Error Nature: SQLSTATE[42000]: Syntax error or access violation: 1064 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 's head in life-size with the cooperation of Odd studio, who produced the origina' at line 1


code

if (!@function_exists("FLIB_Backend_ItemsForm_Step7")) {
   function FLIB_Backend_ItemsForm_Step7($informations) {
      ?>
      <!-- Open Tab -->
      <?= opentabbody("", "step_7", true); ?>
      <div class="row m-t-20">
         <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">

            <!-- Description -->
            <?= form_textarea("figure_description", $informations['locale']['fields-1801'], $informations['data']['figure_description'],
               array_merge(["placeholder" => $informations['locale']['fieldplaceholder-1801']], $informations['textarea'])
            ); ?>

            <!-- Accessories -->
            <?= form_textarea("figure_accessories", $informations['locale']['fields-1802'], $informations['data']['figure_accessories'],
               array_merge(["placeholder" => $informations['locale']['fieldplaceholder-1802']], $informations['textarea'])
            ); ?>
            
      <!-- Close Tab -->
         </div>
      </div>
      <?= closetabbody(); ?>
      <?php
   }
}
You can view all discussion threads in this forum.
You cannot start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
You cannot set up a bounty in this discussion thread.
Moderator: Support Team
Users who participated in discussion: Catzenjaeger