PHP Error

Permalink Browser Info Environment
mysqlt error: [1406: Data too long for column 'ipAddress' at row 1] in EXECUTE("INSERT INTO btJbSurveyAnswerSet ( questionSetId, customerID, requestStatus, requestStatusChanged, paymentMethod, paymentStatus, paymentAmount, paymentStatusChangedDate, paymentCCtype, paymentCCname, paymentCCnumber, paymentCCexp, paymentCCcvv, ipAddress) VALUES ('1438860321','1','submitted','2015-08-06 13:29:29',NULL,'PENDING','0','2015-08-06 13:29:29',NULL,NULL,'','',NULL,'41.182.4.134')")

Is the unexpected error when you click complete survey

Type: Pre-Sale
Status: In Progress
slowdive
View Replies:
jb1 replied on at Permalink Reply
jb1
Hi

I'm currently looking into this and get back to you.

JZ
jb1 replied on at Permalink Reply
jb1
Hi

Kindly upgrade your copy to the latest version. Let me know how it goes.

JZ
slowdive replied on at Permalink Reply
slowdive
After a brief test it seems to be working now, thanks for the super quick report.

I will let you know if I have any more problems, thanks for a a great plugin which is making our project happen.
Brian

concrete5 Environment Information

# concrete5 Version
5.6.3.3

# concrete5 Packages
Add Multiple Pages (1.2), Advanced Survey System (0.9.2), Are You A Human (1.0.1), Cobble (1.13), Content+ (0.9.0), Easy Accordion (1.1), Easy tabs (1.6.9), Email List Signup (1.03), Formigo Documents Manager (1.0.1), Galleria image gallery (2.0), Installs Ministry of Education Arts and Culture Theme (1.2), Login (1.0), Pictures Gallery (1.1.2), SCALA IT Optimize MySQL database (1.0), Security Wall (0.5), Social Icons (1.1), tnSpacer (1.2), User Info (1.9), Who's Online (2.2).

# concrete5 Overrides
jobs/si_mysql_optimize.php, languages/ru_RU, languages/cs_CZ, languages/es_AR, languages/ro_RO, languages/ar, languages/it_IT, languages/vi_VN, languages/fi_FI, languages/pt_PT, languages/es_ES, languages/fa_IR, languages/sv_SE, languages/de_DE, languages/fr_FR, languages/tr_TR, languages/el_GR, languages/da_DK, languages/es_MX, languages/es_PE, languages/sl_SI, languages/sk_SK, languages/zh_TW, languages/nl_NL, languages/ja_JP, languages/nb_NO

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off

# Server Software
Apache/2.4.16 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4

# Server API
cgi-fcgi

# PHP Version
5.4.43

# PHP Extensions
bcmath, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, filter, ftp, gd, gettext, hash, iconv, imap, ionCube Loader, json, libxml, mbstring, mcrypt, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, sockets, SPL, sqlite3, standard, suhosin, tokenizer, xml, xmlreader, xmlwriter, Zend Guard Loader, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 512M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
suhosin.cookie.max_array_depth - 50
suhosin.cookie.max_array_index_length - 64
suhosin.cookie.max_name_length - 64
suhosin.cookie.max_totalname_length - 256
suhosin.cookie.max_value_length - 10000
suhosin.cookie.max_vars - 100
suhosin.executor.include.max_traversal - 0
suhosin.executor.max_depth - 0
suhosin.get.max_array_depth - 50
suhosin.get.max_array_index_length - 64
suhosin.get.max_name_length - 64
suhosin.get.max_totalname_length - 256
suhosin.get.max_value_length - 512
suhosin.get.max_vars - 100
suhosin.log.phpscript.is_safe - Off
suhosin.memory_limit - 0
suhosin.post.max_array_depth - 50
suhosin.post.max_array_index_length - 64
suhosin.post.max_name_length - 64
suhosin.post.max_totalname_length - 256
suhosin.post.max_value_length - 1000000
suhosin.post.max_vars - 1000
suhosin.request.max_array_depth - 50
suhosin.request.max_array_index_length - 64
suhosin.request.max_totalname_length - 256
suhosin.request.max_value_length - 1000000
suhosin.request.max_varname_length - 64
suhosin.request.max_vars - 1000
suhosin.session.max_id_length - 128
suhosin.upload.max_uploads - 25

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.130 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.