More VB2 to VB3 Issues...

[Zilvia.net]

Ok, I cant upgrade my copy of ReviewPost and PhotoPost without getting errors when done. I have had lots of issues with the upgrades and have been stuck on version 1.02 ReviewPost and PhotoPost 3.3.1.

But one thing at a time, lets try to get ReviewPost working and im sure the other will be simular to fix.

Here is the error I get after a seccessful upgrade from 1.02 to 2.52 and after updating the vb2 value on line 41 of the database to vb3.

MySQL error reported!
Query: SELECT groupid,cpaccess,modaccess,uploads,reviews,editpho,editposts FROM rp_usergroups WHERE groupid='1' LIMIT 1

Result: Table 'reviewpost.rp_usergroups' doesn't exist

Database handle: Resource id #5

http://www.zilvia.net/review/index.php

Thanks so much for you help!!!

[Interdit]

Well try to "reupload" in phpmyadmin a usergroup table

Francois

[Chuck S]

It would also help to post in the reviewpost installation forum also

Now as Francois stated it looks like your reviewpost usergroup table is not there.

You can use phpmyadmin and add that usergroup-vb3.sql table via the sql box.

[Zilvia.net]

Sorry its been forever on this question. Can you please explain what to run in the query box? I know how to use PHPAdmin, just not how to write the code. Sorry and Thanks!!

[Chuck S]

This should set you up

CREATE TABLE rp_usergroups (groupid int(5) NOT NULL auto_increment, groupname varchar(50) NOT NULL default '', cpaccess smallint(3) NOT NULL default '0', modaccess smallint(3) NOT NULL default '0', uploads smallint(3) NOT NULL default '1', reviews smallint(3) NOT NULL default '1', editpho int(3) NOT NULL default '0', editposts int(3) NOT NULL default '0', PRIMARY KEY (groupid)) TYPE=MyISAM;
INSERT INTO rp_usergroups VALUES (6,'Administrator',1,1,1,1,1,1);

[Zilvia.net]

WOOHOOOO! It worked! THANKS SO MUCH!