The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!
UserSpice   ›   Support Center   ›   UserSpice 4.3 and Below   ›   Table Join

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Table Join
JeffJ
User
Joined: Oct 2016
Posts: 6

Reputation: 0
#1
10-19-2016, 12:06 PM
I'd like to create a MySQL view that joins the UserSpice user table with my own user table using a SQL JOIN. This seems possible if I install UserSpice into my existing database. Is it possible to install UserSpice into an existing MySQL database (i.e., a database that's already populated with several other tables)?

Thanks.
  Reply
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#2
10-19-2016, 12:09 PM
Absolutely. I install userspice in the same db as wordpress and joomla all the time. The only issue is that userspice will not natively support db_prefixes for its own tables until 5.0. There are ways around it, other than that, it works great.
  Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)