Solved Error during installation

Sadiq6210

Licensed
Licensed
User Moods Manager
Required Custom Fields On Upgrade
Change Type Resource
Joined
Aug 26, 2019
Messages
68
Reaction score
29
Hello,

1. I tried to install the addon in our offline forum (for testing purposes), and I was unable to install it due to this error:

1569473380627.png

Code:
Server error log
XF\Db\Exception: Batch install error: MySQL statement prepare error [1146]: Table 'DB_NAME.xf_User' doesn't exist src/XF/Db/AbstractStatement.php:217
Generated by:  26 Sep 2019 at 7:43 AM
Stack trace
            SELECT user_id,
             username,
             mood_id
            FROM xf_User
            
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(155): XF\Db\AbstractAdapter->query('
            SE...', Array)
#5 src/addons/XenSoluce/UserMoodsManager/Setup.php(69): XF\Db\AbstractAdapter->fetchAll('
            SE...')
#6 src/XF/AddOn/StepRunnerInstallTrait.php(60): XenSoluce\UserMoodsManager\Setup->installStep3(Array)
#7 src/XF/AddOn/StepRunnerInstallTrait.php(27): XenSoluce\UserMoodsManager\Setup->installStepRunner(3, Array)
#8 src/XF/Job/AddOnInstallBatch.php(289): XenSoluce\UserMoodsManager\Setup->install(Array)
#9 src/XF/Job/AddOnInstallBatch.php(86): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#10 src/XF/Job/Manager.php(253): XF\Job\AddOnInstallBatch->run(G)
#11 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#12 src/XF/Job/Manager.php(111): XF\Job\Manager->runJobEntry(Array, G)
#13 src/XF/Admin/Controller/Tools.php(120): XF\Job\Manager->runByIds(Array, 8)
#14 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#16 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#17 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#19 src/XF.php(390): XF\App->run()
#20 admin.php(13): XF::runApp('XF\\Admin\\App')
#21 {main}
Request state
array(4) {
  ["url"] => string(30) "/forum/admin.php?tools/run-job"
  ["referrer"] => string(52) "/forum/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }

It says cannot find table xf_User, however, I entered the database and I can see the table !

1569473664771.png



2. Will XF1 mood disappeared from the legacy list after I install XF2 addon successfully? and what will happen to XF1 mood values/data in the database?

1569473909113.png
 
Hello,

We will make a new version with a fix, thank you for the report ! ;)

Regards, SyTry
 
Hello,

1. I tried to install the addon in our offline forum (for testing purposes), and I was unable to install it due to this error:

View attachment 249

Code:
Server error log
XF\Db\Exception: Batch install error: MySQL statement prepare error [1146]: Table 'DB_NAME.xf_User' doesn't exist src/XF/Db/AbstractStatement.php:217
Generated by:  26 Sep 2019 at 7:43 AM
Stack trace
            SELECT user_id,
             username,
             mood_id
            FROM xf_User
           
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(155): XF\Db\AbstractAdapter->query('
            SE...', Array)
#5 src/addons/XenSoluce/UserMoodsManager/Setup.php(69): XF\Db\AbstractAdapter->fetchAll('
            SE...')
#6 src/XF/AddOn/StepRunnerInstallTrait.php(60): XenSoluce\UserMoodsManager\Setup->installStep3(Array)
#7 src/XF/AddOn/StepRunnerInstallTrait.php(27): XenSoluce\UserMoodsManager\Setup->installStepRunner(3, Array)
#8 src/XF/Job/AddOnInstallBatch.php(289): XenSoluce\UserMoodsManager\Setup->install(Array)
#9 src/XF/Job/AddOnInstallBatch.php(86): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#10 src/XF/Job/Manager.php(253): XF\Job\AddOnInstallBatch->run(G)
#11 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#12 src/XF/Job/Manager.php(111): XF\Job\Manager->runJobEntry(Array, G)
#13 src/XF/Admin/Controller/Tools.php(120): XF\Job\Manager->runByIds(Array, 8)
#14 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#16 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Tools), NULL)
#17 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#19 src/XF.php(390): XF\App->run()
#20 admin.php(13): XF::runApp('XF\\Admin\\App')
#21 {main}
Request state
array(4) {
  ["url"] => string(30) "/forum/admin.php?tools/run-job"
  ["referrer"] => string(52) "/forum/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }

It says cannot find table xf_User, however, I entered the database and I can see the table !

View attachment 250



2. Will XF1 mood disappeared from the legacy list after I install XF2 addon successfully? and what will happen to XF1 mood values/data in the database?

View attachment 251
Hello,
could see this happening:
to the Setup.php file that is located: src\addons\XenSoluce\UserMoodsManager
once you open you go to the line: 70 and you will find that:
PHP:
FROM xf_User

and replace it with this:
PHP:
FROM xf_user

Regards, CRUEL-MODZ
 
Hello,
could see this happening:
to the Setup.php file that is located: src\addons\XenSoluce\UserMoodsManager
once you open you go to the line: 70 and you will find that:
PHP:
FROM xf_User

and replace it with this:
PHP:
FROM xf_user

Regards, CRUEL-MODZ

Thanks, this solved the error

I installed it successfully but I have this issue:

The moods is not showing here:

1569512138091.png

This is one for the mood link:
"/account/" is not correct.

and no icons in admincp as well:

1569512250199.png

1569512334789.png

but it is showing fine here:

1569512273739.png

1569512724203.png
 
Nice !

And if you add a "/" before styles/default ?

Regards, SyTry
 
Ok, I will have a look but I don't have this error :unsure:

Can you try to create a new mood please ?
 
Same:

1569513938098.png


____________

Also, I noticed that sorting is not imported from XF1 moods, all display order = 1
Any chance to import (Display order) from XF1 addon? :)
 
Cannot PM you (no permission)
Can you start conversation with me? :)
 
Hello,

Thank you, this is now fixed in the 2.1.1 Fix 1 version ! (y)

Regards, SyTry
 
Thanks for support, I installed fix1 and it fixed the issues :D

2. Will XF1 mood disappeared from the legacy list after I install XF2 addon successfully? and what will happen to XF1 mood values/data in the database?

View attachment 251

1569473909113.png


What should we do with XenMoods legacy addon? Normally it is upgraded to XF2 and disappeared from legacy.
 
XenMoods is not my add-on, so this is not like an "upgrade". My add-on copy your data from XenMoods to User Moods Manager. I think you can uninstall XenMoods when you have installed my add-on ;)
 
Top Bottom