some problem with my directory please help

forumrating Notable Member

Messages:: 6,565

Likes Received:: 347

Best Answers:: 0

Trophy Points:: 275

#1

Fatal error: Call to a member function on a non-object in /home/director/public_html/index.php on line 150

url is directoryrating.com

please some one help me with this issue thanks.

forumrating, Apr 2, 2007 IP

paidhosting likes this.

SasaVtec Notable Member

Messages:: 1,588

Likes Received:: 150

Best Answers:: 0

Trophy Points:: 275

#2

What did you change right before seeing this error?

SasaVtec, Apr 2, 2007 IP

forumrating likes this.

forumrating Notable Member

Messages:: 6,565

Likes Received:: 347

Best Answers:: 0

Trophy Points:: 275

#3

i dint change anything , just saw the directory its showin me error suddenly frm no where.

forumrating, Apr 2, 2007 IP

paidhosting Peon

Messages:: 4,822

Likes Received:: 483

Best Answers:: 0

Trophy Points:: 0

#4

Did u just upload some new template files? Or changed index.php file? And did u check that all files are present in that folder?

paidhosting, Apr 2, 2007 IP

forumrating likes this.

NeoGen Writer

Messages:: 2,303

Likes Received:: 301

Best Answers:: 0

Trophy Points:: 230

#5

Can you just post the lines from 145 through 155 of index.php over here..

Are you using PHPLD?

NeoGen, Apr 2, 2007 IP

forumrating Notable Member

Messages:: 6,565

Likes Received:: 347

Best Answers:: 0

Trophy Points:: 275

#6

$row = $rs->FetchRow();
if ($id == 0 && CATS_PREVIEW > 0) {
$rs2 = $db->SelectLimit("SELECT * FROM {$tables['category']['name']} WHERE STATUS=2 AND PARENT_ID = ".$row['ID']." ORDER BY HITS DESC, TITLE", CATS_PREVIEW);
$row['SUBCATS'] = $rs2->GetRows();
$rs2->Close();
}
if (ENABLE_REWRITE && empty ($row['TITLE_URL'])) {
$row['TITLE_URL'] = preg_replace('`[^\w_-]`', '_', $row['TITLE']);
$row['TITLE_URL'] = str_replace('__', '_', $row['TITLE_URL']);
}
$row['COUNT'] = $db->GetOne("SELECT COUNT(*) FROM {$tables['category']['name']} WHERE STATUS=2 AND PARENT_ID = ".$row['ID']);

$row['COUNT'] += $db->GetOne("SELECT COUNT(*) FROM {$tables['link']['name']} WHERE STATUS=2 AND CATEGORY_ID = ".$row['ID']);
$categs[] = $row;
}

$rs->Close();
Click to expand...

line 150-165

forumrating, Apr 2, 2007 IP

NeoGen Writer

Messages:: 2,303

Likes Received:: 301

Best Answers:: 0

Trophy Points:: 230

#7

Login to your cpanel and try to repair your mysql database through phpmyadmin. especially check the category table.

NeoGen, Apr 2, 2007 IP

forumrating Notable Member

Messages:: 6,565

Likes Received:: 347

Best Answers:: 0

Trophy Points:: 275

#8

i don't know how to repair the db

forumrating, Apr 2, 2007 IP

NeoGen Writer

Messages:: 2,303

Likes Received:: 301

Best Answers:: 0

Trophy Points:: 230

#9

are you using cpanel hosting, if yes can you login into cpanel??

NeoGen, Apr 2, 2007 IP

seolion Active Member

Messages:: 1,495

Likes Received:: 97

Best Answers:: 0

Trophy Points:: 90

#10

If its saying error at line 150, I need to see few lines above that as well.

Can you post 140-150 ?

seolion, Apr 2, 2007 IP

forumrating likes this.

forumrating Notable Member

Messages:: 6,565

Likes Received:: 347

Best Answers:: 0

Trophy Points:: 275

#11

