PhotoPost Community - View Single Post - MySQL result resource in /gallery/search.php on line 261

aacircle · December 3rd, 2006, 04:19 PM

www.animeonline.net/gallery is the one that doesn't work.

Our other gallery over at www.aacircle.com.au/forums/gallery works perfectly, so am baffled cause we followed the exact same upgrade instructions.

Thanks for looking into this.

<<EDIT>>

Well, think I found out the problem. Our tables do not have a pp_db_prefix. Hence the search table was also being using by vBulletin. So now "search" cannot be used site wide as it has been renamed to searchids.

Would it be possible to just copy the searchids and create a search table? Does the vb and Photopost search table look and function the same?

Ideally we should go and rename all photopost tables to start with pp_. Do you recommend this? Of course I would then need to update the config-inc.php, config-int.php file, and setttings in photopost admin.

Thank you.

December 3rd, 2006, 04:19 PM	#5 (permalink)
aacircle Member Verified Customer Join Date: Jan 2006 Posts: 207	www.animeonline.net/gallery is the one that doesn't work. Our other gallery over at www.aacircle.com.au/forums/gallery works perfectly, so am baffled cause we followed the exact same upgrade instructions. Thanks for looking into this. <<EDIT>> Well, think I found out the problem. Our tables do not have a pp_db_prefix. Hence the search table was also being using by vBulletin. So now "search" cannot be used site wide as it has been renamed to searchids. Would it be possible to just copy the searchids and create a search table? Does the vb and Photopost search table look and function the same? Ideally we should go and rename all photopost tables to start with pp_. Do you recommend this? Of course I would then need to update the config-inc.php, config-int.php file, and setttings in photopost admin. Thank you. Last edited by aacircle; December 3rd, 2006 at 05:19 PM.