Installed.... Now MySQL Errors. Please Help!

Chris@TSE · August 1st, 2005, 04:36 PM

I know this is probably something stupid or simple, please help me nonetheless...

I installed photo post classifieds today as a vb3 integration. Everything seems to have worked fine but i am getting mysql errors at the top of my pages, above the vb headers, sometimes one, sometimes a few....

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

And here is one under my nav bar in vb....

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

I believe I set all the directories correctly, everything seems to be working aside from these annoying errors. Thanks in advance for any and all assistance! Have a wonderful day.

link: http://topshelfexotic.com/vbulletin/classifieds/

Chris@TSE · August 1st, 2005, 04:44 PM

I got more errors trying to go into the admin control...... it let me log in tho, then directed me to the main page and i could not do anything...

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

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

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

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

Chuck S · August 1st, 2005, 06:01 PM

Looks to me like when you installed the application you did not specify the proper vbulletin table prefix.

Chris@TSE · August 1st, 2005, 06:05 PM

Thanks, and how would I go about repairing this and finding the correct table prefix? Certain place to look? And where can it be edited? Thanks.

Chuck S · August 1st, 2005, 06:24 PM

Your correct table prefix and database info is in your vb config file in the vb includes directory

You would either use phpmyadmin to view the photopost settings table and enter the prefix in the setting field for entry 83 or reinstall the application again with the correct information

Chris@TSE · August 1st, 2005, 06:34 PM

i cant remember if it was vb3 or blank, ill have to look. if it were blank should the entry just be blank as well?

thanks in advance.

Chuck S · August 1st, 2005, 06:39 PM

CORRECT The database settings for the forum have to point to the forum and be exact

Chris@TSE · August 1st, 2005, 07:01 PM

okay now it says "You are not a valid administrator or moderator! "

There are no options to post or place a new ad....etc. but I am sure that I have to login as an admin so I can turn these options on. The one time i did sucessfully login, i only had the ability to view the empty barebone software. No real options, but it is now loading without sql errors tho... So im sure once im in as admin the rest should go easy..

now.... all i could think to check were the following:

my vb license (NOT CUSTOMER NUMBER) is entered correctly and the cookie prefix (tseforums) in the db around line 175 or so is the same as I specified in the vb install.

my vb install is at http://topshelfexotic.com/vbulletin/
and my photopost classified install is at http://topshelfexotic.com/vbulletin/classifieds/

possibilities...? Please be specific as possible... Thanks again in advance!

(almost there!!! soooooooo anxious to get this working!!

)

Chuck S · August 1st, 2005, 07:25 PM

Your cookie domain is blank in both apps and you have them installed on two separate domains. www makes a difference

Set both apps to use the cookie domain .topshelfexotic.com so both www and no prefix will work.

Chris@TSE · August 1st, 2005, 07:27 PM

strange, im showing entries for cookie prefix in both apps.....

where do i edit these settings, i dont want to foul anything up this close to getting it working properly. i want to check the cookie prefix for both programs and make them the same or blank, and i want to correctly modify the cookie domain in both. just need the locations to do so... thanks so much....

I can almost SMELL the working software! lol

Chuck S · August 1st, 2005, 07:35 PM

I said cookie domain not prefix

Chris@TSE · August 1st, 2005, 07:38 PM

okay, i changed the domain as you said, cleared my cookies, and tried logging in and it worked..... no admin error message.

one problem though.... i dont have any admin options, i go to log into admin, sign in, says i logged in sucessfully, and sends me to the regular classifieds listing.

what am i doing wrong. something tells me it has to be a VERY stupid mistake on my part... lol

thanks again

Chris@TSE · August 1st, 2005, 07:43 PM

nevermind.... that explains it...

just got the "You are not a valid administrator or moderator! " error again

im about ready to pull my hair out. both domains were set as you specified
( .topshelfexotic.com )

should i have anything in particular set in vbulletin for "Path to Save Cookies"... its currently "/"

i dont know what else it could be

Chuck S · August 1st, 2005, 07:47 PM

Your sure your logging in with an admin account that belongs to usergroup 6. It must be usergroup 6 as thats the main admin usergroup and the only one set to control panel access on install

Cause everything else looks okay as far as cookies are concerned

Chris@TSE · August 1st, 2005, 07:53 PM

yes, im an administrator. user group 6. just double checked. could it have naything to do with paths or anything in the config files?! am i going to the wrong admin screen or something?

i've just about had it, everything looks like its right yet i can login as an admin!

Chris@TSE · August 1st, 2005, 07:55 PM

i just created a test account with admin access, got the same message. tried it from another pc too. nothing.

Chris@TSE · August 1st, 2005, 08:04 PM

im browsing thru the database for photopost classifieds..... is there supposed to be a setting for "Forum database table prefix" ?

mine is blank.

other than that i am at a total and complete loss. i dont know what to do. it should be working...

Chuck S · August 1st, 2005, 08:06 PM

Move user Omegatron in Vbulletin to usergroup 6.

In phpmyadmin if you view the classifieds usergroups table is there an entry for admins groupid of 6 and cpaccess set to 1

Chris@TSE · August 1st, 2005, 08:10 PM

sure, try it in one minute....

cpaccess in usergroups is set to the following:

type: smallint(3)
attributes: nothing here
Null: No
Default: 0 ( is this supposed to be 1? )
Extra: nothing here

Chris@TSE · August 1st, 2005, 08:15 PM

groupid in usergroups is set to the following:

type: int(5)
attributes: nothing here
Null: No
Default: nothing here
Extra: auto_increment

im fairly lost in phpmyadmin...... sorry if that isnt what you're looking for

if it comes down to it i can grant access let me know what to change and if i cant ill hook ya up. thanks again.