upgrade issues

[sifuhall]

We just upgraded today (and was very happy to do so as we are running vb3.5) and the upgrade seemed to go smoothly, however when viewing the reviewpost index we get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/reviews/forums/vb3.php on line 361

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/reviews/pp-inc.php on line 2255

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/reviews/forums/vb3.php on line 361

We are also unable to log into the admin panel (just loops back to the login page).

I'm sure it is something we have screwed up, but I have reviewed the setting several times and I can't find where the problem is.

[Chuck S]

Well look at your usergroup table as vb3.php line 361 is that it is having trouble getting your usergroup info which means you could be using an old vb3.php you need to have the new one uploaded to be recognized

$query[] = "ALTER TABLE {$rp_db_prefix}usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL, ADD uplimit INT(3) DEFAULT '0' NOT NULL";

Your pp-inc.php error tells me you did not run the upgrade script. This was added to the cats table on that upgrade and I am gonna guess your missing your moderators column

[sifuhall]

OK, I re-uploaded all files, configured the config-inc and config-int files,
then ran upgrade.php. In the upgrade I clicked on 2.9 -> 3.0 and it runs immediately (I assume it is immediately since I get no warning messages).

Then I click on Import Zip Codes. Again I get no error messages, but a new window is opened to the same page.

After this I go to my reviewpost directory and get:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/reviews/forums/vb3.php on line 361

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/reviews/pp-inc.php on line 2255

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/reviews/forums/vb3.php on line 361

[Chuck S]

$query = "SELECT groupid,cpaccess,modaccess,uploads,reviews,editpho,editposts,reqmod,uplimit FROM {$Globals['rp_db_prefix']}usergroups WHERE groupid='$groupvalue' LIMIT 1";
$result = ppmysql_query($query,$link);
list( $usergroup,$cpaccess_a,$modaccess_a,$uploads_a,$reviews_a,$ueditpho_a,$ueditposts_a,$reqmod_a,$uplimit_a ) = mysql_fetch_row($result);


Check your reviewpost usergroup table this is where your failing

The upgrade adds the new new fields you need so you need to run that query and find out what is the issue.

[sifuhall]

looks like I missing the fields reqmod and uplimit

I'm not sure which way to proceed here. When I click on the upgrade links I do not get any error messages so I assume it upgrades successfully.

Should I try to simulate the upgrade manually by adding the missing fields or should I try to find out why upgrading didn't add these fields?

[Chuck S]

ALTER TABLE rp_usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL, ADD uplimit INT(3) DEFAULT '0' NOT NULL


interesting dont see why if ran it does not exist but you can surely add em