Record not found

8 posts by 2 authors in: Forums > CMS Builder
Last Post: November 8, 2010   (RSS)

By (Deleted User) - November 6, 2010

Hi,

I keep on getting a "Record not found" on a new editor:

http://koshertravelinfo.com/food/food.php

Can't seem to find out what is wrong...

Re: [Jason] Record not found

By (Deleted User) - November 8, 2010 - edited: November 8, 2010

Hi,

See the code below. I remove navigation and headers etc. Only think I can think off is this editor was imported by Interactive Tools from our old List Manager and the name of the table was "eat". I renamed it to food in CMS.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/listingTemplate.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<?php
require_once "/cmsAdmin/lib/viewer_functions.php"; list($foodRecords, $foodMetaData) = getRecords(array(
'tableName' => 'food',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$foodRecord = @$foodRecords[0]; // get first record // show error message if no matching record is found
if (!$foodRecord) {
print "Record not found!";
exit;
} ?>
<title><?php echo $foodRecord['food_name'] ?></title> <div id="mainContent">
<h1><?php echo $foodRecord['food_name'] ?></h1>
</div>
<!-- end #mainAriea -->
</div>
<div id="footer">
<p>Footer</p>
<!-- end #footer --></div>
<!-- end #container --></div>
</body>

Re: [RapidWeb] Record not found

By Jason - November 8, 2010

Hi,

When you changed the name from "eat" to "food", did you only change the menu name or did you change the MySQL name aswell?

try this page inside CMS Builder:
admin.php?menu=food

When you go there, do you see any records? The issue is that you're query isn't returning any results.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Record not found

By (Deleted User) - November 8, 2010 - edited: November 8, 2010

The SQL table name was changed and the table is populated. Please see the attached Print Screen.

(note: there is no sensitive info on the print screen).
Attachments:

interactive.gif 117K

Re: [RapidWeb] Record not found

By Jason - November 8, 2010

Hi,

Okay, I think the best way to proceed would be to fill out a 2nd Level Support Request here:
https://www.interactivetools.com/support/email_support_form.php

So we can take a closer look at exactly what's happening.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [RapidWeb] Record not found

By Jason - November 8, 2010

Hi,

I've taken a look into this and found the problem. Since these records were created in another program and then moved over to CMS Builder, they were attached to user accounts that no longer exist. By default, CMS Builder will filter out records that were created by users no longer in or active in the system. We can get around this by adding this line to the getRecords query:

'includeDisabledAccounts' => true,

That should take care of the issue for you.

Hope this helps.
Jason
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Record not found

By (Deleted User) - November 8, 2010

Thank you so much!

Next time I will post for help on the support board before trying to do this on my own spending all weekend pulling out my hair...[:)]