Xenforo Error

Reeftanksonline · January 26th, 2011, 07:46 PM

Im getting an error after xenforo install and the integration does not work I cant sign in to admin

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/public_html/nyphotoforum/photos/forums/xenforo.php on line 332

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/public_html/nyphotoforum/photos/forums/xenforo.php on line 225

Chuck S · January 26th, 2011, 08:34 PM

This is the query your having an issue with

Code:

Content visible to verified customers only.

I would suspect that you incorrectly installed like wrong table prefix maybe. For example my prefix is xf_ and there is an xf_option table on my install. The query seems valid so please check your site and let me know.

A community photo gallery - My Photo Gallery

Main Index - PhotoPost Classifieds

I have two separate installs there.

If you want me to look at your site you would need to send a url admin login and ftp through the contact us link.

I would suspect your seeing this query error because your on the login page and thats the first thing that pops up.

Chuck S · January 26th, 2011, 08:37 PM

Yep I viewed your sites main gallery index you have not placed the proper xenforo table prefix most likely xf_ on step 4 of install.

Reeftanksonline · January 26th, 2011, 08:40 PM

Cool thanks Ill look into it now!

Reeftanksonline · January 26th, 2011, 08:43 PM

that was it thanks for the fast response!

Reeftanksonline · January 26th, 2011, 08:45 PM

Is there a easy way to get my header and footer to show up?

Chuck S · January 26th, 2011, 09:15 PM

Alot of this was discussed in the xenforo thread.

There is no way in the program currently to load your forums header and footer. I do not see that functionality in xenforo yet. If there becomes a way to load the xenforo header footer around a page let me know and I can look into it.

What I did for my site was take a look at my forum page source and do an html mock header footer over my apps.

Reeftanksonline · January 27th, 2011, 03:30 PM

you wouldn't happen to have the header html and the footer would you?

Chuck S · January 27th, 2011, 04:41 PM

Well that would change with each specific sites html

My test site they are simply in header footer files like this

http://www.omegatron.net/photos/header.htm

http://www.omegatron.net/photos/footer.htm

Reeftanksonline · January 27th, 2011, 05:56 PM

thanks I got a pretty good result Ill post links when Im done tweeking !

Chuck S · January 27th, 2011, 05:59 PM

No problem have fun.