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.

SQL error help needed

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

CodeDownload  
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
   }
}

Thread Information
Author
Replies
1 post
Views
477 times
Last Post
Last updated on 2 years ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can 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.
Users who participated in discussion: Catzenjaeger