Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1200
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: 1200
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: 7315

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 Weirdo results with JOINKEYS Balaryan DFSORT/ICETOOL 4 Wed Oct 18, 2017 9:04 pm
No new posts HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts Search for a string in many PDS KARTHIGADEVI CLIST & REXX 5 Fri Sep 08, 2017 2:32 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us