Warning: mysql_fetch_array(): supplied argument is not a valid Please help

[tidy_boy]

Hi there I have just tried to install this review post and when I go to the adm-index.php file to log in I have this error at the top of the screen

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /xxxxxxxx/xx/xxxxxxxxx/htdocs/harddanceaddict/review_post/forums/vb3.php on line 26



When I did the install I told it to use to the vb users registration. So I tried to log into through the adm-index.php page with my normal details and get this error


Warning: chdir(): No such file or directory (errno 2) in /xxxxxxxxxx/xx/xxxxxxxxxxxx/htdocs/harddanceaddict/review_post/header-inc.php on line 61

Warning: main(./global.php): failed to open stream: No such file or directory in /xxxxxxxxxxxxxx/xx/xxxxxxxxxxxxx/htdocs/harddanceaddict/review_post/header-inc.php on line 62

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/local/lib/php') in /xxxxxxxxxxxxxx/xx/xxxxxxxxxxxxx/htdocs/harddanceaddict/review_post/header-inc.php on line 62


Thanks

[Chuck S]

two issues I see

1. either your users database information is incorrect in the config file and or you did not specify the vbulletin table prefix on installation. Most likely the later is your issue.

2. You specified the incorrect path to your vbulletin forum in the last step of install

reinstall the script and make sure everything is answered correctly and you'll be fine

[tidy_boy]

Ok I have moved my review_posts folder into my forum root and changed the config files but still get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/15/d133566260/htdocs/harddanceaddict/forum/review_post/forums/vb3.php on line 26

When I go to http://www.harddanceaddict.net/forum.../adm-index.php and use my normal log in details I get sent to

http://harddanceaddict.net/review_post/misc.php

I think I have missed something

[Chuck S]

Yes number one on my points I noted above

You did not enter the vbulletin table prefix on install either rerun install and correct or use phpmyadmin to view the photopost settings table and setting 83 place in there the proper table prefix for vb

[tidy_boy]

it is set correctly to vb3_

Right let me see if I have this right

I left the database prefix for review post to rp_

is this correct?

[tidy_boy]

Right I have re run the install script and now I have got this error when I go to

http://www.harddanceaddict.net/forum...post/index.php

Warning: chdir(): No such file or directory (errno 2) in /homepages/15/d133566260/htdocs/harddanceaddict/forum/review_post/header-inc.php on line 61

Warning: main(./global.php): failed to open stream: No such file or directory in /homepages/15/d133566260/htdocs/harddanceaddict/forum/review_post/header-inc.php on line 62

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/local/lib/php') in /homepages/15/d133566260/htdocs/harddanceaddict/forum/review_post/header-inc.php on line 62


if I turn off

define(VB3_INTEGRATION, 'off');
define(VB3_ENHANCEDINT, 'off');
define(VB3_COMMWYSIWYG, 'off');

The errors go away but the sreen does not have my template

[tidy_boy]

Problem sorted my $vbpath was incorrect changed it and now it works

Thanks for your help


Edit: Everything is working but when I am logged into my site and I go to the http://harddanceaddict.net/forum/review_post/index.php and click on admin

I add my details and it then sends me back to http://harddanceaddict.net/forum/review_post/index.php but im logged out

Any ideas please

[Chuck S]

You did not enter your cookie prefix for vbulletin of bb on install you can edit the database settings table setting 172 and enter it or rerun install

[tidy_boy]

Thanks for all your help it is now working correctly

Just one more thing I am going to be using this review section for reviewing clubbing events not products so how do i change all the places where it says product to event


Thanks

[Chuck S]

in admin edit language and change the phrases

[tidy_boy]

right I went ot my admin section and I could not log in correctly with my normal details

I changed something in my config file now it totally does not work here is my config file to see if I have set it up correctly


I am getting this error at the minute

Warning: mysql_connect(): Access denied for user: 'db136673770@212.227.119.174' (Using password: YES) in /review_post/pp-inc.php on line 144
I cannot connect to the Members database. []

[Chuck S]

you changed your mysql password if you get that errror

[tidy_boy]

thanks all sorted now

[tidy_boy]

how do i get rid of these as they show once a review has been added and I do not need them

Recommended By Average Price Average Rating
No recommendations None indicated None indicated

Also Iposted a test review and replied to it, t worked but i get this error at the top of the screen

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /review_post/forums/vb3.php on line 141


Thanks

[Chuck S]

Your vbulletin has been modified from a default vb install

Your missing field2 in your vbulletin userfield table which holds the users location

You would need to add that field back to that table or modify our profile query to remove the location it is trying to get.

As far as removing stuff for display you would alter the associated templates with the script you are wanting to remove this stuff from and remove what you do not want to display

remember when attempting to hack or modify your files you do so at your own will and always make backups.

[tidy_boy]

Originally Posted by Chuck S

Your missing field2 in your vbulletin userfield table which holds the users location

You would need to add that field back to that table or modify our profile query to remove the location it is trying to get.

So how do I remove the location it is trying to get from the profile query please

[Chuck S]

remove everything in bold

Content visible to verified customers only.

[tidy_boy]

Thanks that worked

[tidy_boy]

How do I take out the pros and cons but when you post a reply please

[Chuck S]

edit your quickcom and comments templates