PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Pro Support Forums > Photopost Pro Installation & Upgrades

Photopost Pro Installation & Upgrades If you're having install or upgrade problems

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old December 22nd, 2005, 08:28 PM   #1 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
Issue after Install????

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

can someone tell me why i cant fix this issue, and how to do it??
btwntx is offline   Reply With Quote
Old December 22nd, 2005, 08:33 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,693
How about a file and line number so we can assist you?
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old December 22nd, 2005, 08:36 PM   #3 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
sorry thought i copied it all but must not have

here you go
THANK YOU SO Much for your help




mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/klanwars/public_html/photopost/forums/vb3.php on line 25
btwntx is offline   Reply With Quote
Old December 22nd, 2005, 08:42 PM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,693
Okay can only be one of two things.

Either on the first step of install you did not specify the correct database info for vbulletin or on the next to last step of install you did not input the vb3 table prefix.

You can use phpmyadmin to edit the settings table in photopost and set setting 83 to the correct prefix or if the wrong database info was used you can edit the config-inc.php file to input the right database info

If its easier you can simply rerun install and input the proper info again.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old December 22nd, 2005, 08:56 PM   #5 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
ummmm ok now its giving me this error, im so lost what do i do now???


Parse error: parse error, unexpected T_STRING in /home/klanwars/public_html/photopost/header-inc.php on line 19
btwntx is offline   Reply With Quote
Old December 22nd, 2005, 09:07 PM   #6 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
here is like the first 20 lines of the file

<?php
//
// vBulletin Integration header file
//
// If PhotoPost has an odd background color or squished width, you will need to edit
// vbulletin's default "header" style input box / template and change "{pagebgcolor}"
// and "{tablewidth}" (near the bottom) to your preferred background color and table
// width, respectively.
//

require "config-int.php";

$vboptions = array();
unset($vbuserid);

