Solved Error during installation

S

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
 
Sort by date Sort by votes
Hello,

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

Regards, SyTry
 
Upvote 0 Downvote
Sadiq6210 said:
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
Click to expand...
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
 
Upvote 0 Downvote
CRUEL-MODZ said:
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
Click to expand...

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
 
Upvote 0 Downvote
Nice !

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

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

Can you try to create a new mood please ?
 
Upvote 0 Downvote
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? :)
 
Upvote 0 Downvote
Cannot PM you (no permission)
Can you start conversation with me? :)
 
Upvote 0 Downvote
Hello,

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

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

Sadiq6210 said:
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
Click to expand...

1569473909113.png


What should we do with XenMoods legacy addon? Normally it is upgraded to XF2 and disappeared from legacy.
 
Upvote 0 Downvote
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 ;)
 
Upvote 0 Downvote
You must log in or register to reply here.

Recommended Similar Threads

B
Not a bug Compatibility issue with [XB] Paid Registration add-on
Replies
1
Views
69
CRUEL-MODZ
CRUEL-MODZ
fords8
Support With Coupons Enabled
Replies
6
Views
99
fords8
fords8
CRUEL-MODZ
Add-on [Xen-Soluce] DM Auto Reply
Replies
0
Views
63
CRUEL-MODZ
CRUEL-MODZ
T
  • Solved
Solved How to use? Not intuitive for me
Replies
2
Views
83
tinkbert
T
S
Support Can't buy sub with User Upgrade Pro
Replies
1
Views
102
SyTry
SyTry
Back
Top Bottom