DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Thanks Thanks:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4

Thread: mySQL errors.


Forum: DragonByte vBForms Lite Support

Questions & Answers for DragonByte Signatures.
Click here to buy!

  1. #1
    Member
    Level 3 (2,450 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Aug 2012
    Posts
    39
    Rep Power
    0

    Default mySQL errors.

    Getting errors on 3 separate forms, they all worked when we set them up but now we cannot see them in the forums we assigned them to and when submitting we are presented with mySQL errors.

    Error 1:
    Code:
    Database error in vBulletin 4.2.3:
    
    Invalid SQL:
    INSERT INTO dbtech_dbforms_entry
    	(categoryid, questions, DOB, #, GT, Position, Nationality, Team, Previous, dateline, responses)
    VALUES
    	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:25;s:2:\"CB\";i:26;s:8:\"Scottish\";i:27;s:5:\"Unity\";i:28;s:3:\"n/a\";}', '6', '6', 'Unity Bluefin', 'CB', 'Scottish', 'Unity', 'n/a', 1452814545, 'a:2:{i:0;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15667;s:12:\"responsetype\";s:4:\"user\";s:8:\"dateline\";i:1452814545;}i:1;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15667;s:12:\"responsetype\";s:7:\"manager\";s:8:\"dateline\";i:1452814545;}}');
    
    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 'VALUES
    	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:2' at line 3
    Error Number  : 1064
    Request Date  : Thursday, January 14th 2016 @ 11:35:45 PM
    Error Date    : Thursday, January 14th 2016 @ 11:35:45 PM
    Script        : 
    Referrer      : 
    IP Address    : 
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.5.46-0+deb7u1
    Code:
    Database error in vBulletin 4.2.3:
    
    Invalid SQL:
    INSERT INTO dbtech_dbforms_entry
    	(categoryid, questions, DOB, #, GT, Position, Nationality, Team, Previous, dateline, responses)
    VALUES
    	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:25;s:2:\"CB\";i:26;s:8:\"Scottish\";i:27;s:5:\"Unity\";i:28;s:3:\"n/a\";}', '6', '6', 'Unity Bluefin', 'CB', 'Scottish', 'Unity', 'n/a', 1452814696, 'a:2:{i:0;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15670;s:12:\"responsetype\";s:4:\"user\";s:8:\"dateline\";i:1452814696;}i:1;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15670;s:12:\"responsetype\";s:7:\"manager\";s:8:\"dateline\";i:1452814696;}}');
    
    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 'VALUES
    	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:2' at line 3
    Error Number  : 1064
    Request Date  : Thursday, January 14th 2016 @ 11:38:16 PM
    Error Date    : Thursday, January 14th 2016 @ 11:38:17 PM
    Script        : 
    Referrer      : 
    IP Address    : 
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.5.46-0+deb7u1
    Code:
    Database error in vBulletin 4.2.3:
    
    Invalid SQL:
    INSERT INTO dbtech_dbforms_entry
    	(categoryid, statusid, questions, Current Gamertag, Age, experience, Pos, secondary, Availability, weaknesses, mic, skype, dateline, responses)
    VALUES
    	(1, 1, 'a:9:{i:30;s:13:\"Unity Bluefin\";i:7;s:2:\"27\";i:2;s:0:\"\";i:32;s:2:\"CB\";i:8;a:1:{i:0;s:3:\"CDM\";}i:35;s:4:\"Blah\";i:5;s:4:\"Blah\";i:6;s:3:\"Yes\";i:9;s:4:\"blah\";}', 'Unity Bluefin', '27', '', 'CB', 'CDM', 'Blah', 'Blah', 'Yes', 'blah', 1452814797, 'a:2:{i:0;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15673;s:12:\"responsetype\";s:4:\"user\";s:8:\"dateline\";i:1452814797;}i:1;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15673;s:12:\"responsetype\";s:7:\"manager\";s:8:\"dateline\";i:1452814797;}}');
    
    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 'Gamertag, Age, experience, Pos, secondary, Availability, weaknesses, mic, skype,' at line 2
    Error Number  : 1064
    Request Date  : Thursday, January 14th 2016 @ 11:39:57 PM
    Error Date    : Thursday, January 14th 2016 @ 11:39:57 PM
    Script        : 
    Referrer      : 
    IP Address    : 
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.5.46-0+deb7u1
    Thats the 3 errors, each time we post with the forms were getting forums/newthread.php?do=newthread&f=31 on every single error,
    0 0 0
     
    mySQL errors. Send PM  

  2. #2
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,735
    Blog Entries
    13
    Rep Power
    10

    Default

    Hi there,

    This is because some of the question's Varname fields are using unsupported characters. Please use only upper- and lower-case A-Z characters for these fields.

    Could you please try erasing these invalid questions and replace them with valid varnames and see if this works for you?

    Sorry for the inconvenience
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    mySQL errors. Send PM  

  3. #3
    Member
    Level 3 (2,450 Loyalty Points)

    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Aug 2012
    Posts
    39
    Rep Power
    0

    Default

    Quote Originally Posted by Belazor View Post
    Hi there,

    This is because some of the question's Varname fields are using unsupported characters. Please use only upper- and lower-case A-Z characters for these fields.

    Could you please try erasing these invalid questions and replace them with valid varnames and see if this works for you?

    Sorry for the inconvenience
    I had fixed error 1,2 by the time I seen your response, I kinda figured it out as I went along, my fellow admin set it up and had symbols and spaces etc. Its fixed now, apologies for wasting your time.
    0 0 0
     
    mySQL errors. Send PM  

  4. #4
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,735
    Blog Entries
    13
    Rep Power
    10

    Default

    No problem at all

    I'll look into adding validation code to the insertion to prevent this from happening in the future.

    Thanks!
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 1 0
     
    mySQL errors. Send PM  

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [vB 4.1.x] MySQL Errors a plenty
    By Jem in forum vBActivity & Awards Lite Support
    Replies: 12
    Last Post: 13th February 2012, 23:59

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.