|
I ran into errors running the application on my browser after that above. All seemed related to usergroups. So I went back and restored the old database and tried upgrade.php again only this time without renaming usergroups. Here's what happened:
I got these two new errors on the 1.0 to 2.0 update:
Performing MySQL command: ALTER TABLE rp_usergroups ADD modaccess smallint(3) NOT NULL default '0' ... Error: Table 'tdpri.rp_usergroups' doesn't exist
Performing MySQL command: ALTER TABLE rp_usergroups ADD reviews smallint(3) NOT NULL default '1' ... Error: Table 'tdpri.rp_usergroups' doesn't exist
And then I got all the same errors as before. Plus one or two other rp_usergroups doesn't exist erros farther along the upgrade path.
And I'm getting the same errors on running the reviewpost website:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/tdpri.com/reviewpost/forums/phpbb2.php on line 353
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/tdpri.com/reviewpost/forums/phpbb2.php on line 353
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/tdpri.com/reviewpost/forums/phpbb2.php on line 353
And there is no Admin link on the menu yet is shows me logged in. I'm guessing without usergroups that everyone is logged in.
Can I copy the usergroups table from Classifieds or PhotoPost and apply it to the Reviewpost tables?
|