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 May 27th, 2005, 04:04 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: May 2005
Posts: 11
5.1 errors (with phpBB)

After trying to upgrade, I had to delete all files on server and do a fresh install. Before I did this I installed phpBB.

All installations went fine, but now when I access the main PP site, I get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/virtual/MYUSERNAME/www.MYSITE.com/pp-inc.php on line 2876

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/virtual/MYUSERNAME/www.MYSITE.com/pp-inc.php on line 756

When I try to enter the admin area for PP, I get:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/virtual/MYUSERNAME/www.MYSITE.com/pp-inc.php on line 2876

I use the same DB for both PP and phpBB (photo_)

The phpBB-board is running as it should.....

Any idea?

EDIT:
Whe trying to access with Opera I get:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/virtual/MYUSERNAME/www.MYSITE.com/pp-inc.php on line 2876

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/virtual/MYUSERNAME/www.MYSITE.com/pp-inc.php:2876) in /usr/www/virtual/MYUSERNAME/www.MYSITE.com/forums/phpbb2.php on line 220

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/virtual/MYUSERNAME/www.MYSITE.com/pp-inc.php:2876) in /usr/www/virtual/MYUSERNAME/www.MYSITE.com/forums/phpbb2.php on line 221

Last edited by ConTractor; May 27th, 2005 at 04:20 PM.
ConTractor is offline   Reply With Quote
Old May 27th, 2005, 04:33 PM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,720
Your usergroups table was not created

You can enter this in phpmyadmin make sure to add any prefix

CREATE TABLE usergroups (groupid int(5) NOT NULL auto_increment, groupname varchar(50) NOT NULL default '', cpaccess smallint(3) NOT NULL default '0', modaccess smallint(3) NOT NULL default '0', uploads smallint(3) NOT NULL default '1', comments smallint(3) NOT NULL default '1', diskspace int(10) default NULL, uploadsize int(10) default NULL, uplimit INT(5) DEFAULT '0' NOT NULL, editpho int(3) NOT NULL default '0', editposts int(3) NOT NULL default '0', useralbums int(3) NOT NULL default '0',reqmod INT(3) DEFAULT '0' NOT NULL, canassign INT(3) DEFAULT '0' NOT NULL, PRIMARY KEY (groupid)) TYPE=MyISAM;
INSERT INTO usergroups VALUES ('1','Anonymous','','','','','','',0,0,0,0,0,0);
INSERT INTO usergroups VALUES ('2','Admin',1,1,1,'','','',1,1,1,1,0,1);
INSERT INTO usergroups VALUES ('3','Regular Users','',1,1,'','','',1,1,0,1,0,0);
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.

Last edited by Chuck S; May 27th, 2005 at 04:36 PM.
Chuck S is offline   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
phpBB integration rogoff Photopost Pro Installation & Upgrades 1 July 22nd, 2005 03:00 PM
PHPBB and PHOTOPOST Damir P Photopost Pro How Do I...? 9 February 28th, 2005 10:30 AM
Photopost and PHPBB errors lakerszone Photopost Pro Installation & Upgrades 0 December 23rd, 2004 11:40 AM
RP and phpBB 2.0.8 ncg ReviewPost Installation & Upgrades 5 December 17th, 2004 06:48 PM


All times are GMT -5. The time now is 08:56 AM.

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