$links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 AND (URL LIKE $q OR TITLE LIKE $q OR DESCRIPTION LIKE $q) $feat_where $expire_where ORDER BY {$sort_cols[$sort]} {$sort_ord[$sort]}");
$categs = array();
$path[] = array ('ID' => '0', 'TITLE' => _L('Search Results'), 'TITLE_URL' => '', 'DESCRIPTION' => _L('Search results for: ').$_REQUEST['q']);
$tpl->assign('qu', rawurlencode($_REQUEST['q']));

} else {
$id = get_category();
if (!$tpl->is_cached('main.tpl', $id)) {
$path = get_path($id);
if(FTR_ENABLE){
$feat_links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 AND CATEGORY_ID = $id AND FEATURED=1 $expire_where ORDER BY EXPIRY_DATE DESC");
$tpl->assign('feat_links', $feat_links);
}

// Paging 3
$count = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 AND CATEGORY_ID = $id $feat_where $expire_where ORDER BY {$sort_cols[$sort]} {$sort_ord[$sort]}");
// End Paging 3

$links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 AND CATEGORY_ID = $id $feat_where $expire_where ORDER BY {$sort_cols[$sort]} {$sort_ord[$sort]}{$limit}");
$rs = $db->Execute("SELECT * FROM {$tables['category']['name']} WHERE STATUS=2 AND PARENT_ID = $id ORDER BY TITLE");
while (!$rs->EOF) {
$row = $rs->FetchRow();
Click to expand...

lines 129 - 150

also its showing other error while exporting the db


<div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="http://dev.mysql.com/doc/mysql/en/select.html" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a><a href="tbl_properties.php?db=director_gen&table=PLD_CATEGORY&token=b3d6a041cfd9e5f7d0159e1cbd4da12b&sql_query=SELECT+%2A+FROM+%60director_gen%60.%60PLD_CATEGORY%60&show_query=1"><img class="icon" src=" ./themes/original/img/b_edit.png" width="16" height="16" alt="Edit" /></a> </p>
<p>
<span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SELECT</span> <span class="syntax_punct">*</span> <br /><span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_quote syntax_quote_backtick">`director_gen`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`PLD_CATEGORY`</span> </span>
</p>
<p>
<strong>MySQL said: </strong><a href="http://dev.mysql.com/doc/mysql/en/error-messages-server.html" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p>
<code>
#1016 - Can't open file: 'PLD_CATEGORY.MYI' (errno: 145)
</code><br />
</div><fieldset class="tblFooters"> </fieldset>

<script type="text/javascript" language="javascript">
//<![CDATA[
// updates current settings
if (window.parent.setAll) {
window.parent.setAll('en-utf-8', 'utf8_unicode_ci', '1', 'director_gen', 'PLD_CATEGORY');
}

// set current db, table and sql query in the querywindow
if (window.parent.refreshNavigation) {
window.parent.reload_querywindow(
'director_gen',
'PLD_CATEGORY',
'');
}

if (window.parent.frame_content) {
// reset content frame name, as querywindow needs to set a unique name
// before submitting form data, and navigation frame needs the original name
if (window.parent.frame_content.name != 'frame_content') {
window.parent.frame_content.name = 'frame_content';
}
if (window.parent.frame_content.id != 'frame_content') {
window.parent.frame_content.id = 'frame_content';
}
//window.parent.frame_content.setAttribute('name', 'frame_content');
//window.parent.frame_content.setAttribute('id', 'frame_content');
}
//]]>
</script>
</body>
</html>
Click to expand...

forumrating, Apr 2, 2007 IP

NeoGen Writer

Messages:: 2,303

Likes Received:: 301

Best Answers:: 0

Trophy Points:: 230

#12

I think its problem with your database.. you should repair..

see some of the tutorials here:
http://www.tamba2.org.uk/wordpress/repair/

also see this:
http://www.oscommerce.info/kb/osCommerce/General_Information/Common_Problems/69

NeoGen, Apr 2, 2007 IP

seolion likes this.

Fastian Peon

Messages:: 2,085

Likes Received:: 235

Best Answers:: 0

Trophy Points:: 0

#13

I looks like a DataBase problem to me.

Do one thing. Add an other DB_user to your current Directory Database and then simple change the DB_user in your include/config.php file. See if that helps.

I got a but similar issue when my DB user reached its Queries limit set by my Host.

Fastian, Apr 2, 2007 IP

forumrating likes this.

seolion Active Member

Messages:: 1,495

Likes Received:: 97

Best Answers:: 0

Trophy Points:: 90

#14

Hi Forumrating,

I agree with NeoGen, problem could be with your DB as its giveing error at line containing

$row = $rs->FetchRow();

$rs in not an object (As there was no resultset), the error.

Thats what I guess.

seolion, Apr 2, 2007 IP

an0n Prominent Member

Messages:: 5,688

Likes Received:: 915

Best Answers:: 0

Trophy Points:: 360

#15

firstly, what's your backend? IIS? Apache?
second, try clearing your cache folder: temp/templates/
third, if not 1 or 2, try to repair your DB

also, ping your mySQL server to ensure that its up and running.

need more help let me know. i did get your PM.

Rob

an0n, Apr 2, 2007 IP

forumrating likes this.

NeoGen Writer

Messages:: 2,303

Likes Received:: 301

Best Answers:: 0

Trophy Points:: 230

#16

Great !!!
It was a Database problem, repaired and your directory is back online

NeoGen, Apr 2, 2007 IP

forumrating likes this.

paidhosting Peon

Messages:: 4,822

Likes Received:: 483

Best Answers:: 0

Trophy Points:: 0

#17

NeoGen said: ↑

Great !!!
It was a Database problem, repaired and your directory is back online
Click to expand...

cool good to see another directory back online and kicking ass..

paidhosting, Apr 2, 2007 IP

Log in or Sign up

some problem with my directory please help

forumrating Notable Member

SasaVtec Notable Member

forumrating Notable Member

paidhosting Peon

NeoGen Writer

forumrating Notable Member

NeoGen Writer

forumrating Notable Member

NeoGen Writer

seolion Active Member

forumrating Notable Member

NeoGen Writer

Fastian Peon

seolion Active Member

an0n Prominent Member

NeoGen Writer

paidhosting Peon

Useful Searches