if ( VB3_INTEGRATION == "on" ) {
if ( THIS_SCRIPT == "comments" && VB3_ENHANCEDINT == "on" ) {
################### PRE-CACHE TEMPLATES AND DATA ######################
get special phrase groups
$phrasegroups = array('threadmanage', 'posting', 'PhotoPost_PopUp');
$phrasegroups = array('threadmanage', 'posting');

get special data templates from the datastore
$specialtemplates = array(
'smiliecache',
'bbcodecache',
'attachmentcache'
);

pre-cache templates used by all actions
$globaltemplates = array(
'newpost_attachment',
'newpost_attachmentbit',
'newthread'
);
btwntx is offline   Reply With Quote
Old December 22nd, 2005, 09:11 PM   #7 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,693
There is your issue try reuploading the file your missing all the text escape // characters

// get special phrase groups

thats line 19 for me
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old December 22nd, 2005, 09:19 PM   #8 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
o wow i do that and it goes back to this error:


Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /home/klanwars/public_html/photopost/header-inc.php on line 60

Warning: main(./global.php) [function.main]: failed to open stream: No such file or directory in /home/klanwars/public_html/photopost/header-inc.php on line 61

Fatal error: main() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/klanwars/public_html/photopost/header-inc.php on line 61


sorry to take up so much of your time, i really wish i knew more about the system
btwntx is offline   Reply With Quote
Old December 22nd, 2005, 10:33 PM   #9 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
<?php
//
// vBulletin Integration header file
//
// If PhotoPost has an odd background color or squished width, you will need to edit
// vbulletin's default "header" style input box / template and change "{pagebgcolor}"
// and "{tablewidth}" (near the bottom) to your preferred background color and table
// width, respectively.
//

require "config-int.php";

$vboptions = array();
unset($vbuserid);

if ( VB3_INTEGRATION == "on" ) {
if ( THIS_SCRIPT == "comments" && VB3_ENHANCEDINT == "on" ) {
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
//$phrasegroups = array('threadmanage', 'posting', 'PhotoPost_PopUp');
$phrasegroups = array('threadmanage', 'posting');

// get special data templates from the datastore
$specialtemplates = array(
'smiliecache',
'bbcodecache',
'attachmentcache'
);

// pre-cache templates used by all actions
$globaltemplates = array(
'newpost_attachment',
'newpost_attachmentbit',
'newthread'
);
}
elseif ( THIS_SCRIPT == "showphoto" && VB3_ENHANCEDINT == "on" ) {
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array('posting', 'postbit', 'showthread');

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();
}
else {
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();
}

chdir($vbpath);
require("./global.php");

if ( isset($bbuserinfo['userid']) ) {
$vbuserid = $bbuserinfo['userid'];
define( "VB35", 'off' );
}
else {
// vB3.5.2 uses $vbulletin
$vbuserid = $vbulletin->userinfo[userid];
$vboptions[bburl] = $vbulletin->options[bburl];
$vboptions[forumhome] = $vbulletin->options[forumhome];
$vboptions['storecssasfile'] = $vbulletin->options['storecssasfile'];
$vboptions['avatarenabled'] = $vbulletin->options['avatarenabled'];
$vboptions['usefileavatar'] = $vbulletin->options['usefileavatar'];
$vboptions[avatarurl] = $vbulletin->options['avatarurl'];

define( "VB35", 'on' );
}

eval('$navbar = "' . fetch_template('navbar') . '";');

$headinclude = process_replacement_vars($headinclude);
$header = process_replacement_vars($header);
$navbar = process_replacement_vars($navbar);

$vbheader = "$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>
$headinclude";

if ( VB35 == "off" )
require_once('./includes/functions_showthread.php');
else
require_once('./includes/class_postbit.php');

if ( THIS_SCRIPT == "comments" && VB3_ENHANCEDINT == "on" && VB3_COMMWYSIWYG == "on" ) {
require_once('./includes/functions_newpost.php');
require_once('./includes/functions_editor.php');
require_once('./includes/functions_bigthree.php');
//require_once('./includes/functions_wysiwyg.php');

$textareacols = fetch_textarea_width();

if ( !isset($_POST['WYSIWYG_HTML']) ) {
$editorid = construct_edit_toolbar('{ppcode}', 0, 0, 1);
if ( VB35 == "on" ) {
$messagearea = str_replace( "\"client", "\"". $vbulletin->options['bburl'] ."/client", $messagearea );
$messagearea = str_replace( "\"images", "\"". $vbulletin->options['bburl'] ."/images", $messagearea );
}
else {
$messagearea = str_replace( "\"client", "\"$vboptions[bburl]/client", $messagearea );
$messagearea = str_replace( "\"images", "\"$vboptions[bburl]/images", $messagearea );
}
}

if ( VB35 == "off" ) {
$body = "<body onload=\"editInit();\">";
}
else {
$body = "<body>";
}

$vbheader .= <<<VBHEADER
{ppheader}
</head>
$body
$header
$navbar
<div align="center">
VBHEADER;
}
elseif ( (THIS_SCRIPT == "showphoto" && VB3_ENHANCEDINT == "on") ||
(THIS_SCRIPT == "comments" && VB3_ENHANCEDINT == "on") ||
(THIS_SCRIPT == "search" && VB3_ENHANCEDINT == "on") ||
(THIS_SCRIPT == "comshow" && VB3_ENHANCEDINT == "on") ||
(THIS_SCRIPT == "showmembers" && VB3_ENHANCEDINT == "on") ) {

// We need these functions, too...
require_once('./includes/functions_newpost.php');
require_once('./includes/functions_editor.php');

$istyles_js = construct_editor_styles_js();

$vbheader .= <<<VBHEADER
<!-- set up CSS for the editor -->
<link rel="stylesheet" type="text/css" href="$vboptions[bburl]/clientscript/vbulletin_editor.css" />
<style type="text/css">
<!--
#vBulletin_editor {
background: {$istyles[pi_button_normal][0]};
padding: $stylevar[cellpadding]px;
}
#controlbar, .controlbar {
background: {$istyles[pi_button_normal][0]};
}
.imagebutton {
background: {$istyles[pi_button_normal][0]};
color: {$istyles[pi_button_normal][1]};
padding: {$istyles[pi_button_normal][2]};
border: {$istyles[pi_button_normal][3]};
}
-->
</style>
{ppheader}
</head>
<body>
$header
$navbar
<div align="center">
VBHEADER;
}
else {
$vbheader .= <<<VBHEADER
{ppheader}
</head>
<body>
$header
$navbar
<div align="center">
VBHEADER;
}

$headvars = array( "\"clientscript", "url(images/", "\"search", "\"profile", "\"#usercp", "\"private", "\"member",
"\"subscription", "\"online", "\"misc", "\"forumdisplay", "action=\"login", "\"faq", "\"register",
"\"{$vboptions[forumhome]}.php", "\"#usercptools", "\"usercp.php", "\"login.php", "'misc.php",
"\"calendar.php", "\"images/misc", "\"admincp.php" );
$headrepl = array( "\"{$vboptions['bburl']}/clientscript", "url({$vboptions['bburl']}/images/", "\"{$vboptions['bburl']}/search",
"\"{$vboptions['bburl']}/profile", "\"{$vboptions['bburl']}/#usercp", "\"{$vboptions['bburl']}/private",
"\"{$vboptions['bburl']}/member", "\"{$vboptions['bburl']}/subscription", "\"{$vboptions['bburl']}/online",
"\"{$vboptions['bburl']}/misc", "\"{$vboptions['bburl']}/forumdisplay", "action=\"{$vboptions['bburl']}/login",
"\"{$vboptions['bburl']}/faq", "\"{$vboptions['bburl']}/register",
"\"{$vboptions['bburl']}/{$vboptions[forumhome]}.php", "\"{$vboptions['bburl']}/#usercptools",
"\"{$vboptions['bburl']}/usercp.php", "\"{$vboptions['bburl']}/login.php", "'{$vboptions['bburl']}/misc.php",
"\"{$vboptions['bburl']}/calendar.php", "\"{$vboptions['bburl']}/images/misc", "\"{$vboptions['bburl']}/admincp.php" );
$vbheader = str_replace( $headvars, $headrepl, $vbheader );

eval('$vbfooter = "' . fetch_template('footer') . '";');
$vbfooter = process_replacement_vars($vbfooter);
$vbfooter = "</div>$vbfooter";

$footvars = array("\"$admincpdir", "\"$modcpdir", "\"archive", "\"sendmessage.php");
$footrepl = array("\"{$vboptions['bburl']}/$admincpdir","\"{$vboptions['bburl']}/$modcpdir","\"{$vboptions['bburl']}/archive", "\"{$vboptions['bburl']}/sendmessage.php");
$vbfooter = str_replace( $footvars, $footrepl, $vbfooter );

// One header with no navbar or such
$vbnoheader = <<<VBHEADER
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$styleinclude
$headinclude
{ppheader}
</head>
<body>
<div align="center">
VBHEADER;

$vbnoheader = str_replace( $headvars, $headrepl, $vbnoheader );
}

