Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

[Solved]Could not insert search results

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Suggestions & Feedback
View previous topic :: :: View next topic  
Author Message
boyti ko

New User


Joined: 03 Nov 2014
Posts: 78
Location: Malaysia

PostPosted: Fri Oct 30, 2015 2:41 pm    Post subject: Could not insert search results
Reply with quote

Everytime I try checking other user's posts when posts is about 9k and above, I get this error.

SQL Error : 1406 Data too long for column 'search_array' at row 1

INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES(1805654515, '9a80422ec7af51286e9fb106c68e0b18', 'a:7:{s:14:"search_results";s:77456:"69998, 70144, 70784, 70825, 71756, 72296, 72297, 73055, 73539, 73702, 74183, 74189, 74270, 74301, 74305, 74522, 74548, 74556, 74576, 74577, 74607, 74672, 74677, 74680, 74701, 74726, 74756, 74780, 74838, 74846, 74856, 74871, 75234, 75238, 75275, 75405, 75666, 75769, 75906
.
.
.
332145, 332159, 332161, 332164, 332175, 332186, 332203, 332243, 332247, 332248, 332251, 332271, 332298, 332318, 332327, 332330";s:17:"total_match_count";i:9707;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:5:"posts";s:12:"return_chars";i:200;}')

Line : 774
File : /var/www/vhosts/ibmmainframes.com/httpdocs/search.php
Back to top
View user's profile Send private message

mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1202
Location: India

PostPosted: Fri Oct 30, 2015 8:27 pm    Post subject:
Reply with quote

We are working on this...
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1202
Location: India

PostPosted: Fri Oct 30, 2015 10:34 pm    Post subject:
Reply with quote

Please try now and let me know if its working...
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Fri Oct 30, 2015 11:26 pm    Post subject: Reply to: Could not insert search results
Reply with quote

Looks good for the three users involved.
Back to top
View user's profile Send private message
boyti ko

New User


Joined: 03 Nov 2014
Posts: 78
Location: Malaysia

PostPosted: Mon Nov 02, 2015 12:00 pm    Post subject:
Reply with quote

It's all good. Thank you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Suggestions & Feedback All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts Insert Lines in JCL with Rexx after a... Willy Jensen CLIST & REXX 3 Tue Aug 30, 2016 4:18 pm
No new posts How to insert a lengthy string havin... vidyaa DB2 7 Thu Aug 25, 2016 5:20 pm
No new posts How do I right justify a string in an... rakesh17684 DB2 1 Wed Jun 08, 2016 8:01 pm
No new posts Search a Load Module sreekanth1984 TSO/ISPF 8 Tue Jun 07, 2016 8:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us