Record not found
8 posts by 2 authors in: Forums > CMS Builder
Last Post: November 8, 2010 (RSS)
By (Deleted User) - November 6, 2010
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: [RapidWeb] Record not found
By Jason - November 8, 2010
Can you attach food.php so I can see the code being used?
Is this for a single or a multi-record section? Have you populate the back end with records?
Let me know and I'll take a look into this for you.
Thanks
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
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
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
(note: there is no sensitive info on the print screen).
Re: [RapidWeb] Record not found
By Jason - November 8, 2010
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
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
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...[:)]