4.8.1: MySQL Error on Step 3 of Install

[Muhammad]

I'm trying to install 4.8.1 using external user database for UBBT 6+. Going straight through the install steps, I get this error after filling out the info in step 3 for external user database:

---
MySQL error reported!

Script: install

Query: SELECT groupid, groupname, cpaccess, uploads, comments, diskspace, uploadsize, editpho, editposts, modaccess, useralbums, reqmod, canassign FROM tbnpp_usergroups

Result: Table 'tbn_photopost.tbnpp_usergroups' doesn't exist

Database handle: Resource id #2
---

tbn_photopost is the PhotoPost database. tbnpp_ is the prefix for the tables.

I checked and usergroups doesn't exist. But I do not know why it doesn't exist. And why it's looking for usergroups in the tbn_photopost db when it should be using the external UBBT db for the user db.

All URLs, paths and passwords are correct (checked many times).

TIA,

You gave it the wrong prefix for the forums table names.

[Muhammad]

Originally Posted by donb

You gave it the wrong prefix for the forums table names.

Ok, then what should the prefix be?

[Chuck S]

Check all forum connection information on step 1 of the install. You most likely do not have it entered correctly

Also on the last step of install when selecting ubbthreads also as Don suggested enter the proper table prefix usually by default is w3t_

This is why your photopost usergroups table did not get created as it could not import usergroups from the forum usergroups table. The import query failed.

I run a UBBThreads forum with all the products as well as the developer of Photopost. It most definately works right out of the box provided you enter the correct info.

http://www.reeftalk.com

http://www.viperalley.com