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.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 9 Support
  4. Modifications and Requests - 9
  5. SQL error help needed

SQL error help needed

Asked Modified Viewed 1,125 times
Back to Forum Index Previous Topic Next Topic
Print
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
asked
Senior Member

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

Code Download source
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
   }
}
0 replies
There are no post found.

Category Forum

Modifications and Requests - 9

Labels

Core Developers

Statistics

  • Views 0 views
  • Posts 0 posts
  • Votes 0 votes
  • Topic users 1 member

1 participant

C
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet