Fresh install on vb 3.08, errors

rs25.com · September 16th, 2005, 01:10 PM

Hi,

Just did a new install of 2.41 on vBulletion 3.08, but I get all sorts of errors when I log into the admin:

On the login page:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rs25/public_html/classifieds/forums/vb3.php on line 25

Warning: Cannot modify header information - headers already sent by (output started at /home/rs25/public_html/forums/includes/init.php:27) in /home/rs25/public_html/classifieds/forums/vb3.php on line 202

Warning: Cannot modify header information - headers already sent by (output started at /home/rs25/public_html/forums/includes/init.php:27) in /home/rs25/public_html/classifieds/forums/vb3.php on line 205

Warning: Cannot modify header information - headers already sent by (output started at /home/rs25/public_html/forums/includes/init.php:27) in /home/rs25/public_html/classifieds/forums/vb3.php on line 207

Login Successful!

Click here if you do not want to wait any longer
(or if your browser does not automatically forward you)

Once I am logged in, at the top:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rs25/public_html/classifieds/forums/vb3.php on line 25

and below the nav bar:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rs25/public_html/classifieds/forums/vb3.php on line 54

I read through the other threads here, and checked the settings, but must be overlooking something. How do I fix this?

Cookie setting is right (bb), vb3 for integration, and table prefix should be right... license code is right...

Chuck S · September 17th, 2005, 08:24 AM

Hello did you enter the prefix correctly when installing?

Also depending when you downloaded but this looks like your talking about classifieds even though you posted in the install forum of photopost I beleive 2.42 is the only version compatible with vb3.5 so you might want to update your files

rs25.com · September 17th, 2005, 10:03 AM

Hi,

Which prefix are you referring to? Can you let me know what DB table/field I should check

Yes, it is the classifieds, my apologies if this is in the wrong place. Can you move it?

Finally, I am running 3.08, not 3.5, so that should not be an issue - right?

Thanks!

Chuck S · September 17th, 2005, 11:46 AM

Okay when you install you need to specify the proper table prefix for your vb3 tables.

I beleive you did not do so. you can use phpmyadmin and in our settings table set setting 83 to the proper table prefix. Otherwise you can simply run through the install again makinf sure everything is correct. This may be easier for you

rs25.com · September 17th, 2005, 11:54 AM

Ah, okay, fixed that. I had "vb3_" in there, but it should have been blank.

But now when I try to login to the adm-index.php I get this error:

Quote:

You are not a valid administrator or moderator!

rs25.com · September 17th, 2005, 12:03 PM

Doing some research I found the pp_usergroups table, but there are no rows of data in there.

What data exactly do I need to insert into that table, assuming that is the problem?

Chuck S · September 17th, 2005, 12:04 PM

Is your cookie prefix and vblicense entered correctly

rs25.com · September 17th, 2005, 12:07 PM

Yeah, I checked those already. Everything seems to work except the admin area.

Chuck S · September 17th, 2005, 12:10 PM

Okay yeah on install since you had the wrong prefix your usergroups were not imported. you can rerun install or insert a record in the usergroups table for administrators with a groupid of 6 and cpaccess set to 1. This will get you admin access and you can them import usergroups in admin usergroups editor

rs25.com · September 17th, 2005, 12:13 PM

That worked! Thanks!

rs25.com · September 17th, 2005, 12:17 PM

Oh, I should mention for other folks. Once I fixed this I clicked Edit Usergroups and then the link for Refresh Usergroups from your forum software and they were all imported automatically.

rs25.com · September 17th, 2005, 01:28 PM

Now I am getting another error:

Quote:

Warning: main(/home/rs25/public_html/classifieds/languages/english/showcat4.php): failed to open stream: No such file or directory in /home/rs25/public_html/classifieds/showcat.php on line 155

Fatal error: main(): Failed opening required '/home/rs25/public_html/classifieds/languages/english/showcat4.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rs25/public_html/classifieds/showcat.php on line 155

At this URL: http://www.rs25.com/classifieds/showcat.php?cat=11
And this URL: http://www.rs25.com/classifieds/showcat.php?cat=9

This error only occurs for the two built in catagories I used... thoughts?

rs25.com · September 17th, 2005, 01:34 PM

The quick fix was this:

In showcat.php, line 153:

Code:

Content visible to verified customers only.

I changed to < from > and it seems to work... but what is the real fix?

rs25.com · September 17th, 2005, 01:39 PM

But now you cannot place ads in those catagories:

Warning: main(/home/rs25/public_html/classifieds/languages/english/uploadproduct5.php): failed to open stream: No such file or directory in /home/rs25/public_html/classifieds/uploadproduct.php on line 135

Fatal error: main(): Failed opening required '/home/rs25/public_html/classifieds/languages/english/uploadproduct5.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rs25/public_html/classifieds/uploadproduct.php on line 135

Chuck S · September 19th, 2005, 06:30 AM

FAQ--How to Create Additional Template Set's in Classifieds

You might want to look at that thread. You need to actually create new language and template files when you add a new set