install.php missing usergroups table?

[Mikan]

I's trying to do a fresh install of Classifieds 4.2. (and with VB 3.8)

After step 4 I'm getting that "We're sorry, but the system experienced an unrecoverable error. Please try again later."

If I debug that I'm getting this:

Script:

Query: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic,payment,uplimit,free FROM cp_usergroups WHERE groupid=6 OR groupid=11

Result: Table 'classifieds.cp_usergroups' doesn't exist

Database handle: Resource id #20

Now if I check mysql tables I'm getting this:

mysql> show tables;
+-----------------------+
| Tables_in_classifieds |
+-----------------------+
| cp_admingroups |
| cp_admlog |
| cp_adtypes |
| cp_bidding |
| cp_bids |
| cp_board |
| cp_buddies |
| cp_cache |
| cp_captcha |
| cp_categories |
| cp_comments |
| cp_currency |
| cp_extrafields |
| cp_favorites |
| cp_feedback |
| cp_invites |
| cp_ipcache |
| cp_iponline |
| cp_languages |
| cp_laston |
| cp_messages |
| cp_notify |
| cp_paid_subscriptions |
| cp_payments |
| cp_phrases |
| cp_productextras |
| cp_products |
| cp_searchids |
| cp_settings |
| cp_sort |
| cp_stats |
| cp_subscriptions |
| cp_users |
| zipData |
+-----------------------+
34 rows in set (0.00 sec)

See... no cp_usergroups table at all!

Now if I check install.php file there aren't anywhere a piece of code that creates that usergroup table at all so no wonder it doesn't exist:

# grep usergroups install.php
<a href=\"install.php?step=3\">REFRESH your usergroups or change Admin password</a>

See, that is the only place in whole install.php script where "usergroups" is mentioned.

[Mikan]

Ok - I found that from vb3.php so it's not actually missing (Chuck - can you update the thread title to something else that describes this problem better)

What could cause that mysql error and that cp_usergroups is missing?

[Chuck S]

You have not uploaded all the files and properly installed the application. That can be the only explanation for your issue.

[Mikan]

Chuck - As far as I can tell there has to be something else. I uploaded pp-classifieds.zip file to server. Unzipped that into a folder and copied that to web server root. So unless that zip-file is missing something it's not possible that some files are missing.

I then edited config-inc and config-intc -files and checked file and folder permissions. Then I launch install.php and start the fresh install.

Please remember Chuck that I have had Classifieds installed previously and I also have Photopost installed so this is not a first time I'm doing this.

[Chuck S]

I am merely telling you what I know to be a fact based on the coding. The install file includes whatever integration you are installing it for and in that integration file are both the functions that are called on install to create the usergroups table and popular it with groups from that specific forum. As long as all files are uploaded there should not be an issue if one is installing properly. You can see for yourself we clearly call these functions.

Content visible to verified customers only.

That code is right out of our install file. We include pp-inc.php which includes the integration file your selecting to use and then we do the usergroups. That is all done on step 4 of the install.

[Mikan]

Ok - found the reason for this. And there is a bug...

Explanation and solution is here

[Chuck S]

Okay thanks.