//
// VB2 CODE
//

if ( VB2_INTEGRATION == "on" ) {
chdir($vbpath);
require("global.php");
ob_start();
eval("dooutput(\"".gettemplate('headinclude')."\",0);");
$bodytag="<body>";
echo dovars($bodytag,0);
$vbheader="<head>";
$vbheader.=ob_get_contents();
$vbheader.="{ppheader}</head>";
ob_end_clean();
ob_start();
eval("dooutput(\"".gettemplate('header')."\",0);");
$vbheader.=ob_get_contents();
ob_end_clean();
ob_start();
eval("dooutput(\"".gettemplate('footer')."\",0);");
$vbfooter=ob_get_contents();
ob_end_clean();
chdir($pppath);
}

// vBPortal Integration
// If you want to include the vBPortal header, footer, and left menu, remove
// the "//" slashes from the beginning of the 16 lines of code below, and change
// "/home/public_html/vbportal" to your actual path to vbportal's main directory,
// and change "/home/public_html/photopost" to your actual path to PhotoPost's
// directory. This will override the default header and footer variables set in the
// PhotoPost admin panel.

if ( VBP2_INTEGRATION == "on" ) {
chdir($vbportal . "/");
require("mainfile.php");
$index = 0;
global $Pmenu,$Pheader;
$Pheader="P_themeheader";
$Pmenu="P_thememenu_photopost";
require("header.php");
$vbheader = ob_get_contents();
ob_end_clean();
ob_start();
require("footer.php");
$vbfooter = ob_get_contents();
ob_end_clean();
chdir($pppath . "/");
}

?>
btwntx is offline   Reply With Quote
Old December 22nd, 2005, 10:33 PM   #10 (permalink)
Registered User
 
Join Date: Dec 2005
Posts: 7
i just need to know what to fix if anyone can help me im totaly lost
btwntx is offline   Reply With Quote
Old December 23rd, 2005, 06:50 AM   #11 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,693
You need to upload a clean file so you arent getting a parse error and the other error is simply because on install you specified the wrong path to your forums. Edit the config-int.php and input the proper path to your forums for this variable

$vbpath
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
New Install upload Issue bigfoilin Photopost Pro Installation & Upgrades 12 August 28th, 2005 12:09 AM
Install Issue cherrystar Installs and Upgrade - vBulletin 3.0.X 2 July 24th, 2005 05:42 PM
Fresh Install into VB3.7 cookie issue? testpig Classifieds Installation & Upgrades 25 July 6th, 2005 08:17 AM
Install Issue : PP 5.11 + PHP-Nuke Platinum 7.6.0 VSDan Photopost Pro Installation & Upgrades 1 June 23rd, 2005 12:55 PM


All times are GMT -5. The time now is 01:34 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0