installation problem

[sanddancer]

hi just bought a new classified installation but when trying to install with phpbb as option it

shows up

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/fhlinux199/s/user/htdocs/forums/sellerspost.php on line 237

and i cant login

[Chuck S]

You have installed as a standalone not phpbb2 integration.

I would run install and install integrated with phpbb2

[sanddancer]

umm there didnt seem to be an option for it, it only took me upto step 3 then returned a blank white page??

[Chuck S]

In install.php remove this and try reinstalling

// Upload the zipcode data (if present)
$query = @file("zipData.sql");

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$iquery = str_replace( ";", "", $iquery );
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

you can then finish install and use upgrade.php to import the zipcodes. Your server memory is being used up and you cant do the zipcodes on install

[sanddancer]

hi that seems to have installed when it asked me to log in i entered my username and password but it says You are not a valid administrator or moderator! but it works okay on my other installations??

[Chuck S]

In phpmyadmin what entries are in your classifieds usergroups table?

[Chuck S]

Okay in phpbb2.php file find this

Content visible to verified customers only.

replace with this

Content visible to verified customers only.

You can reinstall after making this change and should be fine

[sanddancer]

that seems to have fixed it omegatron, thanks very much for a excellent response time

[Chuck S]

No problem you helped point out an issue I had to fix so always a pleasure to be of service

[sanddancer]

1 other small little niggle with it, if you goto refresh user groups the follow that right through to refresh the groups

it shows Error: Column count doesn't match value count at row 1

and it does not obtain any of the group information from my phpbb database??

[Chuck S]

Yes the two anonymous group inserts need an extra 0 in the column has been updated above.

[sanddancer]

i already have your updated code in place? do you mean its changed since you first posted it??

[Chuck S]

well yes I just stated I added an extra ,0 in the anonymous inserts go give that a try

[sanddancer]

just tried that again, and it only shows anonymous, regular, and admin groups on our other installation it shows the extra groups Moderators and Admin Team

doing a refresh does not change the listings, also ive noticed the styles are totally different although set up the same?

Thanks!

[Chuck S]

Styles unless you have copied the altered styles to disk will be different. Thats because most people do not realize that when they alter a style in phpbb it changes in the database but does not updated the css file on disk. We load the css file on disk

As far as your groups then you must have no groups that match the importable criteria

$query = "SELECT group_id,group_name FROM $grouptable WHERE group_type=2 OR group_single_user=0";

Try that query in phpmyadmin on your phpbb_groups table

[sanddancer]

running that returns Admin Team which isnt shown when a refresh groups in the classifieds program, phpmyadmin returns it fine?

[sanddancer]

any ideas on this one yet?? thanks

[Chuck S]

Try making your import usergroup function this in phpbb2.php

Content visible to verified customers only.

[sanddancer]

this displays

Warning: array_key_exists(): The second argument should be either an array or an object in /home/fhlinux199/s/user/htdocs/forums/phpbb2.php on line 432
Error: Table 'forum.usergroups' doesn't exist
Error: Table 'forum.usergroups' doesn't exist
Error: Table 'forum.usergroups' doesn't exist

but it does exist??

[sanddancer]

it doesnt seem to want to allow access to admins now, looks like it might be using the cookie prefix instead of database one, in dprefix it shows sdancer_ which it should use but it isnt