The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/printthread.php 16 require_once



UserSpice
4.3 sql error - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: 4.3 sql error (/showthread.php?tid=831)

4.3 sql error - Jeff - 11-16-2017

I have downloaded the 4.3 version and tried a fresh install on a Linux server ruuning PHP 7.0.25 and mysql version 5.5.32 . The installation script fails due to errors in the install/includes/sql.sql file.

These fields have DEFAULT identified but no value given.

Code:
auto_assign_un
int(1) NOT NULL DEFAULT,
Code:
page_permission_restriction
int(1) NOT NULL DEFAULT,
Code:
msg_blocked_users
int(1) NOT NULL DEFAULT,
Code:
msg_default_to
int(1) NOT NULL DEFAULT,
Code:
notifications
int(1) NOT NULL DEFAULT,
Code:
notif_daylimit
int(3) NOT NULL DEFAULT,
Code:
page_default_private
int(1) NOT NULL DEFAULT,
Code:
navigation_type
tinyint(1) NOT NULL DEFAULT,

I have overcome the problem by deleting the DEFAULT setting, but I am not sure if this will cause later problems by not having a specific default value set.

On a less important point, I cannot install Userspice 4.3 on a development server (Xampp/Windows 10) because the sql file is so large PHP times out.

4.3 sql error - mudmin - 11-16-2017

Right! We just figured out a few mins ago that @Brandin botched this. Smile (Throwing him under the bus). A patch is coming! Thanks so much for letting us know. We'll let you know when we have a patch.


4.3 sql error - Brandin - 11-16-2017

Sorrry...sorrrrrry!! I just issued the patch which Mudmin just has to push for everyone. It is in the repo.

4.3 sql error - mudmin - 11-16-2017

haha. 4.3.4 has been pushed. Update available on the update page.