World Community Grid - View Thread - Frequent Search Error "Cannot find the row in table..."

World Community Grid Forums

Category: Retired Forums

Forum: Member-to-Member Support [Read Only]

Thread: Frequent Search Error "Cannot find the row in table..."

Quick Go »

No member browsing this thread

Thread Status: Active
Total posts in this thread: 10

[ ]

Author

This topic has been viewed 1296 times and has 9 replies

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Frequent Search Error "Cannot find the row in table..."

I have often experienced the following error when trying to do a search on this bulletin board (and I'm getting it again now). I get the following notice:

"The error messsage is:
Cannot find the row in table Post where primary key = (7072)."

I have used the Contact Us link to report this a few times, but have never received an email back from an administrator, so I do not know if this is being addressed.

[Jan 13, 2005 6:31:27 PM]

knreed
Former World Community Grid Tech
Joined: Nov 8, 2004
Post Count: 4504
Status: Offline
Project Badges:

180 day badge for Human Proteome Folding

90 day badge for Human Proteome Folding - Phase 2

45 day badge for Help Cure Muscular Dystrophy - Phase 2

90 day badge for Computing for Clean Water

14 day badge for Uncovering Genome Mysteries

45 day badge for Outsmart Ebola Together

180 day badge for FightAIDS@Home - Phase 2

1 year badge for Microbiome Immunity Project

1 year badge for Africa Rainfall Project

180 day badge for OpenPandemics - COVID-19


Re: Frequent Search Error "Cannot find the row in table..."

MNTechnoGuy,

Can you give me the search criteria that you were using for the search and the exact actions you took to generate the error?

Also - if anyone else experiences this error - please post in this thread the search and steps you took to generate the error.

Thanks,
knreed

----------------------------------------
[Edit 2 times, last edit by knreed at Jan 14, 2005 2:49:29 PM]

[Jan 13, 2005 8:20:50 PM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

Knreed,

I was searching by Member Name, using my member name, "MNTechnoGuy." I am getting the same error now.

[Jan 14, 2005 7:52:03 PM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

I can confirm that this is the case but only when using MNTechnoGuy. (notice the period/full stop at the end). If you use MNTechnoGuy on its own, I cannot get it to fail.

I guess that this is a failure condition which does not have a user friendly error message, something like:

We are unable to find a member with that name. Please try again

Not that you cannot use regular expression either. This means that you cannot search for MNTechn*. You can use regexp (limited) in the Text to Search box. This means that you can enter

Dav*

which will find any post that has Dav, Dave, David etc

----------------------------------------
[Edit 1 times, last edit by Former Member at Jan 14, 2005 8:23:42 PM]

[Jan 14, 2005 8:21:32 PM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

I have never searched with the period. The period appeared within quotes because it is proper structure for a sentence ending with a quote. I get the error when searching for "MNTechnoGuy" without a period.

Edit: I have just now tried again, and get the error.

----------------------------------------
[Edit 1 times, last edit by Former Member at Jan 14, 2005 8:44:29 PM]

[Jan 14, 2005 8:43:04 PM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

Ok, I have just got the same error

Cannot find the row in table Post where primary key = (7072).

The only way that this can be resolved is for one of the tech guys to have a look at the underlying (guessing MySQL) database schema and see why it is failing.

Sorry to have thrown a red herring about the period.

Stuart

----------------------------------------
[Edit 1 times, last edit by Former Member at Jan 14, 2005 8:50:28 PM]

[Jan 14, 2005 8:48:47 PM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

Hi MNTechnoGuy

I have hopefully found the solution to your problem
Have a look in your profile and check your Member ID
Heres the link: http://www.worldcommunitygrid.org/forums/wcg/myprofile
I would suggest that your personal profile name may be entered as "mntechnoguy"
The search function is case sensative
Please try using the above in your search
I tried it and it finds your posts without a problem

I hope this helps

Best Regards

----------------------------------------
[Edit 3 times, last edit by Former Member at Jan 15, 2005 11:34:43 AM]

[Jan 15, 2005 11:25:46 AM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

I would suggest that your personal profile name may be entered as "mntechnoguy"

Graham,

I understand what you are saying but his posting show up as MNTechnoGuy so that is what should be entered into the backend database. If there is a problem here, I would say that there is possibly something generically wrong with the search function within mvnForum 1.0.0 RC3

[Jan 15, 2005 9:32:09 PM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

Graham,

Thanks again for your input. I do have one post as "mntechnoguy," but most of my posts have been under "MNTechnoGuy."

I was able to get search results today. This is an intermittent problem.

[Jan 16, 2005 7:06:11 AM]

Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline


Re: Frequent Search Error "Cannot find the row in table..."

Hi MNTecnoGuy
I have been advised that the problem that you reported has been isolated and a fix should be implimented in the next 10 to 14 days
Thank you for your patience

Best Regards

[Jan 18, 2005 3:16:47 PM]

[ ]