Support Forum

ive finished moding the admin.php and the language files

everything works great till i try to run it from the index.

Fatal error: Call to a member function on a non-object in modules/Interviews/index.php on line 503
which correpsonds to something around here i believe

Code

$column = &$pntable['interviews_column'];
    $popquery = buildSimpleQuery('interviews', array ('id', 'title', 'hits'), $querylang, "$column[hits] DESC", 10);
    $result_pop = $dbconn->Execute($popquery);
    $x = 0;
    while (!$result_pop->EOF)  {
        list($id, $title, $hits) = $result_pop->fields;
        $ida[$x] = $id;
        $titlea[$x] = $title;
        $hitsa[$x] = $hits;
        $x++;
        $result_pop->MoveNext();
    }

also when i try to view interviews posted under a or b etc i get this

Error accesing to the database
Program: [webroot]/modules/Interviews/index.php - Line N.: 631
Database: ******
Error (1064) : You have an error in your SQL syntax near ' , , , FROM WHERE UPPER() LIKE 'A%' ' at line 1

any thoughts?

Bueller??

I think it may be an API issuse, does that give anyone any ideas?

There was a recent news item in the mods site about an interview module,

yeah i saw that but damnit if pnRender isnt a pain to get working. i installed in and init both it and xanthia but when i go to admin the interview module i get this error
Fatal error: Cannot instantiate non-existent class: pnrender in modules/dpInterviews/pnadmin.php on line 15

so rather than screw up my site even more i thought moding out a current module would be a bit safer.

i take that back, i cant init Xanthia it gives me a fatal error on the pninit.php file. tried downloading the one linked from the PostNuke modules page about the XTE release but it still wont work.

well im finally getting a chance to work this out.

the dpInterviews module was of no help. And any support for it is in Spanish that I could tell and made no sense to me. Installing 750 is not an option.

So Im back to modifying the Reviews Module. Everything works fine until I try to look up Interviews of a certain letter or send an Interview to the DB.

it says

Error accesing to the database
Program: [webroot]/modules/Interviews/index.php - Line N.: 690
Database: mainsite
Error (1064) : You have an error in your SQL syntax near ' nuke_interviews.pn_score FROM nuke_interviews WHERE nuke_inter' at line 1


now that SQL select statement is the exact same except i changed this part of the function
$reviewstable = $pntable['reviews'];
$column = &$pntable['reviews_column'];

to

$interviewstable = $pntable['interviews'];
$column = &$pntable['interviews_column'];

and pntables.php has all the right entries and the DB was created with the same SQL just replaced nuke_reviews with nuke_interviews

so it should work. but its not. any ideas at all?

to make things even more complicated i reset this part
$interviewstable = $pntable['interviews'];
$column = &$pntable['interviews_column'];

back to

$reviewstable = $pntable['reviews'];
$column = &$pntable['reviews_column'];


and it worked fine but instead of loading the interviews it ofcourse loaded the reviews.

why the hell does changing that listing effect the syntax so that it wont connect properly? im using $interviewstable in the SQL select statement and it doesnt work. and it wont send data to the DB either. when i try to add an interview it says it went through but it never shows up in the DB.

93 views since june and only one response :P someone has to know whats going on

ok, i fixed it and working perfectly.